0 Replies Latest reply: Feb 16, 2013 6:52 AM by user4279685 RSS

    Problem with aggregation in graphs

    user4279685
      I have a five year trend report in a vertical bar graph in OBIEE 11. The vertical axis contains the periods and the horizontal axis the expenses. Years 1 and 2 appear correctly, however years 3-5 do not. It seems that years 1 & 2 are using Sum aggregation (which is correct), while years 3-5 are not aggregating at all and just displaying one of the values from the array.

      I have the data displayed correctly in a pivot table on the same analysis correctly. I have also checked to ensure that all facts are setup in the same way on the analysis and the RPD layer. Any advise would be helpful.

      Thanks in advance -
      Chris

      Edited by: user4279685 on Feb 16, 2013 7:52 AM