Trigger BW Process Chain from BPC - (Prompt vs DTP Filter)

[former_member212236]

Hello Experts,

Thank You so much for being supportive to everyone (Novice / Expert) working in BPC with all your inputs and recommendations.

I am just few weeks old in BPC and handling a small piece of requirement where I need your inputs. Kindly help.

Scenario:

I am working in BPC version 10.0 and I am trying to execute a process chain in BW system from BPC via Data Manager and Prompts.

To handle this, I am using the standard process chain ( BPC: Trigger BW Process Chain - /CPMB/TRIGGER_BW_CHAIN ) based on which my Data Manager package is created. I am able to successfully execute the standard BPC chain as well as the BW process chain which takes care of the loading part.

Here is my Question:

I have set the prompt on a particular dimension (Eg. Category) in Data Manager package. In addition, I do have filters set on certain selections (Year, Currency etc) in the DTP at the BW side.

I am trying to understand,

1. How the process chain in BW is informed about what data needs to be fetched based on the selection in Data Manager prompt ?

2. As I have got selections in two places (one in prompt and the other in DTP filter), which one would be considered first while extracting the data ?

It would be really helpful if anyone can help me understand how does it work when we trigger a load via data manager.

Regards,

Vinoth V

[former_member186338 · Accepted solution]

Sorry, but you can't pass any parameters fro DM prompt to the chain launched by TRIGGER_BW_CHAIN...

Vadim

[former_member212236 · Accepted solution]

Thank You Vadim for letting me know about the fact that I cant pass parameters from DM prompt to BW chain using the BPC chain /CPMB/TRIGGER_BW_CHAIN.

Do I have any other option  to handle my scenario. May be via custom chain, please suggest.

I came across the below document but not sure whether that will really help.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/400861b5-c342-2c10-6fba-b5d2babe5...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20f4252d-98ca-2b10-e689-f85085ae2...

Regards,

Vinoth V

[former_member186338 · Accepted solution]

"to handle my scenario" - but what is the scenario? You are not providing any details...

[former_member212236 · Accepted solution]

Hi,

My Scenario is:

I want my BW process chain to fetch the data considering the selections maintained in the DTP filter in BW and also the prompt values maintained in the Data Manager package in BPC.

Regards,

Vinoth V

[former_member186338 · Accepted solution]

Unfortunately this is not a scenario description - this is what you want

Scenario: what data you have in BW, what do you want to do with this data, why you can't use standard packages etc...

What values do you want to pass to BW chains...

Vadim

[former_member212236 · Accepted solution]

Thank You so much for your Patience Vadim.

I was able to successfully trigger a BW process chain from BPC. Currently, I do not have a provision to test the data loaded in BW due to some ongoing testing by other team.

I was under an impression that my triggered load was working based on the prompt value (i.e. Category = XXXX ) which I had set in BPC. Hence, raised a discussion with the description "Trigger BW Process Chain from BPC - (Prompt vs DTP Filter)" with a motto of understanding how the prompt value is passed to BW chain.

Came to know from your response that the BPC chain /CPMB/TRIGGER_BW_CHAIN cannot be used to pass values. So, my scenario is changed now .

What data you have in BW - Actual and Planned data residing in an Infocube.

What do you want to do with this data - The package would be executed by an end user with some selections in the prompt to view data for reporting purpose.

Why you can't use standard packages - Sorry, I haven't thought about it. Thank You for asking me this question, I will research further on this.

What values do you want to pass to BW chains - If I set the dimension CATEGORY = XXXX in prompt, I want my BW chain to bring the data related to that category.

Kindly let me know if I am on the correct path..

Regards,

Vinoth V

[former_member186338 · Accepted solution]

"What do you want to do with this data - The package would be executed by an end user with some selections in the prompt to view data for reporting purpose." - absolutely unclear! Package to view data? May be to upload data to BPC cube? I am lost...

[former_member212236 · Accepted solution]

Sorry, was unable to edit my response before your's.

May be I am using the terms in an incorrect way. Let me rephrase.

I have two models, each residing in two different environments in a BPC system . I am trying to load the data from one model to another based on the prompt values ( Category = XXX, Entity = YYYY, Time = 2016. March) with the help of the data manager package by triggering a process chain.

Regards,

Vinoth V

[former_member186338 · Accepted solution]

First - what is the idea behind having 2 different environments?

Second - try standard data import package.

Vadim

[former_member212236 · Accepted solution]

Thank You Vadim,

I will get back to you on your first question and also, I will try with standard data import package as suggested.

Regards,

Vinoth V

[Former Member · Accepted solution]

Hi Vinoth,

There is no standard Package that works with 2 Environments. Load from one to another is possible only with BW tools or BPC script BADI.

There is no standard Package to load data from one Model to another within one Environment. You can do it using Script Logic.

It's clear what you want in DMP Prompt; what is not clear is what you want in DTP filter. Can you please clarify?

And since all this is custom, how they'll interact depends on how you implement it.

Regards,

Gersh

[former_member186338 · Accepted solution]

Hi Gersh,

May be my mistake, but I thought that it's possible to use LOAD_INFOPROV_UI to load transaction data from one bpc model to another. Never checked

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Maybe, never tried it, but I think it's not going to bring data from the yellow request.

-Gersh

[former_member186338 · Accepted solution]

Yellow request can be closed before running dm...

[former_member186338 · Accepted solution]

Hi Gersh,

Just tested standard LOAD_INFOPROV_UI to copy data from one environment to another.

To close yellow request first light optimization with "Number of requests that you do not want to collapse": 0 was run.

Then with the following transformation file (models in different environments are the same):

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = TAB

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

ACCOUNT=/CPMB/QDDO7RJ

AUDITTRAIL=/CPMB/QDDXC6C

CATEGORY=/CPMB/QDD88BR

ENTITY=/CPMB/QDDIKR1

FLOW=/CPMB/QDD6KG0

RPTCURRENCY=/CPMB/QDD9MSV

TIME=/CPMB/QDD0NNQ

SIGNEDDATA=/CPMB/SDATA

*CONVERSION

I successfully copied data from one environment to another!

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Of course it will work with all green requests, but then you have to push out all users from that cube. To me it looses all benefits of BPC in that case. BW load would be much faster in that case.

Regards,

Gersh

[former_member212236 · Accepted solution]

Hello Gersh,

Thank You so much for your inputs.

Below are the DTP filter selections:

Month Number = 03, 06, 09, 12

Year = Current Year (I am arriving at the the current year using SY-DATUM field )

Due to some restrictions, I want to let the user only to fetch the records related to current year and month's March, June,September and December.

****************************

Will I able to get the load executed successfully if I keep the below selections in Data Manager prompt.

Category = XXX, Entity = YYYY 

and the below selections in the DTP filter

Month Number = 03, 06, 09, 12

Year = Current Year

****************************

I have found the below thread where a step by step process have been discussed on implementing BADI.Kindly let me know your thoughts.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20f4252d-98ca-2b10-e689-f85085ae2...

Regards,

Vinoth V

[former_member186338 · Accepted solution]

Sorry, but how DM prompt selection is related to DTP???

Badi is another story - for sure you can pass DM prompt selection to the badi parameters but what after?

Vadim

[Former Member · Accepted solution]

Hello Vinoth,

As you probably understood from our discussion you can't combine DTP and Package in one load.

What I'd suggest, is to create a Virtual Provider on the source cube where in inverse routine you can put Month and Year restrictions. Then DM Package will load data from that cube with restrictions on Category and Entity.

Since this approach combines BW and BPC features you have to pay attention to security setting. Do you have any authorization restrictions on the source cube?

Regards,

Gersh