I have been speaking at a lot of conferences and client events over the last year touting the great new features of the new version of Smart View. As a matter of fact, I’m repeating the session on Feb 16th and 18th in interRel Webinars. (contact email@example.com for more info) The questions I often get are “What do I need to upgrade to get functionality” and “If I just upgrade Smart View what functionality do I still get?”
Before I answer thos questions I’ll first answer “What version of Smart View should you upgrade to?” Since Smart View is pretty backward compatible I would upgrade to the latest version 126.96.36.199.310. This is a patch that was released last Monday and includes connectivity to OBIEE or as many Oracle people now call it BIFS (Business Intelligence Foundation Suite). Note, you must be on OBIEE 188.8.131.52 for the connectivity to work. There are a number of other enhancements and bug fixes to this version.
Next, what you you have to upgrade to get full connectivity? Well, for Smart View itself, you should be on 184.108.40.206.102 (or higher) as well as APS and Essbase 220.127.116.11.102 or higher. If you are going the patch route or 18.104.22.168 then I would recommend you get the Smart View patch 22.214.171.124.103 and APS and Essbase patches 126.96.36.199.104. Of course , you are even better if you upgrade to 188.8.131.52.310.
Finally, If you just upgrade Smart View without upgrading APS or Essbase, the functionality you can expect to get (Thank you Smart View development team for this list) is:
- Ribbon specific to Provider
- Re-designed Options Dialog
- Smart View Panel
- Sheet level Options
- Retain Excel Formatting
- Improved Function Builder
- Fix Links (Removes path references in cells with Smart View functions) Before: “=D:\Oracle\Smartview\bin\hstbar.xla’HSGETVALUE(…..
- After: =HSGETVALUE(...
- Performance Improvements
So while you won’t get cool things like multiple grids on a sheet or member name and alias, you get a few perks. The sheet level options are one thing that was missing in prior versions of Smart View that I’m glad got put in.
If you upgrade to at least 184.108.40.206 you also get an awesome new Smart Query tool that enables you to create extremely complex queries that return sets of members/numbers which can be combined and saved. It is fantastic feature that is not getting the press it deserves. In a future post, I‘ll go through a detailed example so you can see its power.