David Taylors Business Intelligence Blog

When I was growing up I always enjoyed putting puzzles together. I loved the challenge of putting all those pieces together so that I could see the whole picture. Sometimes I would borrow a puzzle from a friend and as I was close to finishing the puzzle, I would discover 1 or 2 puzzle pieces were missing. The puzzle was incomplete.

From a BI perspective, APOS has been a long partner of BusinessObjects. My first opportunity to work with APOS came while I was working at Crystal Decisions. Our next generation Crystal Enterprise product was new and although it provided a great framework for the future, there were a few pieces missing from our complete BI picture. Thankfully, APOS developed a number of powerful solutions to fill those gaps so that our customers didn’t have to wait until tomorrow’s release for the functionality they needed today.

Do you feel you are missing a piece from BusinessObjects XI 3.0?

Business Objects has many great partners, but probably non-better than APOS. In January of this year, APOS was awarded the Business Objects Technology Partner of the Year Award for 2007. They have used the BusinessObjects SDK more extensively than any other BusinessObjects partner. They don’t just one solution. Their tools provide dozens of potential missing pieces that might fit your BI puzzle.

My Favorite APOS Tools

So what’s so great about APOS? Well, here are my top 3 list favorite solutions:

1. InfoScheduler – mass scheduling – dead simple. Scheduling has always been one of those areas were BusinessObjects added a few new features with ever release. Unfortunately however it’s not an area that tends to get a lot of attention. It was only in XI 3.0 that we introduced native bursting within the platform. InfoScheduler provides an Excel-based report scheduling tool that allows mass scheduling of reports from an Excel spreadsheet. How easy is that? Can you say zero training? Users can copy paste, import, export data into Excel to provide scheduling for 10, 100 or 1,000s of reports.
2. Object Manager – Although the CMC is a comprehensive administration console, administrators of large reporting environment often struggle with managing this volume of information. In XI 3.0, BusinessObjects introduced a number of new enhancements which made working with multiple objects much easier; however Object Manager takes it to the next level. You can manage users, groups, reports, security and even the report life cycle process. Object Manager provides power, ease-of-use and flexibility.
3. KPI – One of the most common requests I hear from customers is the ability to do reporting off their CMS. BusinessObjects XI provides an auditing database to allow customers to report off of user activity, but how do administrators report off the objects within the CMS? With KPI, APOS allows you to extract all the XML metadata that is stored within the CMS to an external relational database. Now you can create reports that allow you to:

• Analyze Business View and Universe configuration information
• Examine Crystal and Desktop Intelligence report structure
• See How many reports use the database field profit
• Show CMS Statistics
• Discover how many reports are scheduled to run tomorrow.

You can even set an automatic schedule to refresh the external metadata database on a regular basis. It’s your own mini-datamart for reporting off your BI system. You have to see it to believe it.

Southwest is using all three of these tools and several more!

Can’t Find Your Missing Piece?

If you’ve look through the APOS website and you can’t find the type of functionality that you feel is missing from BusinessObjects, call APOS anyway. Necessity is the mother of invention. Each of the solutions that APOS provides today was developed from the real-world needs of customers just like you. APOS would love to talk to you about extending BusinessObjects in a way that they may not have thought of.

Puzzle Complete

As a kid I was rarely able to find the missing puzzle piece, but in the area of extending BusinessObjects, APOS continues to deliver. Their depth of experience means they understand how BusinessObjects works today and how to make it work better for you tomorrow.

Okay – so the auditing and query management that comes with SAP BusinessObjects doesn’t do it for you? Need more umph? Do you want more real-time information about your BusinessObjects system? Are you experiencing query and database performance problems? Need to identify long running queries and kill them?

Every once and a while you hear about a partner technology that makes you say, Wow! And that is what I said when I saw a demonstration of the solution from Teleran.

These guys are amazing and have a great solution for customers that are running Microsoft SQL Server, Oracle or DB2 (no Teradata yet). They have created specialized listeners in their iSight tool that watches the traffic and logs the activity in real-time. They even have a universe and reports already built using SAP BusinessObjects so that you can get up and going quickly. If you find a particular query is taking to long, perhaps you need to tune the universe and tweek the database. Teleran can show you the problem.

