| Table of Contents |
|---|
...
There are many options to build and maintain the structure of each business segment. One or multiple can be used depending on the use case and access to source systems:
...
By default the order of the elements in the dimension will be as in the source, by turning this option on you can configure a different sort order, e.g. alphabetically.
...
Update Steps
Under Under "Update Steps" click the plus icon to create a new step, the next available step index will be pre-selected. Depending on the chosen source type additional fields will appear. After clicking "Ok" the new step should appear in the list and can be expanded and edited. A detailed description of source type specific settings for each step follows in the next paragraphs.
...
There are two types of template formats for the dimension loads the format is specified below. In both cases the "Total Rows" item is supposed to hold any attribute names in the following naming convention:
[Type] AttributeName[locale code], the locale code is optional.
Example: [S] Description[de] -> defines the German locale for a string attribute "Description"
» ByRollup
RowID | vType | vWeight | vParent1 | vParent2 | [vParentx...] | vAttribute1 | [vAttributex...]Example:
...
...
» ByParentChild
RowID | vType | vWeight | vElement | vParent1 | vAttribute1 | [vAttributex...]Example:
...
...