How to save calculated value from BPC to BW.

[Former Member]

Hi Experts,

I have an requirement to do calculation and send calculated value from one model to another model, As i know that i can do this with the help of Destination_APP.

But after that i want to save this value into BW that how to achieve ?

Thanks,

Ravi

[former_member186338]

"i want to save this value into BW" - not to BPC model, just to some BW cube? Can you explain the business idea in details?

For sure you can write abap code in some badi to do whatever you want...

Vadim

[Former Member]

Hi Vadim,

As we knows that any value from BPC is saving in BW (/CPMB) and for that no need to do any thing as it's automated correct ? but what if want to save value in BW cube ..?

As you are telling that we can achieve it by ABAP code in some badi ?

Any help document is there to write that BADI as i do not having knowledge for ABAP ..

Thanks,

Ravi

[former_member186338]

"As we knows that any value from BPC is saving in BW (/CPMB) and for that no need to do any thing as it's automated correct" - correct!

"but what if want to save value in BW cube ..?" - what for? business logic to be explained!

"Any help document is there to write that BADI as i do not having knowledge for ABAP" - I recommend to find an expert, it's not a very easy job

Vadim

[Former Member]

Hi Ravi,

When you say calculated value, do you mean value that is calculated by your script or value defined by member formula?

Regards,

Gersh

[Former Member]

Hi Gersh,

Calculated by script logic but that is not my problem as it is working fine..but after that only i need to save those value into BW cube ...any idea how to do ?

Thanks,

Ravi 

[former_member186338]

Sorry, but try to answer the question about business reason....

[akos_beres]

Ravi,

Since we don't know what you are trying to do I'll

- If you simply need to report off the cube or combine data from another cube, there is a multiprovider that you can leverage.

- If you need to load the data from a BPC cube to a BW cube, create a process chain that would perform a cube to cube load

- you can create a DTP between the BPC cube and another infocube

Hope this makes sense,

Akos

[Former Member]

Hi Ravi,

There is no difference between saving in BW cube calculated values and saving in BW cube original values. I.e. you can save then in exactly same way as you save all other values.

Regards,

Gersh

[Former Member]

Hi Akos,

Yes - I need to load the data from a BPC cube to a BW cube, create a process chain that would perform a cube to cube load.

Any document or link to get the details that how to create process chain ?

Thanks,

Prabhat

[Former Member]

Hi Prabhat,

First you have to create cube, Transformations and DTP. Then go to t/a RSPC and try creating Process Chain by drag & drop. It's very intuitive for simple Process Chains.

Regards,

Gersh

[Former Member]

Hi Ravi,

Actually it would be good to know business logic to help you in healthy way which means

whats Vadim searching for was an important point.

But anyway what you can do is, as Vadim adviced, if you use the UJ_CUSTOM_LOGIC badi for your calculations in BPC, you can call "RSDRI_CUBE_WRITE_PACKAGE" method in that badi to write relevant data to BW cube too. But it's an abap coding, so you need an abaper. The advantage of this solution is, you ll be able to write your data into BPC and BW cubes by using single package run.

But to be honest, i am not sure if this is healthy solution for you because i am not sure about the business requirement you have.

or you can follow the solution given by Akos which is more standart way.

Good luck.

Yusuf

[akos_beres]

Ravi,

Gersh laid out the steps you'll need to go through. Talk to a BW consultant or google the steps Gersh laid out. There is so much out there. Here are just a few links for DTP:

Creating Data Transfer Processes - Business Intelligence - SAP Library

If you want an awesome tunes while you watch a video on DTp (or any BW process)... I recommend this one

16. How to create a DTP and load data to the data target in SAP Business Intelligence (BI / BW) - Yo...

Good luck!

Akos