COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sravantig on 01 Mar 2012 09:51:55 AM

Title: Cube in report studio--- please help
Post by: sravantig on 01 Mar 2012 09:51:55 AM
I'm trying to create a line chart... from a cube(in source tab)
x axis--- years
y axis--- turnover rate
series--- managers, associates

i want to show the turnover rate for the complete ABC company for few years.

My QUESTION is... can I combine managers and associates as one and insert in series? please help me.. I'm a newbie
Title: Re: Cube in report studio--- please help
Post by: absriram on 02 Mar 2012 08:49:14 PM
You have to create 2 queries, one for managers and one for associates. Union these two queries and then create the chart based on the union.

Sriram.
http://www.cognosonsteroids.com (http://www.cognosonsteroids.com)