8 Replies Latest reply on Aug 4, 2017 9:12 PM by Christian Berg

    Analyze dimension data without fact

    3310714

      Hi,

       

      I have this simple model: 

       

      D_REGION <--- F_SALES ---> D_STORES

       

      If I want to get a list of regions (D_REGION) and stores (D_STORES), I get the error "Cannot find logical source coverage for logical columns"

       

      If I include a column from F_SALES, then no issues.  Is there a way to force OBIEE to go through the F_SALES table when I'm just interested in analyzing dimension data?