ACCTYPE in BPC 10.1 Embedded

[Former Member]

Hello,

I have the following InfoObject in BPC 10.1 Embedded:

As it can be seen, I have a ZACCTYPE attribute and I have add my data with the different values: INC, EXP, AST and LEQ.

However, I can not use this functionality. If I have in the InfoCube a Forecasting Category with value -5 and type INC; when I open the report I see the value "-5". And I should see the value "5".

So I believe that the ZACCTYPE attribute is not working. How should I configure it?

--------------------

EDIT: I have solved the reverse sign problem using this link:

https://blogs.sap.com/2016/06/23/assigning-signage-for-account-dimension-in-sap-bpc-embedded/

and this one:

https://blogs.sap.com/2017/01/19/from-bpc-standard-to-bpc-embedded-reverse-sign-for-account-type-wit.../

However, I still have a problem with the aggretation.

In standard we have this:

The accounts B01, B02, O01, O02, C01 and C02 (BALANCE) take just the last value in the aggregation.

However, the rest of accounts (P&L) take the sum of its childs in order to calculate the parent's value.

How can I copy this behavior in BPC 10.1 Embedded.

Now, the parent is calculated as the sum of all its children.

I can select this option in the key figure configuration:

But then it takes the last value for all the accounts.

Thank you.

[former_member186338 · Accepted solution]

Please read:https://blogs.sap.com/2017/01/19/from-bpc-standard-to-bpc-embedded-reverse-sign-for-account-type-with-key-figure-model/

[Former Member · Accepted solution]

Thank you!

I also used this link and everything worked perfect!

https://blogs.sap.com/2016/06/23/assigning-signage-for-account-dimension-in-sap-bpc-embedded/

By the way, I have edit the question because there is still a problem with the aggregation.

Thanks

[former_member186338]

Just look on this blog about YTD/PERIODIC:

https://blogs.sap.com/2017/02/10/report-and-input-value-with-ytd-in-bpc-embedded-model/

[Former Member]

I have seen it, but how can I differentiate in the formula if it is a balance account or a P&L account? I have the property ZACCTYPE but I do not know how to bring this to the BEx.