Skip to Content
avatar image
Former Member

Script logic to add YTD values

Hi,

The below logic works fine for calculating Account ACCPYCALC(Periodic)=PYACCRUAL(Periodic)PYACCRELEASE(Periodic)PYACCACT(Periodic).

But we need to caculate Account ACCPYCALC(Periodic)=PYACCRUAL(YTD)PYACCRELEASE(YTD)PYACCACT(YTD).

Please provide your inputs.

-


*XDim_Memberset FBCategory=ACTUAL

*XDim_Memberset FBAccount=PYACCRUAL,PYACCRELEASE,PYACCACT

*XDim_Memberset FBEntityCostCenter=CEGB1129310Q01

*XDim_Memberset FBRptCurrency=GBP

*XDIM_REQUIRED=FBYEAR

*XDIM_REQUIRED=FBTIME

*WHEN FBACCOUNT

*IS PYACCRUAL,PYACCRELEASE,PYACCACT

*REC(FBACCOUNT=ACCPYCALC)

*ENDWHEN

*COMMIT

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 17, 2010 at 08:30 PM

    What if you built a 2 stage process to aggregate the YTD account values into seperate accounts using Business Rules (CalcAccount), then use script logic to add the 3 accounts to the final account. Wouldn't that work just as easily.

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Only one value is stored in Fact table as Signed data. YTD is calcualed at application level. SQL logic is run against SQL tables and MDX logic is run against the application cube. That is why we are able to pull YTD values in MDX logic and not in SQL logic. If you have any suggestions please add.