Universe Design RSS feed for this section

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

Tuesday, August 10, 2010

0 Comments

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

Finally after three projects and three months later, we are back to finish up our Aggregate Awareness series. In part 1 of our blog, we discussed the definition of aggregates and how to create summary tables. Today we are going to finish the process by showing how to implement these items into a SAP BusinessObjects Universe.

  • Share/Bookmark
Continue reading...

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

Thursday, July 15, 2010

1 Comment

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.

  • Share/Bookmark
Continue reading...

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

Tuesday, July 13, 2010

1 Comment

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.

  • Share/Bookmark
Continue reading...

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

Thursday, May 6, 2010

1 Comment

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.

  • Share/Bookmark
Continue reading...

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

Monday, April 5, 2010

1 Comment

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”

  • Share/Bookmark
Continue reading...

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

Monday, March 8, 2010

0 Comments

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.

  • Share/Bookmark
Continue reading...

What is a Business Objects Universe?

Friday, March 13, 2009

7 Comments

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.

  • Share/Bookmark
Continue reading...