Singele value for a break column

building reports webintelligence
1

We have XiR2 with SQL 200.

We have a simple 6 column report with a break on the2nd column.We need to display the 5th column thats a measure only once for every value of the 2nd column.Ie if the measure value for that column is the same trhen display only once.

sasi70 (BOB member since 2007-01-10)

2

Could you try to explain what you want to do in a different way. I am afraid I couldn’t visualise what you are after from the initial description. It helps if you can provide an example.

dfoster99 :uk: (BOB member since 2010-11-05)

3

Thanks for your time to get clarity.What i needis to only display the cvalue of a measure column once when it has 2 values for the same column on which a break is applied.eg

abc 123 20
def 123 20
erf 234 40

should come up as

abc 123 20
def
erf 234 40

I have a break in the second column(with value 123,234)

sasi70 (BOB member since 2007-01-10)

4

Isn’t it incorrect, because the actual value is 40 if we dont consider the first dimension, it has splitted the 123 values in to 2 (20’s) because the first dimension has 2 different values abc and def.

jprasanthram :switzerland: (BOB member since 2010-12-10)

5

Thanks.
no ,20 is the value for the 2nd column and irrecpective of the 1st dimension we need the measure column value only once for the break

sasi70 (BOB member since 2007-01-10)

6

I am still stuck with finding a solution.Appreciate on any ideas.Thanks

sasi70 (BOB member since 2007-01-10)

7

You may apply a break on the measure then on the dimension which will eventually display only the cv for that dimension .

Regards.

Rmbodvp :india: (BOB member since 2010-10-14)

8

define a variable as

Sum([C_Column]) ForAll ([A_Column])

use this as the 3rd column

then set break on 2nd and 3rd columns. This should give you the desired result.

Mohan :us: (BOB member since 2002-08-15)