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

[selva_amd]

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.

[selva_amd · Accepted solution]

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.

[former_member186338 · Accepted solution]

In general the format of TIMEID has no relation to your issue:

The rule is simple:

1. TIMEID has to be set on BASE members only.

2. Values of TIMEID has to be unique.

3. Months sorted by TIMEID text string has to be in the correct order.

For example:

2016.11 TIMEID: 1611

2016.12 TIMEID: 1612

2017.01 TIMEID: 1701

2017.02 TIMEID: 1702

Format YYMM 🙂

[former_member186338 · Accepted solution]

Ups looks like you are using relatively old BPC SP.

Look on this note:

https://launchpad.support.sap.com/#/notes/2171133

And perform upgrade!

[selva_amd · Accepted solution]

Hi Vadim,

I am on BPC 11.

BPC4HANA 100 SP2

DW4CORE 100 SP6

-- Selva.

[former_member186338 · Accepted solution]

Interesting issue!

Please check the code of class CL_UJK_TMVL Method GET_CUR_TIME

Do you have this code:

  " begin MFA 20150522 note 2171133
  else.
    concatenate sy-datlo(4) '0' sy-datlo+4(2) into l_time_id.
    clear lt_sel.
    ls_sel-dimension = l_time_dim.
    ls_sel-attribute = ujk0_c_dim_pro-timeid.
    ls_sel-sign      = uj00_cs_range-sign_i . "Include or Exclude
    ls_sel-option    = uj00_cs_range-option_eq. "Equal to
    ls_sel-low       = l_time_id.

    APPEND ls_sel TO lt_sel.
    ...

[selva_amd · Accepted solution]

Yes, I see the code in that particular method.

--Selva

[former_member186338 · Accepted solution]

Looks like the idea of the method GET_CUR_TIME is incorrect (the code author assumes some formatting of TIMEID) This method is trying to find the current TIME member comparing the system date with TIMEID. Hope it will be corrected in future.

Currently 2 formats are supported:

YYYYMMDD

and

YYYY0MM

[selva_amd · Accepted solution]

Thanks Vadim on your notes.

-- Selva.

[selva_amd]

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)

[former_member186338]

Have you seen it after posting???????

[selva_amd]

yes. I am able to see it.

-- Selva.

[former_member186338]

And do you see a correct line breaks??? I can see an incorrect post:

[selva_amd]

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)

[former_member186338]

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!

[selva_amd]

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.

[former_member186338]

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

Post screenshot of the prompt when you run DM.

What do you select for TIME?

[former_member186338]

P.S. This line is incorrect:

ENTITY = %ENTITY_SET%

Has to be:

OTHER = [ENTITY = %ENTITY_SET%]

Read note: https://launchpad.support.sap.com/#/notes/1835007

[selva_amd]

Hi Vadim,

Here is the DM code.

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)

BCF input screen.

-- Selva.

[former_member186338]

Sorry, but if you unable to properly post DM script code then I am unable to answer! You simply don't look on your post results.

[selva_amd]

Hi Vadim,

This is the screenshot of DM script. Hope this helps you.

-- Selva

[former_member186338]

"Sorry, but if you unable to properly post DM script code then I am unable to answer! You simply don't look on your post results."

Screenshot is not a text!

It's a waste of time...

[selva_amd]

Hi Vadim,

I am not sure of what you mean by - unreadable text of DM advanced script - line breaks missing!

-- Selva

[former_member186338]

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!