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
What do you do when your report needs an input (filter) from user in order to run report. You use @prompt function.
Ex: User does not want to see all 10 years of data that we have in our data mart. Instead he/she would enter or option to select year value before report run.
Prompts can be used to restrict the data or to make large value objects easier to use. You use the @Prompt function in the WHERE clause for an object. It forces a user to enter a value for a restriction when that object is used in a query, or to select a value or a list of values. When the user runs the query, a prompt
box appears asking for a value to be entered.
Condition forces a query to retrieve the data that meets specified criteria. Condition is placed on a query to show the specific data. Use WHERE clause to define condition. It is used to fetch selected data from the data source. Read more