Setting Smart Slice Preferences

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

NameValueData 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: valThe text to be displayed in cells that contain missing dataEssbase, Planning, Oracle BI EE
noAccessText: valThe text to be displayed in cells containing data not permitted to the userEssbase
aliasTableName: valDisplays the selected alias table of the Smart SliceEssbase, Planning
essIndent: val

None

Subitems: indents only descendents

Totals: indents only ancestors

Essbase, Planning
numFormat: valA 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 placesThe number of decimal places data displaysEssbase, Planning, Oracle BI EE