Union Issue In Report Studio

[ak80]

Hi Cognos Experts,

Please help in resolving this. There is a union query whihc is used in a crosstab. In the crosstab the columns are dynamic based on the period parameter passed in the report. Now the fact value for each row in the crosstab is comming fine. Only for 3 rows like % calculation and one division calculation the value in the union query is getting a huge value. I tried to change the properties for the data item from Total to Calculated, but still its not working.
Can you please provide any input on this.

Regards..

[Francis aka khayman]

try this... maybe this can help.

http://cognosm.fm3online.com/dimensional/incorrect-percentage-summary/

[ak80]

hi Khayman

Thanks for the prompt reply. But the solve solution didnt work for me. Then I tried to do the calculation in the final union query. This worked but as a side effect the rest of the rows which was coming fine, now the data for them is getting doubled. Can you pls help to resolve this.

Regards,
Arati

[Francis aka khayman]

are you using dimensional or relational