Webi Crosstab - duplicate values

building reports webintelligence legacy
1

Hello All,

I have designed a simple crosstab report in Webi. The body values in the crosstab are being replicated. To verify my SQL and Universe, I have designed the same in the full client 6.5 and the results are fine. I have attached word document with the screen shots. Please look into it and let me know where I went wrong.

Thank you,

Jay
Crosstab.zip (78.0 KB)

jayaramponnada (BOB member since 2005-01-04)

2

Hi Jay,

Do you have multiple data providers in your report? Even in WebI 6.5, you can’t link them.

Judy

JMulders :us: (BOB member since 2002-06-20)

3

Judy,

Thanks for your reply. I dont have multiple data providers in the report.

I’m still :crazy_face:

Jay.

jayaramponnada (BOB member since 2005-01-04)

4

Looks to me like the object you are displaying in the body isn’t properly defined in terms of the other objects. That is why I asked if you had multiple data providers.

In other words, since it is just repeating values for every cell in a row, it is not properly related to the field that is displayed across the top of the crosstab. I would start investigating that.

Good luck,
Judy

JMulders :us: (BOB member since 2002-06-20)

5

Hi Jay,

The problem u have faced is the same problem i am facing, i am getting duplications of my vertical axis values, whereas my horizontal values are dates.

Please check the below link:

please do the needful…

coll (BOB member since 2011-11-03)

6

To solve the issue of duplicate values in crosstab report- do the follwing:

create a variable
assign the object that is repeating to this variable
make the variable as a MEASURE (irresepctive of its datatype )
drag the new variable in your cross tab report

mrunalinia :uk: (BOB member since 2009-01-05)

7

This will solve your problem definitely…

coll (BOB member since 2011-11-03)