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