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
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?