Since the release of 11.1.2.5.520 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 11.1.2.5.600 can be found here
Fixes in this release:
Continue reading “Oracle Smart View for Office 11.1.2.5.600 Released”
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 11.1.1.9 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”
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.
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 11.1.2.5.200 after the BI Answers table is modified and a new column is inserted between two existing columns.
Continue reading “Oracle Smart View for Office 11.1.2.5.500 Patch 21635725 Out Now!”
One of my readers, Saptarshi, asked an excellent question. Original post here: https://mondaybi.com/2014/08/07/an-essbase-obiee-integration-walk-through-with-tips-and-tricks/
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”
Taking Your OBIEE to the Next Level with SmartView VBA is meant to be for end users. Yes, it may sound techy, but with the help of macro recorders and Google it’s actually not that difficult after all. Thank you Oracle and OTN for publishing my article!!! And a special thank you to Bob Rhubart for making this happen!!!
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 the presentation by Guillaume Slee
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.
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:
Get the latest version here Oracle Software e-Delivery
And the newest EPM 11.1.2.4 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.
Starting with Essbase 11.1.2.4, these features are no longer supported:
mondaybi.com 