After working with cognos support, we couldn't figure out why this was acting as such. I rebuilt the cube from scratch and the issue resolved itself.
I have a cube built from a transformer model in Analysis Studio. For this error assume the following:
Columns are years: 2005 2006 2007 Total
Rows are states: New York 100 200 300 600
Maine 300 400 500 1200
Vermont 200 300 400 900
Total 600 900 1200 2700
Measure is dollars.
Now when I run this report as is in Excel it produces correct output.
If I drill down on one of the years and run it to Excel it produces the correct output.
The problem comes if I use the "Down A Level" functionality on one of the years (or all for that matter) and then run the report to Excel, the Total Column for each row total is incorrect. Each column total is correct. This also happens when I run the report to PDF. I have attached what the actual spreadsheet is doing and have added a column showing what the total should be. Any help would be appreciated.
Thanks
Jeff
Hi
I understand there is a BI Server Updater 8.2.43.255 HotSite build which solves this problem, or so I have heard. Guess you'll need to get hold of your Cognos Support to resolve/get access to it.