Question script logic/TMVL

[Former Member]

Hi all

We are on SAP BPC 10.1 SP 4 on SAP BW 7.4 SP9.

We want to enter the period e.g. 2016.01 in a user pop-up and then perform calculations for the periods 2017.01 and  2018.01

The calculation for 2016.01 works correct. I do not understand why the calculation is not performed for 2017.01 and 2018.01.

It seems that TMVL(24,%TIME_SET%) delivers the wrong value for the period.

Could anybody please help me?

Thanks in advance and best  regards

Gerd

Script logic

*XDIM_MEMBERSET VERSION=%VERSION_SET%

*XDIM_MEMBERSET TIME=%TIME_SET%,TMVL(12,%TIME_SET%),TMVL(24,%TIME_SET%)

*XDIM_MEMBERSET P_ACCOUNT=930000425100,930000425200,930000420100,930000420200,930000421100,930000421200, 930000422100,930000422200,930000423100,930000423200,930000424100,930000424200, 930000426000,930000426001,930000464000,930000464100,930000464005,930000464105,930000415230,930000490000

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS %TIME_SET%

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS TMVL(12,%TIME_SET%)

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS TMVL(24,%TIME_SET%)

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

In UJKT we test this script with Data Region:

TIME=2016.01

VERSION=PLAN

Result in UJKT:

LGX:

*XDIM_MEMBERSET VERSION=PLAN

*XDIM_MEMBERSET TIME=2016.01, 2017.01 , 2014.08

*XDIM_MEMBERSET P_ACCOUNT=930000425100,930000425200,930000420100,930000420200,930000421100,930000421200, 930000422100,930000422200,930000423100,930000423200,930000424100,930000424200, 930000426000,930000426001,930000464000,930000464100,930000464005,930000464105,930000415230,930000490000

*WHEN VERSION

*IS PLAN

*WHEN TIME

*IS 2016.01

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS PLAN

*WHEN TIME

*IS 2017.01

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS PLAN

*WHEN TIME

*IS 2014.08

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2016-05-20 16:48:25

FILE:\ROOT\WEBFOLDERS\PLANUNG_FI_RD6 \ADMINAPP\PLANNING\TEST.LGF

USER:A114679

APPSET:PLANUNG_FI_RD6

APPLICATION:PLANNING

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING", #dimensions=7

COMPANY_CODE,CURRENCY,MEASURES,P_ACCOUNT,P_FACHBEREICH,TIME,VERSION

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000425100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000425200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000420100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000420200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000421100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000421200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000422100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000422200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000423100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000423200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000424100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000424200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426000]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426001]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464000]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464005]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464105]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426001]*%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 1  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 3  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426001]*%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 1  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 3  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2014.08,2016.01,2017.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

ENDWHEN ACCUMULATION: 38  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

COMPANY_CODE CURRENCY          P_ACCOUNT       P_FACHBEREICH  TIME     VERSION            SIGNEDDATA

1000     EUR       10000000425100            FB000    2016.01 PLAN     310.00

1020     EUR       10000000425100            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000425200            FB000    2016.01 PLAN     310.00

1020     EUR       10000000425200            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000420100            FB000    2016.01 PLAN     310.00

1020     EUR       10000000420100            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000420200            FB000    2016.01 PLAN     310.00

1020     EUR       10000000420200            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000421100            FB000    2016.01 PLAN     310.00

1020     EUR       10000000421100            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000421200            FB000    2016.01 PLAN     310.00

1020     EUR       10000000421200            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000422100            FB000    2016.01 PLAN     310.00

1020     EUR       10000000422100            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000422200            FB000    2016.01 PLAN     310.00

1020     EUR       10000000422200            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000423100            FB000    2016.01 PLAN     310.00

1020     EUR       10000000423100            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000423200            FB000    2016.01 PLAN     310.00

1020     EUR       10000000423200            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000424100            FB000    2016.01 PLAN     310.00

1020     EUR       10000000424100            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000424200            FB000    2016.01 PLAN     310.00

1020     EUR       10000000424200            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000426000            FB000    2016.01 PLAN     0.00

1020     EUR       10000000426000            FB000    2016.01 PLAN     31000.00

