Yes, you can with some tweaking and work on your side, see here for example:
http://www.forumtopics.com/busobj/viewtopic.php?t=16473
You can extract the SQL code of each data provider (using VBA) and then do a search (Match pattern on specific columns and/or table names).
It looks to me that your measures are not using SQL aggregate functions and instead you are bringing back every detail row from the database into your report and calculate your summary data at the rpeort level, am I correct?
Remember that measures should (usually) always use some SQL aggregate...
How universe switching works in version 5.x.and 6.x
Once a universe has been exported to the repository it is assigned a hidden universe ID. Data providers built on such a universe are actually pointing to the universe ID.
If a data provider points to a universe ID, which Business Objects does...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.