Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to have a dimension for year that has a context of "Entered" when referring to orders placed. We have two dimensions.
Fiscal Quarter
Fiscal Date Context = 'Entered'.
I need a dimension that is always Fiscal Quarter in the Entered context so the user does not need to set each individually. I was thinking of a master item but not sure how to go about it.
The dimension should allow for the user to pick the quarter that is automatically set to 'Entered' date context.
Thanks!
if i understood right may be this
len(Fiscal Quarter>0,'Entered') as Fiscal Date Context
Hi Jahanzeb, What I would like is something like this, just not sure how to go about it.
Fiscal Quarter ({$<Fiscal Date Context = 'Entered'>}
to achieve what you are asking, you could create a master item dimension as below:
Aggr( Only( {< [Fiscal Date Context] = {'Entered'} >} Fiscal Quarter), [Fiscal Quarter] )
=replace(text(Fiscal Quarter),Fiscal Quarter,'Entered')