Conditional Copy one to one

[Former Member]

Hi there,
I use BPC 7.5 NW SP 10
I want to copy the values ​​from last year to next year as follows:

I run my package 3 times out:
Step1: Budget  BAS(current year) to Budget BAS(next year)
Step2: Counter BAS(current year) to Budget BAS(next year) (must overwrite if %value%<> 0 or <> "")
Step3: Actual   BAS(current year) to Budget BAS(next year) (must overwrite if %value%<> 0 or <> "")

In dafault Copy Package that does not work, because with Counter or Actual values come ​​also 0 or "".

With Boolean'm not progressed.

Any idea?

Thanks in advance.
Alisher

//---priorization logic

//---My Package

//----My Script

*SELECT(%ERZ_FW%,"[ID]",EDM_PLANT,"[VART]=FW")

*SELECT(%ERZ_KW%,"[ID]",EDM_PLANT,"[VART]=KW")

*SELECT(%ERZ_DL%,"[ID]",EDM_PLANT,"[VART]=DL")

*SELECT(%ERZ_ST%,"[ID]",EDM_PLANT,"[VART]=ST")

//---

*XDIM_MEMBERSET EDM_ACCT = %EDM_ACCT_SET%

*XDIM_MEMBERSET EDM_DATASRC = %EDM_DATASRC_SET%

*XDIM_MEMBERSET EDM_OBJECT = %EDM_OBJECT_SET%

*XDIM_MEMBERSET EDM_PLANT = %ERZ_FW%,%ERZ_KW%,%ERZ_DL%,%ERZ_ST%

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = %EDM_TIME_SET%

*XDIM_MEMBERSET EDM_VIEW = %EDM_VIEW_SET%

*XDIM_MEMBERSET MEASURES = PERIODIC

//---

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME.PERIOD

*IS JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(1,%EDM_TIME_SET%))

*IS FEB

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(2,%EDM_TIME_SET%))

*IS MAR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(3,%EDM_TIME_SET%))

*IS APR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(4,%EDM_TIME_SET%))

*IS MAY

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(5,%EDM_TIME_SET%))

*IS JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(6,%EDM_TIME_SET%))

*IS JUL

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(7,%EDM_TIME_SET%))

*IS AUG

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(8,%EDM_TIME_SET%))

*IS SEP

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(9,%EDM_TIME_SET%))

*IS OCT

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(10,%EDM_TIME_SET%))

*IS NOV

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(11,%EDM_TIME_SET%))

*IS DEC

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(12,%EDM_TIME_SET%))

*ENDWHEN

*ENDWHEN

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN SIGNEDDATA

*IS >0

*WHEN EDM_TIME.PERIOD

*IS JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(1,%EDM_TIME_SET%))

*IS FEB

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(2,%EDM_TIME_SET%))

*IS MAR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(3,%EDM_TIME_SET%))

*IS APR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(4,%EDM_TIME_SET%))

*IS MAY

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(5,%EDM_TIME_SET%))

*IS JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(6,%EDM_TIME_SET%))

*IS JUL

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(7,%EDM_TIME_SET%))

*IS AUG

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(8,%EDM_TIME_SET%))

*IS SEP

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(9,%EDM_TIME_SET%))

*IS OCT

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(10,%EDM_TIME_SET%))

*IS NOV

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(11,%EDM_TIME_SET%))

*IS DEC

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(12,%EDM_TIME_SET%))

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

[former_member186338 · Accepted solution]

Hi Alisher,

I do not understand completely your TIME copy logic (all TMVL's...), please explain!

But the code

*WHEN SIGNEDDATA

*IS >0

Is not supported in BPC NW.

In order to test the value in the current record inside WHEN/ENDWHEN you have to use ternaru operator like:

*REC(EXPRESSION= %VALUE%>0 ? %VALUE% : ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[SOMETIME]),EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=SOMETIME)

If %VALUE%>0 then copy this value to target, if not copy target value to target...

Something like this.

Vadim

P.S. And REMOVE AND FORGET ABOUT COMMIT!

[former_member186338 · Accepted solution]

P.S. If condition is %value%<> 0

then the code will be:

*REC(EXPRESSION= %VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[SOMETIME]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=SOMETIME)

[Former Member · Accepted solution]

thank you for your quick response.

ok, that was not finished script.

With the time logic I just want to copy in the package passed time Members on next year period e.g. 2013.Jan to 2014.Jan.For the first step is actually the default copy package sufficient.I want to run all the steps in one package, where the time dimension in terms of the next year must be variable.

