Thoughts, ideas and solutions from a few EPM consultants.

Kscope 17 Recap - Day 2

I started the day by following Cameron into the Essbase Development session, I was running a bit late, and had a few takeaways.

  • Essbase Studio is not supported on 12c
  • Java and REST API will continue to be supported
  • EAS will not be available in 12c
  • IDCS will be the standard for identity management (federated logins).
  • They haven't defined a roadmap for the REST API but they are pushing it in house (dogfooding)
  • They want to have one API interface (REST > Java)
    • Outline supported
    • Grid View
  • Still don't have full API docs
  • In 12c we are part of BI as opposed to EPM
  • We still can't get an answer on when we can upgrade the java version for security.
  • Views are not the answer to performance improvements in ASO according to Essbase development. Even though they are one of few things that really work at the moment.
  • They have gotten good at Excel parsing but are looking into doing CSV, database, etc. (Missed part of this but I think this was in regards to building cubes off templates.)

For the vendor presentation, I went to Orchestra's which was a good use case. I would like to see more from the tool as a whole but they did a good job of not making the presentation to salesy. A lot of the differentiators between EBX5 and DRM seem to have disappeared with recent versions of DRM; the licensing of it could be way more attractive to customers with huge node sets.

Jake's Groovy REST API

Next, I hopped into Jake's talk on the REST API. This was a great intro to REST which if you missed it or haven't seen before head over to his blog and check out the presentation. Jake has included everything from the demo. Anyway, we queried Twitter and loaded the data into PBCS and found out that the #OrclAPEX people tweet more than the others that are here at Kscope. Us EPM guys need to up our game.

PBJ Client

Sticking with the REST API I visited Jason Jones's session that covered his open source PBJ library that is used for interaction with the PBCS REST API. Now anyone who knows me knows how much I enjoy Java (hopefully I can find the time to port it to Python or .NET). It's really cool to see others that see the value in providing a cleaner method to access these API's than stringing together a set of EPM Automate commands in batch.

Kafka

Lastly, I headed over to see another Kafka session by Bjoern Rost. Now, this was mostly around using Kafka with an Oracle database but I can really see the value of a persistent message bus and look forward to getting an environment of my own setup.