Skip to Content
0
Former Member
Feb 04, 2011 at 02:35 PM

LGF VS MDX FORMULAS

22 Views

Hi gurus;

What is the difference between MDX and Script Logic formulas?

For example

Can i write below formulas in LGF ?

function MOVEMENT(%ACCOUNT%)

iif(COUNT(%Time_Dim%.Children) =0,

%ACCOUNT%-(%ACCOUNT%,%Time_Dim%.PrevMember),

SUM(Descendants(%Time_Dim%.CurrentMember,99,LEAVES)))

*endFunction

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