Why Navigational attribute work as characteristic in Reporting and Modelling in SAP BI

Hi All,

In this post, i am going to explain that we all know Fact table is surrounded by dimension table and master data in connected to dimension tables using SID's.

So any master data object which has SID can act as characteristic in reporting or in Cube.

If you add an attribute to any characteristics, we know what are all the tables will generate.

Display time independent -- P Table

Display time depended -- Q Table

Navigational time independent -- X Table

Navigational time dependent --- Y table.

If you check P and Q table in BI system, it will not contain SID values. But if you check X and Y values, it will contain SID values for this characteristic and we will have SID values of main characteristic(to which this is navigational attribute).

The following figure illustrates the relationship between X table and the SID table of navigational attribute.

Let’s take we have defined LOCATION as navigational attribute for 0CUSTOMER.

As navigational attributes contains SID values, it will act as characteristics in reporting and Cube. 

Document Link: Click me to read the document for characteristic tables structure 

 Hope it helps...