Presentation Variables:
These variables are used to capture user response with the help of prompts.
Demonstration:
- Login to Analytics using administrator privileges-->new-->dashboard prompt-->sales-->add-->
save this dashboard prompt as "PV_PROMPT".
- Now develop a report using region, district, revenue. Right click region-->filter-->add more options-->presentation variable-->variable expression '@{V_USER_SELECTION}'--> check the box of "convert this filter to SQL expression" -->ok. The filter will be added as shown below:
- Save this report as PV_REPORT. Now let us create new dashboard. New--> Dashboard-->
- Name: PV_DASHBOARD
- Location: Shared folders/sample folders/Dashboards
- Drag and drop PV_PROMPT and PV_REPORT from catalog on to the blank dashboard. save and run. We will see dashboard prompt "Select user selection", type in Central and hit apply. It will show central region data. If we change case in Central then it will not show the data since it wont find any match.
- We can write UPPER() on both sides to avoid case sensitivity.
- This is how we make use of presentation variables to display the data in the report by capturing user response in a prompt.
No comments:
Post a Comment