BPC standard package /CPMB/ARCHIVE_ACTIVITY

[former_member213777]

I have a question on how you can run /CPMB/ARCHIVE_ACTIVITY using a todays date and time minus 90 days?

When you run the standard delivered data manager package you need to specify a timestamp in the format 'YYYYMMDDHHMMSS'

Can you mange to fill this automatically and without getting the prompt so you get following?

YYYYMMDDHHMMSS =<current date - 90 days>000000

E.g. Can current date be taken from system date?

Run Package /CPMB/ARCHIVE_ACTIVITY

Timestamp via prompt

I believe somehow it should be possible if you modify the script?

Current script (SAP standard):

PROMPT(TEXT,%TIMESTAMP%,"Archive audit older than timestamp(YYYYMMDDHHMMSS)",)

TASK(/CPMB/ARCHIVE_ACTIVITY,AUDIT_TIMESTAMP,%TIMESTAMP%)

Our environment are following: ***SAP BPC NW 10.1 (Standard/Classic) ***

SAP_BASIS 740 0011 SAPKB74011

SAP_ABA 740 0011 SAPKA74011

SAP_GWFND 740 0012 SAPK-74012INSAPGWFND

SAP_UI 740 0013 SAPK-74013INSAPUI

PI_BASIS 740 0011 SAPK-74011INPIBASIS

ST-PI 740 0002 SAPK-74002INSTPI

BI_CONT 747 0013 SAPK-74713INBICONT

SAP_BW 740 0011 SAPKW74011

CPMBPC 810 0006 SAPK-81006INCPMBPC

POASBC 100_731 0004 SAPK-10204INPOASBC

ST-A/PI 01R_731 0000

Message was edited by: Mikkel Bojsen-Møller Updated with pictures.

[former_member186338 · Accepted solution]

Hi Mikkel,

Unfortunately only with the help of ABAP and custom chain...

Vadim

[former_member213777 · Accepted solution]

Vadim,

Can you share an example of a customized process chain.

I did try a custom Proceschain but are very much in doubt if I need all procces chain variants how to configure them.

1) copy process chain /CPMB/ARCHIVE_ACTIVITY to an customized version

2) How to configure A (is this needed)?

3) How to configure B

4) How to configure C (is this needed?)

[former_member186338 · Accepted solution]

Try the following: look on the code of UJD_TEST_PACKAGE, perform the required code modifications to calculate the date, then create a new chain with modified UJD_TEST_PACKAGE.

[former_member213777]

I did some research. In many situations filling the prompt in the backend can be achived using a combination of a BW process chain calling program UJD_TEST_PACKAGE. The UJD_TEST_PACKAGE again calls a BPC data manager package (which again uses the standard process chains /CPMB/ARCHIVE_ACTIVITY).

Do following:

1. Create a BPC data manager package that are based SAP standard BW/BPCprocess chain e.g. /CPMB/ARCHIVE_ACTIVITY
   
   
   
2. Run the data manager package from BPC and fill the prompt manually
   
   
   
3. If you view the log details of the data manager package run you'll get inspiration on how to fill the prompt variable i the backend
   
   
   
4. With the inspiration go to backend system t-code SE38 and find program UJD_TEST_PACKAGE. Create a variant for the program.
   
   
   
5. The variant shall be filled with proper information. Start by choosing the data manager package created in the first step.
   
   
   
6. Fill the remaing fields to you needs. Experiment with the prompt using informantion from SAP note:
   
   "1599387 - How to create an AnswerPrompt file for programs UJD_TEST_PACKAGE and UJD_TEST_PACKAGE_LONGPROMPT"
   
   
7. When your satisfied with the variant then build your process chain in t-code RSPC having a 'Start Proces' pointing to an 'Execute ABAP program' process chain variant.
   
   
8. Start og schedule your process chain. The process chain will start the BPC data manager package with the variant (including the prompt).

When your need to derive a dynamic prompt which I will need for running the data manager package created for /CPMB/ARCHIVE_ACTIVITY I will need to make a cusomized program copy of UJD_TEST_PACKAGE where the 90-days offset can be made using ABAP.

BW Process Chain:

Execute ABAP Program proces variant:

SE38 - Variant used for UJD_TEST_PACKAGE

[former_member186338]

"I will need to make a cusomized program copy of UJD_TEST_PACKAGE where the 90-days offset can be made using ABAP." - yes, that was the idea I told you...

[former_member213777]

Sure - but also the Answer Prompt was tricky and here SAP note 1599387 is very helpful even the note are from older BPC versions. Without the correct formatted and filled Answer Prompt the design  of a customized programming can't be done.

What I don't understand is why this is not possible using the 'modify script' as a standard in the BPC data manager. It would have been nice if SAP provided standard variables and the possibility to create custom variables that could be used to fill the values from the prompts with an offset like the 90 days.

[former_member186338]

"What I don't understand is why this is not possible using the 'modify script' as a standard in the BPC data manager." - unfortunately advanced script is very limited, just concatenation of strings...