I'm trying to implement this and share with you the result.

Alisher

[Former Member · Accepted solution]

Hi Vadim,

I have scripted for 2013.Jan/2014.Feb and run the package.

Status "Error", "Unknown Dimension Name in Keyword": "

What is wrong with in thie script?

Why do I have to remove "*Commit"?

Is there any possibility for the condition that if "FALSE" then do nothing?

Thx

Alisher

//---

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME.PERIOD

*IS JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(1,%EDM_TIME_SET%))

*ENDWHEN

*ENDWHEN

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME.PERIOD

*IS JAN

*REC(EXPRESSION=%VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[TMVL(1,%EDM_TIME_SET%)]) :%VALUE%,([EDM_VIEW].[COUNTER],[EDM_DATASRC].[IMPORT],[EDM_TIME].[EDM_TIME_SET%]))

*ENDWHEN

*ENDWHEN

[former_member186338 · Accepted solution]

Please test script for single month with fixed TIME members.

Second - you incorrectly copied my code:

*REC(EXPRESSION=%VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[TMVL(1,%EDM_TIME_SET%)]) :%VALUE%,([EDM_VIEW].[COUNTER],[EDM_DATASRC].[IMPORT],[EDM_TIME].[EDM_TIME_SET%]))

What do you mean by bold part??? Is it the same as in:

*REC(EXPRESSION= %VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[SOMETIME]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=SOMETIME)

Instead of SOMETIME put some TIME member

Please, read help about REC statement.

COMMIT is absolutely useless with WHEN/ENDWHEN, remove it.

Vadim

[former_member186338 · Accepted solution]

If you want to copy from 2013.Jan to 2014.Jan etc. then you need different logic for TMVL:

Something like:

*FOR %M%=%EDM_TIME_SET%

*XDIM_MEMBERSET EDM_TIME=%M% //single source period

...

*REC(...,EDM_TIME=TMVL(12,%M%),...) //12 months shift to the next year

...

*NEXT

[Former Member · Accepted solution]

Ok, I've corrected the script, still get the same error status:

*FOR %M%=%EDM_TIME_SET%

*REC(EXPRESSION=%VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[TMVL(1,%M%)]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2020.DEC)

*NEXT

[former_member186338 · Accepted solution]

Please provide the FULL code and the result in UJKT! And test it without FOR/NEXT, for SINGLE fixed month!

Show UJKT screenshot!

Vadim

[former_member186338 · Accepted solution]

And please, read here:

[Former Member · Accepted solution]

UJKT code:

Full code:

No status change!

[former_member186338 · Accepted solution]

Please read

You didn't provided the scope in the Data Area...

[Former Member · Accepted solution]

[former_member186338 · Accepted solution]

Please, attach the UJKT result (lgx and log) as text file to the message. The script has to run without issues.

[Former Member · Accepted solution]

*SELECT(%ERZ_FW%,"[ID]",EDM_PLANT,"[VART]=FW")

*SELECT(%ERZ_KW%,"[ID]",EDM_PLANT,"[VART]=KW")

*SELECT(%ERZ_DL%,"[ID]",EDM_PLANT,"[VART]=DL")

*SELECT(%ERZ_ST%,"[ID]",EDM_PLANT,"[VART]=ST")

*XDIM_MEMBERSET EDM_ACCT = ACC2210,ACC2230,ACC2240,ACC2250

*XDIM_MEMBERSET EDM_DATASRC = %EDM_DATASRC_SET%

*XDIM_MEMBERSET EDM_OBJECT = %EDM_OBJECT_SET%

*XDIM_MEMBERSET EDM_PLANT = %ERZ_FW%,%ERZ_KW%,%ERZ_DL%,%ERZ_ST%

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = %EDM_TIME_SET%

*XDIM_MEMBERSET EDM_VIEW = %EDM_VIEW_SET%

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JAN)

*ENDWHEN

*ENDWHEN

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JAN]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2020.DEC)

*ENDWHEN

*ENDWHEN

LGX:

*XDIM_MEMBERSET EDM_ACCT = ACC2210,ACC2230,ACC2240,ACC2250

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_OBJECT = P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004

