How to pass BEx variable (Parameters) values to an SAP Xcelsius dashboard
Use Case: You have a parent dashboard, and a child dashboard. Now you want to pass parameters from parent to child.
Background:Traditionally dashboards(xcelsius) are able to embed opendoc url’s within them and invoke webi reports along with passing parameters. This works like charm with the url component invoking these links. But when it comes to invoking the dashboards, there are a few extra steps we need to include(in the parent) to achieve the same.
What you need to have in parent and child SAP dashboards:
- Parent dashboard: A URL link with all the syntax to pass the parameters to the child
- Child dashboard:Flash variables configured to receive the parameters from the parent dashboard and also refresh the queries in the child dashboard.
How you do it? Follow the below steps Read more
If you need alternatives to query browser in SAP Dashboards, Consider BIWS (SAP Business Intelligence web services)
Background: Your company has invested millions of dollars and purchased the BI 4.0 suite for reporting and dashboarding.
Problem: You are trying to build a dashboard in the traditional way and now you cannot map Bex variables to excel spreadsheet.
What does that mean to a dashboard design? SAP has restricted its customers from mapping the variables from BEx to excel spreadsheet. That means the only we can refresh a query is to use the “Query Prompt selector“. The query prompt selector itself works fine but its always a combo box for selection from user. If the user wants to click on the chart and refresh a query then its not possible. That is when you need to map the variables to the excel spreadsheet.
What can be done? Read more
The combined query technique combines the results of one query with the results of another query into single query or data provider. Read more
In a nutshell, a data warehouse is a “repository for historical data, used to make decision”. Of course there’s much more to it than that.
Data warehousing is a concept. It is a set of hardware and software components that can be used to better analyze the massive amounts of data that companies are accumulating to make better business decisions. Data Warehousing is not just data in the data warehouse, but also the architecture and tools to collect, query, analyze and present information. Read more