If you are having problems with user generating bad SQL, out-of-compliance queries, or if you simply want to add additional governs around the system they also have a tool called iGuard. iGuard is integrated directly into tools like WebIntelligence, so instead of a user getting a message like, “Query Error ODBC – Unable to Connect”, then can get a message like, “The product server is currently down for maintenance. Please try again in 25 minutes”. Now THAT is user friendliness.

Because Teleran understands how SAP BusinessObjects works, even if you are using a single user id such as “report_user” at the database level, Teleran can read the user, universe and connection, etc. information and let you easily audit who is doing what at the database level. Don’t worry about turning on database logging and slowing down your production database. You can offload the work to Teleran.

The Greatest Part of All

The greatest part of Teleran is not that it’s a great solution for SAP BusinessObjects managers and administrators, it’s great for the entire EDW. Why? Because Teleran runs between the database and the query tool and is NOT SAP BusinessObjects dependent. You see, it can monitor ALL queries – not just queries from BusinessObjects. This means that if you have users access the database via TOAD, you can turn it off. You can turn off access to any unauthorized reporting/SQL generating tool.

To me, this seems like a must have solution for organizations who are struggling to get a handle on their data warehouse and need to make sure they are delivering a robust and high performing environment.

Check it out! You’ll be glad you did.

I just read a great article that I agree with wholeheartedly. John Myers writes a regular blog on BEYE website. Unfortunately he doesn’t provide a trackback, so I can’t easily reference his original posting, but here’s what he says:

The next time that I hear about how IT departments want to drive to a standard, I will forward to them either this Elana Varon interview with Gary Hamel, famed business strategist, or just send them in the direction of his new book.

Hamel rightly points out in Varon’s interview that too many IT organizations are moving toward a best practices model rather than a best for business model:

“So many companies are now running the same software platforms, whether Oracle or SAP or whatever. Increasingly, we rely on the same handful of off shoring companies or IT service companies. There are a whole lot of things that IT folks have to do to keep up as part of the IT arms race, but in the end the only thing that’s really going to make a difference is whether you’re using IT in a unique way to do unique things where you don’t find any other benchmarks. If you ask the average CIO what percentage of his total budget and headcount is devoted to things that are unique to his industry, I think it’s probably too small a number.”

For every opportunity to optimize business operations, those IT departments are taking one step away from maximizing the unique attributes of the business. In telecommunications, management needs to focus their strategies, and budgets, on what will break them from the pack of the “established” telecos (ie AT&T, Verizon, Vodafone, Telefonica) and position them for a unique position or offering that will provide competitive advantage.

Since I work for Business Objects, it’s my job to work with companies and help them to use Business Intelligence as a competitive advantage. The problem is that so often it’s the IT organizations that try and keep you at arms length. They treat you as “a vendor” and not as a strategic partner… and yet in my experience there are two key qualities which set companies apart:

1. The Acknowledgment of BI as a technology to provide strategic, competitive advantages
2. The mandate from upper management to realize those advantages

What companies so often don’t understand is that BI can be a GREAT vehicle for that competitive advantage. The marketing departments of every successful software company have articles about ROI, increased revenues, increased efficiencies, decreased costs, ROI, etc.

But what about long-standing competitive advantage?

This is especially critical in industries such as telecommunications where competition is fierce and we continue to see major innovations as these companies uses technology to set itself apart, but one of the biggest challenges is to know where you are today and were do you go from here? It’s amazing to me how many companies lack a comprehensive view of key corporate metrics. If you don’t know where you are, how are you supposed to know where to go next?

Do you know the answers to some of these key questions about your customers and products?

• Should we focus on customer attrition or on customers who are spending less that they did previously?
• How do targets affect discounts?
• Which products are discounted the most? Why?
• What is the spending profile of my different customer segments?
• How much revenue came from new vs. existing customers?
• Who is making the most revenue from the least number of sales?
• What percentage of our customers deliver the top 25% of our revenue?
• Why are customers moving from one segment to another?
• How soon after the sale do customers call for help? What products do they need help with?
• Did customers receive adequate training and information about the product?

Business Intelligence provides you a framework to answer all these types of questions. Most organizations have this data somewhere in their enterprise data warehouse or operational system but either don’t see the value or have yet to make the appropriate investments and having the data but not turning that data into intelligent information, is like burning money.