OBIEE Error [39074] Logical dimension table has a source with aggregation content set to level 'Deta — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Error [39074] Logical dimension table has a source with aggregation content set to level 'Deta

Question
2
Views
0
Comments
938767
938767 Rank 4 - Community Specialist
edited Aug 13, 2024 7:17PM in Oracle Analytics Cloud and Server

I'm having an issue setting up my level based logical dimension.

I have a dimension 'quote' with two levels. The top level is the 'quote' level, and the lowest level is the 'detail' level which contains all the line items included on the quote.

I have one fact that joins to the detail level of the quote, and a different fact that should only be displayed at the higher level.

In the higher level logical fact table source, I set the content level to the quote level. For the other fact that is more granular, I set the content level to use the lower level.

Everything works as expected. The 'higher level' shows up as long as you don't pull in one of the lower level attributes - exactly as I expect. The only issue is my RPD now has this **warning** that I can't get rid of:

    Business Model Client:

    [39074] Logical dimension table 'dim_crm_quotes' has a source 'xxdw_d_crm_quotes_items' with aggregation content set to level 'Detail Level'. The same dimension has aggregation content set in fact source 'fact_crm_dyn_opportunities.opp, conv' to a higher level.

I am on OBIEE 11.1.1.7