Skip to Content
avatar image
-1
Former Member

/BPC/DEFAULT_FORMULAS package generated only one APO request

We run a customer package based on /CPMB/DEFAUL_FORMULAS process chain with logics script in order to copy data between two BCP cubes . It finish properly but in destination BCP cube only one APO request is generated with the total of records. In develop environment the same process generated n APO request with 80.000 records aprox. Whats is the difference?. How can I forced system to generate several APO request.

Thanks in advance

Abel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

12 Answers

  • Jan 31, 2017 at 04:57 PM

    You have to provide full info based on:

    https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    It's not possible to answer your question without script, advances DM script, user selection and all other details

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2017 at 06:48 PM

    Hi Vadim:

    Thanks for you quick answer. This is DM package and script code, so it's very simple code, the focus is trasnfers all data from a BPC cube to another BPC cube create as model of first one, I mean, both BPC cubes have same structure.

    SOURCE BCP MODEL: PLANIFICACION

    TARGET BCP MODEL: PLANIFICACION_COPY2

    DM PACAKGE BASE IN /CPMB/DEFAULT_FORMULAS

    'PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")
    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,@@@SAVE@@@@@@EXPAND@@@|DIMENSION:COD_PADMON||DIMENSION:COD_PRECIO||DIMENSION:CONCEPTOSPL||DIMENSION:CONTRATO||DIMENSION:EDT||DIMENSION:FASE||DIMENSION:PRECIOS||DIMENSION:P_GROUPS||DIMENSION:VERSION)
    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
    'TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,COPIA_A_COPY.LGF)

    LOGIC SCRIPT COPIA_A_COPY.LGF

    This process, in develop environment create several APO resquest with 80.000 regs each one and in test environment create only one APO request with all records.

    Thanks again,

    Abel

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 07:01 PM

    Forget about requests, meaningless in BPC!

    Scripts are strange in general!

    Advanced DM - if you don't want to pass members then remove the line:

    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,@@@SAVE@@@@@@EXPAND@@@|DIMENSION:COD_PADMON||DIMENSION:COD_PRECIO||DIMENSION:CONCEPTOSPL||DIMENSION:CONTRATO||DIMENSION:EDT||DIMENSION:FASE||DIMENSION:PRECIOS||DIMENSION:P_GROUPS||DIMENSION:VERSION)

    Script logic is also strange, has to be:

    *WHEN VERSION
    *IS * //Any version!
    *REC(FACTOR=1)
    *ENDWHEN
    //And no *COMMIT!!! useless!

    And what is the idea to copy all data from one model to another?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2017 at 08:06 PM

    WE have to insert a new dimensión in original Model but this cube have data, so we must first move al data to another backup cube, then empty original one in order to allow insert a new dimensión and finally come back data.

    I will try your cose.

    Prefix Z is because I have abap background skill, and used to prefix all customer object begining with Z.

    Thanks Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • In general you don't need to clear data to add a new dimension. Add new dimension with one member and this member will be assigned to all data.

      If you still want to backup restore then:

      Strange idea to save data this way :) It's better to export data to text file and import it later.

      Or you can use cube to load data using /CPMB/LOAD_INFOPROV_UI between BPC cubes (just close yellow requests)...

  • avatar image
    Former Member
    Feb 01, 2017 at 09:37 AM

    We already tried it and system return us the following errro message from web administration console:

    Thanks,

    Abel

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01, 2017 at 09:49 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01, 2017 at 10:26 AM

    I just did a test with a BPC cube with transactiona data as you suggest in https://archive.sap.com/discussions/thread/3836999.

    First delete ENABLE_FIXED_CUBENAME from model parameters,

    Then add new dimension in web console administration to model

    but ...... we have error again

    We are on 810 SP 10. SAPK-81010INCPMBPC

    Thanks,

    Abel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01, 2017 at 10:53 AM

    Ok, I´ll contact with SAP Support because I just did a test with ENABLE_FIXED_CUBENAME to empty and I've got same result.

    Thanks anyway Vadim

    Abel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2017 at 04:32 PM

    Hi Vadim:

    Just to tell you that I think know why with from the same source BPC infocube with DM package with script inside, once create only one APO request in target BPC cube and other times several 80.000 records APO request are genetared in target BPC cube. It`s depends how do you create BPC cube in admistration web console. So , if you create a new BPC model as a copy of the other, this cube will generate only one APO request but if you create a new blank model, insert dimension and save it, this BPC cube will generate many APO request.

    Do you have an explanation about this behavior?

    Best regards,

    Abel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2017 at 08:47 AM

    Hi Vadim,

    I only want to know the behavior, there are no differences an the end, data are in target cube in both cases, but It seemed strange to me.

    It's just.

    Best regards,

    Abel

    Add comment
    10|10000 characters needed characters exceeded

    • And if you run light optimization (recommended to be launched regularly) all requests will be collapsed! I don't see the point to think about requests with BPC standard.