Ad-Hoc Reporting

You can run queries and use selection criteria to develop and generate ad-hoc reports.

It is possible to utilize the Business Objects BI Launch Pad for ad-hoc report development against Production data. However, it is important to take note of the following:
  • Customer’s Responsibility: Queries that are utilized when developing and generating ad-hoc reports are the customer’s responsibility. It is possible that a poorly written report that is executed on the server could have a negative impact on performance. This is not Deltek’s responsibility, and the user developing ad-hoc reports must not overlook this. Deltek can help to triage and remediate these issues if a Support Case is raised.
The following restrictions apply to ad-hoc reporting and must be adhered to:
  • Manual SQL or report SQL amendments are not allowed.
  • Only universe based reports are allowed.
  • Reports amended or written in production cannot be promoted to other environments.
  • Personal reports might be impacted after a universe upgrade.

Access to all items within the public folders (that includes all standard and custom reports) will be read only. No one will be able to create or edit reports within the public folders.

A control group of people will have full access to their own BO personal folder. These users should be able to copy a report from the public folders to their personal folder. The personal copy version of that report can then be edited for personal use only. These users should also be able to create their own report or query within their personal folder. This is based on standard and custom universes (access to some universes might need restriction).

Warning: Ad-hoc reporting can adversely affect performance of the production system.
We recommend that selection criteria is used to ensure that only necessary data is fetched. For a new report, start with narrow selection criteria and broaden it gradually to minimize the risk of a long running report. If you expect a report to return large data sets and run for a long time, schedule it to run outside of peak hours.

Please note that reports in the personal folder will not be taken into account when upgrading standard or custom universes and reports.

All users:
  • Public folder = Read only
  • Personal folder = No access
  • Edit report = No access
  • New report = No access
Control group of user:
  • Public folder = Read only
  • Personal folder = Full control
  • Edit report = Edit standard/custom reports within the personal folder once copied from the public folders to their personal folder
  • New report = Create new report in the personal folder based on existing standard and custom universes
Warning: From Business Objects version 4.2 SP5 a (GDPR) data protection popup message has been introduced.The message reads: "The product contains open or freely configurable entry fields, which are not intended for storing personal data without additional technical and organizational measures to safeguard data protection and privacy." End users can silence this message by selecting “Do not show this message again”.