/BPC/DEFAULT_FORMULAS package generated only one APO request

[Former Member]

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

[Former Member]

Issue with fixed cube names??,you mean the issue regarding with insert a new dimension in BPC cube with data?

Regards,

Abel

[former_member186338]

Yes! Insert new dimension...

[Former Member]

Yes, you're right. I only just to understand the behavior.

Thanks again Vadim,

Abel

[former_member186338]

If you want "just to understand the behavior" - then ABAP debugging is a solution 🙂 !

[former_member186338]

P.S. Have you contacted SAP support to understand the issue with fixed cube names?

[Former Member]

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

[former_member186338]

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.

[Former Member]

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

[former_member186338]

Sorry, but I see no practical effect of this difference 🙂 What do you want to achieve?

[Former Member]

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

[Former Member]

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

[former_member186338]

You have to set ENABLE_FIXED_CUBENAME to empty.

If not working - contact SAP support...

[former_member186338]

Please read my answers here:

https://archive.sap.com/discussions/thread/3836999

[Former Member]

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

Thanks,

Abel

[Former Member]

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

[former_member186338]

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)...

[former_member186338]

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?

[former_member186338]

P.S. Strange idea to prefix DM package name with Z 🙂

[Former Member]

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

[former_member186338]

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