1000     EUR       10000000426001            FB000    2016.01 PLAN     310.00

1020     EUR       10000000426001            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000464000            FB000    2016.01 PLAN     310.00

1020     EUR       10000000464000            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000464100            FB000    2016.01 PLAN     310.00

1020     EUR       10000000464100            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000464005            FB000    2016.01 PLAN     310.00

1020     EUR       10000000464005            FB000    2016.01 PLAN     3100.00

1000     EUR       10000000464105            FB000    2016.01 PLAN     310.00

1020     EUR       10000000464105            FB000    2016.01 PLAN     3100.00

1020     EUR       10000000415230            FB000    2016.01 PLAN     100.00

1020     EUR       10000000490000            FB000    2016.01 PLAN     100.00

38  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING", #dimensions=7

COMPANY_CODE,CURRENCY,MEASURES,P_ACCOUNT,P_FACHBEREICH,TIME,VERSION

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING", #dimensions=7

COMPANY_CODE,CURRENCY,MEASURES,P_ACCOUNT,P_FACHBEREICH,TIME,VERSION

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

#dim_memberset=2

TIME:2016.01,1 in total.

VERSION:PLAN,1 in total.

SCRIPT RUNNING TIME IN TOTAL:10.00 s.

LOG END TIME:2016-05-20 16:48:35

[former_member186338 · Accepted solution]

HI Gerd,

The reason is simple TIMEID property is not correctly maintained in your TIME dimension. Has to be set as increasing string for the base meMyers of TIME. TMVL will sort base members using this property and perform shift using arguments.

Vadim

[former_member186338 · Accepted solution]

P.S. Look at the beginning of your lgx - time member for 2018 is incorrect   and you don't need to test the whole script, just test XDIM_MEMBERSET line

[Former Member · Accepted solution]

Hi thanks for your answers.

I have maintained the time dimension according to the documentation.

It looks now for the property TIMEID like this:

The script logic does not work yet as desired for the periods of the next years. What could be the reason for that?

Thanks in advance and best regards

Gerd

[former_member186338 · Accepted solution]

You have to provide some test info!

What is the result of just single line in UJKT (Execute simulate):

*XDIM_MEMBERSET TIME=%TIME_SET%,TMVL(12,%TIME_SET%),TMVL(24,%TIME_SET%)?

Vadim

[Former Member · Accepted solution]

Hi Vadim,

the result is

LGX:

*XDIM_MEMBERSET TIME=2016.01, 2017.01 , 2018.01

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2016-05-24 10:43:39

FILE:\ROOT\WEBFOLDERS\PLANUNG_FI_RD6 \ADMINAPP\PLANNING\TEST.LGF

USER:A114679

APPSET:PLANUNG_FI_RD6

APPLICATION:PLANNING

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

LOG END TIME:2016-05-24 10:43:39

As I expected. This seems to work properly. What else can I check?

Thanks in advance and best regards

Gerd

[former_member186338 · Accepted solution]

Test the simple script like:

*XDIM_MEMBERSET VERSION=%VERSION_SET%

*XDIM_MEMBERSET TIME=%TIME_SET%,TMVL(12,%TIME_SET%),TMVL(24,%TIME_SET%)

*XDIM_MEMBERSET P_ACCOUNT=930000425100

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*ENDWHEN

Ensure that you have data in accounts: 930000425100 and 900000425100 for 2016.01, 2017.01 , 2018.01

Test result in 10000000425100

Vadim

P.S.

Absolutely useless lines - already scoped:

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS %TIME_SET%

[Former Member · Accepted solution]

Hello Vadim,

I have tried the script that you have suggested to test. The script works. These are the results:

LGX:

*XDIM_MEMBERSET VERSION=PLAN

*XDIM_MEMBERSET TIME=2016.01, 2017.01 , 2018.01

*XDIM_MEMBERSET P_ACCOUNT=930000425100

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2016-05-25 17:19:15

FILE:\ROOT\WEBFOLDERS\PLANUNG_FI_RD6 \ADMINAPP\PLANNING\TEST.LGF

USER:A114679

APPSET:PLANUNG_FI_RD6

APPLICATION:PLANNING

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING", #dimensions=7

