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.