YTD calculation using SQL script logic

[Former Member]

Hi,

Has anyone used the SQL logic to generate YTD numbers. I have a requirement where I need to have a account which should have a Net_Income_YTD value stored in it. I can have this easily through MDX, but trying to see if we can achieve this in any way through SQL logic.

MDX formula for this calculation is:-

(Account).(Net_Income_YTD) = (Account).(Net_Income),(Measures).(YTD)

Thanks

Sharath

[Former Member]

Sharath,

I'm guessing as YTD,QTD are Calcualted members, probably they are not accessible via SQL logic.

again my guess here...

vishal.