Oracle BI metadata repository - IV. Create custom indicators

In " Oracle BI metadata repository - III. Creating Presentation Layer (Presentation Layer) "is described" step-by-step "approach based on both business model to build a presentation layer to which users will access analytical system. The aim of this article is to show ' Step-by-step "approach in how to create their own business model and how the calculations are then made ​​available to end users.

The resulting presentation layer and business model accompanied by their own calculations

NOTE: Calculations can be created in two ways, namely:

1. based on existing logical columns (described in this article)
2. based on physical columns, see more. here

Both ways you can assemble any combination of indicators and functions using the BI Server or the source database. BI Server itself includes a library of various aggregation, text, math, conversion and other functions (see the exact list. Chapter SQL Reference here ) that are transcribed before executing a query into the specific functions of the source database. If you want to use certain features napřímo source database , to that end, the BI Server provides three functions called Evaluate (see description. here ). 


A / Creation profits
first Select facts table "F_PRODEJ $"> right click> New Object> Logical Column ... 2nd Name index> select "Use existing logical columns as the source"> Expression Builder and create a calculation of B / creation order of revenues and expenses first Indicators of "Order of income" (VYNOS_PORADI) and "order cost" (NAKLAD_PORADI) to create the same way as earnings, instead of just "reading the two indicators" use the analytic function RANK (







)


2nd Move and rename the new indicators in the Presentation Layer
Note: Note that for the newly defined indicators did not have to set (or even not set) aggregate function. The reason is that the use of pre-logical indicators of aggregate functions which the particular indicator formed. Eg. indicator of profit is made ​​up of logical indicators SUM (Revenue) - SUM (cost) . 


The result is a presentation layer for new indicators added

The next part will be devoted to re-Business model - more settingshierarchies for dimensions and create level-based and financial ratios .