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

    Analyze dimension data without fact




      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?