If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Total is different to the hirarchies

Started by sivabisnai, 07 May 2008 07:26:42 AM

Previous topic - Next topic

sivabisnai

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

dlafrance

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%

Is it the only row you have when you drill?