Pages

Thursday, September 29, 2016

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 

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>
       

Wednesday, September 21, 2016

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. 

Friday, September 16, 2016

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

Friday, September 9, 2016

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: