cancel
Showing results for 
Search instead for 
Did you mean: 

Extract BPC 7.0 Data Directly from ECC system

Former Member
0 Kudos

Hi experts,

I have requirement to Extract BPC data from ECC system on demand. I am new to BPC, Can anyone explain in detailed way how to achieve this requirement in code level?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

former_member200327
Active Contributor
0 Kudos

This approach is not advisable.

It could work fine if you want to bring data from some ECC table that doesn't have delivered SAP extractor, but if you want to bring data from something that has BW extractor, like GL, Sales, Purchasing, etc. I'd highly recommend using traditional approach. Traditional approach is - load data from ECC to BW and then use standard DM Package to load to BPC. You can join those two in one Package so user won't see that there is pit-stop there.

If nevertheless you want to put some code together for bringing data from ECC to BPC one of the ways is to use Custom Logic BAdI. When it's called you can call extraction from ECC and populate that parameter with retrieved data.

Please let me know if you need more details.

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh,

I have a similar requirement from my client.

During the close(monthend) they want to bring data directly from ECC into BPC (bypassing the BI layer, to expedite the process).

While at other times, they want the traditional setup (ECC->BI->BPC)

Can you give more details abt how to bring the data directly from ECC to BPC.

Thanks.

Apeksha

former_member200327
Active Contributor
0 Kudos

Hi Apeksha,

Since you are talking about month end closing I assume that it's Financial data. You can not retrieve Financial data directly from ECC tables: you'll have to handle deltas and this will break BW deltas.

Is there any good justification of why they want to bring data from ECC directly to BPC? What data they want to bring: since last BW load or everything for that period? Can you please explain how benefits of direct extraction can overweight grave disadvantages of that approach?

Idea of that approach is to call extractor from Custom Logic, but in case of Finance I don't see any benefits.

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh,

Yes, you're right , I'm talking abt the financial actuals data from ECC.

I think they'd like to bring delta load from ECC (changes that happened after the last BW load).

The intention is to reduce the time for data load in BPC by bypassing the BW layer(during the closure)

I'm not sure of the pros and cons of the method,and how to make it possible.

But to give a rationale to customer, can you suggest the exact cons you see in the direct data transfer methodology from ECC to BPC.

Please clarify your stmnt where you say- for Financial data this approach will not work.

Thanks

Apeksha

Former Member
0 Kudos

Hi Gersh,

Thanks for your response. I need to fetch BPC data from the ECC system using BAPI or some other way.

Please advice.

Thanks.

former_member200327
Active Contributor
0 Kudos

Hi Apeksha,

I'd assume you have the following scenario. ECC FI_GL data is loaded regularly to BW and then to BPC. At the and of the month accounting wants to get data from ECC directly to BPC. I'd also assume that those loads to BW are delta loads, not full loads. After month end they want to resume ECC-> BW-> BPC way of data.

Now, when you load data from ECC to BPC you probably also want to load just deltas for performance an data consistency reasons. So, if you do it once and do not mark that data in ECC as already extracted it could work fine, but when you want to do it next time you'll bring that data again and I doubt that you want that. If on the other hand side, you mark that data in ECC as extracted you'll miss it when you run your next BW delta and what will happen when that data comes from BW to BPC?

Also, how much data do you plan to bring and how many seconds to save?

Is that enough reason to not do this?

Gersh

former_member200327
Active Contributor
0 Kudos

Hi,

BAPI is just another type of ABAP programs, so saying that you what to use BAPI is same as saying that you need to use SAP delivered programs.

Can you please tell what kind of data you want to bring from ECC to BPC directly? Do you want it to be deltas or full loads, how often, etc?

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh,

I donu2019t need to bring the data from ECC to BPC.As you discussed in above is the normal process to load the data from ECC to BW to BPC, but I need some reverse process. Read BPC data from the ECC using custom program.

For example: Read FI related data (that is processed in BPC system) from BPC to ECC.

Thanks.

former_member200327
Active Contributor
0 Kudos

This is not clearer to me.

So, do you want to WRITE BPC data back to ECC? There is a RETRACTION Package and an example in the documentation how to write back data to ECC from BPC. That's where BAPIs come into play, because it's the preferred way of writing data back to ECC.

Can you please confirm that this is what you need or I didn't guess it again:).

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh,

I think now we are in right line. Yes just I need to Get BPC data from ECC where ever the BPC data that stored in BPC system for some comparison process.

Is it possible or not? If possible give some detailed idea about that.

If suppose RETRACTION Package is satisfy our requirement please explain some detailed points.

Thanks.

former_member200327
Active Contributor
0 Kudos

Comparison between BPC and ECC is a new turn in that discussion.

What kind of comparison it should be: a report that shows data in BPC as well as in ECC? some data check that compares totals to ensure that ETL was correct? Where do you want to runt that report: in ECC or in BPC?

As title of this thread says you want to "extract ... data ... from ECC". Retraction does the opposite, it extracts data from BPC and stores it in ECC. So, what really you are looking for?

If you are not sure, can you please provide some more details on what kind comparison you want to achieve and hopefully it will give me a better idea of what "tool to use".

Gersh

Former Member
0 Kudos

Hi Gersh,

Sorry for the inconvenience.

I need to Retract BPC data from ECC for compare some Total values or Volumes. The comparison process code should be run In ECC system.

I hope this will give some idea.

Thanks.

former_member200327
Active Contributor
0 Kudos

Hi,

So, I assume that you need to Retract some data from BPC Application back to ECC and run comparison report in ECC.

You can take a look at SAP Documentation [Retract Transaction Data Using a BAdI|http://help.sap.com/saphelp_bpc75_nw/helpdata/en/03/5d7212e96c43e99a007e8b830d3e87/frameset.htm].

[Retraction BAdI Definition|http://help.sap.com/saphelp_bpc75_nw/helpdata/en/01/d24991bc31439698f66ba7f6c3f116/frameset.htm] shows an example how to do this.

Please let me know if this is not what you were looking for.

Gersh

Former Member
0 Kudos

Yes Gersh,

I need to retract some data from BPC Application to ECC and run comparison report in ECC when I required the output, and also I need to retract data from BPC 7.0 version.

Thanks.

former_member200327
Active Contributor
0 Kudos

Now I see the point - 7.0 doesn't have that Process Chain.

A question that is valid no matter what version you are running - do you know a program in ECC (or BAPI) that can populate required tables? If you don't know it or you know that it doesn't exist, you'd have to develop an RFC enabled program that does it.If you already know or have such program - good for you.

Now on BPC side, you can try using UJ_CUSTOM_LOGIC enhancement with QUERY = ON - this will populate table parameter of that BAdI with data from Application. Then you call that BAPI (or RFC enabled program) to send that data to ECC.

Is that what you are looking for?

Gersh

Former Member
0 Kudos

Hi Gersh,

See this is my requirement; I need to create one custom program in ECC, and when run that program itu2019ll fetch the data from BPC Application then compare some ECC value to BPC value and populate some message like both values are matched or not.

I donu2019t need to call RFC program while executing BADI.

Is there any possible way for my requirement?

Thanks.

former_member200327
Active Contributor
0 Kudos

Hi,

To retrieve data from another system you need RFC. Now this is again a different requirement.

You can build a wrapper around BPC RSDRI function if you don't need node values or SQE function if you need node values. That wrapper function should be RFC enabled. Then you can call this function from your ECC program. It will bring back data from BPC Application and you can compare it to your ECC data.

Is that closer to what you are looking for?

Gersh

Former Member
0 Kudos

Hi Gersh,

Yes, we are very closer to our requirements. Can you give more details about how to use BPC RSDRI function or SQE in RFC, also provide some Step by step document or sample Code?

Thanks.

former_member200327
Active Contributor
0 Kudos

I don't think there is any document that describes how to use RSDRI or SQE - those are internal SAP interfaces.

Do you know which one you will need?

I just found that there is RFC enabled function RSDRI_INFOPROV_READ_RFC, so you can try using that one. I don't know any program where that FM is used, but you can look into RSDRI_INFOCUBE_DATA_COPY to see how RSDRI_INFOPROV_READ is used.

Regards,

Gersh

Former Member
0 Kudos

Hi Gersh,

Thanks for your response Iu2019ll try with this.

Answers (0)