*XDIM_MEMBERSET EDM_PLANT = P001_15,P002_15,P003_15,P004_15,P005_15,P006_15,P007_15,P008_15,P009_15,P010_15,P011_15,P012_15,P013_15,P014_15,P015_15,P016_15,P017_15,P018_15,P019_15,P020_15,P025_15,P029_15,P033_15,P043_15,P044_15,P045_15,P046_15,P047_15,P048_15,P054_15,P055_15,P079_15,P080_15,P081_15,P082_15,P083_15,P084_15,P085_15,P086_15,P087_15,P088_15,P089_15,P090_15,P091_15,P092_15,P093_15,P094_15,P095_15,P096_15,P097_15,P098_15,P099_15,P100_15,P101_15,P102_15,P103_15,P104_15,P105_15,P106_15,P107_15,P113_15,P114_15,P115_15,P116_15,P117_15,P118_15,P119_15,P120_15,P121_15,P122_15,P123_15,P124_15,P125_15,P116_20,P021_19,P022_19,P023_19,P024_19,P025_19,P026_19,P027_19,P028_19,P030_19,P031_19,P032_19,P034_19,P035_19,P036_19,P037_19,P038_19,P039_19,P040_19,P041_19,P042_19,P049_19,P050_19,P051_19,P052_19,P053_19,P055_19,P056_19,P057_19,P058_19,P059_19,P060_19,P061_19,P062_19,P063_19,P064_19,P065_19,P066_19,P067_19,P068_19,P069_19,P070_19,P071_19,P072_19,P073_19,P074_19,P075_19,P076_19,P077_19,P078_19,P018_17,P020_17,P025_17,P029_17,P047_17,P054_17,P114_17

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = 2013.DEC

*XDIM_MEMBERSET EDM_VIEW = COUNTER

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JAN)

*ENDWHEN

*ENDWHEN

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JAN]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2020.DEC )

*ENDWHEN

*ENDWHEN

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

LOG:

FILE:\ROOT\WEBFOLDERS\EON_BAGN \ADMINAPP\EDM\TEST.LGF

USER:U-DOM1\A39523

APPSET:EON_BAGN

APPLICATION:EDM

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.DEC,1 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.DEC,1 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

SCRIPT RUNNING TIME IN TOTAL:0.34 s.

[former_member186338 · Accepted solution]

Ok, now it's clear - you original scope don't have records to match *IS condition in WHEN/ENDWHEN:

Scope:

EDM_TIME:2013.DEC,1 in total.

EDM_VIEW:COUNTER,1 in total.

In the first WHEN/ENDWHEN:

*WHEN EDM_VIEW

*IS BUDGET - no records

*WHEN EDM_TIME

*IS 2013.JAN - no records

In the second:

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME

*IS 2013.JAN - no records

Please, test with correct scope!

Also, remove useless lines (it's default):

*XDIM_MEMBERSET MEASURES = PERIODIC //the model is periodic!

*WHEN_REF_DATA=TRANS_DATA

Vadim

[Former Member · Accepted solution]

Hi Vadim,
I have your first suggestion (* REC (EXPRESSION =% VALUE%> 0% VALUE%?: ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[SOMETIME]),EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=SOMETIME)) taken, and the validation and simulation as well package are successfully gone through.

Script file:

//----------------------VART---------------------------------------------------------

*SELECT(%ERZ_FW%,"[ID]",EDM_PLANT,"[VART]=FW")

*SELECT(%ERZ_KW%,"[ID]",EDM_PLANT,"[VART]=KW")

*SELECT(%ERZ_DL%,"[ID]",EDM_PLANT,"[VART]=DL")

*SELECT(%ERZ_ST%,"[ID]",EDM_PLANT,"[VART]=ST")

//---

*XDIM_MEMBERSET EDM_ACCT = ACC2210,ACC2230,ACC2240,ACC2250

*XDIM_MEMBERSET EDM_DATASRC = %EDM_DATASRC_SET%

*XDIM_MEMBERSET EDM_OBJECT = %EDM_OBJECT_SET%

*XDIM_MEMBERSET EDM_PLANT = %ERZ_FW%,%ERZ_KW%,%ERZ_DL%,%ERZ_ST%

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = %EDM_TIME_SET%

*XDIM_MEMBERSET EDM_VIEW = %EDM_VIEW_SET%

*XDIM_MEMBERSET MEASURES = PERIODIC

//---

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JAN)

*IS 2013.FEB

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.FEB)

*IS 2013.MAR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.MAR)

*IS 2013.APR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.APR)

*IS 2013.MAY

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.MAY)

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*IS 2013.JUL

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUL)

