Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 231 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
An "is between" prompt which sets a presentation variable: how to reference values in the filter?
Hello,
I have a "Fiscal Year" column prompt with an "is between" operator. Obviously, an user has to enter two values - "beginning of range" and "end of range". And there's also a presentation variable varRange being set by this prompt.
Now, I want to put a filter which is basically to only use Fiscal year between those "beginning of range" and "end of range" values entered by user. I know I don't need to have a presentation variable for this, and simply use "is prompted". But still, if I were to use the presentation variable's value for this filter, how do I do that? I mean, varRange variable now holds two values, so how do I split the varRange variable into two values - "beginning of range" and "end of range"? Can I use an array-like syntax, something like @{varRange}->[0] and @{varRange}->[1] ?
Answers
-
The value passed by your prompt will look like 2018,2019. You'll have to parse it and cast as an integer or leave as text, depending on your need.
first value: CAST(LEFT('@{dashboard.variables['presvar']}',POSITION(',' IN '@{dashboard.variables['presvar']}')-1) as INTEGER)
second value: CAST(SUBSTRING('@{dashboard.variables['presvar']}' FROM POSITION(',' IN '@{dashboard.variables['presvar']}')+1 FOR 20) AS INTEGER)
You may be able to just use the '@{presvar}' syntax, instead of '@{dashboard.variables['presvar']}'. I get lost on when to use which one, but I know I have to use the latter in some filters.
0 -
Excellent. Thank you, Jerry!
0
