Skip to Content
0
Jul 01, 2019 at 11:25 AM

Parent member as a driver

63 Views Last edit Jul 01, 2019 at 11:29 AM 2 rev

Dear experts,

I need your advise.

Calculation engine used: JAVASCRIPT

List of dimensions: ACCOUNT_PL, TIME, VERSION, COMPANY, DATASOURCE, FOCUS, MEASURE, RPTCURRENCY, TERM, PARTNER, VENDOR.

Script to be launched by DM package

The task is to forecast the value of the account AC_ZRT005283 for the planning horizon %HOR% using the value of the account AC_ZRT005283 as of last available actual month (%LAST_ACTUAL_MONTH%) and change it using the growth rate of the account AC_ZRT005266 (current period %T% to %LAST_ACTUAL_MONTH%). Account

AC_ZRT005266 is a parent member of 3 accounts (AC_ZRT005267, AC_ZRT005268,AC_ZRT0052669).

Script:

*XDIM_MEMBERSET VERSION = VE_201803090101

*XDIM_MEMBERSET ACCOUNT_PL = AC_ZRT005283

*XDIM_MEMBERSET COMPANY = CO_6

*XDIM_MEMBERSET RPTCURRENCY = EUR_EUR

*XDIM_MEMBERSET TERM=TE_1

*XDIM_MEMBERSET PARTNER=PA_P1

*XDIM_MEMBERSET TIME = %LAST_ACTUAL_MONTH%

*FOR %T% = %HOR%

*WHEN TIME

*IS %T%

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[%T%],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[%LAST_ACTUAL_MONTH%],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=%T%,PARTNER = PA_P1)

*ENDWHEN

*NEXT

*COMMIT

UJKT result:

LGX:

*XDIM_MEMBERSET VERSION = VE_201803090101

*XDIM_MEMBERSET ACCOUNT_PL = AC_ZRT005283

*XDIM_MEMBERSET COMPANY = CO_6

*XDIM_MEMBERSET RPTCURRENCY = EUR_EUR

*XDIM_MEMBERSET TERM=TE_1

*XDIM_MEMBERSET PARTNER=PA_P1

*XDIM_MEMBERSET TIME = 2018.03

*WHEN TIME

*IS 2018.04

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.04],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.04,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.05

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.05],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.05,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.06

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.06],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.06,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.07

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.07],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.07,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.08

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.08],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.08,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.09

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.09],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.09,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.10

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.10],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.10,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.11

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.11],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.11,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2018.12

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.12],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2018.12,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.01

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.01],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.01,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.02

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.02],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.02,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.03

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.03],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.03,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.04

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.04],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.04,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.05

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.05],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.05,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.06

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.06],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.06,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.07

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.07],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.07,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.08

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.08],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.08,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.09

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.09],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.09,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.10

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.10],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.10,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.11

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.11],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.11,PARTNER = PA_P1)

*ENDWHEN

*WHEN TIME

*IS 2019.12

*REC(EXPRESSION =%VALUE%*([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2019.12],[TERM].[TE_TOTAL])/([ACCOUNT_PL].[AC_ZRT005266],[PARTNER].[PA_TOTAL],[TIME].[2018.03],[TERM].[TE_TOTAL]),ACCOUNT_PL = AC_ZRT005283,TIME=2019.12,PARTNER = PA_P1)

*ENDWHEN

*COMMIT

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

LOG:

APPLICATION:PLANNING01

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="PLANNING01", #dimensions=11

ACCOUNT_PL,COMPANY,DATASOURCE,FOCUS,MEASURES,PARTNER,RPTCURRENCY,TERM,TIME,VENDOR,VERSION

#dim_memberset=7

VERSION:VE_201803090101,1 in total.

ACCOUNT_PL:AC_ZRT005283,1 in total.

COMPANY:CO_6,1 in total.

RPTCURRENCY:EUR_EUR,1 in total.

TERM:TE_1,1 in total.

PARTNER:PA_P1,1 in total.

TIME:2018.03,1 in total.

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

Attachments

bmdsc.png (5.9 kB)