MDX Expression question

#1

Hi,

I am trying to build a cube which analyzes the impact of exchange
rates on costs. The amounts have about 5-6 dimensions. Is it possible
to have an expression like [Year.Amount * Year.ExchangeRate] -
[PreviousYear.Amount * PreviousYear.ExchangeRate] without having to
hardcode the year values in the formula ?

Thanks
Sridhar

#2

Something along the lines of (untested):

[Year.Amount * Year.ExchangeRate] -

Quote:

[(Year.CurrentMember.PrevMember, Amount) * (Year.CurrentMember.PrevMember,
ExchangeRate)]

--
Jacco Schalkwijk
SQL Server MVP

"Sridhar" <vsridhar420 (AT) gmail (DOT) com> wrote

Quote:

Hi,

I am trying to build a cube which analyzes the impact of exchange
rates on costs. The amounts have about 5-6 dimensions. Is it possible
to have an expression like [Year.Amount * Year.ExchangeRate] -
[PreviousYear.Amount * PreviousYear.ExchangeRate] without having to
hardcode the year values in the formula ?

Thanks
Sridhar

#3

Thanks Jacco, It works great !

Regards
Sridhar

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MDX Expression question

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

MDX Expression question - 10-04-2004 , 02:59 AM

Re: MDX Expression question - 10-04-2004 , 08:06 AM

Re: MDX Expression question - 10-07-2004 , 06:22 AM