I was hoping that someone may have an answer to a problem I have been having using information from a personal data file (excel) and linking it to a business objects query. The excel file contains employee ids and their assigned manager ids. The business objects query contains employee id and number of customers. I am able to link the two data providers by the common dimension, employee id.
Everything is fine until I try to break on the manager id. It appears that my measure (a sum of the number of customers column) is summing up for the whole report at each manager break, not the sum for each manager. I have tried playing with the ForEach and ForAll, but this is not working either.
In a message dated 98-09-15 12:58:56 EDT, you write:
I was hoping that someone may have an answer to a problem I have been
having using information from a personal data file (excel) and linking it to a business objects query. The excel file contains employee ids and their assigned manager ids. The business objects query contains employee id and number of customers. I am able to link the two data providers by the common dimension, employee id.
Everything is fine until I try to break on the manager id. It appears that my measure (a sum of the number of customers column) is summing up for the whole report at each manager break, not the sum for each manager. I have tried playing with the ForEach and ForAll, but this is not working either.
It sounds like your linking is not working correctly. Try putting employee ids from both queries on a single report block along with the manager id. Is everything working okay? Look all the way at the bottom of the block and make sure there are no partial rows (rows with some columns blank).
Typically when you see a measure “rollling up” too far, it is a join (link) problem. You should make sure that the employee id is exactly the same in both places. Perhaps you may need to use the “Remove trailing blanks” option on the query panel, or verify your data in your spreadsheet.
You can verify this also by using manager id and employee id from your spreadsheet along with the count measure. If it is rolling up too far when you don’t use the employee id from the BusObj query then I would say that you definitely have a linking problem.
You should make sure that the employee id is exactly the same in both places. Perhaps you may need to use the “Remove trailing blanks” option on the query panel, or verify your data in your spreadsheet.
Thank you for the information, it seems that the employee id in my spreadsheet was not exactly the same as it was in the query and caused the linking problem. Also, I found that I needed to change the Manager ID column from a dimension to a detail object. Once this was done, the sums were corrent.