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.

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”

Creating a Pass through Prompt in Designer (Top N, Industry Standards, etc.)

This topic seems to be a request that comes in on every project that I am on and since I haven’t had a blog post in awhile, I thought it would be a quick and useful blog . Well, the ability to pass through a value into a WebI doc without having it to correspond to any dimensions/details/measures is a pretty simple process and can be easily done using a predefined query filter in Designer. We really have two things we need to look at and that is the logic and the syntax.

What is a Business Objects Universe?

A Business Objects Universe is the semantic layer that resides between an organization’s database and the end user but more importantly, it is a business representation of your data warehouse or transactional database. It allows the user to interact with their data without having to know the complexities of their database or where the data is stored. The universe is created using familiar business terminology to describe the business environment and allows the user to retrieve exactly the data that interests them.