Hi All,

I need to set default member of my time dimension to be 'Current Period' of
my system not based on system date , Now().
The 'Current Period' of the system is stored in a record in Parameter File /
Table, a table that only has one record, Table : AppPara, Column :
CurrPeriod (Int, YYYYMM).
E.g : even if we are in April now by system date, but the period of the
system is still 200403.

MDX Expression below, instead of relying on Now() function, what if I want
to refer to the value of CurrPeriod in AppPara table ??

StrToMember("Time.["+Iif(Year(Now())>=1998,"1998",Str(Year(Now())))+" ].[Q"+i
if(Month(Now())<=3,"1",iif(Month(Now())<=6,"2",iif (Month(Now())<=9,"3","4"))
)+"].&["+Str(Month(Now()))+"]")

Thank you for any help,
Trist

Other than via a custom function, which has drawbacks, there's no way to
reference relational objects from MDX. Maybe you can join this param table
with your time dimension table, and then create a member property based on
the current date.

public @ the domain below
www.tomchester.net

"tristant" <krislioe (AT) cbn (DOT) net.id> wrote