If You Love Somebody Set Them Free

SAP, if you love your BI platform users, it’s time to set them free.

BusinessObjects Rainbow Logo

In 1985, Sting stunned the world with Dream of the Blue Turtles, his first solo album after breaking up with The Police. The “hybrid” recording wasn’t jazzy enough for jazz purists nor rocky enough for fans of The Police. But his ambitious effort to combine rock-and-roll with jazz musicians Omar Hakim, Darryl Jones, Kenny Kirkland, Branford Marsalis, Dolette McDonald, and Janice Pendarvis yielded several hit singles and insured that Sting would be a relevant artist for the next several decades.

“If You Love Somebody Set Them Free” was the first single released from Dream of the Blue Turtles.

It’s clear from current product roadmaps that SAP’s hybrid approach to analytics is to place all future analytics innovation into SAP Analytics Cloud while keeping the on-premise BI platform, its universe semantic layer, and its Crystal Reports and Web Intelligence document formats at arms length with reduced levels of future investment. SAP’s analytics strategy makes sense if you run most or all of your business with SAP applications, whether it’s the on-premise business suite or cloud applications like Ariba, Concur, Fieldglass, and SuccessFactors. The strategy makes less sense the more non-SAP applications power your organization. And as anticipated, the strategy makes the least sense to customers whose only SAP product is the on-premise SAP BusinessObjects BI platform.

But instead of winners and losers, what if SAP’s analytics strategy was changed so everyone became a winner? Let’s explore some ideas.

Universes Everywhere

In the age of Qlik and Tableau, a third-party market has sprung up to provide universe-based data to non-SAP tools. In a curious arrangement, these vendors have LLC’ed themselves to be annoying to SAP product managers without being financially lucrative enough to attract the interest of SAP’s legal department.

No offense to their creators who are fulfilling a market need. But these products should not need to exist. SAP itself should provide the best universe support to both its own analytics tools and beyond – let’s call it “Universes Everywhere”.

Back in 2014, a BusinessObjects Universe connector mysteriously showed up in Microsoft Power BI (see Microsoft’s related article, Power BI Connectivity to SAP BusinessObjects BI Now Generally Available). As mysteriously as it arrived, it then disappeared.

Update May 2016: SAP BO connectivity is no longer available.

With SAP Analytics Cloud restricting the universe to be on-premise, what does SAP have to lose by licensing universe support to Microsoft, Tableau, Qlik, or whoever wants it? Customers would be delighted, probably save for the extra cost of some kind of new BI platform license that legalizes such third-party tool support. Microstrategy adopted a similar approach this year, insuring that its customers are delighted enough to keep licensing Microstrategy’s core technology platform while using their data visualization tool of choice. (see related ZDNet article, Enterprise, self-service BI hook up: MicroStrategy releases connectors for Power BI, Tableau, Qlik).

Web Intelligence Explorer

As part of a renewed commitment to the universe semantic layer and innovation specifically targeted to the on-premise BI platform, SAP should commit developers to an updated version of the BI platform (4.3? 5.0?) with a new version of SAP BusinessObjects Explorer – one that does not rely on Adobe Flash- as its centerpiece. Keep in mind that Explorer without a Flash UI already exists – as SAP BusinessObjects Mobile for iOS. The Explorer web client should be written as tightly coupled to Fiori-fied Web Intelligence as architecturally possible and its Flash-based back-end should be ported to the Fiori-fied BI Admin Console that made its debut with SAP BusinessObjects BI 4.2 SP5 (see related article, The Road Unexplored: A Future for SAP BusinessObjects Explorer). SAP customers shouldn’t have to look to other vendors to find the next generation of search-based data discovery (see related article, The Road Unexplored: Alternatives to SAP BusinessObjects Explorer).

If SAP Won’t Invest It Should Divest

