Data Different between Report and SP 1

[strom99]

I have a report that I displaying the max number of uses for specific tools. I am using a stored procedure (SQLServer 2000) and it returns the data correctly, when I call the stored procedure through BO, the data comes in fine when viewing throught the data manager or exporting to excel, but when displaying the data on the actual report tab, the numbers for max use are really inflated. I am stumped as to why this is happening, any ideas?

Thanks Much!!

 

[skrandel]

You likely are experiencing some dimensional rollup.

Format-Table - on the general tab, select "avoid duplicate row aggregation"

By default BO will take measure and add them up. Your MAXes are rolling up accross common dimensions.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[strom99]

Sweeeet....it works