BPC Ownership load from external

[srikanth_ramachandran]

Hello,

Am interested in knowing if anyone has experience with loading ownership data into BPC from an external source - basically the data is maintained in an external application and submitted to BW/BPC. I know the flat file upload is an option from Data Manager but lacks control/flexibility so also exploring a BADI option to update the data to the cube after performing some validations.

Thanks,

Sri

[former_member186338 · Accepted solution]

"I think what you're saying is the existing DM flat file load approach can be used whilst leveraging a routine BADI that can have custom logic." - yes, possible approach.

Another approach is to write custom logic badi that will read external data from, for example SQL server, perform required validations and save data to BPC.

Everything depends on details that your are unable to provide...

P.S. There is no "best" solution for all cases!

[srikanth_ramachandran · Accepted solution]

OK thanks for the input Vadim - will get back on this when I am at the 'doing' stage. Did help to vet my thoughts.

[former_member186338]

No brainstorming required! You can use routine badi or custom logic badi to do whatever you want 🙂 No magic!

Try to ask practical questions, not theoretical...

[srikanth_ramachandran]

Okay ... right I get that .. just wanted to know if anyone has prior experience with this type of thing and lessons learned / roadblocks encountered etc ... so that the practical path becomes easier 🙂

I think what you're saying is the existing DM flat file load approach can be used whilst leveraging a routine BADI that can have custom logic.

[former_member186338]

Sorry, but requirements are not clear!

What do you mean by: "after performing some validations"??? Please explain the real scenario...

[srikanth_ramachandran]

Hi Vadim,

I dont have an exhaustive list of validations at this point but thinking ahead - so that any errors can be caught before data is saved to the cube. Since the data is maintained in and sent from an external application, I was wondering about using the flat file load which is almost like a dump. Hence brainstorming the idea of a BADI in case we need more control and validations. Hope that makes sense.