I have a report in Business Objects that is looking good. I then run the same report (I re-created the entire query) in Business Query and it’s not summing up the same way as Business Objects is. In the BO report, it’s summing up the sales for a agent over a period of time. In Business Query it’s showing several rows of data for an agent. If you add the rows, it totals the BO report. The exact same SQL is being generated. Does anyone have a clue why it’s rolling it up in BO and not in BQ?
Business Query will give you the exact same results as the raw data (Data View) in Business Objects. It does not sum any rows unless it is done in the SQL. Your Business Objects report is obviously summing rows and showing the summarized view. To do the same with Business Query you will have to do subtotals in Excel.
<< I have a report in Business Objects that is looking good. I then run the same
report (I re-created the entire query) in Business Query and it’s not summing up
the same way as Business Objects is. In the BO report, it’s summing up the sales for a agent over a period of time. In Business Query it’s showing several
rows of data for an agent. If you add the rows, it totals the BO report. The exact same SQL is being generated. Does anyone have a clue why it’s rolling it
up in BO and not in BQ?
Christina:
You are actually seeing the same data in both places. The difference is that BusObj is automatically summing identical rows. This is a feature that you can turn off by selecting your block and then selecting Format + Table (I assume it’s a table) from the menu.
On the first tab you will see a checkbox with the intuitive text: Avoid Duplicate Row Aggregation. If you check this, then BusObj will display each row of data, just like BQ is doing.
There is no equivalent in BQ, since the data is returned to MS Excel.
As others have mentioned, if you roll the numbers up at the database side you will get identical answers in both BO and BQ.