COMPANY_CODE,CURRENCY,MEASURES,P_ACCOUNT,P_FACHBEREICH,TIME,VERSION

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000425100,1 in total.

REC :[P_ACCOUNT].[900000425100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 12  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 10  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

12  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 12  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

COMPANY_CODE CURRENCY P_ACCOUNT P_FACHBEREICH TIME VERSION SIGNEDDATA

1000 EUR 10000000425100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000425100 FB001 2016.01 PLAN 0.00

1000 EUR 10000000425100 FB100 2016.01 PLAN 310.00

1000 EUR 10000000425100 FB120 2016.01 PLAN 0.00

1020 EUR 10000000425100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000425100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000425100 FB000 2017.01 PLAN 310.00

1020 EUR 10000000425100 FB000 2017.01 PLAN 3100.00

1020 EUR 10000000425100 FB100 2017.01 PLAN 3100.00

1000 EUR 10000000425100 FB000 2018.01 PLAN 310.00

1020 EUR 10000000425100 FB000 2018.01 PLAN 3100.00

1020 EUR 10000000425100 FB100 2018.01 PLAN 3100.00

12  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:1.00 s.

LOG END TIME:2016-05-25 17:19:16

When I run my own script I do not get results for the  periods 2017.01 and 2018.01

Here is my script logic.

I performed it for

TIME=2016.01

VERSION=PLAN

*XDIM_MEMBERSET VERSION=%VERSION_SET%

*XDIM_MEMBERSET TIME=%TIME_SET%,TMVL(12,%TIME_SET%),TMVL(24,%TIME_SET%)

*XDIM_MEMBERSET P_ACCOUNT=930000425100,930000425200,930000420100,930000420200,930000421100,930000421200, 930000422100,930000422200,930000423100,930000423200,930000424100,930000424200, 930000426000,930000426001,930000464000,930000464100,930000464005,930000464105,930000415230,930000490000

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS %TIME_SET%

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS TMVL(12,%TIME_SET%)

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS %VERSION_SET%

*WHEN TIME

*IS TMVL(24,%TIME_SET%)

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Here is the result. I only get values for 2016.01 but not for 2017.01 and 2018.01

LGX:

*XDIM_MEMBERSET VERSION=PLAN

*XDIM_MEMBERSET TIME=2016.01, 2017.01 , 2018.01

*XDIM_MEMBERSET P_ACCOUNT=930000425100,930000425200,930000420100,930000420200,930000421100,930000421200, 930000422100,930000422200,930000423100,930000423200,930000424100,930000424200, 930000426000,930000426001,930000464000,930000464100,930000464005,930000464105,930000415230,930000490000

*WHEN VERSION

*IS PLAN

*WHEN TIME

*IS 2016.01

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS PLAN

*WHEN TIME

*IS 2017.01

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

*WHEN VERSION

*IS PLAN

*WHEN TIME

*IS 2018.01

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*WHEN P_ACCOUNT

*IS 900000425100

*REC(EXPRESSION=[P_ACCOUNT].[930000425100]*%VALUE%*31,P_ACCOUNT=10000000425100)

*IS 900000425200

*REC(EXPRESSION=[P_ACCOUNT].[930000425200]*%VALUE%*31,P_ACCOUNT=10000000425200)

*IS 900000420100

*REC(EXPRESSION=[P_ACCOUNT].[930000420100]*%VALUE%*31,P_ACCOUNT=10000000420100)

*IS 900000420200

*REC(EXPRESSION=[P_ACCOUNT].[930000420200]*%VALUE%*31,P_ACCOUNT=10000000420200)

*IS 900000421100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421100]*%VALUE%*31,P_ACCOUNT=10000000421100)

*IS 900000421200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000421200]*%VALUE%*31,P_ACCOUNT=10000000421200)

*IS 900000422100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422100]*%VALUE%*31,P_ACCOUNT=10000000422100)

*IS 900000422200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000422200]*%VALUE%*31,P_ACCOUNT=10000000422200)

*IS 900000423100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423100]*%VALUE%*31,P_ACCOUNT=10000000423100)

*IS 900000423200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000423200]*%VALUE%*31,P_ACCOUNT=10000000423200)

