Hello Cognos SMEs, I'm facing a peculiar problem with multiple charts of dashboards after performing the upgrade from 11.2.4 to 12.0.4 version.
I have a line chart showing 2 lines (Rolling 12 months CY and PY) with the Months column (Data type: Text, Usage: Attribute, Aggregation: None) shown on the x-axis. Only the month names are shown as I wanted the two lines to overlap and give a better view of comparisons of CY with PY. This worked well in 11.2.4.
After the upgrade was performed, the same chart shows only 1 line, and there is a yellow Asterix icon with the following message: "The data displayed has been limited.
Unaggregated data points are not supported by this visualization. Only the first values will be displayed."
I believe the problem is with the 'Members Display' section in the Properties for the month column, as when I select Display Options as 'Automatic', the chart works as expected, and I see both lines. However I lose the sorting order and the charts show from Jan to December (instead of April-March).
Has anyone experienced this issue or a similar one? And what can be some possible solutions, as I need to show the Rolling 12 months in that order instead of Jan-Dec.
Thanks in advance!