2 Replies Latest reply on May 8, 2017 9:21 AM by Gianni Ceresa

    Bar chart grouping by 2 dimensions

    c8523899-d78b-4c63-8c3f-a581895b306a

      Dear all,

       

      Please help me to create a stacked bar chart in Analysis in OBIEE like the picture below

      Capture.PNG

      I have a table data like this

          

      Fail_Reason_CodePeriodDirect_reasonIndirect_reason
      AIThisPeriod103
      AILastPeriod124
      TAThisPeriod72
      TALastPeriod104
      WEThisPeriod155
      WELastPeriod113
      RAThisPeriod139
      RALastPeriod75

       

      I think I should create a dimension with level-based hierarchy in RPD. I tried but seems I am on wrong way.

       

      Please help me.

       

      Thanks in advance.

      Pham