*IS 2013.AUG

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.AUG)

*IS 2013.SEP

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.SEP)

*IS 2013.OCT

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.OCT)

*IS 2013.NOV

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.NOV)

*IS 2013.DEC

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.DEC)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JAN]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JAN)

*IS 2013.FEB

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.FEB]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.FEB)

*IS 2013.MAR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAR]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.MAR)

*IS 2013.APR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.APR]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.APR)

*IS 2013.MAY

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAY]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.MAY)

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*IS 2013.JUL

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUL]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JUL)

*IS 2013.AUG

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.AUG]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.AUG)

*IS 2013.SEP

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.SEP]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.SEP)

*IS 2013.OCT

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.OCT]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.OCT)

*IS 2013.NOV

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.NOV]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.NOV)

*IS 2013.DEC

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.DEC]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.DEC)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS ACTUAL

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JAN]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JAN)

*IS 2013.FEB

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.FEB]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.FEB)

*IS 2013.MAR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAR]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.MAR)

*IS 2013.APR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.APR]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.APR)

*IS 2013.MAY

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAY]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.MAY)

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*IS 2013.JUL

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUL]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JUL)

*IS 2013.AUG

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.AUG]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.AUG)

*IS 2013.SEP

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.SEP]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.SEP)

*IS 2013.OCT

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.OCT]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.OCT)

*IS 2013.NOV

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.NOV]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.NOV)

*IS 2013.DEC

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.DEC]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.DEC)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

UJKT log file:

LGX:

*XDIM_MEMBERSET EDM_ACCT = ACC2210,ACC2230,ACC2240,ACC2250

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_OBJECT = P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004

*XDIM_MEMBERSET EDM_PLANT = P001_15,P002_15,P003_15,P004_15,P005_15,P006_15,P007_15,P008_15,P009_15,P010_15,P011_15,P012_15,P013_15,P014_15,P015_15,P016_15,P017_15,P018_15,P019_15,P020_15,P025_15,P029_15,P033_15,P043_15,P044_15,P045_15,P046_15,P047_15,P048_15,P054_15,P055_15,P079_15,P080_15,P081_15,P082_15,P083_15,P084_15,P085_15,P086_15,P087_15,P088_15,P089_15,P090_15,P091_15,P092_15,P093_15,P094_15,P095_15,P096_15,P097_15,P098_15,P099_15,P100_15,P101_15,P102_15,P103_15,P104_15,P105_15,P106_15,P107_15,P113_15,P114_15,P115_15,P116_15,P117_15,P118_15,P119_15,P120_15,P121_15,P122_15,P123_15,P124_15,P125_15,P116_20,P021_19,P022_19,P023_19,P024_19,P025_19,P026_19,P027_19,P028_19,P030_19,P031_19,P032_19,P034_19,P035_19,P036_19,P037_19,P038_19,P039_19,P040_19,P041_19,P042_19,P049_19,P050_19,P051_19,P052_19,P053_19,P055_19,P056_19,P057_19,P058_19,P059_19,P060_19,P061_19,P062_19,P063_19,P064_19,P065_19,P066_19,P067_19,P068_19,P069_19,P070_19,P071_19,P072_19,P073_19,P074_19,P075_19,P076_19,P077_19,P078_19,P018_17,P020_17,P025_17,P029_17,P047_17,P054_17,P114_17

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = 2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,2013.MAY,2013.JUN,2013.JUL,2013.AUG,2013.SEP,2013.OCT,2013.NOV,2013.DEC

*XDIM_MEMBERSET EDM_VIEW = COUNTER

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JAN)

*IS 2013.FEB

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.FEB)

*IS 2013.MAR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.MAR)

*IS 2013.APR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.APR)

*IS 2013.MAY

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.MAY)

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*IS 2013.JUL

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUL)

*IS 2013.AUG

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.AUG)

*IS 2013.SEP

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.SEP)

*IS 2013.OCT

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.OCT)

*IS 2013.NOV

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.NOV)

*IS 2013.DEC

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.DEC)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JAN]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JAN)

*IS 2013.FEB

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.FEB]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.FEB)

*IS 2013.MAR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAR]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.MAR)

*IS 2013.APR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.APR]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.APR)

*IS 2013.MAY

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAY]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.MAY)

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*IS 2013.JUL

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUL]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JUL)

*IS 2013.AUG

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.AUG]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.AUG)

*IS 2013.SEP

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.SEP]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.SEP)

