double values of sum function

[#1]

hi all,

i have one problem here,

as shown in this picture,

                           dimensions                                   expressions

i have 2 dimensions (OSPH Pemegang Saham and PH Awal Pemegang Saham) based on sql queries, that related many tables too,

and 2 expressions (OSPH Pemegang Saham (sum([OSPH Pemegang Saham])) and PH Awal Pemegang Saham (sum([PH Awal Pemegang Saham])))

and also no synth table found on table layout,

the problem is, when i create the pivot chart using sum function for both dimensions, i found 2 double values from the source, (marked red on the picture)

can anyone help me?

thanks

[#2]

Hi ,

Pls can u provide some more information.

I dont see any double values in the picture you posted.

Thanks,

Robinson

[#3]

selvaraj,

i just updated the picture, double values are marked red on the picture

thank you

[sridhar240784]

Hi,

Did you tried running your sql query in SQL Client (example TOAD or SQL SERVER) and chcked the value? are you not getting the double counted figure?

-Sridhar

[swuehl]

I assume you just have multiple (double) records for these combinations of

OSPH Pemegang Saham and PH Awal Pemegang Saham

Maybe you could add a 3. dimension with a unique record ID (like rowno() created in the load)? This should show the multiple records then.

[#6 · Accepted solution]

thanks swuehl,

yeah finally the result correct, i forgot to add a unique dimension (transaction ID) before 

OSPH Pemegang Saham and PH Awal Pemegang Saham .

thank you all