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