BPC 10.0 SP20 : Completing entirely the ownership manager through Excel

Hi BPC experts,

I have a request from a client that he would like to set the whole structure of the ownership manager through Excel only.

In other words, he would open an Excel file and does everything in this file (ownership structure, % PCTRL/POWN). Nothing would be done in the ownership manager itself. The Ownership structure is defined/updated in Excel which will automatically update the Ownership Manager structure as well.

As far as I know, we use an input form to record % PCTRL/POWN in Excel but I do not know if there is a way to define the Ownership Structure by using only Excel.

Do you have any ideas ?

Thank you in advance,

Dat