Skip to Content

LOGIC SCRIPT ERROR - INVALID MEMBER

Dear Experts,


Question:

Can anyone please tell me what is the issue with the logic file(FXTRANS) when we select <ALL> for DATASOURCE in Data Manager Package? I believe it has to do something with the line OTHER = [ENTITY=.............] .

Also what is the use of OTHER in logic scripts , tried to find it but couldn't find it?


Details:
I'm trying to execute FXTRANS.LGF. The error arises when the package is executed via DMP and AUDIT(DATASOURCE) is selected as ALL from the dropdown box then package results in error- Member "xyz" does not exist in the dimension DATASOURCE.

Where "xyz" is a Entity member

Selections-
CATEGORY = ACTUAL

TIME=2017.OCT
ENTITY = <ALL> (selected from drop down)

DATASOURCE(AUDIT)= <ALL> (selected from drop down)


Now when the DATASOURCE is selected via member selection - any member or member and descendants then the package is finished successfully.

MODEL - FINANCE

Script:




Attached screenshot of DMP failure and UJKT.




SYSTEM DETAILS:-
BW - 740 SP 13
BPC - 810 SP 08

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 30, 2017 at 09:10 AM

    Try to add the following code at the beginning:

    *SELECT(%DS%,[ID],DATASOURCE,[ID]=%DATASOURCE_SET% AND [ID]=CALC AND [CALC]=N)

    "AND" between same property (ID) is working like "OR"

    And change OTHER line to:

    OTHER=[ENTITY =%ENTITY_SET%; DATASOURCE =%DS%]
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2017 at 01:27 PM

    Strange script! Look on my comments:

    *XDIM_MEMBERSET FXCURRENCY = FC // No effect on CURR_CONVERSION - useless!
    *XDIM_FILTER DATASOURCE = [DATASOURCE].Properties("IS_CONVERTED") = Y  // No effect on CURR_CONVERSION - useless!
    *XDIM_FILTER LOCALACCOUNT = [LOCALACCOUNT].Properties("CALC") = N  // No effect on CURR_CONVERSION - useless!
    *XDIM_ADDMEMBERSET DATASOURCE = BAS(DS.SUBTOTAL)  // No effect on CURR_CONVERSION - useless!
    *FOR %CATS% = %CATEGORY_SET%
    *RUN_PROGRAM CURR_CONVERSION
    CATEGORY = %CATS%
    FXCURRENCY = USD //INCORRECT line, has to be: CURRENCY = USD
    TID_RA = %TIME_SET%
    OTHER = [ENTITY = %ENTITY_SET%; DATASOURCE = %DATASOURCE_SET%,CALC] //INCORRECT line ",CALC" - to be removed
    RATEENTITY = GLOBAL //Not GLOBAL but Global (case!)
    *ENDRUN_PROGRAM
    *NEXT

    Please post a text of advanced DM script for this package.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2017 at 02:23 PM

    Corrected script without strange and useless lines:

    //Step #1 - TC to FC
    *XDIM_MEMBERSET FXCURRENCY = BAS(TC)  
    *XDIM_MEMBERSET DATASOURCE = TC.INPUT
    *START_BADI CURR_TRAN
    QUERY = ON
    WRITE = ON
    *END_BADI
    
    //Step #2 - FC to USD
    *FOR %CATS% = %CATEGORY_SET%
    *RUN_PROGRAM CURR_CONVERSION
    CATEGORY = %CATS%
    CURRENCY = USD
    TID_RA = %TIME_SET%
    OTHER = [ENTITY = %ENTITY_SET%; DATASOURCE = %DATASOURCE_SET%,CALC] //OK, looks like you always want to convert CALC datasource
    RATEENTITY = Global
    *ENDRUN_PROGRAM
    *NEXT
    
    //Step #3 - Inflation Inputs
    *XDIM_MEMBERSET DATASOURCE = INF.CALCCOMP,INF.INPUT
    *XDIM_MEMBERSET INTERCO = I.NA
    *XDIM_MEMBERSET LINEITEM = LI.001
    *XDIM_MEMBERSET LOCALCC = CC.NA
    *XDIM_MEMBERSET SCENARIO = S.NA
    *XDIM_MEMBERSET FXCURRENCY = FC
    *WHEN DATASOURCE
    *IS *
    *REC(EXPRESSION = %VALUE%, FXCURRENCY = USD)
    *ENDWHEN
    Add comment
    10|10000 characters needed characters exceeded