Friday, March 24, 2017

Using Direct Page Links for Forms and Dashboards in PBCS!!!

Like we had the smartcuts in On-premise the same functionality is available in PBCS as direct page links. Let’s cover them in this blog

Straight from the documentation it says “Oracle Planning and Budgeting Cloud supports direct URL links that allow you to access Oracle Hyperion Planning forms and dashboards and to integrate with Oracle Sales Cloud. You can use direct page links to create a URL that points to a specific form or dashboard. If users have appropriate access permissions, they can use the URL to go directly to the form or dashboard to view or update it within Planning and Budgeting Cloud.”

To use this feature, first create a form or dashboard, and then assign access and manage users and roles. You can then set up the URL for a direct page link and communicate the URL to users.

Composite forms are not supported for direct page links.

Wednesday, March 22, 2017

Creating a large number of Period mapping using LCM–PBCS!!!

Well creating a large number of period mapping from 2013 to 2015 will take a while to create manually. Creating the same period mapping for multiple application is also a trouble if you create It manually.

Friday, March 17, 2017

Creating a large number of access to member’s in PBCS using Excel!!!

We all know what does the Access to members does and how to assign to a particular member in PBCS

The challenge here is how will do a mass/huge creation of access to members. Again a thanks to Johngoodwin who helped me here.

The process is as follows,

  1.  Create a couple of Assess to members to get start with manually
2.    Once we have a handful of them, create a LCM export using “Application Management”

Under Security it will display the users and the groups which were given access to the dimension members

Export the artefacts by selecting only the Security as at this point we are interested in only security. But the whole application can be selected and the changes can be imported back.

The exported files will look like following

 Update the Security information as needed,
Ø  Extract the zip file using 7zip

ØOpen the Users.xml for assigning the access to users and Groups for giving the access to the groups.The users.xml will display as below,
Under <name> add  the user you want to assign the access
Under <objectName> add the dimension member you want to assign the access
Under <flag> provide one value as needed
Under <accessMode> either provide READ or READWRITE as needed.
Once the file is edited and ready for both the users.xml and Groups, have them zipped using 7zip.

     Let’s see how to build the xml files using Excel

Open Excel and create a data source using the original xml file exported from LCM

Once you have the needed content in the excel re you get that saved as a XMl file using “XML Data” as the save option.

4.    Importing the edited artefacts back to PBCS.
Now the artefacts can be imported back (after adding all the needed access to the dimension members) to PBCS either manually or getting it automated
Uploading Manually and importing it back
Selecting the uploaded artefacts and importing it.          

That’s it you are done. As i write this blog Celvin have come up with awesome idea of creating the xml using the Groovy