Re: Dynamic Default member ?
From: Tom Chester (nospam_public_at_tomchester.net)
Date: 04/06/04
- Next message: Bas Kersten [MSFT]: "RE: Failure of SP3 during Analysis Service update"
- Previous message: Les McPhee: "Calc member too slow..."
- In reply to: tristant: "Dynamic Default member ?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Apr 2004 23:13:10 -0700
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@cbn.net.id> wrote in message
news:OUXTqw4GEHA.2848@TK2MSFTNGP10.phx.gbl...
> 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
>
>
- Next message: Bas Kersten [MSFT]: "RE: Failure of SP3 during Analysis Service update"
- Previous message: Les McPhee: "Calc member too slow..."
- In reply to: tristant: "Dynamic Default member ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
