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

Not able to aggregate for 'All' using a repeater table

Started by Dineshpullagura, 02 Mar 2015 04:25:59 PM

Previous topic - Next topic

Dineshpullagura

Hello,

I am creating an active report, using cube as my data source.

This is the scenario,  i have to display a measure in my report, i am using a repeater table for this which provides me extra items option to filter the data. I added two different dimensions, like year and  product type and quantity is my measure.

I want my report to show the quantity as one aggregated value over all the years  and product types by default. But my report is showing data for combinations of the two dimensions.

For example, i want total quantity to be displayed as 10000, but i am getting two different values for the two years i have,
6500 3500

If add more dimensions along with year , it is showing all the combinations.

Is there a way for my report to show the default value as total for all the dimensions, like
Years -> All
Product Type -> All

If i select any year, then my measure should be total for
years ->2013
Product Type ->All

Please reply if the explanation is not clear.

Thanks for your time.