Thursday, December 13, 2012

SAP BusinessObjects Migration SWOT Analysis

SAP BusinessObjects migration planning can benefit from SWOT analysis — the more such investigation and planning that goes on upstream, the fewer surprises you'll encounter downstream in your migration project management. But SWOT analysis is even more critical in migration pre-planning efforts — the stage at which you are gathering internal approvals and executive sponsorships.

The business case for SAP BusinessObjects migration is a strong one, but it needs to be examined in light of the particular environment, circumstances, and business needs within your enterprise. Without the business case, there is no project.

As a platform manager seeking buy-in, you need to translate generic benefits into line-of-business-specific selling points to make the case for migration. One way to nail down those selling points while committing to due diligence is to perform formal SWOT analysis

Tuesday, December 11, 2012

APOS Insight Lite - BusinessObjects System Metrics

Are you an SAP BusinessObjects platform manager or administrator being asked to do more with less? Do you need a clear inventory of the objects, schedules and instances in your deployment? Do you want to know which objects in your deployment are most frequently used? Most rarely used? Would the ability to analyze and compare report processing windows help you optimize your system?

APOS Insight Lite can help you deal with these questions and more.

APOS Insight Lite is a subset of the services found in the APOS Insight Advanced Solution, a full-featured system metrics, performance analytics, and system planning solution for SAP Business Objects.

Find out more about APOS Insight Lite BusinessObjects system metrics.

Tuesday, December 4, 2012

Embed Location Intelligence in Dashboards, Crystal Reports

