Skip to Content
0
Former Member
Sep 27, 2013 at 02:14 PM

Dimension logic questions-identify syntax

14 Views

Hello Fellow BPC'ers,

We have implemented a DSO calculation in our P/L application that uses dimension logic. The speed is fine but I am debugging this and trying to pull apart the individual calculations and understand how this thing is put together (I was not the creator).

Can anyone explain what the bolded part of the following dimension logic is doing? I get the [TIME].CURRENTMEMBER.LAG(DSO_MONTHS) part, but I do not get the syntax of the preceding DAYS_IN_MONTH followed by a comma and how that plays with the following part of the calculation.

IIF(GRS_ACCT_REC_TRD=0,NULL,(DSO_DAYSBASIS+(DAYS_IN_MONTH,[TIME].CURRENTMEMBER.LAG(DSO_MONTHS))*((GRS_ACCT_REC_TRD-DSO_SALESVATBASIS)/DSO_SALESVATLAG))),SOLVE_ORDER=201

Thank for your help!

Kevin