Complex Crosstab Report

building reports webintelligence
1

Hi all,

Is it possible to achieve the following using a crosstab or any other alternative method in Web XI:

Where the:

Year = Dimension
Week = Dimension
Gain, Loss, etc. = Measure

I guess I’m trying to group by Measures and have the Dimensions act like Measures and sit under the Measure.

I know I can create seperate Blocks and just hide the Week column on all new Blocks next to the first, but was just wondering if the above is possible with the Crosstab functionality?

Thanks!

schone (BOB member since 2009-02-16)

2

It is possible…!!

Just place crosstab template in report and place objects as you want.

If you face any issues just post them…

Thanks

BOCP (BOB member since 2007-07-02)

3

Hmm…

When I try it just inserts a column next to the previous measure.

So that I end up having

2007 2007 2007 2008 2008 2008
gain loss … gain loss …

I want to have

2007 2008 2007 2008
gain gain loss loss

Any ideas?

schone (BOB member since 2009-02-16)

4

Apply Break on gain and loss.

Thanks

BOCP (BOB member since 2007-07-02)

5

Hmm

It just breaks the columns up so that it is a seperate years.

The Gain and Loss aren’t actually variables or dimensions they are measures. So when I drag them up the top they are actually numbers.

Any more ideas?

schone (BOB member since 2009-02-16)

6

Can you post snap of it… If not possible

Create variables for Gain and Loss , they must be Dimensions and place them in report and place measures in below of them.

If it not in your required form then apply breaks on Dimensions or on Year, to get them.

Thanks

BOCP (BOB member since 2007-07-02)

7

This would be a lot easier to achieve if you had a dimension indicating if it’s a gain or a loss we’re talking about. I’ll explain:
At the moment, from what I can gather, you have the following objects:
year (dim)
week (dim)
gain (meas)
loss (meas)

if you have the freedom to change your query (or possibly universe/ database) to this form, it would be easy:
year (dim)
week (dim)
type (dim)
value (meas)

Where type is a String, indicating either loss or gain.
You can then take this dimension, but it in the horizontal header of your crosstab, and break on it, as others have suggested.

-Ethan

ethan1701 :israel: (BOB member since 2004-05-05)