The preferences that you specify are stored as part of the Smart Slice definition, and they override the global preferences set in the Options dialog box. Users can select options in the Options dialog box that are not grayed out. For more complete information on options, see User PreferencesFrom the Smart Slice Designer, select Options, then select from the dropdown menu or enter preferences:
Table 4. Smart Slice Preferences
Name | Value | Data Source |
---|---|---|
row_suppression: missing | Disabled: displays data rows containing cells with missing data Enabled: suppresses data rows that contain cells with missing data | Essbase, Planning |
row_suppression: emptyBlocks | Disabled: displays data rows containing cells with missing data Enabled: suppresses data rows that contain cells with missing data | Planning |
col_suppression: missing | Disabled: displays data columns containing cells with missing data Enabled: suppresses data columns that contain cells with missing data | Planning |
zoomin: ancestor | bottom: retrieves data for the lowest members in a dimension top: retrieves data for the highest members in a dimension | Essbase, Planning |
zoomin: mode | children: retrieves data for the children of the current member descendents: retrieves data for the descendents of the current member base: retrieves data for level 0 members | Essbase, Planning |
includeSelection: val | Enabled: retains the selected member along with the other members retrieved as a result of the zoom | Essbase, Planning |
repeatMemberLabels: supression | Enabled: suppresses repeated member names Disabled: displays repeated member names | Essbase, Oracle BI EE |
missingLabelText: val | The text to be displayed in cells that contain missing data | Essbase, Planning, Oracle BI EE |
noAccessText: val | The text to be displayed in cells containing data not permitted to the user | Essbase |
aliasTableName: val | Displays the selected alias table of the Smart Slice | Essbase, Planning |
essIndent: val | None Subitems: indents only descendents Totals: indents only ancestors | Essbase, Planning |
numFormat: val | A sample number that displays your selections for numFormat: thousands separator and numFormat: decimal places. | Essbase, Planning, Oracle BI EE |
numFormat: thousands separator | Yes: use a thousands separator No: do not use a thousands separator | Essbase, Planning, Oracle BI EE |
numFormat: decimal places | The number of decimal places data displays | Essbase, Planning, Oracle BI EE |