Tuesday, December 11, 2018

Oracle Managed OAC BI and MDX

Earlier this year I posted  OAC - BI with MDX.  This was for Customer Managed OAC.  

So what are your options if you have Oracle Managed (a.k.a. Autonomous)?  We know that you do not have access to the server.

if you go to the following URL for your Oracle Managed OAC 

https://oac_instance.analytics.ocp.oraclecloud.com/bipodadmin/ 


Double click on the 0 after the entry obis.EVALUATE_SUPPORT_LEVEL and change to a 2.


Just like you would have done in the NQSConfig.INI


Since this is Oracle Managed you will need to submit an SR for Oracle to restart your server for this change to take effect.



Thursday, October 25, 2018

How Can I Help?

I recently ran for the ODTUG Board of Directors.  There were 4 open positions and 9 candidates on the ballot.

This morning I received the call that I did not make the cut.  While this was disappointing to hear, I told Mike Riley, the ODTUG Secretary, that I will continue to look for other opportunities to volunteer and add value to the organization.

This evening while I have been catching up on a TV series that I have found interest in I heard the main character ask “How can I help?”

For those of you who watch network TV you will recognize this quote from the main character Max in “New Amsterdam”.

So, for my readers who belong to a professional organization or for that matter any organization; ask yourself…”How Can I Help?”

Most professional organizations run on volunteers.  If they are anything like the ones I belong to, IOUG and ODTUG, they are always asking for people to help.

So ask yourself…”How Can I Help?”

Do you have a couple hours a month to volunteer to be on a committee?   

Do you have an experience on recent project or implementation that you could share?  Write an article for the newsletter or conduct an educational webcast.  

 Better yet submit an abstract to speak at a conference...believe me once you have done it, public speaking is not that scary.

So, for all you professionals out there who want to grow in your profession ask yourself…”How Can I Help?”

Please consider volunteering within the professional organization you are a member of.

Tuesday, March 27, 2018

OAC - BI with MDX

At KScope15 I attended a session presented by Mike Nader titled "Finding a Needle in a Haystack - Aggregate to Transaction-Level Financial Reporting Using Essbase and OBIEE"

In this session he talked about using a Driver query as a source for a filter.  The driver query made use of a MDX function and the EVALUATE clause within the Criteria section of an Analysis.  The slide from his session that this post is based on is shown here.

 
This presentation and concept has lingered in the dark recesses of my brain and recently when trying to create a filter for a range of members in my Time Dimension it bubbled back up.

So a bit of set up is needed.  First I have an OAC BI sourcing data from OAC Essbase.  My cube has a unified Time Dimension...That means my Year and Period are one dimension instead of 2 separate so it looks like this:


While for many Essbase developers this is not a typical design; it is how OBIEE likes to look at Time and makes for Time Series reporting a lot easier.


If this was a relational database I could easily get the a list of past 6 quarters via SQL.  But how can i get a range of months from an Essbase Cube?



EVALUATE('{[FY17_Q3].lag(5):[FY17_Q3]}/*%1*/',"Time"."Gen3,Time")




Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)
SQL Issued: SELECT EVALUATE('{[FY17_Q3].lag(5):[FY17_Q3]}/*%1*/',"Time"."Gen3,Time") FROM "ESSB_MapTest"
OK (Ignore Error)






Make a back up of the NQSConfig.INI and download a copy

Edit the entry EVALUATE_SUPPORT_LEVEL. 


Set the value equal to 2 so that all users can use the results of the function call.  Upload the revised NQSConfig.INI and restart the BI Services via the scripts provided in your OAC instance.


So now when I re-run the query I get my current Quarter and past 5.


This will be useful when combined with a Substitution Variable for Current Quarter.