SAP BPC 10 NW - Ownership % Changes

[former_member226891]

Hello,

As per my Client requirement the Ownership % of the Entities can change in a year.

So how should I automate this effect so that my minority calculations are done automatically.

Like for example as below

Co Code	%(31.03.2013)	%(31.09.2013)	%(31.12.2013)	%(31.03.2014)
1070	11.39	77.2	77.2	77.2

So how should I take the effect in the changes so that my Minority is calculated properly.

Regards,

Ravi

[Former Member]

Hi Ravi,

you should set up members in your flow type dimension with flow_type entries for changes. There is a list of these in the online help. These should automatically calculate values when you have changes in ownership.

In terms of minority interest, there are two parts. First you need to adjust the opening balances for minorities. BPC will do this for you with the flows described above. Second it's the profit. The system will take the YTD profit and calculate YTD minorities each period with the percentage entered for that period. You can then use manual adjustments to get to the figure you need.

BR,

Arnold

[former_member226891]

Hi Arnold,

Can you please guide me through some online links as I am unable to get any solution to my issue.

The Client keeps on changing the ownership pattern so how should I tackle it.

At the end my Consilidation should not be of the whole year but it should a kind of incremental whenever there are changes in ownership the system should be knowing it and calculate it accordingly.

So can you please guide me through some links?

Regards,

Ravi

[Former Member]

Hi Ravi,

the flow types are described here: Subtable Dimension Properties - SAP Business Planning and Consolidation, version for SAP NetWeaver -...

Please set those up and run two consolidations. One for a year end and one for a period in the following year for which the percentages in the ownership model have changed.

[former_member226891]

Hi ,

Thanks for the way to resolve it.

But as I am new to Consolidation can you guide me with some configurations.

Now where I should be using the FLOW TYPE and that too I think I need to use the FLOW TYPE VARSCPPERC?

Please can you guide me with some configurations

[Former Member]

Hi Ravi,

have you set up new members in your flow dimension and assigned the flow types listed in the link I gave you above?

You do not have a choice here with BPC, once you have set up those elements and run a consolidation, BPC will select what to do and on which flow.

[former_member226891]

Hi,

Below is the FLOW Dimension that has been setup.

So now how can I utilize VARSCPPERC?

Regards,

Ravi

[Former Member]

Hi Ravi,

have you consolidated a year end and a period in the following year with a change in ownership%?

[former_member226891]

Hi,

Below has been setup for normal full consolidation for period 2014.00.

Now the Ownership has changed on 2013.09 so now I should maintain it for that period?

After that I should run the Consolidation? then where is the use of the FLOW_TYPE here?

Please guide me

Regards,

Ravi

[Former Member]

Hi,

I don't understand period 2014.00 but I would guess that 2013.09 is before 2014.00. The question is though if 2013.09 is the year end period?

So, if 2013.09 is a year end period and you then have changed ownership data for the later period 2014.00, yes, please consolidate both in chronological order.

BPC will use the flows as it determines it should from the flow_type, you do not need any more configuration.

[former_member226891]

Hi,

My Closing Period is 2014.00 and now the results are showing wrong in 2014.00.

As the Ownership got changed on 2013.09. So now how should I perform my Consolidation.

I should first run the Consolidation for the Period 2013.09 then Period 2014.00?

In my transactional data I have only used "CLOSING" as my FLOW.

So how the FLOW will automatically take care of it?

Regards,

Ravi

[Former Member]

Hi,

If 2014.00 is your base (=year end) period, then why are you consolidating 2013.09 and 2014.00? The system also works out the difference between a period you consolidate and the prior year end period. As 2014.00 I assume is later than 2013.09 consolidating 2014.00 and then 2013.09 won't do any good.

If 2014.00 is a year end, what is the prior year end period? 2013.00? And for one entity, what is the ownership percentage for 2014.00 and the prior year end?

[former_member226891]

Hi,

I am running the Consolidation for the year 2013-14 for which my special Closing Period is 2014.00 which contains the data from 2013.01 to 2013.12

