Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 17, 2018 at 12:51 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2018 at 04:00 PM

    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.

    Add comment
    10|10000 characters needed 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 it points to a documentation to support the 'business content' package:

      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