Oracle Smart View for Office Released

Since the release of we can now user Smart View with Windows 10 and Office 2016. I always suggest to keep updating your Smart View as this is the Oracle’s Strategic Office Integration Tool.

The newest Smart View version can be found here

Fixes in this release:

Continue reading “Oracle Smart View for Office Released”


What’s New In This OBIEE Version? Cumulative Feature Overview Took Kit

So you might ask your Oracle Sales, what’s new in this Oracle BI EE version. Majority of the time, they will tell you a few features.

Here’s the site, Cumulative Feature Overview.

The objective of the tool is to help IT plan ahead to its upgrades and whether it is worth it. Obviously, I if you read my post on “OBIEE Features that makes you upgrade today!”, you will find it absolutely worthwhile to upgrade!

Here’s how to use it:

Continue reading “What’s New In This OBIEE Version? Cumulative Feature Overview Took Kit”

Oracle Smart View for Office Patch 21635725 Out Now!

I don’t usually send out information on Smart View patches but in OBIEE, there is one particularly resolved issue that needs to be highlighted and worthwhile to make your upgrade today. It is highlighted in blue below.

Download here

Oracle BI EE

19475349 — In reports created in the Smart View View Designer, if the associated data contained the hexadecimal value of 0x13, an invalid character error occurred, resulting in this message: “’!!’, hexadecimal value 0x13, is an invalid character.”

20295285 — Oracle BI EE content is not viewable in Smart View when called from an Oracle BI EE catalog shortcut link.

20698288, 20803386 — When retrieving data from a table in Oracle BI EE, the first column gets merged every 500th record.

20833815 — When more than three tables from Oracle BI EE are inserted into a worksheet, the cell positions of some tables are not maintained.

20912635 — Column order is not maintained in Smart View after the BI Answers table is modified and a new column is inserted between two existing columns.

Continue reading “Oracle Smart View for Office Patch 21635725 Out Now!”

Demystifying OBIEE Essbase Date Measure – The Solution

About the mystery

One of my readers, Saptarshi, asked an excellent question. Original post here:

He asked:

I am integrating Essbase and OBIEE. I have few measures (accounts) as date in Essbase, such as Receipt Date etc.

Now when I fetch this in OBIEE, they appear as numbers.

How to get date measures from Essbase to OBIEE exactly the way they are sitting in Essbase?

And he’s right! They do appear as numbers. So I Googled and see how frequent this question is asked and if there were already answers I can refer him to. This is what I got!



Opps, just questions, no answers! Questions like this comes in every few years. Saptarshi actually also posted in Oracle Community too, 16 hours ago! Good job Google! As promised last night, I’m going to demystify and give you a solution to this! In return, just like my Facebook page which was just launched yesterday! Click here!

Continue reading “Demystifying OBIEE Essbase Date Measure – The Solution”

Top Gun 2015 – Thanks Guillaume Slee – Essbase as a Source and Bursting in OBIEE?

About Top Gun 2015

Top Gun is one of the most technical conferences in UK that focuses strictly on Hyperion EPM. This year, thanks to Guillaume Slee, EPM Services Director of Brovanture, kindly used some of the materials from my blog. I feel extremely glad to be referenced in his presentations. I would also like to congratulate him for being voted The Most Popular Presentation out of the entire conference! And again, thank you for referencing my materials!

Check out Top Gun 2015

Check out the presentation by Guillaume Slee

Essbase as a Source & Bursting in OBIEE?

Probably this was one of the questions asked in the conference? Interesting question, but with current Publisher, this could not be achieved for sure and I wouldn’t even try. Clearly because it is stated in the documents that SQL is the only available language for bursting in Publisher.

Any workarounds?

Well depending on your objective isn’t it? There’s bursting in Financial Reporting. If the bursting is about exporting in CSV or Excel or emailing reports in HTML format, I would recommend using Agents (traditionally known as iBots). I would not give a step by step guide here, but will do so later on probably in May as I have extremely limited time lately to write a in depth tutorial. An overview guideline to how this could be achieved is as follows:

  1. Create native users from MaxL with the same bursting security. Say for example you wanted to burst the Customer dimension, then create the same number of users as Customers with the security setup as the customer itself.
  2. Create an Analysis report. Please don’t use Customer as a filter. You would want the customer to be displayed in the report.
  3. Create an Agent
  4. Remember to run as recipient.
  5. Add all the users you created with MaxL. Of course, they will also need id for OBIEE.
  6. Run this report and if everything is setup correctly, they will individually get a report and security of the report is handled through Essbase instead. This would be quite similar to bursting in Publisher but of course with a lot more setup effort. Personally, I would use HFR for such bursting needs unless absolute necessary.

EPM Released! Essbase

EPM Released!

Get the latest version here Oracle Software e-Delivery

And the newest EPM documentation!

I do really wonder how Hybrid is doing. Is Hybrid official now? I went through documents, but it seems that it’s still not officially documented.

Essbase Features No Longer Supported

Starting with Essbase, these features are no longer supported:

  1. Oracle Essbase Integration Services, including Hybrid Analysis and Advanced Relational Access
  2. Many of the basic concepts of Hybrid Analysis and Advanced Relational Access have been folded into the functionality of XOLAP cubes in Oracle Essbase Studio.
    Visual Basic API
  3. Oracle strongly recommends using the Essbase JAVA APIs. You can also use the Essbase C APIs.
    Configuration settings:


Continue reading “EPM Released! Essbase”

OBIEE SmartView Part 3 – Your own secure mini reporting book

Your own secure mini reporting Excel workbook or NOT?

OBIEE SmartView Part 1 – Creating your first OBIEE SV Report

OBIEE SmartView Part 2 – Connecting to Essbase

It is required to have the skills from Part 1 and Part 2 before you can fully understand what I am doing here. I will not provide screen shots for every step.

What you will achieve after reading this is a way to create your own mini reporting book or even a dashboard with full security and data refresh when needed.

First, you are required to create a new workbook and from Part 2, create Excel Table in sheet 1 (ExcelTable sheet in Part 2) and for the chart, click on cell H1, then click View Designer then follow steps in Part 2 to create the Line Chart. Your result should look like this:



Continue reading “OBIEE SmartView Part 3 – Your own secure mini reporting book”

%d bloggers like this: