cancel
Showing results for 
Search instead for 
Did you mean: 

RUN_LOGIC:Time is not available in model MEGPC_PRICE

Micheal-sorial
Explorer
0 Kudos
161

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

View Entire Topic
former_member186338
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

P.S. Ups, typing mistake:

CATEGORY = %DEGPC_PLANACT_SET

Has to be:

CATEGORY = %DEGPC_PLANACT_SET% <-!!!!

Micheal-sorial
Explorer
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
Micheal-sorial
Explorer
0 Kudos

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
Active Contributor
0 Kudos

"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
Explorer
0 Kudos

thnx vadim

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

     coz business rule

former_member186338
Active Contributor
0 Kudos

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.