Skip to Content
1

How to manage Account dimension with live connection in SAP Analytics Cloud (SAC)

Jan 17 at 12:21 PM

104

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

Hi Jordi,

Any update. Were you able to get this working?

0

Ping!

Any update. Were you able to get this working?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jan 17 at 12:51 PM
3

Jordi - if you are using ECC, have you tried using the financial statement hierarchy? That is how we built our financial statements (using Crystal Reports) with the SAP Trial Balance Statement report as a data source. So if you are modeling in BW I would model the BEx query based on the SAP Trial Balance - report is dependent if you are on New GL or Classic.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 07 at 04:00 PM
1

Thank you Tammy but according to SAP product experts there isn't easy solution for this problem. All financial examples of the SAC BI content are prepared for import connections and not for live connections. It doesn't matter if you build the model from BW or from HANA views. You can not identify the fields that correspond to the ACCOUNT dimension in the data preparation phase in SAC.

Our solution will be to create a Account dimension for the main mesures (amount, quantity, etc.) and the chart of accounts will be linked to a generic dimension.

Thank you very much.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi,

I'll be honest, I'm struggling a bit to understand what you are trying to do. Maybe a screenshot or two would help illustrate the pinch-point?

Anyway, going back to your point about 'all the financial examples are based on import connections' , i'm not sure that's quite right. If you look at this page in the Help guide https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/078868f57f3346a98c3233207bd211c7.html it points to a documentation to support the 'business content' package: https://help.sap.com/doc/f04e1b585e9e40548d4e8de7582c9dfc/release/en-US/Documentation_SAP_SAC_CONT.pdf

As per my interpretation, the SAC examples that are related to Finance LoB are typically coming from S/4 HANA Cloud (Yes it can be on-premise, but it can only be S/4). In some cases, yes, it is an import from a CDS view via a transient infoprovider (i.e. using the embedded OLAP engine in S/4, like a mini BW mart). But there is also content for Real-time finance & planning use-cases based on Live data (P&L financial statement, and Actual v Plan reporting). In those sections there is plenty of talk of leveraging the know G/L chart of accounts structure, coming from sFIN.

Does your SAC project have a Customer Success Manager assigned to it? maybe ask internally towards the SAP account executive, to get additional support whilst you onboard this implementation.

I think in this case, the secret-sauce is to be on S/4HANA to have a better integration experience.

regards, H

1