Set the general properties of the Essbase model in the General tab of the Essbase Model Properties dialog box.
For information on models, see Essbase Models Overview.
To set general properties for an Essbase model:
Access the Essbase Model Properties dialog box using the procedure in Accessing the Essbase Model Properties Dialog Box.
The model and cube schema names are displayed in the read-only Name and Cube Schema fields.
Optional: Enter an explanatory note in the Comment text box, for example, “To be used in conjunction with April analysis.”
Optional: Click the button to right of the Last deployed field to view the complete deployment history of the model.
The Last deployed field displays information about the most recent deployment.
Note:
If the current model has never been deployed, the “Last deployed” field is blank.
Optional: Select one or more of the following options:
ASO storage model—Enables the model to support aggregate storage.
Select this option to store data in aggregate storage format. Use this option when the Essbase outline contains a large number of sparse dimensions and one or no dense dimensions.
If you select the “ASO storage model” option, the following message will be displayed:
“Setting a model to aggregate storage can sometimes require adjustments to some of the settings. Click 'Yes' if you want Essbase Studio to inspect the model and make these adjustments to the model, otherwise, click 'No'.”
The intent of these adjustments is to eliminate potential validation warnings and errors, and it is recommended that you select “Yes.” If you select “No.” you can continue all operations with the model, but you are less certain of avoiding validation warnings and errors.
Duplicate member name support—Enables the model to support duplicate member names.
In an Essbase outline that supports duplicate member names, duplicates are allowed in different dimensions and under different parent levels. This greatly enhances ease-of-use in creating analytic applications where members (such as cities in a customer dimension and a supplier dimension) may have names duplicated.
Use Unicode character set—Enables the model to support Unicode character sets.
Use this option if you want your Essbase application to encode character text in UTF-8, enabling users with computers set up for different languages to share application data.
XOLAP Model—Enables the model to function as an XOLAP model.
See XOLAP Overview.
Optional: Click the Custom data load settings button to access the Define Data Load Settings dialog box where you can customize SQL for data loads.
Note:
This dialog box is enabled only when all the elements in a model are sourced from relational sources. If you do not customize SQL for data loads, the message “Custom SQL enabled: false” is displayed to the right of the “Custom data load settings” button.
See Overriding Standard Data Load SQL for more information.
Under Typed Measures Support, select a Date format.
The default date format is yyyy-mm-dd.
See Specifying Typed Measures for more information.
Note:
To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.