Provider settings
The widget has options to control these features for a selected database:
- Format of unique names
- Duplicate elements in subsets
- References to restricted elements
- Splashing
Changes to these options require the database to be restarted.
Unique names
The unique names of database elements can be in Long, Short, or Reduced format. This table shows examples of the different formats:
| Format | Example |
|---|---|
| Long Displays dimension name, all ancestors, and element name |
[Product].[All
Tires].[Car Tires All Season] |
| Short Displays dimension name, element name, and the number of occurrences |
[Product].[Car Tires All
Season].[1] |
| Reduced Displays dimension name and element |
[Product].[Car Tires All
Season] |
Subsets
Subsets are customized lists that can be used in place of, or with, the levels in a dimension.
For example, if a Region dimension contains Asia, Europe, Middle East, Americas, North America, South America, Australia/Pacific and Africa, but not EMEA (Europe, Middle East and Africa). You could use a named set for the EMEA region. This can result in there being multiple instances of some elements. Select Suppress duplicate elements in subsets to display each element only once.
Restricted elements
Access to elements of dimensions can be restricted through the use of permissions. This affects how you define lists and slices for such dimensions. If the setting Allow references to restricted elements is off, then report designers must ensure that all elements that are referenced in list definitions are accessible by all users. If Allow references to restricted elements is switched on, then a report designer can safely reference restricted elements in lists by selecting, for example, children, siblings, or descendants in the Application Studio list designer. In either case, only unrestricted elements of a list are returned to users.
We recommend that, if permissions are applied at the element level, you select Allow references to restricted elements.
Example
You have a report that shows all sales results by region. The list has been defined as Children of all Regions. Each regional sales manager might be given access to their own regions' sales results, but not to those of other regions. A sales director would have access to all regions elements, including the All Regions element. This scenario has these effects:
- If Allow references to restricted elements is disabled, then only the sales director sees data in that list. For all regional sales managers, who cannot see the All Regions element, the list fails because restricted elements must not be referenced in lists. But, a list defined as, for example, All elements on level Region, works for all users because no restricted element is referenced.
- If Allow references to restricted elements is enabled, then all regional sales managers see their regions' results, because the restricted element, All Regions, can be referenced by the list definition - Children of All Regions.
Splashing
You can specify the maximum number of cells that can be filled in one splashing operation. The limit is valid only for equal allocation and absolute distribution. The default maximum is 100000 cells. There is no limit on splashing in other modes such as weighted and basic.
Cell values that are calculated by rules can differ from values that are entered by splashing. By default, cells that are calculated by rules are excluded from splashing operations. To enable splashing, select Allow splashing on rule calculated cells.