Set Context for Date Dimension

[Anonymous]

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!

[zebhashmi]

if i understood right may be this

len(Fiscal Quarter>0,'Entered') as Fiscal Date Context

[Anonymous]

Hi Jahanzeb, What I would like is something like this, just not sure how to go about it.

Fiscal Quarter ({$<Fiscal Date Context = 'Entered'>}

[agigliotti]

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] )

[zebhashmi]

=replace(text(Fiscal Quarter),Fiscal Quarter,'Entered')