| Wiki Markup |
|---|
{scrollbar} |
...
Use the Format construction mode in cases where you have a given code that allows you to establish the hierarchy of the dimension's categories. For example, in the Accountancy Plan, there is a code for each Item, defined as follows:
"n.n.nn.nn" |
Each "n" represents a digit between 0 and 9, and each code represents a detail level of the code similar to its parent. For example, the Item 1.1 is a detail level of code 1, just as 1.2, 1.3, etc. are. The item 1.1.1 is subordinate to 1.1, and so on. This is how you define an Accountancy tree, where the sum of the entries to the children items accumulates to form the balance of the parent account.
In this instance, you must declare the dimension that represents the Accountancy Plan with the Format construction mode. This allows O3 to automatically create hierarchies from the values for the field representing the code in the Data Sources. Notes
The values for "n" can be any alphanumeric character. Also, the delimiter is not restricted to . (period), but can be any character.
| Section | |||||
|---|---|---|---|---|---|
|
...
From
...
...
0
...
1
...
2
...
1
...
4
...
2
...
7
...
2
|
|
|
Adding a Format Dimension
...
Use the Add Dimension command or the Insert Dimension command to add a dimension in format construction mode.
anchor
To add a dimension in format construction mode:
- Select the Dimension branch in the Design tree.
- Add a new Dimension
- To add a dimension
- to the end of the list, choose the Add Dimension command.
The dimension is added and the Properties
...
- Pane is displayed.
- To insert a dimension right after an existing dimension, select
...
- it and choose the Insert Dimension command.
The dimension is added and the Properties
- it and choose the Insert Dimension command.
...
- Pane is displayed.
- Turn on the Format radio button.
- Complete the fields in the Property Pane.
- To add a field to the Levels table, choose the New Field button. A row adds.
- Double-click on each field in the row to enter a value.
- To remove a field from the Levels table, click on the row, Choose the Delete Field button. The field is deleted.
- To continue adding or deleting fields, repeat steps 5 through 6.
Notes
- The From and Length definitions do not include the delimiting periods.
- Changes made in the Property pane apply when you leave the pane or perform another operation in O3 Designer.
A Sample Format Dimension Property Pane Anchor
The Dimension Property Pane - Format Construction Mode
In Format construction mode, the dimension property pane includes two tabs:
- Description
- General
...
- Order
The Description Tab
Property | Description |
|---|---|
Name | Enter the name of the dimension. |
Description | Enter a description of the dimension. |
The General Tab
Property | Description |
|---|---|
Default Value for Null Fields | Enter the label of the special node created to accumulate the registers in cases where data from the Measures Data Source has null values in the identification of this dimension key, or out of range values for the hierarchy category. |
Store Dimensions As | For every dimension you can select any of this options to store the elements of the dimension. To select one you must know how many total elements (for all levels) the dimension will have.
|
Related Dimension | Links a dimension with another with the same structure and similar information. (See Related Dimensions) |
Key | Enter the field name, from the Data Sources, that contains the categories for this level. |
Short Label | Often the categories provided by the field associated with the key correspond to element codes. You can assign a label to clarify this for the O3 Browser end-user. |
Levels Table | Specify each of the levels in this table. Indicates the position of the code in the From field, and the length of each level, in characters. |
The Order Tab
This section refers to a mechanism that activates rankings from O3 Designer during the design phase of the model.
Property | Description |
|---|---|
Activate Order | Activates the automatic ranking of elements in the dimension. |
All Elements | Indicates that all elements will be displayed after sorting |
First | Indicates that only the first N elements will be displayed after sorting. |
Show Others | In cases when only a few elements are shown, it is possible to include an extra element, called Others, that summarizes those left out of the view. |
This feature does not imply the sorting of elements in the hierarchy. This is just a presentation feature. To sort elements in the dimension see the sorting options in the properties pane for dimension levels in standard dimensions
...
| Wiki Markup |
|---|
{scrollbar} |
| Child pages (Children Display) |
|---|