*IS 900000424100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424100]*%VALUE%*31,P_ACCOUNT=10000000424100)

*IS 900000424200

*REC(EXPRESSION=[P_ACCOUNT].[ 930000424200]*%VALUE%*31,P_ACCOUNT=10000000424200)

*IS 900000426000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426000]*%VALUE%*31,P_ACCOUNT=10000000426000)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[ 930000426001]*%VALUE%*31,P_ACCOUNT=10000000426001)

*IS 900000464000

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464000]*%VALUE%*31,P_ACCOUNT=10000000464000)

*IS 900000464100

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464100]*%VALUE%*31,P_ACCOUNT=10000000464100)

*IS 900000464005

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464005]*%VALUE%*31,P_ACCOUNT=10000000464005)

*IS 900000464105

*REC(EXPRESSION=[P_ACCOUNT].[ 930000464105]*%VALUE%*31,P_ACCOUNT=10000000464105)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000415230]*%VALUE%,P_ACCOUNT=10000000415230)

*IS 900000426001

*REC(EXPRESSION=[P_ACCOUNT].[930000490000]*%VALUE%,P_ACCOUNT=10000000490000)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2016-05-25 17:23:52

FILE:\ROOT\WEBFOLDERS\PLANUNG_FI_RD6 \ADMINAPP\PLANNING\TEST.LGF

USER:A114679

APPSET:PLANUNG_FI_RD6

APPLICATION:PLANNING

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING", #dimensions=7

COMPANY_CODE,CURRENCY,MEASURES,P_ACCOUNT,P_FACHBEREICH,TIME,VERSION

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000425100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000425200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000420100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000420200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000421100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000421200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000422100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000422200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000423100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000423200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000424100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000424200]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426000]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 6  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 3  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

6  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426001]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464000]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464100]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464005]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000464105]*%VALUE%*31

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426001]*%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

REC :[P_ACCOUNT].[900000426001]*%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

#dim_memberset=3

VERSION:PLAN,1 in total.

TIME:2016.01,2017.01,2018.01,3 in total.

P_ACCOUNT:930000415230,930000420100,930000420200,930000421100,930000421200,...20 in total.

ENDWHEN ACCUMULATION: 102  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

COMPANY_CODE CURRENCY P_ACCOUNT P_FACHBEREICH TIME VERSION SIGNEDDATA

1000 EUR 10000000425100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000425100 FB001 2016.01 PLAN 0.00

1000 EUR 10000000425100 FB100 2016.01 PLAN 310.00

1000 EUR 10000000425100 FB120 2016.01 PLAN 0.00

1020 EUR 10000000425100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000425100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000425200 FB000 2016.01 PLAN 310.00

1000 EUR 10000000425200 FB001 2016.01 PLAN 0.00

1000 EUR 10000000425200 FB100 2016.01 PLAN 310.00

1000 EUR 10000000425200 FB120 2016.01 PLAN 0.00

1020 EUR 10000000425200 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000425200 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000420100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000420100 FB001 2016.01 PLAN 310.00

1000 EUR 10000000420100 FB100 2016.01 PLAN 310.00

1000 EUR 10000000420100 FB120 2016.01 PLAN 310.00

1020 EUR 10000000420100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000420100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000420200 FB000 2016.01 PLAN 310.00

1000 EUR 10000000420200 FB001 2016.01 PLAN 310.00

1000 EUR 10000000420200 FB100 2016.01 PLAN 310.00

1000 EUR 10000000420200 FB120 2016.01 PLAN 310.00

1020 EUR 10000000420200 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000420200 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000421100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000421100 FB001 2016.01 PLAN 310.00

1000 EUR 10000000421100 FB100 2016.01 PLAN 310.00

1000 EUR 10000000421100 FB120 2016.01 PLAN 310.00

1020 EUR 10000000421100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000421100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000421200 FB000 2016.01 PLAN 310.00

1000 EUR 10000000421200 FB001 2016.01 PLAN 310.00

1000 EUR 10000000421200 FB100 2016.01 PLAN 310.00

1000 EUR 10000000421200 FB120 2016.01 PLAN 310.00

1020 EUR 10000000421200 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000421200 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000422100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000422100 FB001 2016.01 PLAN 310.00

