Content Level In OBIEE

Content Level : 

It Always specify the content level in all logical table sources, both in facts an dimensions.

• It will allow BI Server to select the most optimized LTS in queries.
• It will help consistency checker finding the issues in RPD configuration, preventing runtime errors.

Implicit fact :

• It prevents users from getting wrong results if they create a report without fact column.
• Use a constant as the implicit fact column to optimize performance

Difference between Alias Table & Duplicate Table

Alias Table:

1. Its a mirror image of the Parent Table
2. We can't edit or modify Alias Table
3. When there is a need to avoid self-join or circular join
4. Changes made in Parent Table is automatically reflected in Alias table

Duplicate Table:

1. Its a Copy of the Parent Table
2. We can edit/modify/delete columns in Duplicate table
3. Changes made in Parent table are not reflected in Duplicate table
4. Used when there is a need to use few columns of Parent table.

Next Time ...

How To Find Out Old Table Names In The Exiting Reports

Hi,

Problem:I created reports using some tables(Fact Or Dime) after Long time changed table names that time how to find old reports.

Solution: we can solve this problem using catalog manager.find bellow steps

1.Catalog Manager->Open the catalog (online or offline)
2.Select Catalog Root 
3.Go To Tools
4.Create Report
5.Select type to report on Analysis
6.Select required columns to Columns in Report
7.save it as .csv

Thanks,