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!”
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!!!
OBIEE SmartView Part 1 – Creating your first OBIEE SV Report
OBIEE SmartView Part 2 – Connecting to Essbase
OBIEE SmartView Part 3 – Your own secure mini reporting book
It is required to have the skills from Part 1, Part 2 and Part 3 before you can fully understand what I am doing here. Moreover, you will need some basic skills of VBA. I’m not a VBA or Excel expert, but coding and programming is more or less the same everywhere. There are loads of resources on learning VBA if you google it. So I won’t google it for your and I’m not going through VBA bits and pieces.
So what is this Part 4 all about? Let say you would like to export an Answer report to workbook with multiple sheets based on members 2 different selections. Answer won’t be able to do that and SmartView alone won’t be able to do that. In this post, I will use this as an example as to what you can do with SmartView OBIEE VBA. In short, I’ll call this example, MultiSheet Excel Export.
Continue reading “OBIEE SmartView Part 4 – Beyond Answers with VBA”
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”
Before we continue, you need to know how to use SmartView connecting to OBIEE, which was part 1 and can be found here: http://goo.gl/mE23az.
So why would you use OBIEE SmartView instead of SmartView Provider Services when connecting to Essbase? For 3 simple reasons:
I’m sure you will think of other reasons, but let’s just start with those common ones for now. You might also want to read OBIEE Integration with Essbase before you continue reading: http://goo.gl/idX4Ml.
Continue reading “OBIEE SmartView Part 2 – Connecting to Essbase?”
mondaybi.com 