LINE 11 syntax error: " missing name after .operator"

[Former Member]

Hi Can you guys help me how to reslove this error. Iam trying to create 6 months forecast logicscript. Just started with the first month and iam getting this error.LINE 11 syntax error: " missing name after .operator"

*XDIM_MEMBERSET CATEGORY = Forecast

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET PRODUCT_ALLOC = %PRODUCT_ALLOC_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET TIME = %TIME_SET%

*SELECT(%ACCTSET%,"ID",ACCOUNT,"IS_ACCT_FC = 'Y'")

*FOR %ACCT% = %ACCTSET%

[ACCOUNT].[#%ACCT%] = 1/6 * (([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-1,%TIME_SET%)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-2,%TIME_SET%)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-3,%TIME_SET%)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-4,%TIME_SET%)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-5,%TIME_SET%)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-6,%TIME_SET%)]))

*NEXT

*COMMIT

[Former Member · Accepted solution]

Hi vadim, this time also no luck, please find the attached datafile and test_result.Any comments on this please.

[former_member186338 · Accepted solution]

Sorry, but why "no luck"?

In the log it's clearly stated that "5 records are generated". And to see the results you don't provide the report with Category "Forecast"!

Vadim

[Former Member · Accepted solution]

Sorry, please find the Test_result...

[former_member186338 · Accepted solution]

In UJKT have you used Execute and not Execute Simulate?

With Execute you will see the generated records...

Vadim

[Former Member · Accepted solution]

Thanks vadim, when i changed the account to base member level able to see the below results

[former_member186338 · Accepted solution]

It means that the script is working correctly! 2000/6=333.33

Vadim

[Former Member · Accepted solution]

What i observed from the result, its forecasting only for the specified month, but my requirement is it should forecast next 6 months from the selected month. Can you please give me some idea on this . Thanks for your patience and response.

[former_member186338 · Accepted solution]

Easy! But looks that non of my answers are useful

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET PRODUCT_ALLOC = %PRODUCT_ALLOC_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*SELECT(%ACCTSET%,[ID],ACCOUNT,"[IS_ACCT_FC] = 'Y'")

*XDIM_MEMBERSET ACCOUNT=%ACCTSET%

// Scope 6 previous months

*XDIM_MEMBERSET TIME = TMVL(-1,%TIME_SET%),TMVL(-2,%TIME_SET%),TMVL(-3,%TIME_SET%),TMVL(-4,%TIME_SET%),TMVL(-5,%TIME_SET%),TMVL(-6,%TIME_SET%)

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%/6,TIME=%TIME_SET%,CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(1,%TIME_SET%),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(2,%TIME_SET%),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(3,%TIME_SET%),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(4,%TIME_SET%),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(5,%TIME_SET%),CATEGORY=Forecast)

*ENDWHEN

[Former Member · Accepted solution]

Thanks vadim, appreciated. You answered  all my questions and you are so helpful.

[former_member186338 · Accepted solution]

Then close this discussion!

[Former Member · Accepted solution]

Hi Vadim,

Some observations after executing Rolling forecast logic script.

ex.

2011.01	2011.02	2011.03	2011.04	2011.05	2011.06	2011.07	2011.08	2011.09	2011.1	2011.11	2011.12
Actual	Actual	Actual	Actual	Actual	Actual

Current: If the user selects 2011.04 , it is caliculating the forecast for next 6 months but its taking the average of 6 months.(Eventhough user is selected only 3 months actuals)

Expected: If the user selects 2011.04 it should forecast for the next 6 moths based on the average of previous 4 months actual data.

Can you help me how to achieve this ?

Thanks in advance.

[former_member186338 · Accepted solution]

Sorry, but:

"Expected: If the user selects 2011.04 it should forecast for the next 6 moths based on the average of previous 4 months actual data." - Expected by whom? Is it possible to clearly explain the requirements from the very beginning? (by the way, to forecast next 6 months based on previous 6 months average looks more logical then to use months from the beginning of the year!)

Second: Is it absolutely bad idea to try to write the script yourself for the new requirements?

