Skip to Content
-1

/BPC/DEFAULT_FORMULAS package generated only one APO request

Jan 31, 2017 at 04:20 PM

170

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

12 Answers

Vadim Kalinin Jan 31, 2017 at 04:57 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Abel López Bartolomé Jan 31, 2017 at 06:48 PM
0

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


script.png (43.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 31, 2017 at 07:01 PM
0

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Abel López Bartolomé Jan 31, 2017 at 08:06 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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)...

1
Abel López Bartolomé Feb 01, 2017 at 09:37 AM
0

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

Thanks,

Abel


add-dimension.jpg (25.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Feb 01, 2017 at 09:49 AM
0
Share
10 |10000 characters needed characters left characters exceeded
Abel López Bartolomé Feb 01, 2017 at 10:26 AM
0

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


model.jpg (23.9 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

You have to set ENABLE_FIXED_CUBENAME to empty.

If not working - contact SAP support...

0
Abel López Bartolomé Feb 01, 2017 at 10:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Abel López Bartolomé Feb 09, 2017 at 04:32 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Abel López Bartolomé Feb 10, 2017 at 08:47 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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.

0