The resulting presentation layer and business model supplemented by a hierarchy, level-based and RatiosA / Creating hierarchies for dimensions Note: The hierarchy of the OBI allow end users to interactively drill / decay values within the dimension. In the current version is natively supported by the OBI-based Level (Balanced) hierarchy. If you need to deal with Value-Based (Unbalanced / Ragged) hierarchy, then instructions can be found here . Of course, in one dimension can have multiple hierarchies, as it can be found here .
1st Select a Business Model "Sales"> right click> New Object> Dimension ... 2nd Name hierarchy third Insert the highest level of the hierarchy in a dimension, a dimension, select the> right click> New Object> Logical Level ... 4th Name the level and mark it as possibly "Grand total level"Note: Mark footing Grand total level is not mandatory . Grand total level is only when you need to create a Level-based indicators for the highest level of dimensions, but the actual dimensions of this level ( "ALL") lacks.Eg. dimension for the "Period" is usual to have the highest level of years, ie. Economics is missing . 5th Insert the lower level of the hierarchy in a dimension, select the level of "ALL"> right click> New Object> Child Level ... 6th Name the level and estimate the number of elements Note: How to make / find the exact number of elements in the dimensions can be found here on the 7th Load the lowest level of the hierarchy in a dimension, select the level of "CELA_EU"> right click> New Object> Child Level ... 8th Name the level and estimate the number of elements Note:How to make / find the exact number of elements in the dimensions can be found here on the 9th Drag the column EU_CELKEM logical hierarchy to the level CELA_EU and the level of STAT STAT 10th Both columns (EU_CELKEM and STAT) as a mark "Logical Level Key" (ie the key through which the drill), select the column level> right click> New Logical Level Key ... 11th Same way, insert the other dimension hierarchy for PERIOD (YEAR> KVARTAL) and sales channels (PRODKANAL_VSE> PRODKANAL).Period hierarchy for the dimension currently do not select a Time Dimension! (will be explained in the following part) B / Creating level-based indicators Note: Level- based index is an indicator whose values are calculated on a specific dimension level or a combination of levels of different dimensions. Example: I want to create a report showing the ratio of "national income" to "revenue accruing to the whole EU." I was able to create it, I need to know the yield of individual states, the total sum (ie total earnings of all states), and the need for rate I get on the same line in the report as income the individual states - this ensures I Level-based index calculated on The whole dimension of the EU level Geography. 1st Select income indicator (table facts "F_PRODEJ $")> right click> Duplicate 2nd Rename the income indicator # 1, select it> right click> Properties ... > Name: VYNOS_ZA_ EU's third Switch to the Levels tab> set the level for the dimension Geography CELA_EU 4th Do the same for indicators of the costs and gains (the result is the location of pointers to the appropriate level of the hierarchy dimension Geography) C / formation ratios 1st Select facts table "F_PRODEJ $"> right click> New Object> Logical Column ... > Name pointer POMER_VYNOS_ZA_EU > select "Use existing logical columns as the source"> ... Expression Builder and create the calculation of income to revenue accruing to the EU .2nd In the same way, create Ratios costs to those of the EU and the profit to gains for the EU . 5th Move and rename the new indicators to the presentation layer (the hierarchy will be used automatically) results are based hierarchy for the dimension Geography, Period, and sales channel, then level-based and Ratios The next part will be re-dedicated business model - specifically how to set time dimension and how to create indicators for comparing the time of the "period" Ago and "period" Today .
Posts
