What is the difference between MDX and Script Logic formulas?
Can i write below formulas in LGF ?
If yes, Whats the meaning of 99? and Children
The another question is IIF MDX Formulas
Iif([Time].CurrentMember.Children.Count=0, [Account].[AccRec] - ([Account].[AccRec], [Time].PrevMember), SUM(Descendants([Time].CurrentMember, [Time].[Month], LEAVES)))
I want to forward datas to month 8 but if month 8 is not empty , do nothing.
My account dimension name which want to forward is : SALES_K
account dimension member which want to forward is : K1005
My Time dimension name : TIME current month:8 id name: 2010008
Time period id : 2010001 , 2010002 , 2010003 ...
Many thanx for your replies
Have a nice day