1000 EUR 10000000422100 FB100 2016.01 PLAN 310.00

1000 EUR 10000000422100 FB120 2016.01 PLAN 310.00

1020 EUR 10000000422100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000422100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000422200 FB000 2016.01 PLAN 310.00

1000 EUR 10000000422200 FB001 2016.01 PLAN 310.00

1000 EUR 10000000422200 FB100 2016.01 PLAN 310.00

1000 EUR 10000000422200 FB120 2016.01 PLAN 310.00

1020 EUR 10000000422200 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000422200 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000423100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000423100 FB001 2016.01 PLAN 310.00

1000 EUR 10000000423100 FB100 2016.01 PLAN 310.00

1000 EUR 10000000423100 FB120 2016.01 PLAN 310.00

1020 EUR 10000000423100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000423100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000423200 FB000 2016.01 PLAN 310.00

1000 EUR 10000000423200 FB001 2016.01 PLAN 310.00

1000 EUR 10000000423200 FB100 2016.01 PLAN 310.00

1000 EUR 10000000423200 FB120 2016.01 PLAN 310.00

1020 EUR 10000000423200 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000423200 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000424100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000424100 FB001 2016.01 PLAN 0.00

1000 EUR 10000000424100 FB100 2016.01 PLAN 310.00

1000 EUR 10000000424100 FB120 2016.01 PLAN 0.00

1020 EUR 10000000424100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000424100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000424200 FB000 2016.01 PLAN 310.00

1000 EUR 10000000424200 FB001 2016.01 PLAN 0.00

1000 EUR 10000000424200 FB100 2016.01 PLAN 310.00

1000 EUR 10000000424200 FB120 2016.01 PLAN 0.00

1020 EUR 10000000424200 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000424200 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000426000 FB000 2016.01 PLAN 0.00

1000 EUR 10000000426000 FB001 2016.01 PLAN 0.00

1000 EUR 10000000426000 FB100 2016.01 PLAN 0.00

1000 EUR 10000000426000 FB120 2016.01 PLAN 0.00

1020 EUR 10000000426000 FB000 2016.01 PLAN 31000.00

1020 EUR 10000000426000 FB100 2016.01 PLAN 31000.00

1000 EUR 10000000426001 FB000 2016.01 PLAN 310.00

1000 EUR 10000000426001 FB100 2016.01 PLAN 310.00

1020 EUR 10000000426001 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000426001 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000464000 FB000 2016.01 PLAN 310.00

1000 EUR 10000000464000 FB100 2016.01 PLAN 310.00

1020 EUR 10000000464000 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000464000 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000464100 FB000 2016.01 PLAN 310.00

1000 EUR 10000000464100 FB100 2016.01 PLAN 310.00

1020 EUR 10000000464100 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000464100 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000464005 FB000 2016.01 PLAN 310.00

1000 EUR 10000000464005 FB100 2016.01 PLAN 310.00

1020 EUR 10000000464005 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000464005 FB100 2016.01 PLAN 3100.00

1000 EUR 10000000464105 FB000 2016.01 PLAN 310.00

1000 EUR 10000000464105 FB100 2016.01 PLAN 310.00

1020 EUR 10000000464105 FB000 2016.01 PLAN 3100.00

1020 EUR 10000000464105 FB100 2016.01 PLAN 3100.00

1020 EUR 10000000415230 FB000 2016.01 PLAN 100.00

1020 EUR 10000000415230 FB100 2016.01 PLAN 100.00

1020 EUR 10000000490000 FB000 2016.01 PLAN 100.00

1020 EUR 10000000490000 FB100 2016.01 PLAN 100.00

102  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :25.00  ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING", #dimensions=7

COMPANY_CODE,CURRENCY,MEASURES,P_ACCOUNT,P_FACHBEREICH,TIME,VERSION

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING", #dimensions=7

COMPANY_CODE,CURRENCY,MEASURES,P_ACCOUNT,P_FACHBEREICH,TIME,VERSION

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

#dim_memberset=2

VERSION:PLAN,1 in total.

TIME:2016.01,1 in total.

SCRIPT RUNNING TIME IN TOTAL:35.00 s.

LOG END TIME:2016-05-25 17:24:27

