Posts Tagged ‘business objects’

Possible Business Objects XI R2 + R3 Scheduling Issue When Clocks Change (UPDATED)

I just received the following alert from the UK Business Objects User Group (very good, you should join) and have scraped the following text from the SAP support site…

SAP Business Objects Enterprise Daylight Savings Brief

Applies To: All Business Objects Enterprise XI r2 FP6.3 and earlier, and XI 3.1 SP3+ (FP3.1, 3.2, 3.3, 3.4, 3.5 ) Environments.

Brief: Due to Daylight Savings Time changes that went into effect on March 13, 2011 in the Americas and are scheduled for March 27, 2011 in Europe there is a potential of scheduling issues and excessive failed instances to appear on Recurring Daily Schedules in Business Objects Enterprise XI r2 FP6.3 and earlier as well as XI 3.1 SP3+ environments. If you encounter any issues please refer to the SAP Knowledge bases below for workarounds and resolutions and if required please raise a Message for Processing to via the Service Marketplace.

I’ve installed the fix pack recommended here: https://websmp210.sap-ag.de/sap/support/notes/1448881 and I’ll post an update after the weekend to say whether or not it worked.

UPDATE:  The instance of Business Objects that I manage appears to have crossed the clock change boundary without any duplication of scheduled reports so either the fix pack mentioned above did the trick or the issue itself did not occur!

More Business Objects Browser Problems: Java/Tomcat in IE9 (UPDATED: WORKAROUND)

UPDATE: An excellent workaround has been posted by one of the members of the BOB Forums, please see this thread. 

Hot on the heels of my Business Objects problems with Firefox, I’ve now encountered an issue with Internet Explorer 9 (again a new release), again with the Java / Tomcat version.  Whenever I click to view or modify a report I receive the following error message…

Thankfully everything is fine in the IIS / ASPx version but nonetheless I am still advising my users not to upgrade until either Microsoft or SAP are able to provide a fix.

Business Objects Java Query Panel Issues with Firefox 4 (UPDATED: WORKAROUND)

UPDATE: Milos, a reader of bisql.net has posted a comment on this thread with a workaround:

• Enter “about:config” in the browser’s address bar. 
• Search for “html5.parser.enable”. 
• Double-click the row to set the value to “false” (row should also go bold to indicate change). 

There is a possibility that it may cause HTML5 compatibility issues down the road but it solved the issue I experienced in XI 3.1 so thanks Milos! 

Mozilla released Firefox 4 yesterday, touting speed improvements as one of the key features so I installed it to see if it would make a good client for Business Objects.  Unfortunately it seems that there is a bug whereby Firefox fails to recognise that Java is correctly installed and so whenever I go to modify a report using the Java Query Panel I see the following screen…

… and when I click on the “Install Missing Plugins” button I end up with the following message stating “No suitable plugins were found.”…

I tried re-installing both 32-bit and 64-bit Java runtime packages and it made no difference whatsoever, I then reinstalled Firefox 4 with still no change.  For now I’ve gone back to Firefox 3.6 and it works like a charm so until I see an updated version or a decent workaround I am advising my users not to upgrade.

Register for the SAP Business Objects XI Release 4 Launch

UPDATE: since the event has now passed you can also read my SAP BI 4.0 Launch rundown and my What’s New in Business Objects XI Release 4.0 posts, of course – don’t let that put you off reading the remainder of the article below…

I just wanted to give people a head’s up – SAP are running a “Launch Event” for the upcoming 4.0 releases of their BI and EIM tools in London on the 7th of April, I’m assuming that this is going to be the release of the XI 4.0 product though there could be a change in branding to remove the ‘XI’ portion and fall more in line with SAP’s naming conventions.  I’ve not seen much in the way of expected features so it’ll be an interesting event I expect, most of the speakers are unfamiliar to me although I’ve seen Richard Neale speak at a number of BOUG (Business Objects User Group) events and he always comes across confidently gives a compelling view of the product.

One thing that is clear is that there’s definitely some coming together of traditional SAP products and the Business Objects line, if nothing else the sponsors/exhibitors bear that out pretty clearly with the inclusion a few ‘big guns’ such as Atos Origin and Cap Gemini as well as some smaller SAP specialists like Bluefin and Edenhouse.