The Standard Edition of the APOS Intelligence Solution (LIS) is free map viewing software available in HTML5, Silverlight, and Flex versions. Use the free APOS LIS map viewer to embed interactive maps (such as those available at Esri's in SAP BusinessObjects Dashboards (Xcelsius) and Crystal Reports.

The free application provides:

  • Compelling geospatial visualization
  • Quick connection to web maps
  • Easy deployment
  • Ability to load your own data, configure pop-ups
  • Interactive selection and drilldown tools

Learn more, view demos, download white papers, view recorded webinars.

Monday, December 3, 2012

An SAP BusinessObjects Backup/Restore Alternative

Jonathan Haun (@jdh2n) of Decision First Technologies has published a great piece on backing up and restoring SAP BusinessObjects on his All Things BOBJ BI blog.

The essence of his post is that SAP BusinessObjects administrators don't generally give too much thought to backing up their deployment. Usually, they simply give a list of requirements to someone in IT and assume the job has been done to those specifications.

However, restoring an SAP BusinessObjects deployment may not be so straightforward, nor particularly timely. Should some object be accidentally deleted or become corrupted, your options are limited to:

  • Full restore - replacing the entire deployment with the last known good backup.
  • Temporary restore - restoring to a new location and using an import wizard to restore missing or corrupted objects to the production deployment.
  • BIAR file restore - use Business Intelligence Archive files (BIARs) to archive and restore portions of the CMS db system and input/output FRS.

Jonathan rightly notes that all of these methods have issues, and the BIAR file method, which had become an easy-to-use favorite of administrators using XI 3.1, has become significantly less than friendly in early BI 4.0 deployments. Jonathan floats the Upgrade Management Tool as a limited workaround for BI 4.0 issues.

There is no replacement for performing regular backups of your SAP BusinessObjects deployment, but that's the easy part. When it comes to maintaining easily accessible archives, all of the methods listed by Jonathan are time-consuming and error-prone, and they look at archive, backup and restore as simply operational issues. What if you have regulatory concerns? What if you are migrating and need to archive instances that you are not migrating in an easily accessible and secure way?

APOS Storage Center
offers a solution that complements an incremental SAP BusinessObjects backup strategy. It allows you to back up objects securely and selectively restore them in one simple operation. You can also archive instances in formats not dependent on data connections (e.g., PDF) to server as documents of record for compliance purposes.

Download the APOS Storage Center white paper, or watch the APOS Storage Center recorded webinar.

Monday, November 12, 2012

BusinessObjects Migration Challenges & Best Practices

APOS solution consultants have been working with BI 4.0, SAP BusinessObjects XI, and their many precursors for over 15 years. They've been through many migrations and upgrades. In fact, many of our solutions began their lives as migration support applications.

Some of those solution consultants delivered a standing-room-only presentation on BI 4.0 migration challenges at the 2012 ASUG BusinessObjects User Conference in September, and partially reprised their presentation in an October webinar. (Download or view the recorded webinar on SAP BusinessObjects 4.0 migration challenges.)

We've collected some of their planning and preparation best practices for your convenience on our website.

Monday, October 29, 2012

Product Update: APOS Publisher and Xcelsius Bursting

APOS Publisher now includes the ability to burst Xcelsius in the form of a static image (PNG). This new feature lets you export from Xcelsius to a PNG file, and embed the image within PDFs and Excel files, which you can then distribute to multiple destinations, or to print.

This new functionality is in addition to the existing ability to export Xcelsius to SWF files.

Tuesday, October 23, 2012

Webinar Reminder: Well Managed Migration

When: Oct. 24, 2012, at 10am and 4pm EDT
Migration to SAP BI 4.0 from an earlier version of SAP Businessobjects has been a popular topic at the business intelligence events we've attended this year. If you missed our "Well Managed Migration" presentation at this year's ASUG BusinessObjects User Conference in Orlando, then here's your chance to catch up.
This webinar will help you establish some of the administrative and platform management best practices you will need to plan and manage the migration process. We will show how APOS solutions can help you before, during and after your migration. Our solutions complement and enhance SAP'S administrative and platform management capabilities, so you can migrate from a clean environment to a clean environment.
APOS has almost 20 years experience improving BI administration, performance and ROI. We know from that experience that our solutions can help you before, during and after the migration process, saving you both money and headaches.
  • Before Migration – Clean up and back up before you move
  • During Migration – Test, evaluate and tweak
  • After Migration – Maintain your well managed BI
You should plan on attending this webinar if you are considering migrating or are currently planning to migrate your system to SAP BusinessObjects BI 4.0.

Wednesday, October 17, 2012

Press Release: APOS .NET Plug-in Lets .NET Applications Call Web Intelligence® Reports in SAP BusinessObjects BI

APOS Systems Inc., a leading provider of well-managed business intelligence (BI) solutions for SAP® BusinessObjects™ solutions, announces the availability of its new APOS .NET Plug-in for SAP BusinessObjects Web Intelligence® software. The plug-in allows users to schedule reports in SAP BusinessObjects Web Intelligence from .NET applications.

Read the full press release.

Tuesday, October 16, 2012

Press Release: APOS Integrates Location Intelligence and SAP BusinessObjects Dashboards

This morning, APOS announced at SAP TechEd 2012 that the APOS Location Intelligence Solution (LIS) now takes advantage of advances presented in the SAP® BusinessObjects™ Business Intelligence 4.0 platform to deliver integration between location intelligence and SAP BusinessObjects Dashboards 4.0 (formerly known as SAP BusinessObjects Xcelsius® Enterprise), as well as with the SAP Crystal Reports® family of offerings.

Visit us at Booth 104.

Read the full press release.

Monday, October 15, 2012

Webinar Recording: BI Dashboards & Location Intelligence

For those of you who missed our very well attended webinar on embedding location intelligence in SAP BusinessObjects Dashboards 4.0, this webinar and many others are available from the APOS Recorded Webinars page.

Learn about adding geospatial visualization capabilities to your dashboards -- the next step in the evolution of business intelligence.

Wednesday, October 10, 2012

Webinar Reminder: BI Dashboards & Location Intelligence

When:Oct 11, 2012, at 10am and 4pm EDT
Dashboards have long been an informative, at-a-glance means of visualizing and understanding critical information, whether administrative, financial or operational. From the executive information systems of the '90s to today's sophisticated SAP BI 4.0 Dashboards (formerly Xcelsius), dashboards have provided the real-time information that managers need in order to manage assets and processes in a timely and competitive fashion.

Modern enterprises need speed to insight, and real-time geospatial visualization provides it, facilitating operational efficiency and creating competitive advantage. They don't need to understand last year's trends next year. They need to understand them, and act on them, now.

Adding geospatial visualization capabilities to your dashboards is the next step in the evolution of business intelligence.

Join us on October 11 for a 45-minute webinar that will introduce you to the easiest and most flexible way to add location intelligence to your SAP BI 4.0 Dashboards. We will discuss:
  • Why location intelligence (LI) matters to your enterprise
  • How SAP BI 4.0 Dashboards (formerly Xcelsius) fit into your decision-making workflows
  • What LI / Dashboards integration delivers
  • How LI / Dashboards integration benefits enterprise finance, operations and administration
  • Where you can apply LI / Dashboards integration within your enterprise (3 scenarios)
  • How to develop and deploy LI / Dashboards integration
We hope you can join us for this exploration of geospatial visualization for SAP BI 4.0 Dashboards. 

Thursday, September 27, 2012

Webinar reminder: Well Managed BI Today at 2pm ET

There's still time to register for today's Well Managed BI webinar. APOS COO Allan Pym shows you how  SAP BusinessObjects platform management and administration best practices can liberate your resources for more proactive activities and increase BI ROI.

Friday, September 21, 2012

Visual Discovery Infographic

There's a great infographic, sponsored by SAP, produced by the Aberdeen Group, and incorporated in Pierre Leroux's SAP blog entry, Is Visual Discovery for You and Your Organization?. Leroux's claim is that:

Best-in-class companies are already adopting visual discovery solutions over traditional business intelligence (BI), resulting in more agility for their organizations in the face of decreasing business response time.

The infographic tells us that, in visual discovery (or interactive BI): "Business users receive a rich, highly interactive interface, allowing them to manipulate and explore information directly."

The hope is that, in the age of the social Web, with its multi-voiced conversations between companies and customers, BI itself is becoming more conversational, better meeting the needs of information consumers through interactive, visual discovery. SAP's Visual Intelligence (or Visi), working with HANA, and providing drag-and-drop document creation, is a step toward realizing that concept.

Thursday, September 20, 2012

Desktop Intelligence Compatibility Patch (DCP)

Since the 2012 ASUG BusinessObjects User Conference in Orlando (BOUC) last week, there has been a groundswell of DeskI debate. Is SAP bringing the "Deadski" back to life? Will my organization be able to migrate to SAP BI 4.x without converting all of my users (and my reports) over to WebIs? Can I possibly dodge this bullet?

I take no pleasure in raining on your parade, but the answers are "No," "No," and "No."

The Desktop Compatibility Pack, which many people became aware of in Orlando last week, will not save you from phasing out Desktop Intelligence reports when you migrate to SAP BI 4.x. It may ease the pain, but not until release 4.1, when the pack becomes available

Olivier Duvelleroy, publishing on the SAP Community Network site, clarifies the situation on behalf of SAP

No, DeskI is not "back". We have no intention of building a 4.x version of Desktop Intelligence. We have announced the planned end of life of Desktop Intelligence with the BI XI 3.x line. The end of maintenance for Desktop Intelligence 3.x is the same as BI XI 3.x in 2015, and the end of support is in 2017.

In other words, nothing has changed. The false hope many feel is the result of SAP's attempt to smooth the migration path to BI 4.x:

The “Desktop Intelligence Compatibility Patch” will be an add-on to install on top of the Desktop Intelligence XI 3.1 SP6 desktop product. When installed, it will allow the Desktop Intelligence reports, users, universes and database connections to be managed by the BI 4.1 platform. The estimated release date is mid-year in 2013.

Our goal is to allow Desktop Intelligence users and content to move to BI 4 as easily as possible.  The Desktop Intelligence Compatibility Patch helps in scenarios with reports are difficult or costly to convert to Web Intelligence.

What else can you do to ease the pain of migration? APOS Storage Center can help you archive those existing reports in an accessible format. But a well managed migration is multi-faceted. Read how other APOS solutions can help you create and execute that plan:

Wednesday, September 19, 2012

ASUG BOUC 2012 - Thanks!

Judging by the talk around the water cooler, this year's ASUG SAP BusinessObjects User Conference was a golden opportunity for APOS representatives to catch up with old friends and make many new ones. Thanks to all of you who made our time at ASUG BOUC 2012 valuable, interesting, and fun.

Our team delivered two presentations at this year's conference: one on geospatial BI; the other on BI 4.0 migration. If you would like more information on either of these topics, visit:

Tuesday, September 18, 2012

Enterprise Location Intelligence Industry Review

The TEC blog, from Technology Evaluation Centers, notes that " The need for location-based analysis is not new."

Location information is key in many industries and lines of business for acquiring a business understanding and a baseline for many analysis efforts. Location intelligence or location analytics applications can provide organizations with the means to easily collect and connect the data with location-based information and perform location-based analysis (‘plug and play’). They can also help organizations to achieve greater visibility and agility in business activities by enabling them to respond on time and on location.
(Using Location to Gain Intelligence, September 12, 2012)

Although the term "location intelligence" is relatively new, the practice is certainly not. The difference between scientific, location-based investigation such as John Snow's 1854 cholera epidemic visualization and modern business practice is the available technology.

While Snow's study led to real scientific progress, the needs of modern enterprises are different. They need speed -- real-time geospatial visualization that provides speed to insight and leads to operational efficiency and creates competitive advantage. They don't need to understand last year's trends next year. They need to understand them, and act on them, now.

The technology available in the location intelligence category as a whole is undergoing rapid transformation thanks to technology trends such as big data and cloud services. Our own APOS Location Intelligence Solution (LIS) is keeping pace with those trends with SAP BI 4.0 Dashboards integration, a new HTML5 viewer, and other great innovations that simplify the deployment of location intelligence and make it a true enterprise-level solution.

Thanks to TEC for the enterprise location intelligence industry summary, as well as the mention.

Friday, September 7, 2012

ASUG BusinessObjects User Conference 2012

We'll have a substantial presence at this year's ASUG BusinessObjects User Conference in Orlando, September 10 - 13. If you are attending, drop by and see us at Booth 100.

And don't miss our two presentations:

  • Well Managed Migration: Learn techniques, strategies and tips for successful migration to the SAP BusinessObjects BI 4 platform. APOS consultants will share insights from our 15+ years of migration consulting and BI solution development, and Mark Richardson of Rose-Richardson Enterprises will share his customer perspective on migration and the relevance of APOS Solutions.
  • Geospatial BI 101 - a Primer for Mapping Your Route to a Successful Location Intelligence Deployment: Understand the technology and business potential of location intelligence, and what you have to do to make geospatial BI happen in your organization. Learn how to leverage geospatial technology and techniques to unlock new analysis and insight options with SAP BusinessObjects. Chris Hickman of Decision First Technologies joins APOS to present a series of use-case examples that will help participants understand the business value of deploying geospatial BI.

Friday, August 31, 2012

Need BI 4.0 WebIs from .NET Apps?

If you're investigating migration to BI 4.0, you probably already know that BI 4.0 doesn't include a plug-in to let you schedule Web Intelligence reports from .NET applications. If that's all that was keeping you from migrating, then we have good news: the APOS WebI .NET plug-in lets you schedule WebIs and manage defaults from .NET applications.
We created this plug-in to allow our own well managed BI solutions to work with BI 4.0, and now we're offering to the SAP BusinessObjects developer community. The APOS WebI .NET plug-in lets the developer handle format, prompt information, and other flags while scheduling Web Intelligence reports from .NET apps or saving report defaults.

Another issue that our plug-in solves is prompt reconstruction. When you create a new Web Intelligence report, or update an existing one, the prompt information on the report object becomes unavailable to the developer through the SDK. The APOS WebI .NET plug-in uses prompt reconstruction functionality to let the developer access the prompt information. You can schedule the report with the reconstructed prompts or save the report object for later use. You do not have to update the source report in order to schedule an instance.

You will notice that we are not using the GetPluginInterface method to initialize our plug-in. On a Web Intelligence object that method simply fails regardless of what you try to do with the returned object. We actually support using the plug-in interface to initialize our plug-in but this will not work with a Web Intelligence object. We tested it with other InfoObjects with no issues.


Using sm As CrystalDecisions.Enterprise.SessionMgr = New CrystalDecisions.Enterprise.SessionMgr
    Using es As CrystalDecisions.Enterprise.EnterpriseSession = sm.Logon("My Account", "My Password", "My CMS", "secEnterprise")
        Using iStore As CrystalDecisions.Enterprise.InfoStore = es.GetService("InfoStore")
            Using objs As CrystalDecisions.Enterprise.InfoObjects = iStore.Query("SELECT TOP 1 * FROM CI_INFOOBJECTS WHERE SI_NAME = 'My Report'")
                Using obj As CrystalDecisions.Enterprise.InfoObject = objs(1)
                    Using plg As APOSWebiPlugIn.webi = New APOSWebiPlugIn.webi(obj)
                        plg.WebiAPOSLicenseKey = "<your key here>"
                        'Choose to schedule to XLS format
                        plg.WebiFormat = APOSWebiPlugIn.CeWebiFormat.ceWebiFormatExcel
                        'Get the list of prompt names
                        Dim prompts As List(Of String) = plg.WebiGetPromptList()
                        'GEt the lsit of values for the first prompt
                        Dim vals As List(Of APOSWebiPlugIn.WebiPromptValue) = plg.WebiGetPromptValues(prompts(0))
                        'Clear the list of values
                        'Add Texas as the only value for the prompt
                        vals.Add(New APOSWebiPlugIn.WebiPromptValue("Texas"))
                        'Save the list of values back to the report
                        plg.WebiSetPromptValues(prompts(0), vals)
                        'Schedule the report
                    End Using
                End Using
            End Using
        End Using
    End Using
End Using

You are welcome to try it and let me know what you think. Just email to ask for the library or send in any comments.

Tuesday, July 17, 2012

The Big Data Challenge


Why are companies such as HP, IBM and Oracle spending big money to acquire big data capabilities? Michael Vizard's Slashdot article, "The Multi-Billion-Dollar Data Management Challenge,"shows how serious the quest for Big Data supremacy has become. (Thanks to Jim Harris (@ocdqblog) for passing this along via Twitter.)

As of 2012, the world creates approximately 2.5 quintillion (2.5 x 1018) bytes of data daily (Wikipedia). The mathematical notation in parentheses is not not redundant, because the definition of "quintillion" varies according to which side of the Atlantic you are standing on. In the US and Canada, a quintillion has 18 zeroes; in the UK, France and Germany, a quintillion has 30 zeroes. That's just a simple example of the difficulty involved in dealing with Big Data.

Volume, variety, velocity and veracity are the four "Vs" of Big Data, but there's one "M" we should mention as well: metadata. Metadata is the key to managing and indexing the massive inflow of data, making accurate operational and competitive intelligence available in a timely manner to your decision makers.

For SAP BusinessObjects platform managers, now is the time to get your own metadata house in order. APOS Insight's enhanced audit and metadata management capabilities can help.

Monday, July 16, 2012

RIP Stephen R. Covey

In The Seven Habits of Highly Effective People, Stephen R. Covey told us to begin with the end in mind ("Habit 2"). The end of his life today reminds us of the formative effect he had on so many of us.

In "Habit 2", he told us to
use our whole brain, and especially to find ways to tap into our right brain -- the hemisphere of passionate creativity and visualization.
Location intelligence may not have been what he had in mind as he was writing in 1989, but I'd like to think his whole-brain call to arms was prescient with regard to today's geospatial visualization trend.

Stephen R. Covey dead as a result of a bicycling accident.

Thursday, June 28, 2012

Going Post-Digital - Deloitte Tech Trends 2012

The Deloitte Tech Trends 2012 report's theme is "elevating IT" in a post-digital business environment, so its focus is on how IT can make an impact, and how the described trends present "an opportunity for IT to truly help elevate business performance" (Preface).

Will these technological trends be disruptors or enablers? Essentially, the way each trend affects your organization is up to IT leadership. The degree to which each technology trend will be disruptive or enabling within your organization depends on how proactive/progressive you are in implementing it.

BYOD and BYOT are two trends not mentioned in the report, but which are related to the status of IT within organizations in a so-called "post-digital" age. (The "post" prefix is somewhat ironic in that it denotes not a lessening of digital technology's impact, but an amplification of its effect within an organization ‑ to the point where it manifests as a paradigm shift.)

The post-digital organization is one in which the role of IT is lessened, because more technology is embedded, more devices are personal, and more networks are outsourced. The technology trends delineated in the Deloitte report present an opportunity for IT to re-assert itself as a progressive voice within the enterprise, but to do so, IT leaders must understand how these trends work individually and together to transform the enterprise.

Friday, June 22, 2012

Crowdsourcing Artificial Intelligence

Via Bonnie Hohhof (@hohhof)

This story brings a whole new meaning to the phrase "gaming the system."

DARPA, the US Defense Advanced Research Projects Agency is using online gamers as part of its strategy to develop the behavioral intelligence needed by unmanned submarine hunting vessels, according to a post by Stewart Baines on the Connecting Technology blog.

DARPA has released a gaming combat simulator called Dangerous Waters. With the permission of the gamers, the simulator returns information back to DARPA for analysis and application to their unmanned vessel control algorithms. They are, in essence, assimilating the wisdom of crowds.

Wednesday, June 20, 2012

What's New in APOS Location Intelligence - Webinar Reminder

Tomorrow's webinar: What's New in APOS Location Intelligence. I'm personally looking forward to this one, because there's so much that' new and exciting in the APOS Location Intelligence Solution.
You're probably already familiar with the Xcelsius/Dashboards support we announced some time ago. There's lots more including:
  • Enhanced Xcelsius support and other BI content support
  • Mobile LI applications
  • Esri Web Map availability update
  • Big Data query handling
  • HTML5, Silverlight & Flex support update
  • Visualizing points from tabular & spatial sources
  • WMS maps and FME integration
  • Location Intelligence roadmap update
Tune in at 10am ET or 4pm ET tomorrow, June 21, 2012.

Tuesday, June 19, 2012

APOS Presentation at Esri PUG 2012

APOS Sales Manager Jay Murdoch presenting at the Esri Petroleum GIS conference (PUG) in Houston, Texas.

Big Data's Fourth "V"

Volume, Variety, and Velocity are the three "Vs" of Big Data. @RobertKugel tweeting on a talk by IBM's Brenda Dietrich reveals a fourth: Veracity. Here's an IBM presentation slide (PDF) that shows the relationship:

The Fourth Big Data V stands for Veracity

Monday, June 18, 2012

Friday, June 15, 2012

Location Intelligence: Disruptive or Enabling?

The Deloitte Technology Trends 2012 Report is out and it's a great read. The report groups 2012 trends into 2 categories, Disruptors and Enablers.

  • Disruptive innovation tends to be revolutionary ‑ it changes your workflows. Included in this category are Social Business practices, Enterprise Mobility and Cloud technology.
  • Enabling innovation tends to be evolutionary ‑ it improves existing workflows. Included in this category are Big Data and Geospatial Visualization.

The report makes the case that Geospatial Visualization (e.g., Location Intelligence) is enabling rather than disruptive, and thus that its implementation within an enterprise is evolutionary rather than revolutionary. It is perhaps a small distinction, but one that might have a significant effect on implementation decisions, so let's delve into the report's methodology:

Our 2012 report shares ten trends grouped into two categories. Disruptors are technologies that can create sustainable positive disruption in IT capabilities, business operations and sometimes even business models. Enablers are technologies in which many CIOs have already invested time and effort, but which warrant another look this year because of new developments. Enablers may be more evolutionary than revolutionary, but the potential is there to elevate the business game with technology. (Preface)

Can we judge from these definitions whether Location Intelligence is disruptive or enabling, revolutionary or evolutionary?

I think the problem with these definitions is that they are relative to the particular enterprise. You cannot say absolutely that Location Intelligence is an enabling or disruptive technology if the designation depends on work already done by the CIO within individual enterprises. So, Location Intelligence may be revolutionary in some contexts, and evolutionary in others.

It's important to note that there are no value judgments attached to these labels. Just because a technology is labeled disruptive, that is no reason not to implement it. While implementing a disruptive technology may be more capital-, time- and labor-intensive, and present a higher risk, the implementation may be fully justified by return on investment and competitive advantage. Only diligent cost-benefit analysis will tell you for sure.

Geospatial Visualization will be an enabler if you integrate it with current enterprise information workflows ‑ with the existing technology and practices within your enterprise. Your information consumers will realize the benefits much more quickly.

The APOS Location Intelligence Solution (LIS) integrates SAP BusinessObjects with Esri ArcGIS technology, letting you introduce Geospatial Visualization within existing enterprise infrastructure and workflows. If you already have SAP BusinessObjects, APOS LIS is most definitely an enabling technology.

Friday, June 8, 2012

Facebook IPO: Data Rich, Information Poor, Analysis Absent?

Michael Rappa's analysis of the circumstances surrounding the Facebook IPO reveals just how easy it is for a large and seemingly bulletproof enterprise to fail miserably at Business Intelligence, Business Analytics, and Big Data:

Facebook has mountains of data on a scale few companies have ever seen before. Shouldn't it have unparalleled insights into its users and their value to advertisers? Reading the prospectus, I was surprised to see the IPO rested as heavily as it did on the weight of a single trend line ‑ growth in active users over time ‑ and not on data-driven insights into its user community. If Facebook is making good use of its data, it’s not evident to investors.

It seems to be a classic case of selling the sizzle rather than the steak, and the market figured it out pretty quickly, though not quickly enough to prevent a lot of people losing a lot of money. Has the dot-com bubblereally faded from our collective memory that quickly?

It's already hard to remember what we did before social media, but the question about social media, as with the dot-com ventures, has always been how to monetize its great wealth of community and data.

But the Facebook story is now also a Big Data story, because the information Facebook has about each of us is vast, and comes in many formats. It has volume and variety, two of the three defining qualities for Big Data.

The third defining quality for Big Data is velocity: It's not enough to analyze the available data; the analysis has to be as close to immediate as possible. If Big Data offers competitive advantage, it is in the velocity with which insight can be delivered and monetized.

Risk management, management by strategic objective, and public company governance find common cause in Big Data. Jill Dyché says as much in her Harvard Business Review article, "Data: One Antidote to Risky Behavior":

Savvy managers understand that weaving data-driven decisions into the fabric of corporate governance can obviate organizational infighting and drive progress. By establishing clear accountability measures, managers can determine whether and how corporate goals are being achieved, and hold people accountable for how they are achieving those goals. This motivates business people to rely less on hunches and more on hard data.

When we apply what we know, when we know it, to the realization of strategic objectives, we mitigate risk, and increase shareholder value. The attraction of managing by "gut feelings" has always been its immediacy. Providing the hard data to support or counter gut feelings with the same kind of immediacy is the Business Intelligence/Business Analytics/Big Data challenge.

Tuesday, June 5, 2012

APOS Insight Baseline Scan

APOS Insight is our enhanced audit and metadata management solution for SAP BusinessObjects. During today's Well Managed Migration webinar, Blair Pzytula noted that APOS offers a service based on APOS Insight called the APOS Insight Baseline Scan. 

The APOS Insight Baseline Scan uses Insight's incomparable audit and metadata management capabilities to identify the objects in your system (Crystal Reports, Webis, Deskis, Universes, Folders) and their structures and dependencies. This information is invaluable for planning migration, or even for system sizing excercises.

The Baseline Scan is offered as a free, limited service to qualified customers. if you want to know whether you qualify, contact your APOS Account Manager.


Monday, June 4, 2012

Webinar Reminder: Well Managed Migration

June 5, 10am ET and 4pm ET.
  • Before Migration – Clean up and back up before you move
  • During Migration – Test, evaluate and tweak
  • After Migration – Maintain your well managed BI

Wednesday, May 30, 2012

Welcoming a New Voice to Well Managed BI

You may have noticed a new voice on the Well Managed BI blog: Brad McCallum will be contributing regular posts on numerous topics, with a particular focus on location intelligence issues.

Before joing APOS as Marketing Manager over 2years ago, Brad spent 8 years working for Esri Inc. at their Redlands, California, headquarters. At Esri, Brad worked in the Industry Solutions Group as a technical liaison between the business and GIS communities, helping businesses, GIS developers, and Esri partners build industry-specific GIS solutions.

While with Esri, Brad spent a substantial amount of time working with Dr. David Huff, developer of the Huff Model, and Huff's Law.

Brad learned GIS at COGS (College of Geographical Sciences).

Tuesday, May 29, 2012

On the Road...

APOS hit the ground running in January and we haven’t slowed down since. We kicked off 2012 with a number of location intelligence events that focused on the geospatial side of our product line. One event in particular was very rewarding: the Esri business partner conference in Palm Springs, where we were presented the award for Enterprise Integration Application. We are very honoured to be identified as a leading partner with the GIS giant Esri.

Since then, we have continued to meet and interact with people focused on location intelligence by attending some industry focused events, such as HiMMS, the Esri Petroleum users group, the Location Intelligence Conference and TDWI, an event that promotes leadership and best practices for BI professionals.

In addition to these LI focused events, we participated in SAP BI 2012 and the Sapphire Now & ASUG annual Conference.

To all of you who dropped by to see us at these conferences and tradeshows, we thank you. Without your feedback,
we can't continue to be the leading provider of well managed BI solutions for SAP BusinessObjects.

The summer is always a slow time for conferences; however, we plan to be out on the road promoting our well managed BI and location Intelligence successes. To find out where we'll be next and arrange to meet with members of our team, please feel free to contact 
Jay Murdoch

SAP BusinessObjects Migration with APOS Publisher

Your organization probably has many reasons for moving to SAP BusinessObjects BI 4.0. SAP cites data access as one of the key reasons enterprises should upgrade. Better integration with SAP BW, the new dimensional semantic layer, and multi-source universes enhance that access, but enhanced access is only half of the story. If you have more, or more detailed, information at your disposal, then you will also likely have increased or more complex delivery requirements.
What will you do to enhance delivery of information to the all-important information consumers in your organization?

APOS Publisher is a complete publishing solution for SAP BusinessObjects, allowing you to maintain consistent document bursting, consolidation and delivery processes across multiple versions of SAP BusinessObjects.

With APOS Publisher, you can:
  • Use business rules to generate a large number of individually scheduled reports automatically.
  • Burst large report instances into smaller instances based on business rules, convert to a common format and distribute.
  • Emulate Desktop Intelligence's use of scripts to extract data from various data sources.

APOS Publisher is an essential solution for organizations that have complex SAP BusinessObjects distribution requirements with multiple report format and destination types. For such organizations, APOS Publisher is a complete SAP BusinessObjects publishing solution, including robust bursting management, post-processing distribution service, report package management, and assured delivery to extend those available in SAP BusinessObjects. Publisher automates these tasks while providing personalized reporting to your information consumers.

SAP BusinessObjects platform managers and technicians value the flexibility and agility that Publisher's custom properties, flags and settings add to their scheduling, bursting and distribution efforts, and the ability to zip and encrypt reports.

SAP BusinessObjects Migration with APOS Storage Center

APOS Storage Center makes it easy to back up, archive and selectively restore your documents of record in a secure and timely manner — essential to ensuring regulatory compliance and meeting the needs of your information consumers, particularly when you are limiting the amount of content you are migrating.
APOS Storage Center is a dedicated SAP BusinessObjects document lifecycle management solution. It is designed to ensure the integrity of your documents, safeguard data privacy, and support regulatory compliance. It should be a key element in your disaster recovery plan ‑ before, during and after migration.

APOS Storage Center helps you:
  • Mitigate risk by safeguarding objects, document instances, and instance integrity for audit and compliance purposes.
  • Migrate document instances from one deployment of SAP BusinessObjects to another; perform partial or complete migration.
  • Extract and export objects and document instances to other formats such as PDF (e.g., export Web Intelligence reports, which are Universe-dependent, and Desk Intelligence reports, which are deprecated in BI 4.0, to PDF to ensure access to the documents of record).
  • Implement an intelligent means to purge Web Intelligence reports while retaining retrievable versions.
  • Manage disc space carefully.

SAP BusinessObjects Migration with APOS Administrator

APOS Administrator automates and simplifies object, instance, and schedule management. During migration, reports are typically relocated. Use APOS Administrator to save, import, batch modify, and export schedules.

You can:
  • Adapt the migrated source system to the new environment using bulk operations on a large number of system objects (reports, folders, users, security, settings, etc.).
  • Import schedules from the legacy system, then map and export them to the new system.
  • Analyze an entire report instance environment at once.
  • Apply actions to instances in bulk.
  • Establish control over migrated instances/schedules.
  • Modify recurring schedules.
  • Manage scheduling crises quickly and efficiently.
  • Manage objects in bulk.
  • Perform sophisticated deployment of reports and documents to the system.
  • Promote objects from development/testing to production efficiently and in compliance with data security and privacy requirements.
  • Control security to the various objects.
  • Perform common maintenance of Users and Groups, simplifying the onerous task of setting advanced security rights.

APOS Administrator provides administrative capabilities that simplify, complement and enhance SAP BusinessObjects object and document instance management and scheduling features. In the hands of platform managers, BI technicians and other power users, APOS Administrator makes SAP BusinessObjects more responsive to enterprise information needs.

APOS Administrator saves valuable administrative time through automation and task streamlining, reducing human error, and providing the agility and flexibility to meet the changing needs of information consumers. Whether you're managing or re-engineering business processes, establishing crisis management or disaster recovery procedures, or preparing for migration to a newer version of SAP BusinessObjects, APOS Administrator creates value through operational efficiencies, establishing trust through reliability.

SAP BusinessObjects Migration with APOS Insight

The APOS suite of well managed BI solutions simplify, automate and complement many SAP BusinessObjects management and administrative tasks. They enhance system visibility and increase your control over BI content. Because they help you optimize your BI system, they are also extremely useful during all phases of your SAP BusinessObjects BI4.0 migration.

APOS Insight provides a complete snapshot of what is happening at any given time within your system, meaning that you can analyze system usage and bottlenecks over time as a preliminary step in planning your new implementation. You can:
  • Populate a database with point-in-time snapshots of system status
  • Extract benchmark information about your system before the migration, then after the migration, and compare them.
  • Run comparison reports/queries of what has changed.
  • See where reports have moved to in the new deployment.
  • Map IDs in one system to IDs in the other.
  • Compare the security structures between the two environments to ensure groups are in place, users are in groups and all are properly permissioned, thus eliminating security holes.

Once you have deployed the new version of SAP BusinessObjects, APOS Insight continues to provide high value with enhanced metadata management, audit, and monitoring capabilities.

Well Managed Migration with APOS Solutions

From the frequent feedback and numerous requests we've received, it's clear what's on many of our customers' minds: migration. Specifically, migration to the new SAP BusinessObjects BI 4.x platform.
SAP's instructions for migrating to its new version are deceptively simple. If you have any project management experience, you'll know that that apparent simplicity hides substantial complexity and many potential risks. For any enterprise softsware deployment or upgrad, risk mitigation has to be the primary objective.
How can you ensure your risks are low and your ROI is high?
APOS well managed BI solutions should be part of your SAP BusinessObjects risk mitigation strategy ‑ before, during and after the migration process. Together, these solutions form a suite of well managed BI solutions to help you perform due diligence with regard to the "5 pillars" of well managed BI:
  • Strategy / Optimization
  • Security
  • Performance
  • Operational Maintenance
  • Compliance

The time to achieve well managed BI is before you migrate to BI 4.0 FP3, not after, and APOS has the solutions to help you plan, design, implement, cut over and go live effectively. The key to a successful migration is effective risk management. The more variables you account for during planning and design, the fewer deviations there will be from the project plan during and after implementation (and the more likely the project will be to come in on time and on budget). You mitigate risk by knowing your system, your requirements, and your capabilities prior to migration.

That's the role of APOS well managed BI solutions:
  • APOS Insight benchmark and optimize performance, plan the target environment, compare security environments.
  • APOS Storage Centersafeguard object, instance integrity for audit and compliance; save to neutral formats; purge Web Intelligence reports intelligently; manage disc space.
  • APOS Administrator clean up content; manage security and users; apply bulk operations on objects, instances, recurring schedules to simplify complex deployments.
  • APOS Publisher develop enhanced information delivery capabilities ‑ advanced bursting, consolidation and document delivery based on business rules.

Tuesday, May 22, 2012

SAP Announces Intent to Purchase Ariba - $4.3BN

Ariba, the Sunnyvale, California, based cloud computing developer, is the latest acquisition target for SAP. According to SAP, Ariba "is the leader in cloud-based collaborative commerce applications and the second-largest cloud vendor by revenue." The purchsase price is said to be US$4.3 billion.

Thursday, May 17, 2012

Redefining BI

In the March 2012 edition of IT in Europe,'s Brian McKenna presents a simplified definition of BI:

Business Intelligence is ripe for defamiliarisation as a term. For IT professionals, the temptation is to understand it to mean query and reporting tools from the BI megavendors. But for one of the finance professionals quoted in this issue of IT in Europe: Data Management & BI Edition, “business intelligence means trying to make money out of data.” [Emphasis added.]

I like this definition, because it takes us closer to first principles. It takes us back to strategic objectives.

When we get set in our ways, comfortable and complacent in the status quo, we start to mistake the practice for the objective. Why do we do things the way we do them? Because that's the way we've always done them.

But the imperative to optimize the top and bottom lines of an enterprise requires us to re-examine our practices on a continuous basis. Can the practice be improved to bring us closer to our strategic objectives? Can a practice be said to be a best practice if it is not connected somehow to the realization of a strategic objective?

As I said, I like the redefinition. However, I don't think it goes far enough. I'm in the Peter Drucker school of thought on this one. Drucker was suspicious of the profit motive as a primary business driver. The purpose of a business, according to Drucker, is to create a customer. By measuring the success of the company against the ongoing relationship with the customer, we create a business that is first and foremost sustainable, but also mutually profitable.

BI's potential contribution to the pursuit of strategic objectives is obvious but not inevitable. BI professionals need to take a progressive approach ‑ to look for ways to achieve strategic objectives through better utilization of the BI platform.

In an article dedicated to the centenary of Drucker's birth, Oliver Marks notes another Drucker maxim: "Knowledge has to be improved, challenged, and increased constantly, or it vanishes." For the BI professional, it's not just about improving knowledge, but about improving the way knowledge is stored, managed and disseminated.

Tuesday, May 15, 2012

Location Intelligence for SAP BusinessObjects Dashboards (Xcelsius) -Free

The APOS Location Intelligence Solution (LIS) can now be embedded in SAP BusinessObjects BI 4.0 (FP3) Dashboards (formerly known as Xcelsius) ‑ free of charge.

The APOS LIS Standard Edition lets you embed maps you create using Esri's ArcGIS Online ( At, you can choose from hundreds of maps with valuable business information and use them as backdrops for your business data.

Try the interactive demo

The Standard Edition presents an opportunity to apply location intelligence to Xcelsius dashboards and Crystal Reports, letting you communicate compelling geospatial visualizations throughout your enterprise. It also provides a clear upgrade path to enterprise location intelligence.

Wednesday, May 9, 2012

The New APOS Website Is Here

Here's a shout-out to Martijn van Foeken (@mfoeken), who was one of the first to notice and tweet about the redesigned APOS website. Since the site's soft launch at the end of April, we've had lots of feedback from our friends, but none so vocal as Martijn's. Thanks.

The site does not represent a departure for us: it's just catching up. It now shows our focus on the concept of "well managed BI," the organizing principle of our solution set.

What do you think of when you think of APOS Systems Inc.? Maybe you think of report scheduling, or report bursting. Maybe you think of system monitoring and alerts. Maybe you think of backup and selective restore capabilities. Many people use APOS solutions to resolve specific issues they have esperienced in SAP BusinessObjects.

But the point is that APOS solutions grow with your SAP BusinessObjects deployment and your information consumers' needs, helping you become less reactive and more proactive in meeting those needs. APOS solutions resolve the issues you have now, and many of the ones you haven't yet experienced -- but will. They help you in your ongoing quest for well managed BI.

Monday, April 9, 2012

Webinar: Progressive Enterprise Publishing Solutions for SAPBusinessObjects

Are your current publishing processes growing more complex and consuming more and more of your administrative resources? Are they based on costly and outdated legacy software and platforms? This webinar will show you how to plan, automate, execute, and monitor document and statement generation from within a modern BI-integrated enterprise publishing solution.

The APOS Publisher Solution provides the agility, flexibility and security to meet complex BI publishing requirements. APOS Publisher complements the inherent strengths of SAP BusinessObjects, and brings end-to-end monitoring, control and output management to your process.

Join us on Tuesday, April 17, 2012, at 10 am or 4pm EDT for this thought-provoking discussion.

Tuesday, March 27, 2012

APOS Wins 2012 Esri Partner Award for Enterprise Integration Application


The APOS Location Intelligence Solution (LIS) integrates Esri's market-leading GIS platform and the SAP BusinessObjects business intelligence platform to create enterprise location intelligence.

Location intelligence joins business intelligence to the geospatial intelligence that organizes it, letting information consumers see information in its geospatial context in order to comprehend and communicate more effectively, and to reach informed decisions more quickly ‑ achieving "speed to insight."

Enterprise location intelligence makes this speed to insight available and relevant to the whole enterprise through high-volume queries that draw on diverse data sources from across that whole enterprise.

The key to enterprise location intelligence lies in how effectively you integrate the business intelligence and GIS platforms. That's why this award is so satisfying.

Allan Pym, Chief Operating Officer at APOS, said:

We are extremely pleased to receive this award. This award recognizes both the unique position and quality of our Location Intelligence Solution in the enterprise BI market, and the close nature of our relationship with Esri.

Read the press release:

APOS Wins 2012 Esri Partner Award for Enterprise Integration Application

Monday, March 12, 2012

Harvard Study: Do eHealth Initiatives Add to the Cost of Healthcare?


According to Jesse Hirsh on CBC Radio this morning, a recently published study by Harvard researchers shows that eHealth initiatives may be too successful in that they make it too easy to access and take action on patient data. "It's a classic case of the hidden effects of technology; any time you try to solve one problem, you're inadvertently going to create another."

The Harvard study, published in Health Affairs, looked at two groups of physicians: one that used eHealth technology and one that didn't. The study found that the physicians using eHealth technology were 40% to 70% more likely to order extra tests for their patients. As a result, healthcare costs rise where eHealth technology is used. The study's abstract provides a brief conclusion to the research:

We conclude that use of these health information technologies, whatever their other benefits, remains unproven as an effective cost-control strategy with respect to reducing the ordering of unnecessary tests.

Now, this study, or at least the media coverage of this study, begs the question of the purposes for which eHealth record initiatives were introduced in the first place. Before we trumpet the failure of a certain technology to deliver cost savings, we need to look at the larger picture

One of the purposes for which eHealth records were introduced in the US was certainly to drive healthcare cost efficiencies. But the equal, and in some ways opposite, objective was to improve patient outcomes. (See the IOM's report Crossing the Quality Chasm: A New Health System for the 21st Century, published in 2001.) It is certainly possible to see how ordering additional tests could lead to better patient outcomes.

The conflict is not a new one. We see it all the time in business. It reminds me of the frustrations of a friend who worked in a call center some years ago. She felt she had been given conflicting objectives. She thought it was unrealistic that management should expect her to improve customer service while decreasing call time.

But are these objectives necessarily in conflict? No, they are only in conflict if we take them as absolute imperatives, and that's simply not how the world works. There have to be tradeoffs, and the real challenge for the customer service representative in the call center, and for the doctor using eHealth technology, is to balance the needs of the customer/patient versus the sustainability of the system.

Triage is not practiced only on battlefields and in emergency rooms. While decisions in the call center or the physician's practice may not always be life or death, they still require a triage mentality that balances the needs of the one against the needs of the many. Anyone who is concerned for the viability of an enterprise makes these decisions every day. To mix a metaphor, do we escalate or do we cut bait? The technology does not take away the need for human beings to make decision, balance priorities, and practice an ethic.

So, are the additional healthcare costs a result of a technological failure. No, they are more likely the result of a failure to train technology users sufficiently, a failure to adapt, and thus perhaps also a failure of vision. It's hard to satisfy your examiners when you are unaware of the criteria on which you are being judged.

Tuesday, March 6, 2012

From Legacy Headaches to BI ROI

I remember a time when the biggest debate in enterprise IT departments was whether to purchase "best-of-breed" solutions or integrated systems. Line-of-business managers leaned toward the rich functionality of the best-of-breed solutions, and executives and corporate directors were more interested in the wider and easier access to data provided by integrated systems. IT departments were caught in the middle, trying to please multiple masters.

These past battles come down to us as today's legacy applications. The average enterprise IT department may have dozens of software systems to maintain. But they also have to maintain the numerous platforms on which these software systems reside. And sometimes the demise of the platform overtakes the usefulness of the application.

It's a rare crisis that doesn't also present an opportunity to those who can see through the confusion. Many BI platform managers are in this position today. They have under their control a best-of-breed business intelligence solution that can access all enterprise data sources. The BI system is that formerlly elusive combination of best-of-breed solution and integrated system.

When the ROI of a legacy platform or solution is under review, the first question should be whether state-of-the-art systems such as your BI system can absorb the legacy function for increased BI ROI and reduced TCO.

Wednesday, February 29, 2012

Location Intelligence Answers the Question: "What Else?"

We've all heard the estimate: 80% of business information has a location aspect. It's been repeated so often that it has become common wisdom, but it is a very round estimate, and the importance of location varies quite widely depending on the business you are in.

So, rather than being impressed by a vague number that may or may not reflect our actual business scenario, we should ask ourselves how location information can help us achieve our own strategic objectives, and how it can help us execute on a tactical and operational level.

If business intelligence reports tell us the "what" of business information, and analytical tools help us answer the "why" and "what if" of this information, then location intelligence tells us the "what else."

Location gives us a way to ask the question: "What else should we consider before we make important decisions about our product development, sales and marketing operations?"

Location allows us to group customers, industries and anything else that has geographic specificity to discover what else they have in common -- demographics, psychographics, legislative requirements, climate and a host of other factors that can influence our decisions.

Tuesday, February 28, 2012

Live Tweeting APOS #StorageCenter Webinar

I'll be live-tweeting this morning's Storage Center webinar using the hashtag #StorageCenter. The webinar gets under way at 10am, and will be repeated this afternoon at 4pm.

The webinar will discuss the place of robust archive, backup and selective restore capabilities in a well managed BI strategy for SAP BusinessObjects.

Register here.

My Twitter handle: @WellManagedBI.

Monday, February 27, 2012

Healthcare Regulatory Compliance and APOS Storage Center

If you are a provider or payer in US Healthcare, your world has become radically more regulated over the past decade or so, thanks to several pieces of legislation, including:

It's a complex landscape. In no other industry is data such an important asset, and yet such a potential liability. The regulatory burden and responsibility continues to grow for both providers and payers. As a BI platform manager in the healthcare industry, you need to be proactive about data governance.

APOS Storage Center can complement your SAP BusinessObjects system and help you with regulatory compliance through the following features:
  • Rules-based backup, archive, versioning, and selective restore
  • Offline and online archiving
  • Extract and export
  • Versioning, purging retrieving Web Intelligence reports
  • System performance improvements

Being proactive about data governance means not waiting until you have a problem to have a solution in place. APOS Storage Center resolves SAP BusinessObjects document instance archive, backup and restore issues before they become security and regulatory compliance problems.

Webinar: Proactive Information Management for SAP BusinessObjects

Tuesday, February, 28, 2012, 10am ET and 4pm ET.

Register for the webinar.

Most organizations have important compliance and/or operational needs which require them to keep a long history of report instances. Every SAP BusinessObjects platform manager needs control and flexibility over report objects, instances and schedules.

The APOS Storage Center well managed BI solution streamlines administration workflows, minimizes the impact of human error, and gives you more flexibility and control over your SAP BusinessObjects deployment. Storage Center mitigates risk and delivers system storage efficiencies for improved system performance and usability. And it makes migrating your SAP BusinessObjects document instances significantly easier.

Please join us for a 45 minute webinar that focuses on the unique benefits of APOS Storage Center, and the flexible control options that it will provide for you. This webinar will provide a functional overview of the APOS Storage Center solution, including:


  • Business rules driven archive of report instance
  • On-line and off-line archiving

Backup and Versioning

  • Business rules driven backup of report instances
  • Business rules driven backup of report objects with version controls

Selective Restore

  • Restore specific objects without system downtime

Dynamic Exporting

  • Conversion to neutral format and compression for long-term storage

Intelligent Purging

  • Selective purging of instances from main environment

Friday, February 24, 2012

Building a Better Fleet with Location Intelligence

You know a technology has arrived when it starts affecting each and every one of us at some basic level without us being aware of it. Like the price of corn, simple things can have giant effects. has a case study that demonstrates this point well. "Using location intelligence for better truck driver scheduling" tells the story of a company that uses very basic location intelligence to minimize miles driven and balance the driving workload.

There is no knowledge more basic to location intelligence than just knowing where things are at any given moment. That's what GPS gives you. Applying that knowledge systematically to a real business problem creates location intelligence.

In the case of this anonymous company, the dispatcher balances the workload to avoid unnecessary hiring and firing, and plans the most efficient routes for drivers and cargos, saving the company large amounts on wages and fuel, as well as improving customer satisfaction:
Where work needs to be reassigned Joe can update the route planning to add or remove clients against a driver based on the current number of orders, while still keeping a driver focused on delivering mostly in their nearby territory.

Location intelligence is about taking GPS data and using it to manage a fleet more profitably, making informed decisions and planning clearly for the future. It's about having the hard data to use when required to dispose of underutilized assets or request additional drivers.
The rising cost of fuel and commodities is making such simple efficiencies essential.

Via @gpsfortrucks.

Monday, February 13, 2012

Healthcare Outcomes and Business Analytics

In 2001, the Institute of Medicine (IOM), an arm of the US National Academy of Sciences, released a report detailing the many failings of health care provision in the US, and laying out a plan to fix health care. The plan was to become more proactive and less reactive in engaging patients and families to manage their healthcare, improving the overall health of the population, improving the safety and reliability of the healthcare system, coordinating patient care amongst multiple agencies, delivering palliative services, eliminating abuse, maximizing access, and improving the healthcare system's information infrastructure.

In fact, the focus on healthcare IT at the IOM goes back even further. In 1991, they published "The Computer-Based Patient Record: An Essential Technology for Healthcare"(revised 1997), a report heralding computerized patient records as the best hope for higher quality of care.

In the Fall 2010 issue of the Journal of Healthcare Information Management (a publication of the Healthcare Information and Management Systems Society ‑ membership required), Judy Murphy writes about the progress that has been made in healthcare since the IOM's push for better healthcare IT began over twenty years ago:
Robert Wachter, author of two books on patient safety and editor of the federal government's two leading safety Web sites, gives efforts an overall grade of B-, a slight improvement from his grade of C+ when he performed a similar analysis five years ago. Wachter says that overall, the past decade has seen progress in hospitals' responses to accreditation requirements, regulation and error reporting, but health IT has lagged behind, with research in the area slowly advancing and remaining underfunded.
As Judy Murphy notes, progress has been at best mediocre:
Unfortunately, the attractive claims linking health IT and quality outcomes rest on scant empirical data. Several studies and system reviews published in 2009 and 2010 have demonstrated some evidence for cost and quality benefits of computerization at a few institutions, but with little evidence of broader application.
And it seems that the long-term strategic objectives of this initiative have been obscured by the shorter-term tactical objectives:
The modest quality advantages associated with computerization are difficult to interpret, and are clouded by the fact that the quality indicators used today often reflect care process metrics rather than patient care outcomes. In other words, we are measuring how many patients receive smoking cessation counseling or prescriptions for beta blockers; we are not measuring how many patients quit smoking or what their reinfarction rates are.
The bright spot in all of this is the use of clinical decision support tools: also seems clear that implementing and adopting health IT is not enough. The evidence points out that, unless you specifically use systems with clinical decision support tools and paired with practice changes, you are unlikely to improve quality and patient safety and unlikely to achieve overall reductions in health costs.
Before computerization of healthcare records, we said that healthcare was data-rich, but information-poor. Post computerization, it seems healthcare IT is information-rich, but analysis-poor. In other words, we have the information we need to make a difference, but haven't yet applied the appropriate analytics tools and mindset to the larger strategic objectives.

Clearly, budget is a large part of the problem, but in the age of doing-more-with-less, asking for a larger budget is probably a non-starter. So business analytics managers in healthcare need to look at ways to liberate resources from repetitive administrative tasks so they can spend more time adding value to outcomes via better decision support capabilities. You can't focus effectively on the larger issues if you spend all your time resolving the smaller ones.

Friday, February 3, 2012

Location Intelligence and Enterprise Bandwidth

The Constellation Research website has an interesting article on the importance of location in enterprise software. The key insight is this:
If location was stored with objects, that data could then be used to filter information, just like how facets such as time and author are used today... In other words, location is an important data point that could be used to reduce the rapidly increasing amount of information that is being pushed into activity streams.
By leveraging the location aspect of business intelligence / enterprise information, we can refine our searches to the most relevant data, and reduce our use of enterprise bandwidth. So not only does location intelligence allow us to be more effective in targeting our activities, but also to be more efficient in our use of enterprise resources.

Monday, January 30, 2012

Location Intelligence for Alternative Energy Smart Grids

Electrical utility corporations and location intelligence providers have long understood the usefulness of location intelligence to the generation, transmission and consumption of electrical power. The advent of alternative energy supplies and smart grids have made this connection even stronger.

A smart grid:
is a digitally enabled electrical grid that gathers, distributes, and acts on information about the behavior of all participants (suppliers and consumers) in order to improve the efficiency, importance, reliability, economics, and sustainability of electricity services (Wikipedia).
Although the term "smart grid" has been with us for a while, the reality has been slow to develop, largely because smart grid deployment is complex and capital-intensive. For example, one of the first deployments, the Telegestore project in Italy (completed in 2005) saves about 500 million Euros per year, but cost 2.1 billion Euros to deploy. As one of the first such deployments, they had to take responsibility for the design and manufacture of meters, the development of system software, and they had to act as their own system integrator (Wikipedia).

While the world lags in the development of smart grids, the growing popularity of, and need for, alternative energy sources adds a new wrinkle. It's one thing to manage the supply and demand of electrical power efficiently when you have complete control of the rate of generation, quite another when you're using wind and solar, and the wind doesn't blow and the sun doesn't shine.

Growing complexity calls for better ways to analyze data. Smart grids are all about location: where is the power generated? Where consumed? Consumption is obviously an important determinant of where energy should be generated, and alternative generation method, with their low environmental impact, are more amenable to demand-centered location. (NIMBY ‑ not-in-my-backyard ‑ syndrome is likely to be less pronounced then for, say, a nuclear power plant or a hydro-electric dam.)

A recent article in LBx Journal describes the collaboration between SolarReserve and NV Energy. Nevada (NV) Energy manages their smart grid using location intelligence, particularly for site selection, but also for "generating consistent reliable energy to the grid is a whole."

For upper management, location intelligence provides a means of visualizing all of the business intelligence that influences strategic decision making ‑ LI delivers a map of your customers and prospects, suppliers and competitors, assets and liabilities, challenges and opportunities, and your strengths and weaknesses.

For operations, it's all about knowing who is generating and consuming, where and when they are doing so, and how to make supply meet demand without waste.

For more information on location intelligence for utilities, view the recorded APOS webinar:
Location Intelligence: Energize Decision Making in Utilities