on 10-21-2014 7:41 AM
Hi Folks,
I need some help on query prompt selector. I am dealing with BEx query which has a Month prompt. I want my dashboard to load with default value as current month i.e. OCT 2014.
I could do this with dirty fix at the moment by passing current month at the time of designing the query from Query Browser.
Any help is greatly appreciated.
Regards,
Tejas
Hi Tejas,
You can also link the Bex prompt to an Xcelsius Cell where you will put an Excel formula that return the corrent month and year (Depending on your need) ...you can also check the checkBox "refresh before loading componants" while creating the request on Xcelsius, so the data returned by the Bex query is refreshed against the current date while loading the Xcelsius dashboard ...
Regards.
Abdess,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Tejas,
In that case you would need to define it as a formula variable in query designer.
Regards,
Jennifer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.