Why I created a blog

Its been many years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.


Monday, September 17, 2018

Connectiong to Autonomous OAC through MaxL

Just a quick note, since I had to ask to get it to work. You have the capability to download a secure version of MaxL from the OAC Essbase instances. What this means is you can run the MaxL you have on-premises just by changing the server to the cloud URL.  If you are migrating from  on-prem, this can save you a lot of time as you won;t have to write REST calls or EssCLI.

When you connect to a PaaS OAC instance, you can just get the public IP address and use it, but ther is no public IP address for Autonomous OAC (OAAC). Insted, you have to use the server address like:
https://your instance.oraclecloud.com/essbase/, but that does not work.   I order to get it to work after essbase you have to add /agent.

Note, the same thing is true if you want to connect using EssCli.

Good luck. Hopefully your life became easier.

OAC-Essbase has Swagger

Oracle Analytics Cloud (OAC) Essbase has swagger. I don't mean the self-confident arrogant demeanor and walk. Rather I'm talking about something I've seen multiple people ask for.  I've seen requests for documentation on the REST API. For those of you who don't know REST for  it is Representational State Transfer and refers to a protocol for for a stateless casheable communications HTTP based way to execute commands on cloud applications. In OAC it is used for everything from outline updates, to loading data, to stopping and starting applications to just about everything in OAC.  

Rather than provide the historically meaningless written documentation that we have endured for years, the OAC development team decided to provide us with an interactive testable set of documentation called Swagger. In order to get to the documentation, like with other REST calls, you use HTTP connections in your browser.  To connect use:
https://your Essbaseinstancename/essbase/rest/doc/#  

You will most likely be asked to provide your login credentials. 

One loaded the interface will look like:



You then can click on any item and get details about it. For example is we want to find out about the OAC instance we can select About:



Even better, notice above you can try it out. When I executed it I got:



Give it a try and you will have swagger yoursef