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

Repeating Cross Tab

Started by stevekoz, 14 May 2012 03:26:21 AM

Previous topic - Next topic

stevekoz

I have a number of cross tab reports that need to be created to build a subset of data.

The data in the columns of these cross tab are always going to be the same. However, i need to change the data the table looks at in the rows.

So one crosstab would look as follows -

                                        MTD      M-1  YTD  YTD-1
Sales by Channel Vol
Sales by Channel NRR
Sales By Channel Cont

Then i need to create a second cross tab which is by -
                                      MTD     M-1   YTD   YTD-1
Product Family Vol
Prodcut Family NRR
Product Family Cont

and so on, each crosst tab pivoting on the same values but with a different attribute.

Is there a way of creating a report structure in Report Studio that could simply contain the relevant Columns and then as a perhaps a prompt choose the relevant level of the report or set it to repeat.  I thought adding a repeater from the insertable objects list would allow me to do so , but when i extract the report it only pulls out the first crosstab so i'm now a little stuck.

Cheers

blom0344

You can make the attribute dynamic by refering to a parameter value in the definition of the dataitem used in the layout:

CASE
?PARAM_ATTRIBUTE?
WHEN 1 THEN [SALES_BY_CHANNEL]
WHEN 2 THEN [PRODUCT_FAMILY]
....
....
ELSE NULL
END

The ?PARAM_ATTRIBUTE? is then the parameter value associated with a text prompt that is populated with all possible Attribute values.

Here the assumption is made that each attribute is represented by its own dataitem..