I have a fiscal period parameter (Ex. 03) and a fiscal year (Ex. 2018) parameter flowing in from a layer of views below. So the select statement now is:
select from <view>
(P_FiscalPeriod: $parameters.P_FiscalPeriod ,P_FiscalYear: $parameters.P_FiscalYear).
Now the user wants to enter a single parameter 03.2018.
To accomodate this change, I would want to separate out the fiscal period and year from this string before the parameter mapping is done - maybe use one of the substring functions.
The problem is that I can't do this within the parameter mapping code. I cant write P_FiscalPeriod: LEFT($parameters.P_FiscalPeriod,2) . It starts giving syntax errors.
I can't figure out the right syntax or other ways to do this. Am not able to find an example either.
Any help would be greatly appreciated.