RUN_LOGIC:Time is not available in model MEGPC_PRICE

[Micheal-sorial]

Hello EXPERTISE,

I am facing a problem while running the DM package for FXTRANS for FINANCIAL MODLE IN BPC 10.1NW

ERROR IS : RUN_LOGIC:Time is not available in model MEGPC_PRICE

Please help me out in this problem.

Regards,

MICHEAL

MY DIMENSION IN DEGPC_PRICE MODEL

DM SCRIPT

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_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,FX_TRANSLATE.LGF)

LOGIC SCRIPT

*RUN_PROGRAM CURR_CONVERSION

  CATEGORY = %DEGPC_PLANACT_SET

  CURRENCY = %DEGPC_CURR_SET%

  TID_RA = %DEGPC_TIME_SET%

  ENTITY = %DEGPC_LENTITY_SET%

  RATEENTITY = Global

*ENDRUN_PROGRAM

[former_member186338 · Accepted solution]

First - please check that the script name is FX_TRANSLATE.LGF

Then - incorrect line: ENTITY = %DEGPC_LENTITY_SET%

Has to be:

OTHER= [DEGPC_LENTITY=%DEGPC_LENTITY_SET%]

And screenshot of DEGPC_TIME dimension, please!

[former_member186338 · Accepted solution]

P.S. Ups, typing mistake:

CATEGORY = %DEGPC_PLANACT_SET

Has to be:

CATEGORY = %DEGPC_PLANACT_SET% <-!!!!

[Micheal-sorial · Accepted solution]

thanx Vadim

i check logic file name it's correct

i correct entity line to OTHER= [DEGPC_LENTITY=%DEGPC_LENTITY_SET%] instead ENTITY = %DEGPC_LENTITY_SET%

i correct category line with %

but stall the same error

[former_member186338 · Accepted solution]

Please show screenshot of the Package log!

And your time dimension is set incorrectly! First month of the year in PERIOD has to be JAN etc...

For real month names use new property!

BasePeriod has to be also correctly filled 001,002....

YEAR property has to be YYYY

2014_2015 base member has to be setup with 3 level structure (MONTH-QUARTER-TOTAL)

[former_member186338 · Accepted solution]

2015_2014.Q5 Q5 2015_2014 013 QUARTER 13 Q5                     2015 2015_2014.TOTAL <- Do you want it to be under common year total?

2015_2014       2015_2014      013 MONTH      13 DEC 10000000 2015 2015_2014.Q5

P.S. TIME dimension properties are not very flexible

[former_member186338 · Accepted solution]

Please read: https://launchpad.support.sap.com/#/notes/2101349/E

[Micheal-sorial · Accepted solution]

Fiscal year begins in July and ends in June

and i will correct base period and year i will make it 1516 act as from july 2015 to iune 2016

[former_member186338 · Accepted solution]

"Fiscal year begins in July and ends in June" - but PERIOD property of the first month of the year has to be JAN even it's July!!! Create property CALPERIOD and fill it with JUL,AUG...

3 level structure is also required for members like 2014_2015!

year i will make it 1516 act as from july 2015 to iune 2016 - No, years have to be incremented by 1 2015,2016,2017...

You can always create extra property for year with any string!

Sorry, but if you want to have consistent results you have to correct everything!

[Micheal-sorial · Accepted solution]

thnx vadim

  i am change time property time dimension error solved but data manager package still not working

     coz business rule

[former_member186338 · Accepted solution]

Please, do not violate rules of SCN:

"4. Avoid slang. ..."

If the question is answered - mark it answered!

If you have issues with business rule - open a new discussion.