Skip to Content

ACCTYPE in BPC 10.1 Embedded

Feb 21, 2017 at 05:40 PM


avatar image
Former Member


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:

and this one:

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Best Answer
Vadim Kalinin Feb 21, 2017 at 08:25 PM
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you!

I also used this link and everything worked perfect!

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


Vadim Kalinin Feb 22, 2017 at 05:09 PM
Show 1 Share
10 |10000 characters needed characters left 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.