SAP Analytics Cloud: Reverse Sign

[anna389]

Hi SAP Community,

i am looking for the option to reverse the sign of an measure in SAP Analytics Cloud.

By searching this i found some issues and questions regarding this topic so it has to be possible somehow...

I am working with a live connection to SAP S/4 HANA Cloud, but i am also interested in solutions for other connections.

Thanks for your answer!

Anna

[TuncayKaraca]

Hello All,

I saw jhaun00's message and I just want to contribute the discussion. Tagging tkarner, anna389, and peter.kreutlein . What I see is:

Account Types (INC, EXP, AST, LEQ, NFIN) as an Attribute of an Account Dimension are available only for:

• Classical Account Model - Acquired (Import Data Connection)
• New Model (with measures and an account dimension) - Acquired (Import Data Connection)

Account Types (INC, EXP, AST, LEQ, NFIN) are not available for:

• Live Model (Live Data Connection)
• New Model (with measures and an account dimension) - Live (Live Data Connection)
• New Model (Model with measures and no account dimension) - Acquired (Import Data Connection)

Regards,
Tuncay

[ABA2]

We are importing data from S4 into SAC. Is there any information in S4 with which we can load the sign flip into SAC? Or can we even load or derive account types (INC, EXP, AST, LEQ, NFIN) from S4?

[YeeTeng]

If you are using 'Custom Analytical Queries' Fiori App to connect the SAC via Live Data Connection. You can reverse the sign in the 'Display' tab by marking the indicator for 'Reverse Sign',

[sureshkumar_pappureddi]

Sign reversal is possible for live connection for GL Account/ FSV using FSV(Financial Statement version). You can reverse the sign in the S4 system in FSV nodes and it will reflect in the SAC report( Using the FSV hierarchy)

[jonathanhaun]

Unless someone can prove otherwise, this is not possible for live data connections. You have to import the data into the SAC dimension object to setup this funcationality.

[ThomasK]

peter.kreutlein How can reverse sign be handled when using S/4 HANA Live-Connection?

[anna389]

Hi Peter,

thank you!

So reverse the sign is only available for imported data?

Best regards

Anna

[SeerOfSig]

Reverse sign is handled under specific cases for the account (measure) dimension.

See the online help regarding "Attributes of an Account Dimension"

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/15d49a3a617a4f608a7b7a27c...

Account Types

The Account dimension uses an Account Type attribute to automatically handle positive and negative values. From an accounting perspective, account members belonging to the Profit and Loss statement and the Balance Sheet have to be correctly stored in the database with either a positive or negative value so that the accounts balance correctly. In SAP Analytics Cloud, you can enter all values as positive numbers, and the switching of signs from positive to negative is handled automatically on the basis of the Account Type setting.

There are four financial account types: Income (INC) and Expense (EXP) items are included in the Profit and Loss account, and Assets (AST) and Liabilities (LEQ) are Balance sheet items. Automatic switching is applied to the account types INC and LEQ. Note that all formulas work on the displayed value, not the value saved in the database.

When importing data from an external system, a mapping feature is available to ensure that imported data also fits into this schema. This feature is switched on using the Reverse the Sign of the Data Based on Account Type check box in the Details panel when importing data. When this check box is activated, imported data will also be identified by account type and stored and handled correctly.