Morning I'm hoping someone may be able to point me in the right direction.
I've a request to build a dashboard in Cognos Analytics 11.0.13 that is sourced against one of our aggregated Sales cubes.
Whilst this isn't an issue I have encountered a very strange problem when using a column chart and the standard date dimension within our cube.
The request is to display revenue by period and then coloured (grouped) by year. This should then allow them to compare period against period for the last two years.
The attachment titled chart 1 details how the column chart is plotting this data, The date elements detailed are all from the time dimension modelled within Transformer. The chart generates as expected if used within any other studio.
If I create a regular Time dimension and then add either year or period from that regular dimension into the chart I get the expected output, this is shown as attachment chart 2.
Is there a reason as to why this is happening?
I've also tried this within 11.1.1. and I get a different output, in that version the x axis is split by year so displays the correct values but not side by side for comparison.
Any suggestions would be appreciated
second attachment showing how it should display