In terms of what to expect, that’s tough – there’s going to be a lot of emphasis on shiny new features such as Mobile BI, advanced dashboarding and data visualisation but that’s not what I’m there to see.  I’m really hoping for a slicker version of Web Intelligence, less fiddly and more intuitive – you can achieve a lot in the current version of WebI but the interface feels a little dated when compared to many of today’s web tools.

The lag between cloud and in-house software suites is something I think all BI vendors suffer from and it will be a tough problem to solve.  Cloud services are able to evolve continually whilst installed applications represent a snapshot of the industry’s ‘state of the art’ at the time of release and large corporate installations will almost always be 1 or 2 versions behind the bleeding edge.  This never used to be much of a problem but now most users are familiar with rich interactive web tools such as Google Docs, Mobile Me, Nike+ and Garmin Connect – now when your users come into the office they have certain expectations and at the moment I think many BI tools fall somewhat short either in functionality or ease of use.  On a related note I also expect to hear more too about potential cloud offerings from SAP or SAP partners.

Whatever happens I’m sure it will be an interesting day and of course I’ll post an event wrap-up for those of you that can’t attend, if you feel like coming along you can register at sapevent.co.uk/4launch and perhaps I’ll see you there.

Using MySQL BLOB Data via ODBC in SSIS, SQL Server & Business Objects

Whilst trying to build a centralised cross-platform alerting system I spotted a peculiar issue when trying to move the output of a SHOW FULL PROCESSLIST command on MySQL via ODBC.  It seems that the output of the SHOW FULL PROCESSLIST command returns both integers and binary (BLOB) data types even though to they eye (that is, in the MySQL Query Browser) most of the columns appear to be short text fields.

Despite the fact that the data looks like text whenever I tried to return the data into an application, I tried SSIS, SQL Server Linked Servers and Business Objects, each time the data would come back unusable or an error would be returned.  Business Objects gave me the key by declaring “This is a BLOB.” as you can see in the following screenshots…

SQL Server Integration Services

SQL Server Linked Server

Business Objects Desktop Intelligence

As with my recent post about loading data into MySQL with SSIS the saviour turns out to be an ODBC configuration setting, this time in the Metadata tab of the MySQL ODBC driver.  All you have to do is check the “Always handle binary function results as character data” and instantly your problems will be solved…

Out of a crazy fit of completeness I also took screenshots of the final results and it’d be a shame to waste them so here they are…

SQL Server Integration Services

SQL Server Linked Server

Business Objects Desktop Intelligence

Trends in Business Intelligence & 2010 Review

It’s the time of year when magazine editors can’t resist the urge to fill their glossy wares full of ‘thing of the year’ articles, the print equivalent of the mid-season “clip show” that has plagued many a TV series.  Well, if it’s good enough for them it’s good enough for me so here’s my rather unstructured and unscientific take on Business Intelligence and Data Warehousing in the year that was – 2010…

Market Trends

To start, I’ve taken a series of snapshots from the excellent Google Trends showing global search volumes for each of the Big Four offerings to measure the level of interest.  It’s reasonably clear to see from the graph below that interest in OBIEE shows a small but steady growth whilst Reporting Services shows a marked decline and the other two offerings remains roughly static (maybe a small decline?), this surprised me given that with the release of 2008 R2 I think that Reporting Services is really getting to the point where it offers a legitimate choice in the BI marketplace.  Perhaps the issue that Microsoft have fragmented their BI offering to include a mixture of terms with Excel, PowerPivot, SharePoint, Analysis Services and Reporting Services all making up the BI stack and nobody really knows what to call it?

This year has also brought an increased emphasis on Mobile BI with the iPad and iPhone fast becoming common executive playthings, Business Objects making it’s Explorer and Xcelsius products available on Android in addition to the iPhone (Explorer only).  MicroStrategy took the mobile emphasis a step further (perhaps to help stick their head above the crowd) by announcing a strong focus on the mobile BI market and offering a free 25-seat licence for their Mobile Suite.  Despite a strong focus on marketing Mobile BI I’m still not convinced that any of the vendors have really hit the nail on the head with their solutions in that whilst many offer pretty visualisations and slick interfaces most seem to lack the kind of simplicity that helps to present information quickly and succinctly, even the frankly beautiful independent product RoamBI just feels a little overdone when it comes to actually using it.

