Hi,
Wanted to know if it is possible to have a dynamic dimension in a set analysis. for eg
I have 2 expressions based on selection of a calendar year or financial year
for Calendar year my exp is
sum({<DATE_CYYYY=$(v_CDATE)>} Amount)
for Fiscal year my exp is.
sum({<DATE_FYYYY=$(v_CDATE)>} Amount)
I am setting a variable v_Year which can either have value as DATE_CYYYY or DATE_FYYYY. I am setting this value on a click of a button. i.e when user clicks on Fiscal year then, v_Year is set to DATE_FYYYY and if he clicks on Calendar Year then value is DATE_CYYYY.
Now I have an expression as
sum({<$(v_Year)=$(v_CDATE)>}Amount OR
sum({<v_Year=$(v_CDATE)>}Amount
But it doesn't seem to work. Any help is appreciated.
Thanks
Lax