Print Page - Tuple Dimensional Reporting

Title: Tuple Dimensional Reporting
Post by: cognos05 on 26 Feb 2015 04:06:54 PM

Hi,

I have a crosstab where I have to show my core product and new product sale.

Rows Sales on core product Sales on New Product

Distributor A 444 64
Distributor B 342 26
Distributor C 232 55

Here my core products are a set of products and new products are set of products.

What should my data item expression for column1 i.e Sales on core product be .

I tried tuple(Product1, Sales).

My issue is I have a set of products defined under core products from different product level).

Suggestions on expression for core product sales if my core products has 3 products.

Thanks,
Nithya

Title: Re: Tuple Dimensional Reporting
Post by: cognos05 on 27 Feb 2015 07:44:28 AM

Used this one and got the result

Total(Sales within set set(CoreProducts))

Thanks,
Nithya

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 26 Feb 2015 04:06:54 PM