Crosstab

[UcfMike]

In Impromptu, it was possible to reference individual measures in a crosstab measure. This made it easy to do calculations on the crosstab data.

How is this done in Report Studio?

So if the crosstab produces the following when run:

A B
Z 1 3
Y 7 8

and I wanted to do a calculation using the value from Row Z Column B, how would I do that.

 

[mennooo]

use the tuple (Z,B) function

Regards

Menno

 

[ict2000]

Have you tried to modify the query item that is used as the crosstab measure? Change it to something like:

Case
when (row = 'Z' and col = 'B') then your calculation expression
else normal
End

 

[UcfMike]

I did something similar to what you suggested ict2000, and was able to get the results I wanted.

Thanks for the tupel suggestion menoo. I couldn't make it work, and I'm wondering if it's because I'm not using dimensional data.

 

[blom0344]

Very true, Tuple is within the MDX domain used for dimensional sources!

Ties Blom

 

[UcfMike]

That's to bad. It still seems odd to me that Cognos would make it so easy to access specific crosstab intersections in Impromptu, but make it a chore in Report Studio.

Thanks for everyone with their help on this.

 

[blom0344]

I have no experience with Impromptu, but client-based BI software (as BO desktop intelligence, formerly the client BO tool) managed to do some pretty neat things in crosstabs that a Web-based tool skips..

Ties Blom