*IS 2013.OCT

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.OCT]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.OCT)

*IS 2013.NOV

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.NOV]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.NOV)

*IS 2013.DEC

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.DEC]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.DEC)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS ACTUAL

*WHEN EDM_TIME

*IS 2013.JAN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JAN]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JAN)

*IS 2013.FEB

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.FEB]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.FEB)

*IS 2013.MAR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAR]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.MAR)

*IS 2013.APR

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.APR]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.APR)

*IS 2013.MAY

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAY]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.MAY)

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*IS 2013.JUL

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUL]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JUL)

*IS 2013.AUG

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.AUG]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.AUG)

*IS 2013.SEP

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.SEP]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.SEP)

*IS 2013.OCT

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.OCT]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.OCT)

*IS 2013.NOV

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.NOV]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.NOV)

*IS 2013.DEC

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.DEC]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.DEC)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

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

LOG:

FILE:\ROOT\WEBFOLDERS\EON_BAGN \ADMINAPP\EDM\TEST.LGF

USER:U-DOM1\A39523

APPSET:EON_BAGN

APPLICATION:EDM

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.MAR,2013.APR,...13 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

SCRIPT RUNNING TIME IN TOTAL:2.62 s.

_____________________________________________________________

In package I passed throug Counter values for all periods of 2013.

But the results are not correct.

Data in my Input Schedule:

Package log:

LOG BEGIN TIME:2014-07-11 12:12:30

FILE:\ROOT\WEBFOLDERS\EON_BAGN\ADMINAPP\EDM\14_COPY_VART.LGF

USER:U-DOM1\A39523

APPSET:EON_BAGN

APPLICATION:EDM

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JAN]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1139.56 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1053.01 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :53.93 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.FEB]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 815.05 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 845.12 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :36.03 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAR]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1005.28 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 873.63 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :34.03 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.APR]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 784.39 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 942.94 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :35.09 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.MAY]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1017.02 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 814.13 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :35.08 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 910.04 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 822.47 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :34.22 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUL]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 901.21 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 961.12 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :34.90 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.AUG]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 825.28 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1003.41 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :33.91 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.SEP]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 884.02 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 947.27 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :34.94 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.OCT]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 965.04 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 775.08 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :36.87 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.NOV]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1075.35 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1013.55 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :34.88 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

REC :%VALUE%>0?([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.DEC]):%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 975.14 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1080.13 ms. 12  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :33.89 ms.

4  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 48  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

EDM_ACCT    EDM_DATASRC    EDM_OBJECT    EDM_PLANT    EDM_REPCYCLE    EDM_RPTCUR    EDM_TARIFF    EDM_TIME    EDM_VIEW    SIGNEDDATA

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.JAN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.JAN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.JAN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.JAN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.FEB    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.FEB    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.FEB    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.FEB    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.MAR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.MAR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.MAR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.MAR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.APR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.APR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.APR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.APR    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.MAY    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.MAY    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.MAY    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.MAY    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.JUN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.JUN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.JUN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.JUN    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.JUL    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.JUL    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.JUL    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.JUL    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.AUG    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.AUG    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.AUG    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.AUG    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.SEP    COUNTER    10.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.SEP    COUNTER    10.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.SEP    COUNTER    10.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.SEP    COUNTER    10.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.OCT    COUNTER    0.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.OCT    COUNTER    0.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.OCT    COUNTER    0.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.OCT    COUNTER    0.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.NOV    COUNTER    0.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.NOV    COUNTER    0.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.NOV    COUNTER    0.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.NOV    COUNTER    0.00

ACC2240    COPY    P094_T178_010270001    P094_15    KJ    EUR    TID_NAS    2012.DEC    COUNTER    0.00

ACC2240    COPY    P094_T178_010270002    P094_15    KJ    EUR    TID_NAS    2012.DEC    COUNTER    0.00

ACC2240    COPY    P094_T178_010270003    P094_15    KJ    EUR    TID_NAS    2012.DEC    COUNTER    0.00

ACC2240    COPY    P094_T178_010270004    P094_15    KJ    EUR    TID_NAS    2012.DEC    COUNTER    0.00

48  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :246.66  ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2210,ACC2230,ACC2240,ACC2250,4 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,P094_T178_010270002,P094_T178_010270003,P094_T178_010270004,4 in total.

EDM_PLANT:P001_15,P002_15,P003_15,P004_15,P005_15,...130 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JAN,2013.FEB,2013.MAR,2013.APR,2013.MAY,...12 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

