Calculated measures is used to carry out calculation of facts in logical tables. It defines Aggregation functions in Aggregation tab of logical column within the repository.
Create New Measure
Measures are defined in logical truth tables in repository. Any column with an aggregation characteristic implemented on it is referred to as a degree.
Common degree examples are − Unit Price, quantity offered, and so forth.
Following are the pointers to create measures in OBIEE −
- All aggregation ought to be achieved from a reality logical desk and now not from a measurement logical table.
- All columns that can't be aggregated must be expressed in a dimension logical table and not in a fact logical table.
Calculated measures may be defined in methods in logical tables at BMM layer in Administration tool −
- Aggregations in logical tables.
- Aggregations in logical table source.
Create Calculated Measures in Logical Tables the usage of Administration Tool
Double-click on at the column name within the logical Fact table, you'll see the subsequent conversation container.
Go to Aggregation tab and choose the Aggregate characteristic from the drop-down list → Click OK.
You can add new measures using features in Expression builder wizard in Column supply. Measures constitute information that is additive, inclusive of general sales or general amount. Click at the shop option at the pinnacle to save the repository. This is also referred to as creating measures at logical degree.
Create Calculated Measures in Logical Table Source the usage of Administration Tool
You can define Aggregations through a double-click on on Logical desk supply to open logical desk communicate container.
Click on Expression builder wizard to outline expression.
In Expression builder, you may pick out more than one options like - Category, functions, and mathematical features.
Once you select the class, it will display the subcategories interior it. Select the subcategory and mathematical characteristic, and click on on the arrow mark to insert it.
Now to edit the cost to create measures, click on on supply wide variety, enter the calculated price like more than one and divide → Go to Category and select logical desk → Select column to apply this a couple of/division to an existing column value.
Click OK to shut the Expression builder. Again click OK to close the conversation field.