Ten Features That Absolutely Must Be in BI 4.2 SP3

It’s been four years since I published my wish list for BI 4.0 Feature Pack 3. I revisit the list and see what, if anything, has made it into the SAP BI suite.

Four years ago, I wrote an article entitled Ten Features That Absolutely Must Be in BI 4.0 Feature Pack 3. With SAP BusinessObjects BI 4.2 SP3 soon going into general availability, I thought it might be interesting to review the current status of my original wish list.

1. Tree control for Web Intelligence universe selection

No improvements here and none expected for the forthcoming SAP BusinessObjects BI 4.2 Support Pack 3. But perhaps SAP will surprise us with a redesigned universe selector panel in the fully-functional Java-free Web Intelligence coming next year in Support Pack 4?

2. Improved visual distinction between UNV and UNX universes in Web Intelligence

I don’t think there’s been much change here. Still an opportunity for some subtle UI improvements.

3. OLAP universe support for Explorer

Lack of OLAP support for this aging product is by design according to SAP KB 1559221My friend who requested it got tired of waiting and is now a Tableau developer. True story.

4. UNX universe support for Live Office

Fixed. UNX support was finally added to starting with SAP BusinessObjects BI 4.1 SP6. Live Office isn’t for everyone, but Excel geeks seem to really like it. And Live Office is going to live on in the simplified BI portfolio as its functionality is converged into a future version of Analysis for Microsoft Office.

5. Improved qualification selection in Information Design Tool

Fixed. There have been many usability improvements in the Information Design Tool and this is one of them. If you last took a look at Information Design Tool way back when version 4.0 was released, it’s time to take a second look at the new 4.2 release.

6. Corporate customization of Central Management Console

This request is still unfulfilled but perhaps we’ll see something when the CMC gets the Fiori treatment next year? I’m not looking for robust customization like the BI Launch Pad has. I just want a simple way to change some text strings and colors (using preset themes) to easily distinguish multiple landscapes in the BI lifecycle (Development, Test, Production).

7. No more monolithic Adaptive Processing Server

Fixed. SAP BusinessObjects BI 4.1 introduced the System Configuration Wizard for APS configuration and some other post-installation tasks, which you can read about here.

My big gripe here continues to be that Design Studio and Lumira both add services to the Adaptive Processing Server. Because these two products are “add-ons”, the System Configuration Wizard doesn’t accommodate them very well. I hope the situation will improve next year when Lumira and Design Studio 2.0 standardize on a single server-size engine.

8. Improved control of Web Intelligence default paper size

Still an open item. Since non-A4 paper size mostly an accommodation for American users, no doubt this improvement is far down on the enhancement backlog, if it’s there at all. Perhaps paper size is less relevant in a greener 21st century?

9. Improved browser support

Fixed. SAP has made major strides in browser support. The biggest obstacle to browser support is how various browsers handle (or refuse to handle) plugins like Adobe Flash and Oracle Java. Fortunately, SAP is working really hard to deliver a plugin-free version of the platform, starting with enhancements to the Web Intelligence HTML panel in the forthcoming BI 4.2 SP3.

10. Improved and better organized sample content

Still as bad as before, except that SAP has added some really nice sample content for mobile devices (see related article, Sampling the Mobile BI Samples with BI 4.1).

Conclusion

SAP BusinessObjects Business Intelligence BI 4.2 Support Pack 3 is almost ready for general availability and contains some really exciting improvements, including four of the items on this wish list. But I hope there’s still time to include the remaining six improvements in BI 4.2 SP4.

What’s on your SAP BusinessObjects BI 4.2 SP3 wish list?

Installing Two Oracle 12c Clients on One Server

The Oracle 12c 32-bit client requires a little bit of extra attention.

I’ve previously written about best practices for installing the 64-bit and 32-bit Oracle clients on a single Microsoft Windows server that needs to support SAP BusinessObjects BI 4 (see related article, Installing Two Oracle Clients on One Server). Those best practices still apply, but I encountered a small wrinkle with Oracle 12c and apparently I’m not the only one.

The installation of the 64-bit client goes smoothly. It’s only when you attempt to install the 32-bit client that you may encounter the following error, “[INS-10102] Installer initialization failed.”

Oracle 12 32 bit trick 01 500The issue seems to occur when a previous installation of the Oracle 32-bit client (for example, the older 11g client) was previously installed. The registry key named HKEY_LOCAL_MACHINESOFTWAREORACLE has a value named inst_loc behind, which interferes with the Oracle 12c 32-bit installation.

