on 12-16-2015 6:19 AM
Hi all,
1. is there any method like in bex offsets.
please let me know when i providing value for the month and it should return that month and previous 6 months values.
2. is there any way that we create global variable. i have created 7 queries and i have created 7 month variables. these queries are sources for BO dashboard.
when i run the dashboard it is displaying 7 month variables.
if we create global variable in hana and use this variable in all the queries.that will display single variable in BO dashboard.
please help
Hi,
For your first point. Please check below
You need to create a derived table in Data Foundation Layer of Universe in IDT. The query should have the placeholder syntax for the input parameter.
Follow these steps:
1. Create a parameter in data foundation of IDT. This will be the prompt visible to the end user while executing the report.
2.Create a derived table in Data foundation in IDT
3. Use the following syntax for the SQL required in derived table:
SELECT <col1>,<col2>... FROM <viewname> ('PLACEHOLDER'=('$$IP_PSTNG_DATE$$',<prompt>))
In the above syntax, PLACEHOLDER is a keyword,
'$$IP_PSTNG_DATE$$' is the input parameter created by you in your view and <prompt> should be replaced by the actual prompt created by you in step 1.
Now create your business layer using this derived table. This should bind the Input Parameter with the front end prompt.
Thanks
HA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.