The following table lists the properties of hierarchy/level/attribute in an Analytical Object.
Item | Property | Values | Comments |
Hierarchy | Name | Type yourself | You can see the name for this Hierarchy on the High Speed View and reports. |
‘All’ member caption | Type yourself | Caption to be displayed on High Speed View to show the summarized value. | |
Field | Select from list | Value of the field in case of a Time type dimension. | |
Calendar | Select from list | In case of a Time type dimension, for the chosen date field you can select Calendar as ‘None’ to specify Year-Quarter-Month-Day as YQMD, YQM, YQD, etc. under Levels. In case of ‘Standard’ Calendar, along with the levels you can specify the Start and End Dates.
You can also customize the Standard Calendar according to your business needs. For example, an organization may be using a twelve-month Gregorian calendar starting on January 1 and ending on December 31st. However, some organizations may want to use a fiscal calendar that defines the fiscal year used by the organization. |
|
Levels | Select from list | Choose from YQMD, YQM, YQD, and so on. | |
Date | Start Date
End Date |
Specify the first date, month or year in fact table. You can also specify a fixed start date from calendar
Specify the last date, month or year in fact table. You can also specify a fixed end date from calendar |
|
Level | Name | Type yourself | You can see the name for this Level on the High Speed View and reports. |
Field | Select from list | Value of the field in case of a Regular type dimension. | |
Display Field | Select from list | Display name of the field in case of a Regular type dimension. | |
Data Type | Read only | Data type of the field in case of a Regular type dimension. | |
Secure Using Parameter | Select from list | You can choose from the secured parameters to restrict user to view cube data. | |
Hyperlink | Select the option | In case of a hyperlinked field (specified at the analytical object level), you can drill down to open another report or URL on clicking the value of field. Refer “Working with Hyperlinks” under Common Help section to know more about hyperlinking. | |
Level Format | Select from list | If you have specified levels for a TIME type dimension, you can choose a Level Format to display a particular year, month, quarter or day. | |
Attribute | Name | Type yourself | You can see the name for this Level on the High Speed View and reports. |
Field | Select from list | Value of the field in case of a Regular type dimension. | |
Display Field | Select from list | Display name of the field in case of a Regular type dimension. | |
Data Type | Read only | Data type of the selected attribute | |
Secure Using Parameter | Select from list | You can choose from the secured parameters to restrict user to view cube data. |