Location Alias in Planning and Budgeting Cloud Service (PBCS)


How to use Location Alias in Planning and Budgeting Cloud Service (PBCS)?

Currently this feature is not available in PBCS.

Workaround: Planning always creates default aliases when the application is created.

Planning refers to each of the cubes using the following aliases in case of Prod Instance:

  • Plan1 – _RevCube_
  • Plan2 – _PnlCube_
  • Plan3 – _BsCube_

You can refer to these location aliases from one plan type (cube) to refer to the another. For Example in Prod Instance from Plan2  you can refer to Plan1 using _RevCube_.

However, here are few considerations to note :

1) Xref/Xwrites when used in batch calculation, are non-performant and hence should be avoided if possible. Instead administrators can push the data from one plan type (cube) to another using Map Reporting Application.

2) In Planning, if you enable an account member for more than one plan type and chose Source plan type value as one of the cubes, then this value is available in the other cubes by means of a dynamic formula setup in the other cubes that use the location aliases described above to pull the value into the other cube. You should be able to use this functionality to refer to the values from different cubes of the same application

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s