Print Page - SUM is not showing correctly while drilldown in olap cube source report

Title: SUM is not showing correctly while drilldown in olap cube source report
Post by: sivabisnai on 07 May 2008 06:54:21 AM

Hai,

I have a question in Report Studio(cognos8),iam using the cube to develop a report ,
My question is
i have a cross tab report with rows as regions and cols as Cases and mesaure as Qty when ever i run the report it shows the report as

qty HR MK casestotal

AP 9.29% 2.42% 11.72%
MH
GOA

when ever i drilldown the HR i got another hirarchy with values as shown

qty H1 H2 H3 H4 H5 H6 H7 H8 H9 HR
AP 7.34% 0.08% 0.07% 0.05% 1.22% 0.52% 2.84% 0.14% 0.16% 12.41%

Now the Problem is from the above HR shown as 9.29%
From the below its showing that 12.41%

Could u please give any suggestion on that issue
Thanks in advancre

Title: Re: SUM is not showing correctly while drilldown in olap cube source report
Post by: rockytopmark on 07 May 2008 07:20:10 AM

Change SUM to Aggregate

Title: Re: SUM is not showing correctly while drilldown in olap cube source report
Post by: rockytopmark on 07 May 2008 07:22:06 AM

Also, you posted your Q in the wrong forum... you will do better for yourself by postiing in the correct forum, which would be Cognos 8 --> Report Studio

Title: Re: SUM is not showing correctly while drilldown in olap cube source report
Post by: sivabisnai on 07 May 2008 07:24:46 AM

i alredy try with that but i didn't get correct sum
as same as 9.29

Title: Re: SUM is not showing correctly while drilldown in olap cube source report
Post by: sivabisnai on 07 May 2008 07:28:02 AM

Iam new to this form

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: sivabisnai on 07 May 2008 06:54:21 AM