Obiee 简明教程

OBIEE – Calculation Measures

使用计算值对逻辑表中的值进行计算。它在存储库中逻辑列的聚合选项卡中定义聚合函数。

Calculated measures is used to perform calculation of facts in logical tables. It defines Aggregation functions in Aggregation tab of logical column in the repository.

Create New Measure

在存储库中的逻辑事实表中定义值。对其应用了聚合函数的任何列都是一个值。

Measures are defined in logical fact tables in repository. Any column with an aggregation function applied on it is called a measure.

常见的示例值包括 − 单价、销量等。

Common measure examples are − Unit Price, quantity sold, etc.

以下是在 OBIEE 中创建值的指南−

Following are the guidelines to create measures in OBIEE −

  1. All aggregation should be performed from a fact logical table and not from a dimension logical table.

  2. All columns that cannot be aggregated should be expressed in a dimension logical table and not in a fact logical table.

可以在管理工具 BMM 层的逻辑表中以两种方式定义计算值 −

Calculated measures can be defined in two ways in logical tables at BMM layer in Administration tool −

  1. Aggregations in logical tables.

  2. Aggregations in logical table source.

Create Calculated Measures in Logical Tables using Administration Tool

双击逻辑事实表中的列名，你将看到下面的对话框。

Double-click on the column name in the logical Fact table, you will see the following dialog box.

logical fact table

转到聚合选项卡，从下拉列表中选择聚合函数 → 单击确定。

Go to Aggregation tab and select the Aggregate function from the drop-down list → Click OK.

aggregation function

你可以使用表达式构建器向导中的函数添加新值。值代表可以加总的数据，例如总收入或总数量。单击顶部的保存选项以保存存储库。这也称为创建逻辑级别的值。

You can add new measures using functions in Expression builder wizard in Column source. Measures represent data that is additive, such as total revenue or total quantity. Click on the save option at the top to save the repository. This is also called creating measures at logical level.

Create Calculated Measures in Logical Table Source using Administration Tool

你可以通过双击逻辑表来源以打开逻辑表对话框来定义聚合。

You can define Aggregations by a double-click on Logical table source to open logical table dialogue box.

logical table source using administration tool

单击表达式生成器向导定义表达式。

Click on Expression builder wizard to define expression.

在表达式生成器中，您可以选择多个选项，如 - 类别、函数和数学函数。

In Expression builder, you can choose multiple options like - Category, functions, and mathematical functions.

一旦选择类别，它将显示其中的子类别。选择子类别和数学函数，然后单击箭头标记插入。

Once you select the category, it will show the subcategories inside it. Select the subcategory and mathematical function, and click on the arrow mark to insert it.

expression builder

现在要编辑值以创建度量，单击源数字，输入计算值（如乘法和除法）→ 转至类别并选择逻辑表 → 选择列以将该乘法/除法应用到现有列值。

Now to edit the value to create measures, click on source number, enter the calculated value like multiple and divide → Go to Category and select logical table → Select column to apply this multiple/division to an existing column value.

logical table category

单击确定关闭表达式生成器。再次单击确定关闭对话框。

Click OK to close the Expression builder. Again click OK to close the dialog box.