What are facts and dimensions in Obiee?

What are facts and dimensions in Obiee?

A Fact table has two types of columns − facts and foreign key to dimension tables. Additive − Measures that can be added across any dimension. Non-Additive − Measures that cannot be added across any dimension. Semi-Additive − Measures that can be added across some dimensions.

What is fact table and dimension table?

A fact table is the central table in a star schema of a data warehouse. A fact table holds the data to be analyzed, and a dimension table stores data about the ways in which the data in the fact table can be analyzed. Thus, the fact table consists of two types of columns.

Can we join 2 fact tables in Obiee?

It determines that the query wants Fact1 aggregated by DimADesc and DimXDesc. The only fact table that can aggregate by those two dimensions is Fact2.

What is data model in Obiee?

OBIEE data model is based on Dimensional Modeling. The underlying database tables are separated as Fact Tables and Dimension Tables. The dimension tables are joined to fact tables with specific keys. This is usually called Star Schema.

What are fact and dimensions?

Facts and dimensions are data warehousing terms. A fact is a quantitative piece of information – such as a sale or a download. Facts are stored in fact tables, and have a foreign key relationship with a number of dimension tables. Dimensions are companions to facts, and describe the objects in a fact table.

What is the difference between fact and dimension table with examples?

Facts tables could contain information like sales against a set of dimensions like Product and Date. Evert dimension table contains attributes which describe the details of the dimension. E.g., Product dimensions can contain Product ID, Product Category, etc.

What is implicit fact column in Obiee?

To guide OBIEE in the best choice, you need to select a fact attribute (measure) as an implicit fact column. The implicit fact column is used for queries that only select dimension attributes (no facts) from two or more dimensions.

How do you link two fact tables?

There are 2 approaches to do this:

1. Create a “fact table bridge” table. The bridge table contains the fact key columns of each fact table, plus any filtering columns required.
2. Create a new fact table containing all the required measures at the combined grain.

What is fact in fact table?

A fact is a quantitative piece of information – such as a sale or a download. Facts are stored in fact tables, and have a foreign key relationship with a number of dimension tables.

What is data model editor in reports?

The data model editor enables you to perform the following tasks: Link data — Define master-detail links between data sets to build a hierarchical data model. Aggregate data — Create group level totals and subtotals. Transform data — Modify source data to conform to business terms and reporting requirements.

What is data modeling in obiee?

What is Data Modeling in OBIEE? Dimension table is table which describes the business entities of an enterprise which describes the objects in a fact table. Dimension table has primary key which uniquely identifies each dimension row. Dimension table is sometimes called as lookup or reference table.

Why does obiee generate fact1 instead of fact2?

This is because the query that OBIEE generates has the Fact1 in the from clause, instead of having Fact2. This is because OBIEE is aware that there is no join condition between the two.

How to get the result of dim 1 in obiee?

OBIEE can easily figure out the result since DIM 1 is joined to both Fact 1 and Fact 2. In the case when Dim2.Column and Fact2.column is dragged on the criteria you will get null rows.

What is the difference between fact table and dimension table?

Dimensional modeling always uses facts and dimension tables. Facts are numerical values which can be aggregated and analyzed on the fact values. Dimensions define hierarchies and description on fact values. Dimension table stores the attributes that describe objects in a Fact table.