Why Ad Hoc Reporting Won’t Work (part 5): If I Give Them Ad Hoc Access to Data, They’ll Keep Asking For More

Back in March I posted “Five Reasons Why Ad Hoc Reporting Won’t Work In Some Organizations“. In that post, I listed some of the major concerns that I hear from potential clients when the subject of ad hoc reporting is broached. We’ve already addressed “Our people aren’t smart enough to create their own reports”, “We need to massage the data first”, “I don’t want people poking around in data they shouldn’t have access to”, and “I already pay people in IT to create reports”.

As a conclusion to this series, let’s look at out final topic: If I give them ad hoc access to data, they’ll keep asking for more.

Why Ad Hoc Reporting Won’t Work (part 4): I Pay People in IT to Create Reports

One of the other reasons I hear is that managers don’t want to train end-users to create reports, since they have folks in IT that already tasked with that. Some report authoring will always need to be handled by IT, due to it’s complexity, lack of data availability, etc… But I argue that the lion’s share of the development can be handled within each department instead, freeing IT developers to take on other projects critical to the organization.

Why Ad Hoc Reporting Won’t Work (part 3): I don’t want people poking around in data they shouldn’t have access to

Data security is typically a really a big deal for organizations, and it SHOULD be. Thankfully, SAP BusinessObjects offers a number of ways to provide security around functionality, content and data. With some careful planning and a well-designed SAP BusinessObjects implementation, you can rest assured knowing that users will have access to only the information that they are supposed to see.

Aggregate Awareness! What is that? (Part 1 of 2)

In the SAP BusinessObjects community, when someone talks about “AA” they don’t mean the meetings people attend, they are talking about a pretty cool function that is available in Designer. Aggregate Awareness or @aggregate_aware is a term that we use to describe the ability of a universe to utilize aggregate tables in a database. Using the function correctly can greatly improve the performance and user experience. This will be the first of two blogs and will talk about Aggregation and Summary tables. The second post will show how to implement Aggregate Awareness into a SAP BusinessObjects Universe.

Tips for Developing BI Extranets

Over the past eight years or so, we’ve developed a number of business intelligence extranets for our clients. One of our first solutions was developed on top of Business Objects 5.1, and we have touched virtually every subsequent release including Business Objects 6.1, Business Objects 6.5, Business Objects XI, and now…SAP BusinessObjects XI 3.1. (We’ve even had the pleasure of updating several of these applications when the Business Objects SDKs were changed after the Crystal Decisions merger.)

When helping a client plan an extranet, there are a core set of guidelines that we always follow.

Why Ad Hoc Reporting Won’t Work (part 2): We Need to Massage the Data First

Back in March I posted “Five Reasons Why Ad Hoc Reporting Won’t Work In Some Organizations”. In that post, I listed some of the major concerns that I hear from potential clients when the subject of ad hoc reporting is broached. As promised, I will be addressing each of those concerns and showing how they can be overcome. We’ve already addressed “Our people aren’t smart enough to create their own reports.” Now let’s turn our attention to data, and look at “We need to massage the data first.”

Why Ad Hoc Reporting Won’t Work (part 1): Our People Aren’t Smart Enough

I recently posted an article titled “Five Reasons Why Ad Hoc Reporting Won’t Work In Some Organizations”. In that article, I listed some of the major concerns that I hear from potential clients when the subject of ad hoc reporting is broached. As promised, I will be addressing each of those concerns and showing how they can be overcome. Today, we begin with the first one: “Our people aren’t smart enough to create their own reports”

Making Your Measures Behave

Defining measures gets interesting because while they are tied to a high-level corporate goal, they also touch nearly every other aspect of the organization, making it a challenge sometimes to balance all of the competing interests. Plus, as soon as you start converting their behavior into numbers, people will simple adapt their behavior to have good numbers and may not deliver the overall results you had hoped.