1 Reply Latest reply: Jul 25, 2013 8:46 AM by Rajesh Gurram - BI RSS

    OBIEE 11g 11.1.1.7 NON Confirmed dimensions and facts

    911309

      Hi All,

       

      In OBIEE 10g if we had non-conformed dimensions we used to work with by defining logical level of the conformed dimensions to grand total and confirmed dimensions to detail in the LTS of the fact table

      and also set metrics to grand total level.

       

      But in OBIEE 11g doing same is throwing error

       

      [nQSError: 14025] No fact table exists at the requested level of detail

       

      How do we achieve this?

       

      Regards,

      deep