Skip to Content
-1

Balance Carry Forward - RUN_LOGIC:Time is not available in model CONSOLIDATION

Hi,

When I execute Balance carry Forward DM package, i get the error

RUN_LOGIC:Time is not available in model CONSOLIDATION.

Dimensions used in Model:

DM package Script:

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

TASK(/CPMB/OPENING_BALANCES_LOGIC,SUSER,%USER%) TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPPSET,%APPSET%) TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPP,%APP%) TASK(/CPMB/OPENING_BALANCES_LOGIC,SELECTION,%SELECTION%) TASK(/CPMB/OPENING_BALANCES_LOGIC,LOGICFILENAME,COPY_OPENING.LGF)

Time Dimension Members:

time-dimension.png

Need your help on this.

--Selva.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Dec 06, 2017 at 04:06 PM

    Hi All,

    Issue was resolved. Issue was related to TIMEID property in TIME dimension. I have maintained the format as YYYYMMMDD instead of YYYYMMDD. Corrected the values and DM was scussess as excepted.

    -- Selva.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2017 at 04:13 PM

    Hi Vadim,

    I have attached the Time Dimension

    .

    Script logic for BCF:

    *RUN_PROGRAM COPYOPENING

    CATEGORY = %CATEGORY_SET%

    CURRENCY = %RPTCURRENCY_SET%

    ENTITY = %ENTITY_SET%

    TID_RA = %TIME_SET%

    //TIME = %TIME_SET%

    *ENDRUN_PROGRAM

    DM Script Logic:

    DM package Script:

    PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%") TASK(/CPMB/OPENING_BALANCES_LOGIC,SUSER,%USER%)

    TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPPSET,%APPSET%)

    TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPP,%APP%)

    TASK(/CPMB/OPENING_BALANCES_LOGIC,SELECTION,%SELECTION%) TASK(/CPMB/OPENING_BALANCES_LOGIC,LOGICFILENAME,COPY_OPENING.LGF)

    -- Selva.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2017 at 08:40 PM

    Sorry, but if you don't see the issues with your posts, I can't help you. Your posts are missing line breaks (red line) in the code (3 times).

    First:

    Second:

    Third:

    3 times is too much!

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2017 at 08:51 PM

    Hi Vadim,

    Here's the code with line breaks. Hope its clear this time.

    PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%") TASK(/CPMB/OPENING_BALANCES_LOGIC,SUSER,%USER%) TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPPSET,%APPSET%) TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPP,%APP%) TASK(/CPMB/OPENING_BALANCES_LOGIC,SELECTION,%SELECTION%) TASK(/CPMB/OPENING_BALANCES_LOGIC,LOGICFILENAME,COPY_OPENING.LGF)

    Add comment
    10|10000 characters needed characters exceeded

    • Let me try for one last time.

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

      TASK(/CPMB/OPENING_BALANCES_LOGIC,SUSER,%USER%)

      TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPPSET,%APPSET%)

      TASK(/CPMB/OPENING_BALANCES_LOGIC,SAPP,%APP%)

      TASK(/CPMB/OPENING_BALANCES_LOGIC,SELECTION,%SELECTION%)

      TASK(/CPMB/OPENING_BALANCES_LOGIC,LOGICFILENAME,COPY_OPENING.LGF)

  • Dec 05, 2017 at 01:36 PM

    First: unreadable text of DM advanced script - line breaks missing! Please look on your posting results and correct.

    Second: Time dimension screenshot is inserted using "Insert File" instead of "Insert Image" - please correct!

    Third: script text of the LGF file for Balance carry Forward DM package is missing. Please post!

    Add comment
    10|10000 characters needed characters exceeded