About measure groups for shares calculation and consolidation
Financial models with shares calculations have three more measure groups than financial models without shares calculations. The additional measure groups are Shares Owned, Shares Outstanding, and Control and Ownership.
Shares Owned contains the number of shares and voting shares that an entity owns of another entity.
Shares Outstanding contains the number of total shares and voting shares that are outstanding for an entity.
Control and Ownership contains measures that represent the amount of control and ownership that is used in the consolidation process.
You can submit data for these measure groups by using a form assignment. However, data submission for financial models with shares calculations has special requirements.
Planning Server validates measure groups during data table submission. Because Planning Server validates one measure group at a time, you cannot submit data for the Shares Owned measure group and the Shares Outstanding measure group in the same form assignment.
To make sure that data is submitted successfully, create separate submission forms for the Shares Outstanding and for the Shares Owned measure groups. Then, submit the form that contains data for the Shares Outstanding measure group, followed by a form that contains data for the Shares Owned measure group.
Control and Ownership measure group
The measures in the Control and Ownership measure group are used in consolidation process. These measures are Overridden PCON, Overridden PCTRL, Overridden POWN, ultimate percent control (PCTRL), ultimate percent ownership (POWN), percent consolidated (PCON), and the Consolidation Method.
Based on the values that a user enters for Shares Outstanding and Shares Owned, the shares calculation process determines the value of PCTRL, the ultimate percent of control, for each entity in a model. PCTRL is one of six measures in the Control and Ownership measure group, which also includes PCON, POWN, Overridden PCON, Overridden POWN, and Overridden PCTRL. After the shares calculation process determines PCTRL, it determines the values of the other measures of Control and Ownership, and saves the values in the measure group. By using the calculated value of PCTRL, the process also determines the Consolidation Method. Planning Business Modeler stores Consolidation Method values in the Consolidation Method dimension.
This collection of values is specific to a particular entity in a particular scenario for a particular time period.
PCTRL, POWN, PCON, and the Consolidation Method
The Shares Calculation job calculates PCTRL and POWN. Then, based on the value that the process computes for PCTRL, the shares calculation process determines the values for Consolidation Method and PCON. The following table shows how the shares calculation process determines values for Consolidation Method and PCON.
For PCTRL in this range Assign this Consolidation Method Assign this value to PCON >= 0.0 and < 0.2
None
0.0
>= 0.2 and < 0.5
Equity
Same as POWN
>= 0.5 and <= 1.0
Full
1.0
The shares calculation process assigns a Consolidation Method of Holding and a PCON =1.0 to the holding company that is designated in the Entity dimension.
For more information about these values, see About the Consolidation Method dimension, PEL consolidation shares functions and PEL consolidation method functions.
Overridden PCON, Overridden PCTRL, and Overridden POWN
The shares calculation process sets initial values for Overridden PCON, Overridden PCTRL, and Overridden POWN. Users can modify these values. When you run a Consolidation Job, the process only uses the overridden values.
The following list shows the initial values that the shares calculation process sets.
Overridden PCON = PCON
Overridden PCTRL = PCTRL
Overridden POWN = POWN
For information about how to run the Shares Calculation job or the Consolidation job, see About Shares Calculation jobs and About Consolidation jobs.
Overwriting the consolidation method
You can change the value of the Consolidation Method that is assigned the shares calculation process. However, this value is closely associated with the values stored in the shares calculation measure groups, and you must coordinate the change in consolidation method with those values.
After a shares calculation job is finished, you can overwrite the value that this process determines for Consolidation Method in an entity/scenario/time period slice. However, the Consolidation Method is a dimension member, and closely associated with the members of the Control and Ownership measure group.
To make this change, you must first delete the Consolidation Method that you want to change, and delete the values of the six measures of the Control and Ownership measure group. After you change the Consolidation Method, you will copy these values back into their respective measures.
After you delete all these values for the specific entity/scenario/time period/consolidation method that you want to change, you can enter a new Consolidation Method and copy the values of the six measures back into their respective measures.