Connecting Universe in Dash-Board 4.0 through Query Browsing
About Authors:
Author: Amit Pujari
Company: Infosys Limited
Amit Pujari is working as a System Engineer in Infosys Limited and has experience of working in data warehousing. He has a total experience of 1.4 years.He is recently learning SAP Business Object & SAP HANA.
Co-Author:- Sourav Shirsha Banerjee
Company: Infosys Limited
Sourav Shirsha Banerjee is working as a System Engineer in Infosys Limited and has experience of working in data warehousing, BW enhancement for the last 2.1 years. He is recently learning SAP Business Object He is a consistent learner and works proactively to adopt new technology.
Table of Content
Target Readers
Prerequisites
Summary
Introduction to Query Browsing
Steps to Add Universe for Creating Query
Creating Query after Fetching Universe
Executing the Query
Inserting Query Result set to Embedded Spreadsheet of Dashboard
Reference(s)
Target Readers
SAP BO Dash Board developers.
Prerequisites:-
The target readers should have knowledge of Universe Designing, Query Designing in Webi and Basic Knowledge of Business Object 4.0 Dashboard.
Summary:-
This Article helps in gaining knowledge to create connection to universes in Business Object Dashboard 4.0.
Introduction to Query Browsing:-
SAP Business Objects Dashboard, has many new features over Xcelsius 2008 (previous version)
And Query Browsing is one of them; you can connect your Dashboard directly to a universe using Query browsing. Query browser enables you to create a query on universe and the result set can be embedded into spreadsheet of Business Objects Dashboard which can be bound to the components in the dashboard later on. The query added over universe will fetch the data and this result set data will be populated in run-time into spreadsheet in the selected range of cells, and dashboard can be built based on that data.
In the following section we will discuss about how we can connect Business Object Universes in Dashboard 4.0 through Query Browsing.
Steps to Add Universe for Creating Query
1. 1. Open your dashboard design.
2. 2. Open File -> New -> New. It will open up new untitled page with components, properties, object browser and query browser pane.
3. 3. To add a query on a universe go to query browser as shown in the below diagram and click on add query.
1. 4. It will open a new dialog box which asks you to select universe on which you want to build query.
2. 5. Select a universe on which we want to build a query and click on next. It will take you to next page where you can build a query on the selected universe.
Creating Query after Fetching Universe
1. 1. You can drag your objects in Result object panel from Universe pane, in the same way if you want to add filter on some of the object drag and drop Your object in Filters panel. Here as the diagram shows we have added asset type, Model no, Reading start Date in result objects, and put filter on “Reading Hour” which is added in Filter pane.
2. Once you are done with your query building, you can see preview of the result set in “Data Preview / Result Set” pane by clicking the refresh button which will also show query run time & number of rows fetched as shown below.
Executing the Query
1.Click on next it will ask for inputs if you have added in filters with prompt in query, else it will show the result set directly. As we have added filter here it asks the input value as shown below-
,,.
1. 2. And the result set will be shown as below.
Usage Option with Query
Clicking on “Next”, “Usage Options” tab will open. In this tab there are two sections namely “Refresh Option” & “Loading Status”.
Refresh Option
Refresh allows selecting refresh mode i.e. settings of how the query be refreshed.
Refresh before Components are Loaded
This option fetches the latest result-set every time the dashboard is opened i.e the option forces the Data Connection to retrieve data from the source before the components are generated.
Refresh Every ‘N’ Time
This option is helpful in getting the latest result-set when the dashboard is operational for long time. In this the dashboard reflects changes in every ‘n’ time, we choose, according to the change of query result set.
Refresh On trigger
This option allows refreshing underlying query when value of a particular cell or range of cells gets changed. It has two sub-sections –
When the value Changes: This triggering option refreshes the underlying query only when value of a cell gets changed. Say for example, selecting a country from a list of Country will only fetch the related result-set.
When the value becomes. This triggering option refreshes the underlying query only when value of a cell becomes a predefined or stipulated value. For example, selecting a country from a list of Country will only set a cell to a value which in turn will trigger the query to refresh.
Load Status
When the data is been requested and the result has not returned it's in the dashboard is in loading status otherwise it is in Idle status. This option allows configuring the settings while the dashboard is loading or idle status.
Loading Message: - This option allows us to define a particular message while the Dashboard gets loaded. It prevents user interaction during loading.
Idle Message: - This option allows us to define a particular message while the Dashboard becomes Idle.
Insert In: This option allows us to select the cells in the embedded spreadsheet where we can
load and idle messages will be inserted.
Enable Load Cursor : - This option allows us to set the mouse cursor customization when the connectivity loads data, while it goes to usual shape when the connectivity is idle.
Disable mouse input on Load: - Upon requirement of disabling any user interaction when the dashboard is loading status we usually select this option.
Hide Error Message Window: - This option allows us to choose a cell range in the embedded spread **** to receive the error message text.
In the following example we have chosen “Refresh before Components are loaded”
Now you can see your query added in the query browser panel with all usage options as selected.
Inserting Query Result Set to Embedded Spreadsheet of Dashboard:-
1. Now to insert the query result set in spreadsheet select a particular result object and click on “Insert in Spreadsheet”, which in turn will allow us to bind the result set of that object to a cell or range of cell through “Select Range” dialog box.
Note:
- We can only bind the result set of every object individually but not in whole.
- It is best practice to bind the result set of an object to number of rows as low as possible.
In the above case study we have chosen range for "Asset Type" as A1 to A20 assuming the data fetched by a query will not be more than 20 rows satisfying the required scenario.
Same way we have chosen range for “Model No” as B1 to B20. Similarly we can Choose range for other objects.
This data will not be visible in embedded spreadsheet of Dashboard 4.0 but will be available during run-time.
Now we can build the dashboard using this populated data and as the data will not be visible in spreadsheet we have
to build Dashboard components using the cells which we have selected as target for query objects.
Reference(s)
1.
- SAP Managed Tags:
