OBIEE Content Level Question

dilek

Hello everybody,

I try to create a business model in obiee 12c. Here is my scenario;

I have 2 fact tables (Fact A, Fact , 3 dimensions (Dim Time, Dim A, Dim

Fact A --> Dim Time, Dim A (time dimension content level: month)

Fact B --> Dim Time, Dim B (time dimension content level: hour)

When I save the model, it gives warning saying;

Logical dimension table 'D_TIME' has a source 'D_TIME' with aggregation content set to level 'Hour'. The same dimension has aggregation content set in fact source 'F_UZL_DNG_DIGER.F_UZL_DNG_DIGER' to a higher level.

I know that, more than one fact table can be joined in business model by using content level setting. Where is my fault? Can you help me please.

Regards,

Thomas Dodds

Since you have 2 specific granularities month and hour ... really you should have 2 dimensions:  Date dim & Time dim ... then both facts are related through the conformed level of date ... one fact can be aggregated to month from there and one can be aggregated to date from time ...  your fact B with time in it needs to have date as well.  These keys should be separated out and part of the granularity of the physical table.

Try to create conformed fact stars ... what you've got will cause you trouble

dilek

Hi Thomas, thx for your answer. It helped me a lot for the above error.

But now, I have another problem, that is "none of the fact tables are compatible with the query request"

This occurs when I add an extra column that I did not put in logical dimensions. For non conformed dims (Dim A, Dim , I create 2 more logical dimensions (level based), and put total level and child level as pk.

Then set fact tables content level as total and joined table pk. However, when I want to use an attribute columns from Dim A or Dim B (for example type column), then it gives the error above

Here is a snapshot what I want to say;

Thomas Dodds

none of the fact tables are compatible with the query request

This means that the BI server is not encountering the logical fact star model it requires. 

OBIEE - Query Compiler [Gerardnico]  (scroll down to the bottom of this page)

If you don't have a star model (you have some logical snowflaking) you can model around it following these examples:

https://www.google.com/search?q=nonconformed+dimensions+obiee&oq=nonconformed+dimensions+obiee&aqs=chrome..69i57.6334j0j…