Analytics General Settings

For the Analytics module you can set these options:

Load content of data grids automatically – If disabled, data grids in Analytics (Data Feeds, Data Sources, Datamart, Simulations and Rollups) are not populated with data automatically after you open them but only after you click the Refresh icon. This is useful for projects with large amounts of data. In the data grid, you can set a filter first and then you load only a subset of the data which makes the whole operation much faster.

  • Enable DM query optimization relying on daily currency conversion rates – Allows you to increase the speed of queries on a Datamart with a Currency Data Source with daily rates. The key assumption is that there are conversion rates for each currency pair on each and every day (with no gaps) – the gaps are filled automatically if the advanced configuration option paDailyCurrencyConversionRates is enabled.

  • Enable DM data access for users with no user group – If enabled, data in Data Sources with set data entitlements are visible also to users who are not members of any of the entitled user group.

  • Minimal days in the first week – Allows you to synchronize with the Outlook Calendar week numbering. This feature sets the minimum number of days in the first week of the year to align calendar week numbering with Outlook and ISO 8601 standards. The default value is 1 (the maximum is 7) which represents no change to the current application's behavior.

  • First day of the week – This feature sets the first day of the week for Calendar in the Analytics module. The default value is Sunday which represents no change to the current application's behavior.

To see the applied changes, regenerate the Calendar by following these steps:

  1. Change the First day of the week in the application (Configuration > Analytics > Analytics General Settings > First day of the week).

  2. Go to Analytics > Data Manager > Data Sources.

  3. Select the Calendar Data Source.

  4. Go to the Data tab.

  5. Click Truncate.

  6. Go to Analytics > Data Manager > Data Loads.

  7. In the Data Load Type dropdown, select the Calendar option.

  8. Select the Data Load with DMDS.cal Target field. (For more information see Calendar Data Load.)

  9. Click Run Data Load.


Your changes will only take effect once you click Save. If you click the Refresh icon, all recent changes that have not been saved will be lost. The configuration options will revert to the last saved state from the server.