Crosstab: BO 6.5 vs Web 3.1

[Former Member]

Hi,

I would like to reproduce in Webi XI 3.1 SP05 crosstab developed in BO 6.5 (Desktop).

The particularity of this crosstab is the crossbreeding of rows and columns, it displays the values of a dimension with datatype as Alphanumeric and not Number like a measure.

In BO 6.5, it's OK. Qualitative values are properly distributed among the columns and rows.

However in WebI, the result seems to be a Cartesian product. Qualitative values are the same across the row.

Concretely,In BO 6.5:

            Activity1 Activity2 Activity3

Group       A

Group       B                         B

Group       C         C

In WebI XI 3.1 SP05:

            Activity1 Activity2 Activity3

Group       A         A         A

Group       B         B         B

Group       C         C         C

How can we reproduce the BO 6.5's report in WebI XI ?

Thank you in advance for your help.

Best regards

Laurent

[former_member188911]

Hi Laurent,

can you show how the  data come from the dataprovider?

thanks

Simone