0 Replies Latest reply on Jan 28, 2015 10:02 AM by user12188641

    Analysis is not peeking record due to it's created from two different cubes.

    user12188641

      We have created one analysis using two different cubes namely “AR Invoice C” and “Sales Budget Forecast C”, this both cubes have different number of dimension joined with it “AR Invoice C” Cube have around 12-13 dimensions where  “Sales Budget Forecast C” cube have 4-5 dimensions join with it.


      analysis.png


      Now the problem with me is, if any month does not have data for sales than for that month budget is also not coming where budget data is there in OBIEE.


       

      Also please find screen shot for both cubes from AWM showing its dimensions.

        We have renamed “AR_COST_C” cube at RPD Presentation layer to “AR Invoice C”.


      cost_awm.png

      budget_awm.png