Retrieving huge quantities of records in one report

building reports webintelligence
6

Drilling:
You have to setup hierarchies in the universe, you can then choose (via document properties I believe) if you want to pre-fetch data down to a particular drill level, or you can have a new query executed in the background if someone is drilling down a hierarchy with the drill filter set as a condition in the SQL statement.
Workflow example:

  • User opens document, data is shown at Region level.
  • User drills down on Region EMEA
  • BusObjects transparently fetches all countries only for region EMEA (SQL code) and displays the results.

OpenDocument:
Look here for example. It is also documented in the BusObjects Designer guide I believe.

Andreas :de: (BOB member since 2002-06-20)