Dynamic dimension in set analysis

prashantsanchet — Thu, 19 Apr 2018 10:08:57 GMT

Hi team,

I have one dimension as customer and the measure as sum({<[customer={"=Sum([discount])>=1000"} >}sales)

I have one listbox (cliember selection list box extension") where user can select the dimension which he wants.and this will be stored in variable vSelectedDimension.

I have created a one variable vDynamicDimension which will return actual dimension value.

if( vSelectedDimension='Customer' ,[Customer], if( vSelectedDimensionr='Region' ,[Region] ))

Sum({<[vDynamicDimension={"=Sum([discount])>=1000"} >}sales) as measure

But the result in both expression is coming different. What could be the reason?

Re: Dynamic dimension in set analysis

sunny_talwar — Thu, 19 Apr 2018 11:39:51 GMT

You might need dollar sign expansion here

Sum({<$(='[' & vDynamicDimension & ']') = {"=Sum([discount]) >= 1000"}>} sales)

Sum({<$(='[' & $(vDynamicDimension) & ']') = {"=Sum([discount]) >= 1000"}>} sales)