Question Re: Clarification on TMVL in Financial Management Q&A

Clarification on TMVL

praveen_kumar334 — Mon, 16 Mar 2020 17:52:35 GMT

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.

Re: Clarification on TMVL

former_member186338 — Mon, 16 Mar 2020 18:02:53 GMT

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/

Re: Clarification on TMVL

former_member186338 — Mon, 16 Mar 2020 18:04:10 GMT

P.S. sorry, but

looks like validation error

Re: Clarification on TMVL

praveen_kumar334 — Mon, 16 Mar 2020 18:58:51 GMT

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.

Re: Clarification on TMVL

former_member186338 — Mon, 16 Mar 2020 19:13:13 GMT

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

Re: Clarification on TMVL

praveen_kumar334 — Mon, 16 Mar 2020 19:22:50 GMT

Hi vadim,

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

Regards,

Praveen

Re: Clarification on TMVL

former_member186338 — Mon, 16 Mar 2020 19:30:07 GMT

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...

Re: Clarification on TMVL

former_member186338 — Mon, 16 Mar 2020 19:35:08 GMT

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