Create a Universe Query and Embed it into SAP Dashboards 4.1
- by Adam Getz, Manager – Business Intelligence, CGI Federal
- March 10, 2015
Learn how to use the Query Builder component in SAP Dashboards 4.1. See how to create a Universe Query that can be inserted into the embedded spreadsheet within SAP Dashboards or bound directly to components of SAP Dashboards, and gain an understanding about the process of querying a BusinessObjects Universe and integrating the data into a dashboard.
Reading this article, you will learn how to:
- Generate a Query from a Universe in SAP Dashboards 4.1
- Use the Query Builder component in SAP Dashboards 4.1
- Bind a Query to the embedded spreadsheet
- Bind a Query directly to a dashboard component
A BusinessObjects Universe is an intermediary layer between a database or data source and dependent reports, Queries, or dashboards. The Query Builder feature enables the integration of data that is stored within a database into a dashboard component through the use of a Universe. With SAP Dashboards 4.1, data can be retrieved from a database by using the new Query Builder.
SAP Dashboards 4.1 (formerly known as Xcelsius) is a major tool of the BusinessObjects 4.1 application suite that has numerous features for making user-friendly, dynamic dashboards. Originally SAP Dashboards only allowed for visualization of data that was embedded in Microsoft Excel. However, an enhancement in the 4.1 release of SAP Dashboards, Query Builder, allows developers to pull data directly from a BusinessObjects Universe. Fundamentally, the Query Builder enables the integration of data stored within a database into a dashboard component through the use of a Universe. Now data can be retrieved from a database and the functionality of the embedded Excel spreadsheet within SAP Dashboards4.1 can be greatly extended.
I describe how to use the Query Builder component in SAP Dashboards 4.1. I explain how to create a Universe Query that can be inserted into the embedded spreadsheet within SAP Dashboards or bound directly to components of SAP Dashboards. In a nutshell, this tutorial demonstrates the process of querying a BusinessObjects Universe and integrating the data into a dashboard.
In order to use the features described in this article, users must have the following:
- The SAP Dashboards 4.1 designer product installed on their workstation.
- Log-on credentials to an installation of either BusinessObjects 4.0 or BusinessObjects 4.1.
- Permissions to create Queries from a BusinessObjects UNX format Universe.
The Query Builder in SAP Dashboards 4.1 only works with UNX format
Universes. Legacy UNV format Universes cannot be accessed using this
Would you like to see this full item?