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..
try this... maybe this can help.
http://cognosm.fm3online.com/dimensional/incorrect-percentage-summary/
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
are you using dimensional or relational