Model Preferences

When you're designing a new model, you can set preferences for features such as security, auditing, and currency conversion. These settings are available from the (Model Preferences) dialog. (Dimension-specific settings are available from the Dimension Settings panel.)

Note
Not all preferences apply to analytics-type models, and models based on HANA views have different options, as described in this topic: Options for HANA Models.
General Settings

Use the optional Description field to provide some details or a summary of the model.

The Search to Insight section allows users with rights to the model to index HANA live models for use with the Search to Insight functionality in stories. To enable a HANA live model, after saving the model, select Create Index. After the indexing process is completed, a timestamped entry will appear under the Search to Insight section. You have the option to update or delete the index entry. Any user working with a story that includes the indexed model can access quick insights based on the model through Search to Insight.

Note
Do not refresh or close your browser window before the indexing process is completed. Also, you should index only one HANA live model at a time.

If you change the data source for an existing model used by Search to Insight, any index will be deleted when you save the updated model. For more information on using Search to Insight, see About Search to Insight.

Note

Only HANA live models based on SAP HANA 1.0 SPS12 rev 122.14 or higher can work with the Search to Insight feature. When a HANA live model is indexed, metadata such as dimension and measure names, and dimension members, is stored on SAP servers.

Access and Privacy

Data Audit

Auditing within SAP Analytics Cloud is available at either of two levels: high-level auditing or transactional-level Data Changes auditing. If Data Audit is switched on, all changes for this model will be logged.

The audit logs are available from the Users menu (Start of the navigation pathUsers Next navigation step Data ChangesEnd of the navigation path).

Data Locking

For planning models, data locking lets you set up locks on the model data, which prevent the locked values from being changed by data entry and other planning operations in stories.

Turn this switch ON to enable data locking, and set the Default Lock State for the model. This state will apply to all data in the model's public versions, unless otherwise specified in the Data Locking page:

  • Open: Data entry is enabled for all members by default.
  • Locked: Data entry is disabled by default.

For more information, see Configuring Data Locking.

Restricted Export

This setting lets you disable the export of model data to a CSV file. For details, see Exporting Data.

Model Data Privacy

This setting determines whether the model is visible to users other than the owner. Note that this setting can also be changed later after the model has been saved.

If you switch on Model Data Privacy, only the owner of the model and user roles that have specifically been granted access can see the data. Disable this switch if you want the model and data to be public.

Data Access Control in Dimensions

This setting lets you specify in the dimension settings which users will have access to each member in the dimension.

Fiscal Time
If your business fiscal year isn't the same as the calendar year, switch Fiscal Year on, and then select the other parameters as follows:
  1. Choose the starting month of your fiscal year.
  2. Choose whether you denote your fiscal year by the calendar year when it starts, or the calendar year when it ends.
  3. Choose whether to display fiscal periods or calendar months in stories. For example, quarterly reports cover a fiscal period of three months, while annual reports cover a fiscal period of one year.
Planning & Time Range
If you want to use this model for planning, switch Planning Capabilities on, and then choose start and end dates for the timeline for the data.
Note
  • You can switch Planning Capabilities on and off, but not after the model has been saved.
  • If the Planning Capabilities switch is disabled, a tooltip explains why.
  • If planning is enabled in the Data Integration step after importing data (see Preparing Data), Planning Capabilities is automatically switched on, and can't be switched off.
  • Planning Capabilities can be switched on only if there are no facts in the model.
  • If the model contains multiple date dimensions, you can't switch Planning Capabilities on.
  • You can't change the date granularity, planning date range, default date hierarchy, or the Fiscal Year setting, after configuring an allocation process, allocation step, value driver tree, planning sequence, or data locking for the model.
Currency

For information about different currency scenarios, see Currency.

Currency settings without conversion

If your model doesn't use currency conversion, set one of the following options:

  • Default Currency: The currency for all monetary values. For example, if your model only contains monetary values in US Dollars, you can set the default currency to USD.
  • Currency Dimension: The dimension that separates model data into different currencies. Model data will not be aggregated across the different currencies. For more information about adding a Currency column to a dimension, see Dimension Settings.

Currency settings with conversion

Enabling currency conversion allows model data from different source currencies to be converted into a single target currency and then aggregated.

To enable currency conversion, activate the Currency Conversion switch and specify the following settings:

  • Default Currency: Type the three-character code for the default currency. Monetary data will be converted to this currency by default.
  • Currency Dimension: Select the dimension that separates model data into different currencies. For more information about adding a Currency column to a dimension, see Dimension Settings.
  • Currency Rates Table: Select a currency conversion table. The drop-down list shows all tables that have already been created on the Currency Conversion tab of the Modeler.
  • Preconverted Actuals: When this setting is on, both source currency data and preconverted currency data can be imported. For more information, see Preconverted Currency Data.
  • Maximum number of Currency Conversions: This setting determines how many different currency conversions can be simultaneously displayed in a table based on this model. For example, if you want to enable users to view side-by-side figures for USD at the Budget rate, USD at the Forecast rate, and USD at rates defined for three different fixed dates, you can set the limit to five.

    Note
    • You can increase this limit after creating the model, but it cannot be decreased.
    • When you increase the limit after creating the model, the new limit does not apply to existing stories. Each story keeps the limit that was valid when the story was created.
    • Displaying data in its source currency does not count towards the Maximum Currency Conversion Limit.
Data and Performance

Optimize Story Building Performance

Switch on this option to stop the automatic update that happens when changes are made in a chart or table. This reduces the load on the system and improves performance.