SCRIPT RUNNING TIME IN TOTAL:26.03 s.

LOG END TIME:2014-07-11 12:12:55

[former_member186338 · Accepted solution]

Sorry, but it's not possible for me to read all this long text. You have to test on some simple case with limited scope.

Vadim

[Former Member · Accepted solution]

Hi Vadim,
Here is a simplified version as desired.
I have 2013.Jun "Counter" values ​​in DM package passed though, the script does nothing. I would be grateful to you for your support.

Best Regards
Alisher

Input Schedule:

Script Logic:

*XDIM_MEMBERSET EDM_ACCT =ACC2240

*XDIM_MEMBERSET EDM_DATASRC = $VAR1$ //--DM Variable

*XDIM_MEMBERSET EDM_OBJECT = $VAR2$ //--DM Variable

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = $VAR3$ //--DM Variable

*XDIM_MEMBERSET EDM_VIEW = $VAR4$ //--DM Variable

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS ACTUAL

*WHEN EDM_TIME

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

LGX:

LGX:

*XDIM_MEMBERSET EDM_ACCT = ACC2240

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_OBJECT = P094_T178_010270001

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = 2013.JUN

*XDIM_MEMBERSET EDM_VIEW = COUNTER

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN EDM_TIME

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=COUNTER,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS ACTUAL

*WHEN EDM_TIME

*IS 2013.JUN

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=ACTUAL,EDM_DATASRC=COPY,EDM_TIME=2012.JUN)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

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

LOG:

FILE:\ROOT\WEBFOLDERS\EON_BAGN \ADMINAPP\EDM\TEST.LGF

USER:U-DOM1\A39523

APPSET:EON_BAGN

APPLICATION:EDM

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_ACCT:ACC2240,1 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,1 in total.

EDM_PLANT:P094_15,1 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JUN,1 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2240,1 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,1 in total.

EDM_PLANT:P094_15,1 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JUN,1 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

#dim_memberset=10

EDM_ACCT:ACC2240,1 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_OBJECT:P094_T178_010270001,1 in total.

EDM_PLANT:P094_15,1 in total.

EDM_REPCYCLE:KJ,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_TARIFF:TID_NAS,1 in total.

EDM_TIME:2013.JUN,1 in total.

EDM_VIEW:COUNTER,1 in total.

MEASURES:PERIODIC,1 in total.

SCRIPT RUNNING TIME IN TOTAL:0.38 s.

[former_member186338 · Accepted solution]

The code you are trying to run is full of mistakes

Try simple code like:

*XDIM_MEMBERSET EDM_ACCT = ACC2240

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_OBJECT = P094_T178_010270001

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = 2013.JUN //Current month

//First copy BUDGET to BUDGET to 2014.JUN

*XDIM_MEMBERSET EDM_VIEW = BUDGET

*WHEN EDM_VIEW

*IS *

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*ENDWHEN

//Second copy COUNTER to BUDGET if COUNTER<>0 to 2014.JUN

*XDIM_MEMBERSET EDM_VIEW = COUNTER

*WHEN EDM_VIEW

*IS *