[Former Member · Accepted solution]

Hi Vadim,

Sorry for late response, Here is the my requirement, when the user selects date from the combbox, it has caliculate the 6 months rolling forecast based on the selected date.Here is the existing code...

//First Month

*XDIM_MEMBERSET CATEGORY = Forecast

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET PRODUCT_ALLOC = %PRODUCT_ALLOC_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET TIME = $CURRMON$

*SELECT(%ACCTSET%,"ID",ACCOUNT,"IS_ACCT_FC = 'Y'")

*FOR %ACCT% = %ACCTSET%

[ACCOUNT].[#%ACCT%] = 1/12 * (([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-1,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-2,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-3,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-4,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-5,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-6,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-7,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-8,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-9,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-10,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-11,$CURRMON$)]) + ([ACCOUNT].[%ACCT%],[CATEGORY].[Actual],[TIME].[TMVL(-12,$CURRMON$)]))

*NEXT

*COMMIT

like this for next 5 months...

I have modified the suggested code you provided me like the below.Now iam getting invalid TMVL return value.Can you help me on this pls....

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET PRODUCT_ALLOC = %PRODUCT_ALLOC_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*SELECT(%ACCTSET%,[ID],ACCOUNT,"[IS_ACCT_FC] = 'Y'")

*XDIM_MEMBERSET ACCOUNT=%ACCTSET%

// Scope 6 previous months

*XDIM_MEMBERSET TIME = TMVL(-1,$CURRMON$),TMVL(-2,$CURRMON$),TMVL(-3,$CURRMON$),TMVL(-4,$CURRMON$),TMVL(-5,$CURRMON$),TMVL(-6,$CURRMON$)

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%/6,TIME=$CURRMON$,CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(1,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(2,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(3,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(4,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,TIME=TMVL(5,$CURRMON$),CATEGORY=Forecast)

*ENDWHEN

Thanks in advance

[Former Member · Accepted solution]

pls find the screenshot and also suggest me you want me to open a new discussion on this...

[former_member186338 · Accepted solution]

Sorry, but unfortunately you still can't clearly explain you requirements

"Here is the my requirement, when the user selects date from the combbox, it has caliculate the 6 months rolling forecast based on the selected date." what do you mean "based on the selected date"???

Can you simply provide number of examples like:

If user selects 2011.01 I want to have ...

If user selects 2011.02 I want to have ...

If user selects 2011.03 I want to have ...

...

And any error you have can be discussed only with screenshot of UJKT!

Vadim

[former_member186338 · Accepted solution]

Please full page screenshot!!!

Looks like PARAM field is not set - nothing in $CURRMON$!

Please read

Vadim

P.S. In PARAM field you have to put like: CURRMON=2010.06

[Former Member · Accepted solution]

Pls find the screenshot with parm value...

[former_member186338 · Accepted solution]

Not $CURRMON$=2010.06

BUT CURRMON=2010.06

[Former Member · Accepted solution]

Thanks vadim,Finally, Iam able to see the results.Only challenge infront of me is passing the dynamic value to the logicscript.

[former_member186338 · Accepted solution]

Without clear explanation of your requirements I can't help...

[Former Member · Accepted solution]

Hi Vadim,

Can you help me attached rolling forecast report is correct or not ?

for example labor cost:  20 30 40 50 60 70 = 270/6 =45 but in the report it is showing 33.33

[former_member186338 · Accepted solution]

Looks like not!

Looks like you select 2011.06 as a CURRMON

But for this report you have to select 2011.07 as a first Forecast month!

Vadim

[Former Member · Accepted solution]

Hi Vadim,

This is the script iam using and the forecast month selected as 2011.07. please find the report as well.

//SIX MONTS RFC

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET PRODUCT_ALLOC = %PRODUCT_ALLOC_SET%

*XDIM_MEMBERSET RPTCURRENCY =USD

*SELECT(%ACCTSET%,[ID],ACCOUNT,"[IS_ACCT_FC] = 'Y'")

*XDIM_MEMBERSET ACCOUNT=%ACCTSET%

// Scope 6 previous months

*XDIM_MEMBERSET RFC_TIME = TMVL(-1,$CURRMON$),TMVL(-2,$CURRMON$),TMVL(-3,$CURRMON$),TMVL(-4,$CURRMON$),TMVL(-5,$CURRMON$),TMVL(-6,$CURRMON$)

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(1,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(2,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(3,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(4,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(5,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(6,$CURRMON$),CATEGORY=Forecast)

*ENDWHEN

Thanks in advance

[former_member186338 · Accepted solution]

Sorry, please find the error yourself!

Compare you script with my script in:

The error is absolutely simple!

[Former Member · Accepted solution]

Got it thanks vadim

*REC(EXPRESSION=%VALUE%/6,TIME=%TIME_SET%,CATEGORY=Forecast)

[Former Member · Accepted solution]

Thanks finally corrected Report.

[Former Member · Accepted solution]

Hi vadim,

Instead of account based rolling forecast , i would like to do  the prodcut based rolling forecast. Can you guide me how to proceed further. I started modifying ur code as below. Why cant we create attribute like this... pls help me

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET PRODUCT_ALLOC=BAS(CPG_GRP27)

*XDIM_MEMBERSET RPTCURRENCY =USD

*SELECT(%PRODUCT_ALLOC_SET%,[ID],PRODUCT_ALLOC,"[IS_PRD_RC] = 'Y'")

// Scope 6 previous months

*XDIM_MEMBERSET RFC_TIME = TMVL(-1,$CURRMON$),TMVL(-2,$CURRMON$),TMVL(-3,$CURRMON$),TMVL(-4,$CURRMON$),TMVL(-5,$CURRMON$),TMVL(-6,$CURRMON$)

*WHEN PRODUCT_ALLOC

*IS *

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=$CURRMON$,CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(1,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(2,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(3,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(4,$CURRMON$),CATEGORY=Forecast)

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=TMVL(5,$CURRMON$),CATEGORY=Forecast)

*ENDWHEN

[former_member186338 · Accepted solution]

Incorrect line:

*SELECT(%PRODUCT_ALLOC_SET%,[ID],PRODUCT_ALLOC,"[IS_PRD_RC] = 'Y'")

%PRODUCT_ALLOC_SET% - is a reserved variable, you can't use it in SELECT.

And what do you want to do with PRODUCT_ALLOC dimension??? Not clear!

If you want to select PRODUCT_ALLOC members with IS_PRD_RC=Y then:

*SELECT(%PROD%,[ID],PRODUCT_ALLOC,"[IS_PRD_RC] = 'Y'")

*XDIM_MEMBERSET PRODUCT_ALLOC=%PROD%

Or???

[former_member186338 · Accepted solution]

P.S. And if you want to select PRODUCT_ALLOC members only base members of CPG_GRP27 with IS_PRD_RC=Y then:

*XDIM_MEMBERSET PRODUCT_ALLOC AS %PB%=BAS(CPG_GRP27) //special AS statement!

*SELECT(%PROD%,[ID],PRODUCT_ALLOC,IS_PRD_RC=Y AND ID=%PB%)

*XDIM_MEMBERSET PRODUCT_ALLOC=%PROD%

Vadim

[Former Member · Accepted solution]

Hi vadim,

Same error iam getting invalid attribure name IS_PRD_RC in Product dimension. My requirement is like this.

1. When the user  selected  productgroup it should perm rolling forecast based on the product group. One particular prodcut group contains bunch of products.

2. Not every productgroup will not involve in rolling forecast. Only specified productgroups can be rolling forecasted.

( thats the reason i created attribute IS_PRD_RC, if it is Y it is eligible for rolling forecast.

please find the product dimension below.

Thanks

[former_member186338 · Accepted solution]

Ups, you marked product parents with this property... it's another story!

*SELECT(%PRODPARENTS%,[ID],PRODUCT_ALLOC,IS_PRD_RC=Y)

*FOR %PROD%=%PRODPARENTS% //for each parent...

*XDIM_MEMBERSET PRODUCT_ALLOC=BAS(%PROD%)

*XDIM_MEMBERSET RFC_TIME = TMVL(-1,$CURRMON$),TMVL(-2,$CURRMON$),TMVL(-3,$CURRMON$),TMVL(-4,$CURRMON$),TMVL(-5,$CURRMON$),TMVL(-6,$CURRMON$)

*WHEN PRODUCT_ALLOC

*IS *

*REC(EXPRESSION=%VALUE%/6,RFC_TIME=$CURRMON$,CATEGORY=Forecast)

...

*NEXT

FOR/NEXT is slow, if you mark base members with IS_PRD_RC=Y then you will avoid FOR/NEXT

Vadim

[Former Member · Accepted solution]

Hi vadim,

PRODUCT_ALLOC is comein as blank. please find the UJKT Test result

[former_member186338 · Accepted solution]

I have already answered

[Former Member · Accepted solution]

marked to only the base members, then iam able to see the results.

Thanks for helping me, I think  i need  to learn a lot in LogicScripts.

[Former Member · Accepted solution]

Hi Vadim,

Sorry one last final question in Rolling forecast technique. When i observed my UJKT_Result and my Epm reports there was a little differnce in between the results. Holding my head and thinking .... Can you tell me please.

[former_member186338 · Accepted solution]

Just rounding issues - nothing to do! You may create badi to round results if required...

[Former Member · Accepted solution]

Sure , Thanks Vadim. Can you suggest me any good material for logicScripts.

[former_member186338 · Accepted solution]

Help and SAP notes search Also look on documents and blog posts here.

[former_member186338]

Sorry, but I do not recommend using MDX syntax like in your code!

WHEN/ENDWHEN is dramatically faster!

You want to put 1/6 of sum of previous 6 months in the current month!

Then:

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET PRODUCT_ALLOC = %PRODUCT_ALLOC_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*SELECT(%ACCTSET%,[ID],ACCOUNT,"[IS_ACCT_FC] = 'Y'")

*XDIM_MEMBERSET ACCOUNT=%ACCTSET%

// Scope 6 previous months

*XDIM_MEMBERSET TIME = TMVL(-1,%TIME_SET%),TMVL(-2,%TIME_SET%),TMVL(-3,%TIME_SET%),TMVL(-4,%TIME_SET%),TMVL(-5,%TIME_SET%),TMVL(-6,%TIME_SET%)

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%/6,TIME=%TIME_SET%,CATEGORY=Forecast)

*ENDWHEN

Vadim

Message was edited by: Vadim Kalinin CATEGORY corrected

[Former Member]

Thanks for the Response, Its really helpful,i believe this code will suffice for all six months.Please  Correct me if iam wrong.

[former_member186338]

Yes, this code will scope 6 previous months and will write all values divided by 6 into target selected month. It's a standard way of doing things like this...

Vadim

[Former Member]

Hi Vadim,

to test above the logicscript, iam using the datamanager package to run the script. but iam getting the package error. pls correct me if any thing is wrong.

PROMT(SELECTINPUT,,,,"%PRODUCT_ALLOC_DIM%,%ENTITY_DIM%,%RPTCURRENCY_DIM%")

PROMPT(COMBOBOX,%CURRMON%,"cHOOSE THE MONTH",0,2015.07,{2015.01,2015.02,2015.03,2015.04,2015.05,2015.06})INFO(%EQU%,=) INFO(%TAB%,;)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SUSER,%USER%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPP,%APP%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,REPLACEPARAM,CURRMON%EQU%%CURRMON%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,LOGICFILENAME,6MONTHS_RFC.LGF

[former_member186338]

Sorry, but what is the idea to select month with COMBOBOX? Also incorrect COMBOBOX statement...

And incorrect REPLACEPARAM?

And how do you want to use CURRMON???

Vadim

P.S. It's a good idea to test script in UJKT first:

[Former Member]

Thanks Vadim please please find the Debug results. Actually my intension to use combo box is user has the ability to select the  the month to forecast.Can you guide me is there any way we can implement this,Thanks once again.

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = CSO

*XDIM_MEMBERSET PRODUCT_ALLOC = SAP

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET ACCOUNT=PL110,PL120,PL200,PL300,PL310,PL600,PL999

*XDIM_MEMBERSET TIME = 2011.02 , 2011.01 , 2010.12 , 2010.11 , 2010.10 , 2010.09

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=%VALUE%/6,TIME=2011.03,CATEGORY=Forecast)

*ENDWHEN

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

LOG:

FILE:\ROOT\WEBFOLDERS\ENVIRONMENT830 \ADMINAPP\6MONTHS_RFC_MODEL\TEST.LGF

USER:HANAUSER830

APPSET:ENVIRONMENT830

APPLICATION:6MONTHS_RFC_MODEL

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

ACCOUNT,CATEGORY,ENTITY,MEASURES,PRODUCT_ALLOC,RPTCURRENCY,TIME

#dim_memberset=6

CATEGORY:Actual,1 in total.

ENTITY:CSO,1 in total.

PRODUCT_ALLOC:SAP,1 in total.

RPTCURRENCY:LC,1 in total.

ACCOUNT:PL110,PL120,PL200,PL300,PL310,...7 in total.

TIME:2010.09,2010.10,2010.11,2010.12,2011.01,...6 in total.

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

[former_member186338]

COMBOBOX - you will have to manually adjust the list. And you have to pass parameter using different variable...

Why not:

PROMPT(SELECTINPUT,,,,"%PRODUCT_ALLOC_DIM%,%ENTITY_DIM%,%RPTCURRENCY_DIM%,%TIME_DIM%")

Then you will get the selected TIME member in %TIME_SET%

Also you have strange log - not working without error!

May be PRODUCT_ALLOC = SAP - is not a base member?

Vadim

[Former Member]

Thank you very much sir, this is the first time iam using Debugger, Now i executed again with the base member PRODUCT_ALLOC=BW.updated  test results: What actually we can expect even record count? Thanks for your quick response.

LOG BEGIN TIME:2015-09-18 20:06:20

FILE:\ROOT\WEBFOLDERS\ENVIRONMENT830 \ADMINAPP\6MONTHS_RFC_MODEL\TEST.LGF

USER:HANAUSER830

APPSET:ENVIRONMENT830

APPLICATION:6MONTHS_RFC_MODEL

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

ACCOUNT,CATEGORY,ENTITY,MEASURES,PRODUCT_ALLOC,RPTCURRENCY,TIME

#dim_memberset=6

CATEGORY:Actual,1 in total.

ENTITY:CSO,1 in total.

PRODUCT_ALLOC:BW,1 in total.

RPTCURRENCY:LC,1 in total.

ACCOUNT:PL110,PL120,PL200,PL300,PL310,...7 in total.

TIME:2010.09,2010.10,2010.11,2010.12,2011.01,...6 in total.

REC :%VALUE%/6

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 0  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 0  RECORDS ARE GENERATED.

SCRIPT RUNNING TIME IN TOTAL:1.00 s.

LOG END TIME:2015-09-18 20:06:20

[former_member186338]

Now it's better!

But you have no data in the model:

QUERY TIME : 1.00 ms. 0  RECORDS QUERIED OUT.

Vadim

[Former Member]

Hi Vadim

No luck.Data is there in  the model, I dont know why its not taking, is there any tweaks required in the code. please can you check once again.

[former_member186338]

Sorry, but the log:

#dim_memberset=6

CATEGORY:Actual,1 in total.

ENTITY:CSO,1 in total.

PRODUCT_ALLOC:BW,1 in total.

RPTCURRENCY:LC,1 in total.

ACCOUNT:PL110,PL120,PL200,PL300,PL310,...7 in total.

TIME:2010.09,2010.10,2010.11,2010.12,2011.01,...6 in total.

REC :%VALUE%/6

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 0  RECORDS QUERIED OUT.

Clearly states that there is no data in the model for this scope!!!

Vadim