FXTRANS Logic issue

[former_member541461]

Hi Guru's

I am facing issue with currency translation, if I go per standard logic, validation is a problem. Hard coding not possible as I have many items in dimensions. Help me.

FXTRANS.LGS logic

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUP_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

When executed: Error LOG:

UJK_VALIDATION_EXCEPTION:Dimension set:"CATEGORY" not assigned in Data Manager

Pasted below System constant.lgf and Data Manager script.

SYSTEM_CONSTANTS.LGF

//application constants

//--------------------------------------------

*FUNCTION CATEGORYDIM=C_CATEGORY

*FUNCTION TIMEDIM=TIME

*FUNCTION CURRENCYDIM=RPTCURRENCY

*FUNCTION ENTITYDIM=ENTITY

*FUNCTION ACCOUNTDIM=C_ACCT

*FUNCTION INTCODIM=INTERCO

*FUNCTION ACCDETAILDIM=C_FLOW

*FUNCTION DATASRCDIM=AUDITTRAIL

*FUNCTION GROUPDIM=SCOPE

// This part is needed when a RATE cube

// is associated to the application

// (FX = single or multi currency)

//---------------------------------------------

*FUNCTION THISAPP=CONS

*FUNCTION RATEAPP=RATES

*FUNCTION RATEENTITYDIM=R_ENTITY

*FUNCTION RATEACCOUNTDIM=R_ACCOUNT

*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY

*FUNCTION RATEENTITYMBR=Global

*FUNCTION RATESRCCALCMBR=Global

*FUNCTION AVGRATEID=AVG

*FUNCTION ENDRATEID=CLO

*FUNCTION HISTRATEID=HIST

Data Manager Script

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%GROUP_DIM%,%TIME_DIM%")

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,LOGICFILENAME,FXTRANS.LGF)

What we did:

When we have hard coded for each dimension item, we are not facing the error. For example script enclosed below.

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = Actual

GROUP = S_SAmerica

TID_RA = 2012.01

OTHER = [ENTITY=US]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

[former_member186338]

Hi Shanmukha,

It looks like instead of line:

CATEGORY = %CATEGORY_SET%

You have to use the real name of CATEGORY dimension %C_CATEGORY_SET% (and the same for all %XXX_SET% variables. See help about script special keywords:
http://help.sap.com/saphelp_bpc75_nw/helpdata/en/59/f145f708724b9c86d8a65dd57d5e4f/content.htm

B.R. Vadim

[former_member541461]

Hi Vadim,

I set Category = %Category_set%, same for other dimensions.

If I hard code one member each of dimension execution is successful, other wise it is throwing the same error.

Shanmukha

[former_member186338]

What are the real names of your dimensions (case sensitive)? The special variables in the script logic like %DIMNAME_SET% require DIMNAME to be the real name of the dimension not a dimension type like CATEGORY, GROUP ... Looking on your SYSTEM_CONSTANTS.LGF I can suspect that the real name of the CATEGORY type dimension is C_CATEGORY.

"If i hard code category, then it is asking for Entity, If I do for entity, it is asking for time also." - It means that CATEGORY, GROUP and TIME are not the real dimension names.

Vadim

[former_member186338]

In addition if you have FLOW and DATASRC type dimensions in this application you mast setup parameters for those dimensions as it's required for RUN_PROGRAM CURR_CONVERSION.

By the way it looks like you copy sample from help without changing the parameters to be inline with your application.

Vadim

[former_member541461]

I have included dimension names "Dimname_set% (case sensitive), I ve got the same error message.

Yes My application contains FLOW and DATASRC type dimensions, Can you let me know from where and how to set parameters for these lines. I am working with 10 NW.

[former_member186338]

Please, provide the final script and the dimension names! If you are able to run script with hardcoded parameters and get errors with %XXX_SET% variables then the XXX names are still incorrect.

About FLOW and DATASRC - if you are able to run script with hardcoded parameters - then FLOW and DATASRC are OK.

Vadim

[former_member186338]

I hope that when you run DM you properly select members for:

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%GROUP_DIM%,%TIME_DIM%")

[former_member186338]

Also, please read this useful blog post about currency convertion:

http://scn.sap.com/community/epm/blog/2011/05/03/bpc-for-net-weaver--how-many-licks-to-the-center-of...

B.R. Vadim

[former_member541461]

Thank you Vadim very much, Appreciate your co operation.

Shanmukha Rao.

[former_member210696]

Hi Shanmukha,

Are you getting this error while running or when validating. If it is during the validation only, try and ignore the error because at the run time, you will pass the required DM variable, so you may not get this error during execution.

Hope it helps!!

[former_member541461]

Hi Ashish.

This error is during execution.

If i hard code category, then it is asking for Entity, If I do for entity, it is asking for time also.

If i hard code dimension members it is working. This is feasable for category kind of dimension where members are few. What about time dimension.....

Let me know if you need more inputs for this.

Shanmukha

[former_member210696]

Well in that case, as pointed out by Vadim, you need to have actual dimension name for each of the dimension while defining them as in "_SET", so if you are saying "%CATEGORY_SET%", do you have category dimension's name as CATEGORY in the system?