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.

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.