Dear SAP experts,
We need to build a SAC model with P&L accounts and other business dimensions. We have a ECC 7 with HANA DB and a BW embedded on the ERP.
First of all we tried to build a model in BW and we used a query of this model as a datasource in live connected model. This kind of SAC models just allow manage account dimension and it take all of key figures as account members. Do we have create as many key figures as accounts? For this reason we don't know how to create the P&L. We thought about the possibility of create this model with "mono-rate" and build the account structure and hierarchies in global dimension. Thats will be a problem because it will be hard to create new calculated and restricted members and formulas.
We have also the possibility of create the model using "calculate views" from HANA as a datasource but we think that we will have the same problem.
Are there any solution to resolve this kind limitations?
PD: The user does not want to have the data physically in SAC. For that reason we want to use live connections.