*REC(EXPRESSION=%VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*ENDWHEN

//Third copy ACTUAL to BUDGET if ACTUAL<>0 to 2014.JUN

*XDIM_MEMBERSET EDM_VIEW = ACTUAL

*WHEN EDM_VIEW

*IS *

*REC(EXPRESSION=%VALUE%==0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*ENDWHEN

If ACTUAL or COUNTER = 0, then copy destination to destination - no change!

Vadim

[Former Member · Accepted solution]

Hi Vadim,

thanks for detailed script. With "==" does not work, I get all the time the error message UJK_VALIDATION_EXCEPTION: Unknown Dimension Name in Keyword: ":. I replaced "==" with ">", then validation status is "OK". After my testing I found that the condition "if TRUE" does not work.

I transferred this code into Boolean method, however, the Boolean does not support  equation sign "=".

Any Idea?

[former_member186338 · Accepted solution]

The recognition of == and <> depends on BPC version and SP. But > has to work in any version! and if true condition will be calculated. You are doing something wrong, just try some absolutely simple code.

Vadim

[Former Member · Accepted solution]

Thanks Vadim,
I tested with an absolutely simple script and have the following results:

Data:

Script:

//%EDM_OBJECT_SET%:  P094_T178_010270001 (passed from DM)

*XDIM_MEMBERSET EDM_ACCT = ACC2240

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_OBJECT = %EDM_OBJECT_SET%  

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = 2013.JUN

*XDIM_MEMBERSET EDM_VIEW = COUNTER

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN EDM_VIEW

*IS *

*REC(EXPRESSION=%VALUE%>0 ? ([EDM_VIEW].[BUDGET],[EDM_DATASRC].[COPY],[EDM_TIME].[2014.JUN]) : %VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=2014.JUN)

*ENDWHEN

Formula LOG:

I really need a solution. I would be grateful to you for your feedback.
Thanks and regards/Alisher

[former_member186338 · Accepted solution]

Test <0, because if the ACCTYPE of ACC2240 is INC or LEQ then the actual value will be negative opposed to report value.

[former_member186338 · Accepted solution]

Ups, strange logic in in your script - if current record for COUNTER is >0 then do nothing (write same value as in destination) if not - write value from COUNTER to BUDGET...

Test script in UJKT.

Vadim

[Former Member · Accepted solution]

Hello Vadim,

I understood all the time the first part of the scrip as a target for counter, in consequence I have also evaluated incorrectly.

Now it works great and many thanks.

[Former Member · Accepted solution]

Hi Vadim,
here I get only aggregated data. Do you know what it could be?

Script:

*SELECT(%ERZ_FW%,"[ID]",EDM_PLANT,"[VART]=FW")

*XDIM_MEMBERSET EDM_ACCT = ACC2240

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_OBJECT = P094_T178_010270001

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = %EDM_TIME_SET%

*XDIM_MEMBERSET EDM_VIEW = BUDGET

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_DATASRC

*IS*

*FOR %M%=%EDM_TIME_SET%

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=CALC,EDM_TIME=TMVL(12,%M%))

*NEXT

*ENDWHEN

DM Log:

Report:

[former_member186338 · Accepted solution]

Correct TIME scope required:

*SELECT(%ERZ_FW%,"[ID]",EDM_PLANT,"[VART]=FW")

*XDIM_MEMBERSET EDM_ACCT = ACC2240

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_OBJECT = P094_T178_010270001

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = %EDM_TIME_SET%

*XDIM_MEMBERSET EDM_VIEW = BUDGET

*XDIM_MEMBERSET MEASURES = PERIODIC

*FOR %M%=%EDM_TIME_SET% //loop all months

*XDIM_MEMBERSET EDM_TIME = %M%

*WHEN EDM_DATASRC

*IS*

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=CALC,EDM_TIME=TMVL(12,%M%))

*ENDWHEN

*NEXT

AND REMOVE THIS USELESS *WHEN_REF_DATA=TRANS_DATA!

Vadim

[Former Member · Accepted solution]

Hello Vadim,

I want to calculate the revenues with budget and Counter quantities. For this I have price (in scope) and Budget /

Counter quantities (in lookup).

The logic must do the following: if counter values ​​are greater than "0", then calculate the revenue with the Counter quantities; otherwise calculate with budget quantities and write

on budget revenue.

BUT, the Scirpt calculate

me only with budget amounts.

What is wrong with the logic?

Logic:

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_VIEW = BUDGET

*XDIM_MEMBERSET EDM_ACCT = ACC4200

*XDIM_MEMBERSET EDM_TARIFF = FW_T179_AP1_Z1

*XDIM_MEMBERSET EDM_TIME = %EDM_TIME_SET%

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_OBJECT = P094_T179_010270007

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET MEASURES = PERIODIC

//---

*LOOKUP EDM

*FOR %MYTIME% = %EDM_TIME_SET%

*DIM EDM_TIME = %MYTIME%

*NEXT

*DIM EDM_PLANT = P094_15

*DIM EDM_ACCT = ACC2240

*DIM EDM_TARIFF = TID_NAS

*DIM EDM_REPCYCLE = KJ

*DIM EDM_RPTCUR = EUR

*DIM EDM_OBJECT = P094_T179_010270007

*DIM MEASURES = PERIODIC

*DIM AP_MENBUD: EDM_VIEW = BUDGET

*DIM AP_MENBUD: EDM_DATASRC = CALC

*DIM AP_MENCOU: EDM_VIEW = COUNTER

*DIM AP_MENCOU: EDM_DATASRC = IMPORT

*ENDLOOKUP

//---

*FOR %MYTIME%=%EDM_TIME_SET%