Could anybody please help me?

Thanks in advance and best regards

Gerd

[former_member186338 · Accepted solution]

The issue is here

*WHEN TIME

*IS %TIME_SET%

It will work only with initial 2016 year. Remove this lines.

Vadim

[former_member186338 · Accepted solution]

The final, correct version of your script (very short 😞

*XDIM_MEMBERSET VERSION=%VERSION_SET% //optional, the scope will be already set to %VERSION_SET%

*XDIM_MEMBERSET TIME=%TIME_SET%,TMVL(12,%TIME_SET%),TMVL(24,%TIME_SET%)

*XDIM_MEMBERSET P_ACCOUNT=930000425100,930000425200,930000420100,930000420200,930000421100,930000421200, 930000422100,930000422200,930000423100,930000423200,930000424100,930000424200, 930000426000,930000426001,930000464000,930000464100,930000464005,930000464105,930000415230,930000490000

*WHEN P_ACCOUNT

*IS 930000425100

*REC(EXPRESSION=[P_ACCOUNT].[900000425100]*%VALUE%*31,P_ACCOUNT="10000000425100")

*IS 930000425200

*REC(EXPRESSION=[P_ACCOUNT].[900000425200]*%VALUE%*31,P_ACCOUNT="10000000425200")

*IS 930000420100

*REC(EXPRESSION=[P_ACCOUNT].[900000420100]*%VALUE%*31,P_ACCOUNT="10000000420100")

*IS 930000420200

*REC(EXPRESSION=[P_ACCOUNT].[900000420200]*%VALUE%*31,P_ACCOUNT="10000000420200")

*IS 930000421100

*REC(EXPRESSION=[P_ACCOUNT].[900000421100]*%VALUE%*31,P_ACCOUNT="10000000421100")

*IS 930000421200

*REC(EXPRESSION=[P_ACCOUNT].[900000421200]*%VALUE%*31,P_ACCOUNT="10000000421200")

*IS 930000422100

*REC(EXPRESSION=[P_ACCOUNT].[900000422100]*%VALUE%*31,P_ACCOUNT="10000000422100")

*IS 930000422200

*REC(EXPRESSION=[P_ACCOUNT].[900000422200]*%VALUE%*31,P_ACCOUNT="10000000422200")

*IS 930000423100

*REC(EXPRESSION=[P_ACCOUNT].[900000423100]*%VALUE%*31,P_ACCOUNT="10000000423100")

*IS 930000423200

*REC(EXPRESSION=[P_ACCOUNT].[900000423200]*%VALUE%*31,P_ACCOUNT="10000000423200")

*IS 930000424100

*REC(EXPRESSION=[P_ACCOUNT].[900000424100]*%VALUE%*31,P_ACCOUNT="10000000424100")

*IS 930000424200

*REC(EXPRESSION=[P_ACCOUNT].[900000424200]*%VALUE%*31,P_ACCOUNT="10000000424200")

*IS 930000426000

*REC(EXPRESSION=[P_ACCOUNT].[900000426000]*%VALUE%*31,P_ACCOUNT="10000000426000")

*IS 930000426001

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%*31,P_ACCOUNT="10000000426001")

*IS 930000464000

*REC(EXPRESSION=[P_ACCOUNT].[900000464000]*%VALUE%*31,P_ACCOUNT="10000000464000")

*IS 930000464100

*REC(EXPRESSION=[P_ACCOUNT].[900000464100]*%VALUE%*31,P_ACCOUNT="10000000464100")

*IS 930000464005

*REC(EXPRESSION=[P_ACCOUNT].[900000464005]*%VALUE%*31,P_ACCOUNT="10000000464005")

*IS 930000464105

*REC(EXPRESSION=[P_ACCOUNT].[900000464105]*%VALUE%*31,P_ACCOUNT="10000000464105")

*IS 930000415230

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000415230")

*IS 930000490000

*REC(EXPRESSION=[P_ACCOUNT].[900000426001]*%VALUE%,P_ACCOUNT="10000000490000")

*ENDWHEN

[Former Member]

Hi Could you please check in Execute(Simulate) mode in UJKT?

I have verified your scope in my system and i am getting desired output.

Thanks

Raghu