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

 

Resolved-Overall Total Incorrect When Analysis Studio Report Run to Excel or PDF

Started by jguevin, 09 Oct 2007 10:42:59 AM

Previous topic - Next topic

jguevin

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

                                    



trevorp

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.