BIEPM.COM

You can add a Project dimension with information that fits your business needs.
Creating the Project Dimension
Depending on whether you have a Performance Management Architect application or a Classic
Application.
With Performance Management Architect Applications
➤ To create a Project dimension in Performance Management Architect Applications:
1 In the Performance Management Architect Master View, create a generic Project dimension and a Dimension Alias with these properties:
● Dimension Name: Project
● Dimension Class: Generic
● Dimension Alias: Project
2 Under the Project dimension, create a member called No Project to store global assumptions.
3 Add other members to include in the Project dimension.
4 Drag and drop the Project dimension into the Performance Management Architect application you want to deploy.
5 Deploy the Capital Expense Planning Application View to refresh the Planning and Oracle's Hyperion® Essbase® – System 9 outlines

You can also load the Project dimension and its members from an external flat file and refresh
the Capital Expense Planning application.
6 Update data forms and business rules.
With Classic Applications
➤ To create a Project dimension for Classic applications:
1 In Planning, select Administration > Dimensions.
2 Click Add Dimension.

3 Name the dimension Project, select Apply Security (so you can assign access permissions to this dimension), and accept the other defaults.
4 Click Save.
5 Update data forms and business.
Updating Data Forms for the Project Dimension
After creating a Project dimension, update data forms.
➤ To update data forms to include the Project dimension:
1 In Planning, update the Point of View dimensions for these data forms:
● 01. Global Capital Assumptions
● 15A. Global Capital Assumptions - Depreciation only
a. Select Administration > Manage Data Forms.
b. Select the data form, and click Edit.
c. Select Page/Point of View Layout.
d. In the Point of View Dimension(s) area, select No Project as the Project member.
e. Click Save.
2 Edit the other Capital Expense Planning data forms to select Descendant members for the Project dimension:
a. Select Administration > Manage Data Forms.
b. Select the data form, and click Edit.
c. Select Page/Point of View Layout.
d. In the Page Dimension(s) area, for the Project member, select members by relationship
for Project, such as Descendants(Project).
e. Click Save.
3 Update business rules to enable storing global assumptions in multiple
Updating Business Rules for the Project Dimension
After creating the Project dimension and updating data forms, update the Capital Expense
Planning business rules.
➤ To update business rules for the Project dimension:
1 Using Administration Services, create a Global Variable called Project with these properties:
● Name: Project
● Type: Member
● Dimension: Project
● Limits: @Descendants("Dimension"), where "Dimension" is the limit you want to set, for
example, @Descendants("Project")
● Usage Type: Runtime prompt
● Prompt String: Project
2 Update the Capital Expense Planning business rules to include the Project member:
● Add the [Project] member to every place the FIX statement appears in the business rules.
● Update references to global assumptions in the business rules, by adding No Project to them.
3 You must update all these business rules:
Add Asset, AddExistAsset, AddExistIntangible, Add Intangible, CalcAmort,
CalcDepr, CalcExistAmort, CalcExistDepr, ImpairIntangible, Improve Asset,
Remove Asset, Retire Asset, Retire Intangible, RollupAssetEntities,
RollupAssets, Transfer Asset, TransferExistAsset, TransferExistIntangible,
and Transfer Intangible.
Example: Updating the Add Asset Business Rule
Example of Including the Project Dimension
"Useful Life (in Years)" = "No Scenario"->"No Version"->"No Entity"-> "No
Project" ->"Global"->"Useful Life (in Years)";
"Cash Flow Incidence" = "No Year"->"No Scenario"->"No Version"->"No Entity"-
> "No Project" ->"Global"->"Cash Flow Incidence";
"Funding Incidence" = "No Year"->"No Scenario"->"No Version"->"No Entity"->
"No Project" ->"Global"->"Funding Incidence";
cashFlowIncidence = "No Year"->"No Scenario"->"No Version"->"No Entity"-
>"No Project" ->"Global"->"Cash Flow Incidence";
fundingIncidence = "No Year"->"No Scenario"->"No Version"->"No Entity"->"No
Project"->"Global"->"Funding Incidence";
deprMethod = "No Year"->"No Scenario"->"No Version"->"No Entity"->"No
Project"->"Global"->"Depreciation Method";
deprConvention = "No Year"->"No Scenario"->"No Version"->"No Entity"->"No
Project"->"Global"->"Depreciation Convention";
repairsCost = basicCost * "No Year"->"No Scenario"->"No Version"->"No
Entity"->"No Project"->"Global"->"Repairs %";
fundingAmt = basicCost * "No Year"->"No Scenario"->"No Version"->"No
Entity"->"No Project"->"Global"->"Funding %";
insuranceCost = basicCost * "No Year"->"No Scenario"->"No Version"->"No
Entity"->"No Project"->"Global"->"Insurance %";
maintenanceCost = basicCost * "No Year"->"No Scenario"->"No Version"->"No
Entity"->"No Project"->"Global"->"Maintenance %";
Example of Adding Project When it is Referenced for Global Assumptions
FIX(@CHILDREN("Total New"), [Hidden_Scenario], [Hidden_Version],
[Project], [Department], [AssetClass], "Local", "HSP_InputValue")
FIX([Hidden_Scenario], [Hidden_Version],[Project], [Department], "Local",
"HSP_InputValue")
CALC DIM ("Period");
Example: Updating the Remove Asset Business Rule
Example of Adding Project when it is Referenced for Global Assumptions
SET UPDATECALC OFF;
SET AGGMISSG ON;
FIX ([Hidden_Scenario], [Hidden_Version],[Project], [Department],
[AllAssetClass])
CLEARDATA [LocalLineItem];
ENDFIX
FIX ([Hidden_Scenario], [Hidden_Version],[Project], [Department])
@ANCESTORS([LocalLineItem]);
@ANCESTORS([AllAssetClass]);
ENDFIX