Oracle 12 32 bit trick 02 500

Simply remove the offending inst_loc value from the registry.

Oracle 12 32 bit trick 03 500

Then you’ll be able to install the 32-bit client successfully.

Oracle 12 32 bit trick 04 500

Additional fun with Oracle 12c SQL Loader

The 64-bit Oracle 12c client tools also have a small issue with the SQL Loader utility (sqlldr.exe). SQL Loader is not required by SAP BusinessObjects Business Intelligence 4, but I thought I’d document the issue here anyway – “The program can’t start because oranfsodm12.dll is missing from your computer. Try reinstalling the program to fix this problem.”

Oracle 12c SQL Loader Issue

Reinstalling the client tools won’t help because the issue is an Oracle defect, which is described on the Oracle Technology Network. To resolve, make a copy of the oraodm12.dll in the bin directory and rename it to oranfsodm12.dll.

What is your experience with SAP BusinessObjects BI4 and Oracle 12c? Share you thoughts in the comments below.

Waiting on SAP BusinessObjects BI 4.2

Are you waiting, too?

SAP BusinessObjects Business Intelligence 4.2, the eagerly awaited update to the BI4 platform, quietly went into beta last week. Gregory Botticchio and Pascal Gaulin from the Web Intelligence product group in Paris, France (see related article, SAP Paris) were on hand to present “What’s New in SAP BusinessObjects Web Intelligence” (Session 2806). But otherwise, there was barely a word of BI 4.2 news breathed during the recent ASUG SAP BusinessObjects and Analytics User Conference in Austin, Texas.

Web Intelligence 4.2 Innovation Roadmap

Four years ago, I wrote a blog entitled Waiting on SAP BusinessObjects BI4 expressing both excitement and frustration at waiting for the general availability of SAP BusinessObjects Business Intelligence 4.0. Now I find myself eagerly Waiting on SAP BusinessObjects Business Intelligence 4.2 and have shared this sentiment on the SAP Community Network. Check it out!

Read Waiting on SAP BusinessObjects Business Intelligence 4.2 on the SAP Community Network.

 

SAP BusinessObjects Support for Windows 10

Microsoft Windows 10 arrives this week, with SAP BI support not too far behind.

Wednesday, July 29, 2015 is going to be a big day for Microsoft as it formally releases its latest update to its flagship Windows operating system, Windows 10. Since Windows 7 was released nearly 7 years ago on October 22, 2009, most Enterprises have viewed Windows 8 (released October 26, 2012) or Windows 8.1 (released October 17, 2013) more like Vista 2.0 rather than a worthy successor to Windows 7.

Time will tell if Windows 10 features will prompt enterprises to give up on Windows 7 or hang on until its extended support ends on January 14, 2020. Of great interest to SAP customers will be the new Microsoft Edge browser and how it supports plug-ins like Adobe Flash and Oracle Java.

Jayne Landry, SAP General Vice President and General Manager for Business Intelligence, indicates via Twitter that Windows 10 support will be added first to SAP BusinessObjects BI 4.1 SP7 then folded into BI 4.2 later.

Microsoft Windows 10 Support

last updated March 1, 2017

SAP BusinessObjects Enterprise XI 3.1 is unsupported on Microsoft Windows 10. Although Priority One Support for SAP BusinessObjects Enterprise XI 3.1 has been extended to 12/31/2018, it has been out of Mainstream Maintenance support (no more patches) since 12/15/2015.

SAP BusinessObjects BI 4.0 is unsupported on Microsoft Windows 10.

SAP BusinessObjects BI 4.1 SP7 and higher support Microsoft Windows 10.

SAP BusinessObjects BI 4.2 has Windows 10 support from its initial GA to the current release.

What are your organization’s plans for Microsoft Windows 10?

Will Security Concerns Override Your BI Strategy?

The future of Flash may no longer be in the hands of Adobe but instead in the hands of IT security.

It hasn’t been a great month for Adobe Flash. Both Google and Mozilla took extraordinary steps to temporarily disable Adobe Flash from their respective browsers, bringing disruption to SAP Dashboards (see related BusinessObjects Board article).

Dashboards Not Working in Firefox

Adobe released a patch and all was well again, but isn’t it really just a matter of time before we’ll be going through the same exercise? There’s a growing chorus in the mainstream press, not just the technical press, to walk away from Adobe Flash.

