Question Re: SAP Analytics Cloud: Reverse Sign in Technology Q&A

SAP Analytics Cloud: Reverse Sign

anna389 — Wed, 23 Sep 2020 14:33:20 GMT

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

Re: SAP Analytics Cloud: Reverse Sign

SeerOfSig — Wed, 23 Sep 2020 15:00:21 GMT

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/15d49a3a617a4f608a7b7a27c129be85.html

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.

Re: SAP Analytics Cloud: Reverse Sign

anna389 — Thu, 24 Sep 2020 07:16:04 GMT

Hi Peter,

thank you!

So reverse the sign is only available for imported data?

Best regards

Anna

Re: SAP Analytics Cloud: Reverse Sign

ThomasK — Wed, 28 Apr 2021 10:02:31 GMT

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

Re: SAP Analytics Cloud: Reverse Sign

jonathanhaun — Wed, 11 Aug 2021 20:33:38 GMT

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.

Re: SAP Analytics Cloud: Reverse Sign

TuncayKaraca — Wed, 11 Aug 2021 22:05:30 GMT

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

Re: SAP Analytics Cloud: Reverse Sign

sureshkumar_pappureddi — Thu, 23 Feb 2023 21:08:50 GMT

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)

Re: SAP Analytics Cloud: Reverse Sign

YeeTeng — Thu, 23 Mar 2023 10:25:56 GMT

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',

Re: SAP Analytics Cloud: Reverse Sign

ABA2 — Wed, 08 Nov 2023 14:51:27 GMT

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?