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

938767

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