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.
Learning Objectives

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
Key Concept

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.

Note
The Query Builder in SAP Dashboards 4.1 only works with UNX format Universes. Legacy UNV format Universes cannot be accessed using this tool.

Adam Getz

Adam Getz currently serves as a Manager, Business Intelligence for CGI Federal. In this position, he is leading a large business intelligence and data warehousing implementation for a federal client.  He is a thought leader in the field of information technology and an expert in the deployment of leading business intelligence, database management, and data integration products. He has presented at a variety of local, national, and international events, including the 2006 BusinessObjects International Conference, 2007 Oracle BIWA Summit, 2008 Oracle Open World, and 2010 and 2011 ASUG SAP BusinessObjects User Conferences. In addition, Adam is the creator and main author of bi-insider.com, a website, portfolio, and blog that provides rich technical and functional content to business intelligence and data warehousing professionals. He has also published numerous technology white papers that have focused on various topics within business intelligence and data warehousing. Adam currently serves as the chairperson of the Washington DC Business Objects User Group.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.