It’s perfectly understandable that SAP Analytics Cloud is tightly coupled to SAP’s business applications. What’s less clear is why perfectly good software used by thousands of customers has to die on the vine rather than succeed on its own terms. Even webOS– originally developed by Palm to compete with Apple’s iOS- was given a second life powering LG televisions and appliances. It’s even been open sourced (see related Verge article, webOS ready to move beyond TVs, says LG). If universe technology is no longer a strategic fit to SAP, it should be liberated as open source or put up for sale on the open market. SAP acquired BusinessObjects for approximately €5 billion in 2008 (see SAP’s press release, SAP to Acquire Business Objects in Friendly Takeover). I’m confident SAP could get a good return on its decade-old investment and create favorable terms to OEM the software from its new owner until its current hybrid BI strategy is fully realized in the cloud.

SAP, if you love your classic BusinessObjects customers, set them free!

Should SAP continue to invest in the universe semantic layer? Should it put the technology up for sale? Or open source it? I would love to hear your thoughts on how ALL of SAP’s current analytics customers can have a happy ending.

New BI Launch Pad Customization in SAP BI 4.2 SP5

A new and much welcome enhancement for the BI Launch Pad logon screen.

Although SAP is spending most of its analytics budget developing SAP Analytics Cloud, innovation is still happening on the BI Platform. In SAP BusinessObjects BI 4.2 SP5 (released in December 2017), SAP has introduced a new property for controlling the behavior of the Authentication drop-down box on the logon screen.

The behavior of the logon screen can be customized by copying the default BILaunchpad.properties file from C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\config\default to the adjacent directory C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\config\custom (see my original article about BI customization, Customizing SAP BusinessObjects BI 4.1 and BI 4.2).

A new property- logon.authentication.visibleList– now joins authentication.default and authentication.visible that controls which authentication types appear in the authentication drop-down list. By default authentication.visible is set to false, but most organizations have to set it to true so the Administrator can choose Enterprise authentication and everyone else can choose something like Windows AD, LDAP or SAP authentication.

logon.authentication.visibleList property for BI Launch Pad customization

Here is how the default list logon.authentication.visibleList=secLDAP,secWinAD,secSAPR3,secOraApps,secPSE1,secpsenterprise,secSiebel7,secEnterprise appears.

SAP BusinessObjects 4.2 SP5 BI Launch Pad customization

The new logon.authentication.visibleList parameter not only controls which authentication types are displayed, but also the order(!) that they are displayed in. As an example, I’ll move secEnterprise from the beginning to the end of the list.

SAP BusinessObjects 4.2 SP5 BI Launch Pad customization

And here’s what it looks like when I shorten the list to only the desired authentication types.

SAP BusinessObjects 4.2 SP5 BI Launch Pad customization

IMPORTANT: Remember that you must copy the contents of C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\config\custom to C:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config\custom before applying any patches, as the latter is the location the patch installer will redeploy web applications from. I also recommend keeping copies of any customized files on a project intranet or some other location that isn’t a SAP BusinessObjects server.

This small enhancement to the BI platform is a big deal that enables BI teams to simplify the interface, reducing both human error and help desk calls. I’m eagerly looking forward to additional BI platform enhancements that we’ll see later this year in BI 4.2 SP6 (July 2018 timeframe) and BI 4.2 SP7 (December 2018 timeframe).

State of the SAP BusinessObjects BI4 Upgrade – February 2018

SAP BusinessObjects 4.1, SAP Lumira 1.x and SAP Design Studio 1.x maintenance all come to an end in 2018. Here’s how to plan for the future.

It’s been a while since I’ve written one of these “State of the SAP BusinessObjects BI4 Upgrade” articles. In fact, I didn’t write one at all during 2017. But there are some key events happening in 2018 that are going to affect BI strategy for many SAP customers.

Read the State of the SAP BusinessObjects BI4 Upgrade – February 2018 on the SAP Community site.

I wrote the article one week before Michael Flannagan posted his Deeper Look into SAP’s BI and Analytics Strategy, but the points are still valid for SAP customers using the SAP BusinessObjects Business Intelligence suite.

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!