|
IA05.1 - Essbase Parameters
Use Essbase Parameters (IA05.1) to update any of the following for your
data mart: Application Name, Data Base Name, Drill Around (enable or disable),
External Data Sources, Data Mart Status, CSV Output Directory, and Run a
Server
Test.
Updated Files
OLAPDBM -
OLAPDIM -
Referenced Files
APPLICTYPE -
IA05.2 - Essbase Server Test
Use Essbase Server Test (IA05.2) to display the server message.
Essbase Login/Password: Type the login and password for the Essbase
OLAP destination of the data mart.
Updated Files
None.
Referenced Files
OLAPDBM -
ROLAPDBS -
IA05.3 - Star Schema Parameters
Use Star Schema Parameters (IA05.3) to define the storage and optimization
settings for Microsoft Analysis Services.
Data Mart Status: This field displays the status of the data mart. You
do not need to enter a value in this field.
Storage Option: M (MOLAP, multidimensional), R (ROLAP, relational),
H (HOLAP, hybrid of relational and multidimensional)
Aggregation Option: Select how aggregation will be performed. If you
select P (Performance), aggregations are performed until the performance
increase
reaches the percentage entered. For most data marts, 60 892354889s adequate. If you
select S (Storage), aggregations are performed until the storage limit is
reached.
Aggregation Limit: In the first field, type a number for the aggregation
limit. This number represents the maximum storage size or minimum performance
percentage used to perform aggregations.
In the second field, select the option that matches the aggregation
option: (Percent) for performance, MB (MegaBytes) or GB (GigaBytes) for
storage.
NOTE If you are entering storage size, do not exceed the amount of
storage available.
Updated Files
OLAPDBM -
Referenced Files
APPLICTYPE -
INVOKED Programs
IACP
|