Modeling enhancements

The modeling new features include enhancements in numeric data groups, using Excel data formats as default formats in data modules, zoom controls in the relationships diagram, and data module validation improvements.

Enhancements in numeric data groups

The following enhancements are added for numeric data groups:

  • Ability to set fixed high and low range border values.

    The Higher and Lower range border values in the Create a data group and Edit a data group dialog boxes can be changed to numeric inputs.

  • Support for multiple languages.

    The default Group names (ranges) that are generated during the binning process are automatically translated, and reflect the product and content locale settings. The custom Group names that are specified by users during the binning process are not translated.

    For more information, see Creating data groups.

Using Excel data formats as default formats in data modules

Uploaded Microsoft Excel spreadsheets retain the columns data formats, such as percent, currency, date, that were defined in Excel. These formats are set as default data formats in the base data modules that are created from these spreadsheets.

For more information, see Formatting data.

Zoom controls in the relationships diagram

Zoom out and zoom in buttons are added to enlarge or reduce the diagram.

For more information, see Modeling user interface.

Data module validation improvements
The following new and changed features make it easier to notice, analyze, and work with validation issues in data modules.
  • The data module validation icon is added to the application bar. When the module contains validation issues, the number of issues is displayed on top of this icon.
  • The validation tab was replaced by a validation panel that opens when you want to view validation issues.
  • The error details can now be copied to the clipboard making it easier to search for and analyze the issues, and print the details if needed.

For more information, see Validating data modules.