Dear all,
We have a challenge within our organization when loading data from SAP BPC info cube with multiple Account Hierarchy into the SAC data model. When creating a SAC data model based on a SAP BPC cube, it is mandatory to select the Account hierarchy(H1) from the source to load the data into SAC. When you want to load with the second hierarchy(H2) from the source, it will add this hierarchy master data under the same hierarchy column in SAC Account dimension(Hierarchy), which causes huge issue and in principal is incorrect. It doesn't create another hierarchy column in the SAC Account dimension.
Has anyone faced the same issue and if yes, how did you solve this. As I could see, the only way to overcome this, is to create the hierarchy manually in SAC on a public Account dimension and load it from the source, flat file or manually maintaining it in the master data hierarchy, but I would like to automatically update the second hierarchy as a seperate column in Account dimension.
Regards,
Reza Ghazvini