If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Column Chart issue when using Time dimension from a cube

Started by cognosjon, 29 Mar 2019 05:15:54 AM

Previous topic - Next topic

cognosjon

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

cognosjon