While the Occupy Flash movement (yes, there is a movement) advocates letting “your IT department know you can do without Flash”, there are some obvious places (like Explorer and Dashboards/Xcelsius) where the Adobe Flash Player is required by SAP BusinessObjects.

Unfortunately, there are also several less-than-obvious places (see related article, Adobe Flash- Dying but not Dead Just Yet). However, much of everyday web browsing no longer requires the Adobe Flash Player. I was motivated by the recent controversy to remove Adobe Flash from my two Macs, just to see what would happen. I’ll limit Adobe Flash to my Microsoft Windows VM that I use at work.

SAP customers have endured similar scenarios with the Java Runtime Engine and Web Intelligence. But unlike Java, which still manages to have multiple dependencies in today’s enterprise, there are fewer reasons to rely on Adobe Flash and IT security may act more quickly to eliminate it completely from corporate desktops. Mainstream web sites like YouTube no longer require Adobe Flash (and let’s be honest, many organizations prevent you from watching grumpy cat videos at the office anyway).

SAP’s strategy for Dashboards and Explorer has been to leave them as-is as new plug-in free tools like Design Studio and Lumira increase in both maturity and adoption. That strategy assumes that Adobe will continue to support Flash indefinitely, allowing SAP customers to continue to use Dashboards and Explorer content even though the tools no longer receive investment. However, the future of Flash may no longer be in the hands of Adobe but instead in the hands of IT security, keen to remove Flash from the enterprise. This change of direction will to put more pressure on business intelligence competency centers to retire SAP Dashboards and Explorer more quickly than anticipated, and earlier than the current SAP BI roadmap will comfortably allow.

How are Adobe Flash vulnerabilities affecting your BI strategy? Is your organization under pressure to retire Adobe Flash? Please share a comment below.

SAP BusinessObjects 4.1 Running on Windows 10 Technical Preview

SAP isn’t ready for Microsoft Windows 10 but its customers already are.

On Tuesday, Microsoft provided the media with a first look at the next version of its Windows operating system, Windows 10. Windows 10 is currently available as a technical preview for those courageous enough to play with unfinished software. Steph Cowan from IT Performs in Midlands, UK was able to quickly get SAP BusinessObjects Business Intelligence 4.1 SP4 running on the technical preview.

Of course, you won’t find Microsoft Windows 10 on the Supported Platforms/Platform Availability Matrix (PAM) just yet. And no doubt there are issues with any software running on such an early preview OS.

Microsoft has had a painful journey with its current version of Windows, version 8.1. And so have I (see related articles, First Impressions of Microsoft Windows 8 and SAP BusinessObjects Support for Windows 8.1). But addressing the concerns of enterprise IT, which hasn’t deviated from rolling out Windows 7, has clearly been the number one priority for Microsoft. That, and the Microsoft Hair Guy seems to be giving the Apple Scarf Guy a run for his money.

 

While neither have specific delivery dates other than “sometime in 2015”, I’m confident we’ll see SAP BusinessObjects Business Intelligence 4.2 running on Microsoft Windows 10 next year.

What are your first impressions of Microsoft Windows 10?

Don’t Fluster the Cluster, part 2

Don’t let your BI platform become a cluster chuck!

I spied this fantastic new collection of Woodchuck Cider on an end cap at my local grocery store and just had to snap a photo. It’s a variety pack cleverly named the Cluster ‘Chuck Variety Pack.

Woodchuck Cider Cluster Chuck at Kroger

The Woodchuck Cluster ‘Chuck Variety Pack is our new cider sampler. Following suit with the rest of our ciders, the pack has a brand new look to go with our brand new Cidery. Our top notch in-house creative team set out to create a design that fit the spirit of our ciders, our local orchard partners, and our home state of Vermont.

From the Woodchuck Cider blog

I had so much fun talking about SAP BusinessObjects CMS clustering and Ben and Jerry’s Clusterfluff ice cream (see related article, Don’t Fluster the Cluster). A bit of humor can really help bring a dry technical topic to life. The 2014 conference season is now over for me, but I thought somebody out there would see this and be inspired to use it in their own slide decks about CMS clustering. We wouldn’t want any SAP BusinessObjects installations to turn into a cluster chuck, would we?

Raising my glass to SAP BusinessObjects administrators everywhere. Skol!