Now the issue is my Entity Ownership is maintained as 77.2% for 2014.00. So now once I run consolidation it will get values for 77.2%

But for one entity the ownership got changed on 2013.09 from 51% to 77.2% so I need to calculate ownership along with minority from 2013.01 to 2013.09 with ownership value as 51% and for rest of the months as 77.2%.

So how its possible?

Regards,

Ravi

[Former Member]

Hi,

this is from my previous post:

In terms of minority interest, there are two parts. First you need to adjust the opening balances for minorities. BPC will do this for you with the flows described above. Second it's the profit. The system will take the YTD profit and calculate YTD minorities each period with the percentage entered for that period. You can then use manual adjustments to get to the figure you need.

The system will adjust opening balances for minorities, but you have to manually adjust the minority calculation for the profit. For the opening balances the system should calculate the difference (in your case between 51% and 77.2%) and post an adjusting entry (in your case reducing the minority part) to the flow with flow_type VARSCPPERC.

So, assuming the entity has equity of 100.000 in the prior year the system would have calculated 49.000 minority interest (51% owned). For this year it would calculate 22.800 minority interest (77.2% owned). It should therefore post an adjustment of the minority interest of -26.200 onto the flow with flow_type VARSCPPERC.

BPC will calculate the minority interest on the profit with 22.8%. Assuming your model is YTD this percentage will be applied to the complete YTD value and you will need to adjust manually for those months were 49% should have been used.

[former_member226891]

Hi Arnold,

By the below statement as you said.

So, assuming the entity has equity of 100.000 in the prior year the system would have calculated 49.000 minority interest (51% owned). For this year it would calculate 22.800 minority interest (77.2% owned). It should therefore post an adjustment of the minority interest of -26.200 onto the flow with flow_type VARSCPPERC.

It will done automatically? So if its done automatically then I should my Consolidation for period 2013.09 and then again run the Consolidation for period 2014.00 . After running the Consolidation on 2014.00 the system will automatically identify the difference and it will post in flow_type VARSCPPERC.

I just do no need to set up any rules correct?

Regards,

Ravi

[Former Member]

Hi,

no, you should not need to set up any rules, the flow_type should handle that.

BR,
Arnold

[former_member226891]

Hi,

Is there any way to some how automate the below issue.

As I have triggered the Consolidation on 2013.07 with the Ownership% as 65% I got the below result in Minority Calculation.

ACCOUNT	AUDITTRAIL	CATEGORY	ENTITY	FLOW	INTERCO	RPTCURRENCY	SCOPE	TIME	SIGNEDDATA
40100007	Input	Actual	1080	I_NONE	Balance	INR	S_1000	2013.07	11,549,568.33
MI_PL	Equity	Actual	1080	I_NONE	Balance	INR	S_1000	2013.07	4,042,348.92

Then again I triggered the Consolidation on 2013.12 with the Onwership% as 75%

ACCOUNT	AUDITTRAIL	CATEGORY	ENTITY	FLOW	INTERCO	RPTCURRENCY	SCOPE	TIME	SIGNEDDATA
40100007	Input	Actual	1080	I_NONE	Balance	INR	S_1000	2013.12	1,380,529.33
MI_PL	Equity	Actual	1080	I_NONE	Balance	INR	S_1000	2013.12	345,132.33

But Ideally in 2013.12 it should calculate the difference between 2013.12 & 2013.07 i.e

( 1,380,529.33 - 11549568.33) * 25% its because from 2013.01 to 2013.07 it should be caluclated as 35% and the remaining months with 25% as the ownership got changed.

PFB the screen shots of the Ownership%.

Is there any way to automate this throught Rules or Script Logic?

Regards,

Ravi

[former_member226891]

Hi,

I am still unable to find any solution.

Please give some suggestions

Regards

Ravi

[former_member226891]

Hi,

Please some one guide me on this as its very urgent.

Regards,

Ravi