Clarification on TMVL

[praveen_kumar334]

Hi,

I am getting error while executing the below logic script code.

Input : TIME = 2008.01

*XDIM_MEMBERSET  ENTITY      =     BAS(AsiaPac)
*XDIM_MEMBERSET  TIME        =     %TIME_SET%
*XDIM_MEMBERSET  CATEGORY    =     Actual, Plan
*XDIM_MEMBERSET  ACCOUNT     =     RENT
*WHEN ACCOUNT
*IS   RENT
*REC(EXPRESSION = 100000 , CATEGORY = Plan, TIME = TMVL(12,%TIME_SET%))
*ENDWHEN 

Below is the error screenshot.

But while executing the same code in UJKT, the script is executing correctly. Please find the below UJKT log:

LGX:
*XDIM_MEMBERSET ENTITY = BAS(AsiaPac)
*XDIM_MEMBERSET TIME = 2008.01
*XDIM_MEMBERSET CATEGORY = Actual, Plan
*XDIM_MEMBERSET ACCOUNT = RENT
*WHEN ACCOUNT
*IS RENT
*REC(EXPRESSION = 100000 , CATEGORY = Plan, TIME = 2009.01 )
*ENDWHEN


-------------------------------------------------------------------------------------------------------------------------------------
LOG:


FILE:\ROOT\WEBFOLDERS\AT1 \ADMINAPP\Sales1\TEST.LGF
USER:WUSER32
APPSET:AT1
APPLICATION:Sales1
[INFO] GET_DIM_LIST(): I_APPL_ID="Sales1", #dimensions=8 
ACCOUNT,CATEGORY,ENTITY,MEASURES,PRODUCT,RPTCURRENCY,TIME,ZKEYFIG


#dim_memberset=4 
ENTITY:ASA,ASAREST,CN,IND,JPN,5 in total.
TIME:2008.01,1 in total.
CATEGORY:Actual,Plan,2 in total.
ACCOUNT:RENT,1 in total.


REC :100000


CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 0.00 ms. 5  RECORDS QUERIED OUT.
QUERY REFERENCE DATA
CALCULATION TIME IN TOTAL :0.00 ms.
5  RECORDS ARE GENERATED.
CALCULATION END.


SCRIPT RUNNING TIME IN TOTAL:0.00 s.

But when i hardcode the value in TMVL parameter like TMVL(12, 2008.01) , the script is working correctly. I am getting the issue only when i pass the variable in the TMVL. Please advise on how to fix this issue.

Thanks & Regards,

Praveen.

[former_member186338]

Sorry, but the issue is here: "when i pass the variable in the TMVL"

Please provide advanced DM script of the package.

Also provide detailed version info!

Read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

[former_member186338]

P.S. sorry, but

looks like validation error

[former_member186338 · Accepted solution]

First of all: BW 753 SP00 is outdated. Upgrade to SP04 is a good idea. Or at least to SP01:

https://launchpad.support.sap.com/#/notes/0002646731

[praveen_kumar334 · Accepted solution]

Hi vadim,

This is test environment. Any idea on how to fix the error.

Regards,

Praveen

[former_member186338 · Accepted solution]

praveen.kumar334

Sorry, but I have provided you with the exact SAP note for your particular case!

Have you read it?

What else do you want?

You can implement only this note, not the whole SP...

[former_member186338]

As an alternative you can simply ignore this validation error! 🙂

[praveen_kumar334]

Hi Vadim,

Thanks for the quick response.

BW Version is 7.53.

Advanced DM Script :

PROMPT(SELECTINPUT,,,,"%TIME_DIM%")
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,CALC_RENT_ALLOC.LGF)

Source Data :

Target Data :

Below is the DM Package Log :

LOG BEGIN TIME:2020-03-17 00:23:54
FILE:\ROOT\WEBFOLDERS\AT1\ADMINAPP\Sales1\CALC_RENT_ALLOC.LGF
USER:WUSER32
APPSET:AT1
APPLICATION:Sales1
[INFO] GET_DIM_LIST(): I_APPL_ID="Sales1", #dimensions=8
ACCOUNT,CATEGORY,ENTITY,MEASURES,PRODUCT,RPTCURRENCY,TIME,ZKEYFIG


#dim_memberset=4
ENTITY:ASA,ASAREST,CN,IND,JPN,5 in total.
TIME:2008.01,1 in total.
CATEGORY:Actual,Plan,2 in total.
ACCOUNT:RENT,1 in total.


REC :100000


CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 0.00 ms. 5  RECORDS QUERIED OUT.
QUERY REFERENCE DATA
CALCULATION TIME IN TOTAL :0.00 ms.
5  RECORDS ARE GENERATED.
CALCULATION END.


ENDWHEN ACCUMULATION: 5  RECORDS ARE GENERATED.


DATA TO WRITE BACK:
ACCOUNT	CATEGORY	ENTITY	PRODUCT	RPTCURRENCY	TIME	ZKEYFIG	SIGNEDDATA
RENT	Plan	ASA	ProductB	LC	2009.01	SAQTY	100000.00
RENT	Plan	ASAREST	ProductB	LC	2009.01	SAQTY	100000.00
RENT	Plan	CN	ProductB	LC	2009.01	SAQTY	100000.00
RENT	Plan	IND	ProductB	LC	2009.01	SAQTY	100000.00
RENT	Plan	JPN	ProductB	LC	2009.01	SAQTY	100000.00
5  RECORDS HAVE BEEN WRITTEN BACK.
WRITING TIME :0.00  ms.


SCRIPT RUNNING TIME IN TOTAL:0.00 s.
LOG END TIME:2020-03-17 00:23:54
File path: \ROOT\WEBFOLDERS\AT1\Sales1\PRIVATEPUBLICATIONS\WUSER32\tempfiles\20200317002354\003N7CYC8WCF6MZMG4131D5MX_CALC_RENT_ALLOC.LOG

When running the DM, I am not getting any errors and the records are getting updated in the infocube.

The issue is only with the Logic script syntax error : I am not sure how to fix it .

Please let us know if you need any more info. Thanks.

Regards,

Praveen.