Skip to Content
avatar image
Former Member

ACCTYPE in BPC 10.1 Embedded

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-with-key-figure-model/

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.

capture.png (133.6 kB)
capture2.png (29.6 kB)
capture3.png (58.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 21, 2017 at 08:25 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22, 2017 at 05:09 PM
    Add comment
    10|10000 characters needed characters exceeded

    • 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.