COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Neerajra on 01 Mar 2017 06:54:08 AM

Title: Is it mandatory to enter series (primary axis) in report studio charts?
Post by: Neerajra on 01 Mar 2017 06:54:08 AM
Hi all,

I'm trying to create a column chart in Report studio and I have values for the default x-axis and y-axis and I don't necessarily need a value for the series (primary axis).

Is this mandatory? If not I'm not sure why my report comes up with 'No data' error.

Any help appreciated.

Thanks!
Neeraj
Title: Re: Is it mandatory to enter series (primary axis) in report studio charts?
Post by: CognosPaul on 01 Mar 2017 08:29:18 AM
All a chart needs is a measure with an aggregation other than 'None'. If you're getting "No Data", make sure that the measure is capable of rolling up without the other attribute.

Graphs use the same underlying query structure as a crosstab, recreate the graph as a crosstab and see what happens.
Title: Re: Is it mandatory to enter series (primary axis) in report studio charts?
Post by: Neerajra on 02 Mar 2017 04:33:32 AM
Thanks a lot CognosPaul!!! That really helped.. :)