Skip to Content
0
Former Member
May 09, 2008 at 07:08 PM

*CALC_DUMMY_ORG stopped working after upgrading from 4.2 to 5.1

53 Views

I use this script logic to move net_income (parent member) to retained earnings (base level member):

*CALC_EACH_PERIOD

*XDIM_MEMBERSET ACCOUNT=<ALL>

*CALC_DUMMY_ORG ACCOUNT=PARENTH1

*WHEN ACCOUNG

*IS #NET_INCOME

*REC(ACCOUNT=2930,COSTCENTER=BAL_SHEET,DATASRC=ADJUSTMENT)

*ENDWHEN

This worked in version 4.2 on SQL Server 2000, but it does not work on version 5.1 on SQL Server 2005

Should i be using a MDX dimension logic for that?

Thanks,

Roman