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

Data Relationship Management Integration with FDMEE-Part 2

This blog is continuation to the Data Relationship Management Integration with FDMEE-Part 1

For the FDMEE integration with the DRM the patch 23012151 needs to be applied which do have a prerequisite patch 21240419

Apply the Pre-Requisite Oracle JDeveloper (ADF)   Patch 21240419:

Note! If you have installed Hyperion Financial Management release 11.1.2.4.200 or higher, then this patch is already a pre-requisite and it is not required.

• Download the patch and unzip to the location MW_HOME\oracle_common\OPatch
• Change the directory to: MW_HOME\oracle_common\OPatch
• Run the opatch as follows: 

 Patch applied successfully

Installing EPM 11.1.2.4 in Windows 2012

In this blog let me cover installing EPM 11.1.2.4 in Windows 2012 (i was preparing a VM box for POC, thought to cover the installation as a blog hope it will help someone)

Installing Enterprise Performance Management 11.1.2.4

Have downloaded the needed as shown below for the installation of EPM 11.1.2.4 (I will be installing Essbase, Planning, R&A (FR),FDMEE & DRM) for the Windows 64 bit box.

Extracted the 6 zip files to a common location and calling the installer. Make sure its run as administrator.

Select the language as needed, here it will be English.

The Pre-requisite check is done by the installer and reports any issue if there are any. 

What does Outline Load utility (OLU) offers?

As we all know that the Outline Load utility can be used to import metadata and data for standard & custom dimensions, attributes, UDAs, exchange rates, Smart Lists, and planning unit hierarchies from a flat file or a relational data source. 

You can also export metadata and data to a flat file or export metadata to a relational data source using the Outline Load utility

Here let me cover how to load metadata & data from a relational data source using the Outline Load utility

Loading the Metadata from relational data source to Hyperion Planning using OLU

1. Create a metedata.properties file

A sample .properties file is created as shown below which can connect to a external Relation data source along with the SQL to retrieve the needed metadata in the needed format with all the customized transformation you need, yes if you can't use ODI then this is awesome :-)

# /S:server where Planning is running

/S:Example-Planning-Server.com

# Application where you want to load the metadata

/A:Vision

# User used to load the metadata

/U:admin

# jdbc catalog - the Source Relational Schema

/RIC:HYPTEST

# jdbc url - the Connection URL to connect to the Relational Data-source  Schema

/RIR:jdbc:oracle:thin:@//database:1521/HYPTEST

# jdbc driver

/RID:oracle.jdbc.OracleDriver

# Relational Data-source Schema user 

/RIU:TDQPSPB

# rdbms password 

/RIP:vrX4PSFuHXyyBQGQ0o6yHFzY2T7KLyHgcp3WAqQuJJ/JlYRlIV

# ignore order of members

/-O

# sql queries for loading the Entities & Employee Dimension  

#Kscope16 blog hop: BI & Data Warehousing sessions not to miss

This blog is something special to me, it’s not just a technical blog but expressing my interest on the presentations that will be presented in ODTUG KSCOPE16

In addition to EPM (which is my core area of interest) I would like to pay close attention to the “BI & Data Warehousing” the reason being simple there is always close integration EPM with the BI & Data warehousing.

We all know that EPM always to have a closer relation with the BI & data warehousing (it could be pushing/pulling the data, reporting, data mining etc...)

The Topics I am most interested in attending (in the order they appear in the website)

Database connection url difference for DB 12c with Hyperion Planning

A quick one today.I was in the process of creating a Hyperion Planning application in 11.1.2.4 and came across this issue.

As a routine I have created the needed schema with the needed access and was creating a data source for the Hyperion Application.

As usual practice this was my connection url 

jdbc:oracle:thin:@DbServer:1521:pdborcl

But I was not able to connect to the database.

How to assign more than one owner for an Planning Unit

A interesting discussion came in Oracle OTN which says that having trouble in mapping Budgeting Requirement for approvals and data entry. Is there any way that we can have more than 1 user for any given planning unit?

For example there are 20 entity members and we each member represents a different location/geography. Each Entity member do have 1 user for data entry and 1 approval. The Power User from the Head Office that also have authority to change/update the budget data for all the 20 entities. 

So how can 2 or more users can play the role of Owner for a particular planning unit (Entity)? 

Well we all know that under users you cannot select more than 1 user for a Planning unit.

ODTUG EPM meetup in Pune

  

EPM Meetup - Pune

To all the Oracle Hyperion EPM folks based out of Pune, Planning for an EPM meetup in May 2016 (preferably on a Friday evening).Kindly share your views and comments.

Will share the date & venue. As this is first time happening for EPM community lets make it more of a informal session of gathering and getting to know each other.

I will stay tuned for the comments and suggestion.

Hoping this will be a great EPM meetup in Pune.