*WHEN EDM_TIME

*IS %MYTIME%

*WHEN EDM_PLANT.ACTIVE

*IS "Y"

*WHEN EDM_TARIFF.PL_TYPE

*IS A

*REC(EXPRESSION= LOOKUP(AP_MENCOU)>0 ? (LOOKUP(AP_MENCOU)*%VALUE%):LOOKUP(AP_MENBUD)*%VALUE%,EDM_ACCT=ACC1160,EDM_VIEW=BUDGET,EDM_DATASRC=CALC,EDM_TIME=%MYTIME%)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*NEXT

LGX:

*XDIM_MEMBERSET EDM_PLANT = P094_15

*XDIM_MEMBERSET EDM_VIEW = BUDGET

*XDIM_MEMBERSET EDM_ACCT = ACC4200

*XDIM_MEMBERSET EDM_TARIFF = FW_T179_AP1_Z1

*XDIM_MEMBERSET EDM_TIME = 2013.JAN

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_OBJECT = P094_T179_010270007

*XDIM_MEMBERSET EDM_DATASRC = IMPORT

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET MEASURES = PERIODIC

*XDIM_MAXMEMBERS EDM_PLANT = 10

*XDIM_MAXMEMBERS EDM_OBJECT = 50

*LOOKUP EDM

*DIM EDM_TIME = 2013.JAN

*DIM EDM_PLANT = P094_15

*DIM EDM_ACCT = ACC2240

*DIM EDM_TARIFF = TID_NAS

*DIM EDM_REPCYCLE = KJ

*DIM EDM_RPTCUR = EUR

*DIM EDM_OBJECT = P094_T179_010270007

*DIM MEASURES = PERIODIC

*DIM AP_MENBUD: EDM_VIEW = BUDGET

*DIM AP_MENBUD: EDM_DATASRC = CALC

*DIM AP_MENCOU: EDM_VIEW = COUNTER

*DIM AP_MENCOU: EDM_DATASRC = IMPORT

*ENDLOOKUP

*WHEN EDM_TIME

*IS 2013.JAN

*WHEN EDM_PLANT.ACTIVE

*IS Y

*WHEN EDM_TARIFF.PL_TYPE

*IS A

*REC(EXPRESSION= LOOKUP(AP_MENCOU)>0 ? (LOOKUP(AP_MENCOU)*%VALUE%):LOOKUP(AP_MENBUD)*%VALUE%,EDM_ACCT=ACC1160,EDM_VIEW=BUDGET,EDM_DATASRC=CALC,EDM_TIME=2013.JAN)

*ENDWHEN

*ENDWHEN

*ENDWHEN

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

LOG:

FILE:\ROOT\WEBFOLDERS\EON_BAGN \ADMINAPP\EDM\TEST.LGF

USER:U-DOM1\A39523

APPSET:EON_BAGN

APPLICATION:EDM

[INFO] GET_DIM_LIST(): I_APPL_ID="EDM", #dimensions=10

EDM_ACCT,EDM_DATASRC,EDM_OBJECT,EDM_PLANT,EDM_REPCYCLE,EDM_RPTCUR,EDM_TARIFF,EDM_TIME,EDM_VIEW,MEASURES

#dim_memberset=10

EDM_PLANT:P094_15,1 in total.

EDM_VIEW:BUDGET,1 in total.

EDM_ACCT:ACC4200,1 in total.

EDM_TARIFF:FW_T179_AP1_Z1,1 in total.

EDM_TIME:2013.JAN,1 in total.

EDM_RPTCUR:EUR,1 in total.

EDM_OBJECT:P094_T179_010270007,1 in total.

EDM_DATASRC:IMPORT,1 in total.

EDM_REPCYCLE:KJ,1 in total.

MEASURES:PERIODIC,1 in total.

REC :LOOKUP(AP_MENCOU)>0?(LOOKUP(AP_MENCOU)*%VALUE%):LOOKUP(AP_MENBUD)*%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 228.78 ms. 1  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY LOOKUP DATA FROM APPLICATION: EDM

QUERY TIME : 416.16 ms. 3  RECORDS QUERIED OUT.

QUERY TIME : 310.26 ms. 1  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :328.27 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

[former_member186338 · Accepted solution]

Please open a new discussion and provide the full explanation... I am unable to remember the history of this topic.

What for you are using LOOKUP instead of tuple expression? You are working with the same cube!

What is the TIME logic?

...

Vadim