{"id":12019,"date":"2009-05-12T15:04:54","date_gmt":"2009-05-12T14:04:54","guid":{"rendered":"http:\/\/timoelliott.com\/blog\/?p=753"},"modified":"2009-05-12T15:04:54","modified_gmt":"2009-05-12T14:04:54","slug":"a-new-data-architecture-for-faster-better-bi-sap-businessobjects-explorer","status":"publish","type":"post","link":"https:\/\/timoelliott.com\/blog\/2009\/05\/a-new-data-architecture-for-faster-better-bi-sap-businessobjects-explorer.html","title":{"rendered":"A New Data Architecture for Faster, Better BI: SAP BusinessObjects Explorer"},"content":{"rendered":"

Today at the SAPPHIRE user conference in Orlando, SAP announced<\/a> it would \u201crevolutionize BI with a new solution that delivers insight at the speed of thought\u201d. The new package is called SAP BusinessObjects Explorer Accelerated, and it combines the search and visualization capabilities of SAP BusinessObjects Polestar<\/a> (now renamed SAP BusinessObjects Explorer) with SAP Business Warehouse Accelerator<\/a> (BWA).<\/p>\n

\"leo_demos_explorer\"<\/p>\n

Photo: SAP CEO L\u00e9o Apotheker showing that even a CEO can use the new SAP BusinessObjects Explorer (with a little help from Ian Kimball)<\/p>\n

Implementing business intelligence always<\/em> involves some level of tradeoff between query speed, ease of use, data volumes, and accuracy. For example, it\u2019s perfectly possible to do BI directly against transactional applications, but strict limits are required to stop system failure, and business users are likely to want more than can be made available. So some sort of dedicated analytic storage is always required, but that in turn adds other problems such as data latency.<\/p>\n

Determining the right BI data architecture for an organization is a complex and difficult process. For example, the analyst group Forrester even provides their subscribers with a \u201cBI Data Architecture Decision Tool<\/a>\u201d that requires a 1 to 5 response to 20 different questions to come up with a recommendation \u2013 and that\u2019s just with the default weights to each question.<\/p>\n

Unfortunately, when faced with this complexity, some IT organizations end up selecting what\u2019s easiest and cheapest to maintain, rather than what\u2019s best for the business users. This helps in part to explain why the average proportion of BI users in organizations remains a relatively dismal 8.2%, according to Nigel Pendse\u2019s latest OLAP Report excerpt<\/a> (registration required).<\/p>\n

To try and minimize the tradeoffs, there\u2019s been a recent surge in interest in data access and storage technologies including column databases, data warehouse appliances, in-memory processing, and complex event processing. And vendors are partnering to provide more seamless solutions \u2013 for example, SAP and Teradata recently announced a new partnership<\/a> to support Business Warehouse on the Teradata database (SAP BusinessObjects has worked closely<\/a> with Teradata for many years).<\/p>\n

The new SAP BusinessObjects Explorer Accelerated combines the best of the latest knowledge in data modeling, hardware and in-memory processing, and user interfaces in order to minimize the traditional tradeoffs and barriers to wide-scale BI deployments.<\/p>\n

Innovative Architecture<\/h3>\n

Explorer Accelerated combines the best of the new technologies, with TREX in-memory processing and a blade server architecture provided by SAP\u2019s hardware partners to index data from a BW enterprise data warehouse. Then users can access that data using the intuitive Polestar interface.<\/p>\n

\"explorer_architecture\"<\/a><\/p>\n

The product unveiled today is designed specifically for BW, but future versions will be available for other environments.<\/p>\n

The Need for Speed<\/h3>\n

One of the key requirements for effective business intelligence has always been fast response times. Unfortunately, few users are happy about what they have available today. According to the latest OLAP report extract<\/a>:<\/p>\n

For the fifth year in a row, slow query performance was again the problem generating the most user complaints. But although 19 percent of users saw this as one of the most serious problems, only 11.7 percent of consultants and 11.2 percent of vendors agreed.<\/p><\/blockquote>\n

\"pendse-fig5\"A few years ago, Nigel Pendse tried to calculate the tradeoff between query speed and business value, in an article in DM Review entitled \u201cThe Effect of the BI Application on Business Performance<\/a>.\u201d<\/p>\n

He first calculated at composite business benefit index (BBI) (based on KPIs such as saved costs, better business decisions, etc.), and then charted it for various characteristics, including the typical query time. As Nigel says in his article:<\/p>\n

[this chart] is remarkable. Most people would expect that query performances of under one second were hardly different from query performances between one and five seconds, and there would be no impact on the overall business benefits achieved – but there actually is a measurable impact on business performance as query performance declines.<\/p>\n

When compared to other factors, variations in query performance have more effect on the BBI than any other. If there is one aspect of an application that you want to optimize, choose this one.<\/p><\/blockquote>\n

SAP BusinessObjects Explorer uses hardware acceleration and in-memory processing to produce the kind of sub-second query response times that make such a big difference to the overall business benefits of BI.<\/p>\n

\"image\"<\/h3>\n

Intuitive Experience<\/h3>\n

\"image\"Hundreds of articles have been written over the last twenty years about making BI easier to use, especially for \u201ccasual users\u201d who need access to information to do their jobs, but don\u2019t want to use complex query tools. And tools have improved, but ease-of-use issues are still typically near the top of barriers to wider adoption (see diagram).<\/p>\n

It\u2019s always been possible to provide predefined interfaces such as executive dashboards<\/a> or operational reports<\/a> that have exactly what people want. But these can be expensive to build and maintain and what people need inevitably changes over time as problems get fixed and processes are improved. The ideal interface would still be flexible enough to let people browse through information, but without requiring any specific set up of hierarchies or windows.<\/p>\n

This is the where Explorer is such a breakthrough. It uses an attractive, Adobe-Flex-based interface that provides an experience much more like a typical Google search, and requires no training to use.<\/p>\n

Search<\/strong>. Users can enter any keywords they are interested in, and Explorer will instantly find the most relevant data from across all data sources available in the BW warehouse.<\/p>\n

\"image\"<\/p>\n

Faceted navigation<\/strong>. Explorer provides \u201ccontextual exploration\u201d \u2013 as you browse through data, explorer automatically provides the most relevant details, without having to understand anything about the underlying data model.<\/p>\n

For example, if I\u2019m looking at fridges, Explorer may display \u201cvolume\u201d as the next most relevant characteristic, but if I look at TVs, it may be \u201cscreen size\u201d. It\u2019s important to note that these suggestions are derived from the data itself, and can easily be overridden as the user looks for data.<\/p>\n

\"image\"<\/p>\n

Automated chart generation.<\/strong> Explorer automatically picks the best chart format for the data available, and colors and transitions are used to help the users\u2019 eyes follow the data they are interested in.<\/p>\n

\u00a0\"image\" \"image\"<\/p>\n

Easy sharing.<\/strong> Insights can easily be shared with others, by sending URL links or diagrams, or exporting to other systems.<\/p>\n

Serious Data Loads<\/h3>\n

The volume of data available for analysis continues to explode \u2013 just three years worth of transaction detail for a national chain adds up to billions of transaction records. Because of the server blades, Explorer provides consistent and predictable response times, typically five times as fast as highly-tuned queries and up to 100 times faster than non-tuned queries. Combined with BW, this means you can access information throughout the organization, quickly see the big picture and connections, and still be able to navigate to the detailed information.<\/p>\n

Conclusion<\/h3>\n

Above all, SAP BusinessObjects Explorer is defined by the tradeoffs you don\u2019t<\/strong> have to make. For the first time, a BI solution is available where you don\u2019t have to understand the data structure, you don\u2019t need training, you aren\u2019t constrained by what data you can have access to, and you have sub-second query response time. And all this without needing to create any specific dashboard interfaces.<\/p>\n

With the new exploratory capabilities, people can answer questions they didn\u2019t even know they had. As you explore data, your questions evolve quickly and SAP BusinessObjects Explorer keeps pace with the answers. Response from early customers and beta testers has been impressive:<\/p>\n

\u201cIf you know how to use a computer you can use Explorer.\u201d<\/p>\n

\u201cThis is a perfect tool for our managers who don\u2019t know what they are looking for.\u201d<\/p>\n

\u201cFinding information is as easy as searching the Internet.\u201d<\/p>\n

\u201cThe point and click interface allows users to pick what they want – like you would do on any website.\u201d<\/p><\/blockquote>\n

I\u2019ll post more information and resources about Explorer in the coming posts\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"

Today at the SAPPHIRE user conference in Orlando, SAP announced it would \u201crevolutionize BI with a new solution that delivers insight at the speed of thought\u201d. The new package is called SAP BusinessObjects Explorer Accelerated, and it combines the search and visualization capabilities of SAP BusinessObjects Polestar (now renamed SAP BusinessObjects Explorer) with SAP Business Warehouse Accelerator (BWA).<\/p>\n","protected":false},"author":2,"featured_media":744,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[213,476,826,911,939,941],"class_list":["post-12019","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-businessobjects","tag-explorer","tag-polestar","tag-sap","tag-sapphire","tag-sapphire09"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2009\/05\/leo-demos-explorer.jpg?fit=690%2C460&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3X9RF-37R","_links":{"self":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12019","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/comments?post=12019"}],"version-history":[{"count":0,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/12019\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media\/744"}],"wp:attachment":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media?parent=12019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/categories?post=12019"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/tags?post=12019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}