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.

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

MEMBER

@IDESCENDANTS

@DESCENDANTS

   @CHILDREN

   @ICHILDREN

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 

Oracle PBCS Feb 2017 (17.02) update!!

The Feb 2017 patch for the PBCS is bringing some eye catching updates http://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/pbcs/1702-pbcs-wn.htm

Oracle PBCS Access Logs-Patch applied!!!

This is continuation to the blog I wrote about Oracle PBCS Access Logs!! The changes that was described in the December 16 updates are applied on 6th Jan 2017 .

Loading data into PBCS ASO using Smart-view HsSetValue & HsGetValue!!!

Let me cover a simple one this time, how to load data to a ASO cube using smart view in PBCS using HsSetValue & HsGetValue

Just make sure the following statements are true before the load

The Level 0 members are selected for the data load for all the dimension’s part of the ASO cube

As we all know we can’t load the data to a dynamic calculated members and attribute members

As per the document

HsGetValue

Data sources: Oracle Hyperion Financial Management, Oracle Essbase Cloud, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud

HsGetValue retrieves data from the data source for selected members of a dimension. When HsGetValue retrieves no data, the value specified for the #NoData/Missing Label replacement option is used (see Table 1). When users select Refresh or Refresh All, only

HsGetValue is called. When users select Submit, HsSetValue is called first, HsGetValue is then called only if HsSetValue returns successfully.

Oracle PBCS Access Logs!!

ACCESS LOGS

The much awaited access logs is released in the latest patch update https://cloud.oracle.com/en_US/saasreadiness/epm?readinessRID=1385194682102 – Dec 2016

You can now download a daily access log, a Comma Separated Value (CSV) file, which provides detailed information on the resources that users accessed, duration of user activity, the IP addresses from which users connected to the service, and the action that users performed in the service. The access log is generated each day.

To download an Access Log:

Make sure you are login in to the Simplified Interface 

Click or tap Application, then Overview, and then Activity.

What does EPM Automate Utility offer - Part 1

In this post let me cover basic features & functionalities provided by the EPM Automate Utility.

The EPM Automate Utility installer for Windows and Linux/UNIX is available from the service.

Let me cover the installation for Windows 10 64-bit OS. 

Once downloaded install it by running it as administrator.

Is there a Essbase Web services - Part 4

After the Part1, Part2 & Part3 let me cover the DatasourceService & QueryService in this post.

Accessing the Datasource Service

As stated earlier the Datasource Servcie is invoked via the url 

http://APSBox:13080/essbase-webservices/DatasourceService. 

Note:Since i have added the web-service to the ohs, i can access the using the default webserver port (this is covered already in the earlier post)

  

Following are the various operations available for the Datasource Service 

Create:

Create()

Input: BaseObject

Output: BaseObject

Creating the application BlgPost with the properties 

                <storageType>MULTIDIMENSIONAL</storageType>

                <loadable>true</loadable>

                <autoLoad>false</autoLoad>

                <access>NONE</access>

                <connectable>true</connectable>

                <acceptCommands>true</acceptCommands>

                <acceptUpdates>true</acceptUpdates>

                <securtiyEnabled>true</securtiyEnabled>

                <lockTimeOut>60</lockTimeOut>

       

Is there a Essbase Web services - Part 3

After the continuation of the Part 1 & Part 2 in the post i will cover the Output of the Admin service program in this post.

As per the document the Administration web services can be used to start, monitor, or stop Essbase Server, applications, and cubes and to perform operations, such as executing MaxL scripts. You can perform the following operations:

• Start()

Input: URI (Essbase application or cube)

Output: Void

The Status of Database Plan 1 for the Vision application before performing the Start() operation via Web Services.  

Invoking the operation 

Output of the operation

Status of Database Plan 1 for the Vision application after performing the Start() operation via Web Services. 

Is there a Essbase Web services - Part 2

In the previous post Is there a Essbase Web services -Part 1, I did talk about invoking the Essbase Web services & during the task I did encountered issues and would like to post the solution along with the issues I have encountered.

Issue on a distributed instance:

Once the WSDL is enabled to true in the http:WeblogicAdminServer:7001/em and disabling the OWSM authentication by adding the flag “essbase.webservices.disable.owsm=true”

To the file essbsae.properties

I was getting this error message, while invoking the web services

Is there a Essbase Web services - Part 1

I read about these amazing blogs in December 2015 by John Goodwin Part 1 Part 2 Part 3 & Part 4 (yes i really doubt any one can write such a detailed information about this were there is very little information from the product document)

His blog really motivated me to start exploring about this hidden gem (you will agree with once you understand the potential this service is going to offer)

What is this Essbase Web Service:

From the Oracle doc, http://docs.oracle.com/cd/E57185_01/epm.1112/aps_admin.pdf