Major Product Releases

It’s been quite a year in the BI & Database world with the launch of Microsoft SQL Server 2008 R2, Oracle Business Intelligence Enterprise Edition (OBIEE) 11g and IBM’s Cognos 10…

Microsoft’s launch is effectively a moderate evolution of SQL Server 2008 in most areas with little change to the database engine, it’s ETL tool Integration Services and it’s OLAP engine Analysis Services.  That said, R2 did bring some handy incremental features which will be especially welcomed by the budget-conscious with an increase in the DB size of the free Express Edition from 4GB to 10GB and the addition of Backup Compression to Standard Edition.  There were some interesting additions with PowerPivot, Master Data Services and StreamInsight thought I’m not sure that either will find a natural home for a good year or so as busy DBAs and developers struggle to find the time to try these new features out.

Despite the major jump in the version number Oracle’s release too seems to be mainly an evolution and as a great fan of the product I’m quite considerably relieved since Oracle could quite easily have been over-zealous in integrating their ‘own’ tools like Discoverer and Warehouse Builder with bought-in technologies like Siebel Analytics (which became the bedrock of OBIEE), Hyperion’s Essbase and Sunopsis (now Oracle Data Integrator).  One of the less exciting but fundamentally important additions is that the semantic layer employed in OBIEE will be directly and immediately compatible with future releases of other Oracle products in the CRM, ERP and Finance application spaces.

I’m not as familiar with Cognos as the other two tools having only experimented with Cognos 8 for a couple of weeks but from everything I’ve read it seems that Cognos 10 was certainly a major milestone in the product’s lifecycle.  Aside from the shiny sounding features such as Social Networking and iPad support (actually a very serviceable looking mobile BI app) there are some very cutting-edge additions to the product including a statistical engine drawn from SPSS and Active Reports which allows users to explore and analyse offline data including interactive email reports.

The Future?

No good review and roundup article ends without a nod to the future and whilst I’m not keen on making absolute predictions there are a few developments I’ll be keeping my eye on for 2011 and beyond.

The main event I’m anticipating is the release of Business Objects XI Release 4, I’ve not seen too many concrete details about functionality but over the last few years Business Objects have seen themselves distracted by the Crystal acquisition (including the shoe-horning of their core product into Crystal Enterprise) and in turn their acquisition by SAP.  As a regular and long-term user of Business Objects I’m really hoping that they’ll blow away some of the cobwebs and deliver some new functionality as well as rounding off some of the edges that in previous versions feel a little unfinished, it would be great too if they finally included the key functionality from the legacy desktop client (which many long-term customer still rely on) in their core Web Intelligence product (Freehand-SQL & Grouping – I’m looking at you).

Another area to watch in Business Intelligence and Data Warehousing as well as the wider enterprise market is cloud computing, Informatica’s ETL in the Cloud offering has seen improvements and adoption throughout 2010 and it’s almost a given that Microsoft will be adding some degree of ETL capability to their SQL Azure platform. I’d expect an announcement if not a release along these lines in the coming year, though it’s possible that ETL comes behind providing cloud based analytics (something SSIS guru Jamie Thomson suggests).

In a broader sense I’m expecting to see a little more interest and pickup in the open source BI market, I’ve been saying this for a while (“this time next year, Rodders…“) and I might be wrong for some time to come but I always keep an eye on companies using an Open Source model such as the ETL vendor Talend who recently acquired Sopera (a middleware and SOA vendor), BI vendor Jaspersoft and all-rounder Pentaho.  With the global economy still suffering a hangover from the sub-prime mortgage crisis and banking collapse people have been looking for cheaper alternatives and open source companies provide a great way to achieve that, though some of Talend’s high-end offerings are almost comparable in price with other commercial products.

Another possible area to watch out for is the area of Personal Intelligence, essentially Business Intelligence for the individual.  A colleague and I spoke about this back in 2008 and we could both see that as people increasingly become data-aware they’ll start to look inwards and aim to measure things about themselves, one obvious starting point is fitness and we already have sites to log and chart your weight and calorie intake as well as the brilliant Nike+ product that measures your pace, time and distance during a run using either a sensor in your shoe or GPS (iPhone app), see the sidebar of this blog or below (one of my runs on the Nike+ site) for examples of the output.