We are running BO 5.0.1 with a Informix Version 7.31 DB and have had problems with the reports produced. The kind of problems mainly surround inaccurate data being reported back. We generally run queries against the database and use this to check the reports that BO is producing and have found the reports to be wildly inaccurate in some cases. The system has been tweaked by Vendor in order for us to produce our main reports. However this means that we can't really do adhoc reporting as this would yield the same inaccuracies so we are stuck with a system that only gives us 12 or so standard reports. I have heard of others that have had similar problems where there has been a legacy DB, but no-one seems to know why this happens. Anyone know of any known problems with the creation of the DataWarehouse and legacy database systems, which could cause such anomolies?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Business Objects Report Errors
- Thread starter puresilk
- Start date
- First of all check the differencies between the originating system and the datawarehouse (i.e. if you have 2000 customers in o.s. you must have the same in dwh)
- Check that BO builds the right query (Show SQL in BO and run it independently against dwh and o.s.) this double check should tell you if the reports/universes are wrong or if the data in the dwh is wrong and in which tables. Stick to your guns
- Check that BO builds the right query (Show SQL in BO and run it independently against dwh and o.s.) this double check should tell you if the reports/universes are wrong or if the data in the dwh is wrong and in which tables. Stick to your guns
- Thread starter
- #3
Thanks pabloj, will try to do that. The problem we have is that BO is administered by our Tech Dept who only really administer the server and create users and other basic admin functions. I'm new to the job and apparently this problem has been ongoing for 2 years. I have only the client for BO and can't see that there is anywhere to run queries against data warehouse. Is this done on the server? Have you heard of similar issues that have been resolved successfully, because we are at the stage where we have to decide whether to continue or abandon, which is a shame as it looks like a very good tool.
Many Thanks
Many Thanks
- You can tell which database are you using (dwh or o.s.) from the connection of the report.
- You can see the SQL generated from BO (for that specific report) from the "Modify data provider" -> "SQL" button. Stick to your guns
- You can see the SQL generated from BO (for that specific report) from the "Modify data provider" -> "SQL" button. Stick to your guns
- Status
Similar threads
- Locked
- Question