HOW TO: (Do an impossible crosstab) OR (hide crosstab headers AND add rows text)

Cognos 8 Business Intelligence Report Studio
1

Hi, everybody.

Here’s my problem. I have a Cube with a hierarchy called Zone and the following measures: CONTRIBUTION, REVENUE, PLANNED_CONTRIBUTION, PLANNED_REVENUE.

I need to make a crosstab like this:

        | Zone                   | Zone                   |
        | CONTRIBUTION | REVENUE | CONTRIBUTION | REVENUE |
REAL    |         1234 |    1234 |         1234 |    1234 |
PLANNED |         1234 |    1234 |         1234 |    1234 |
DIFF    |         1324 |    1234 |         1324 |    1234 |

So, in the “Contribution” column, I need to show de CONTRIBUTION measure in “Real” row and PLANNED_CONTRIBUTION in “Planned” row. The same thing with REVENUE. Is it possible to do that?

I think it’s impossible, so I was thinking to make two different crosstabs like this:

| Zone                   | Zone                   |
| CONTRIBUTION | REVENUE | CONTRIBUTION | REVENUE |
|         1234 |    1234 |         1234 |    1234 |

But in the second one showing the “PLANNED” measures, place it under the first crosstab and then HIDE the headers, so it appears to be only one table, but now that I’ve tried to hide them I thinks it’s impossible too :frowning:

Can someone help me with any of those posibble solutions or, even better, propose a new solution?

Thanks.

2

You can do this in the query level. Create two queries one for Real and One for Planned. Union these queries in Query 3 and use Query 3 in crosstab.

Sriram.
http://www.cognosonsteroids.com