SAP BW|BOBJ|Project Management Blog

How To Learn Advanced Data Warehouse Concepts by Using Aggregates

Written by Lonnie D. Ayers, PMP | Fri, May, 11, 2012 @ 08:14 PM

Learn Advanced Data Modeling Concepts

Are you, like so many SAP BW users, suffering from sluggish performance?  Don't really have a big budget for a SAP HANA upgrade yet or even SAP BIW Accelerator?  Don't feel unique!

 

The majority of SAP BW users are still on an older version of SAP BW, usually 3.X or even earlier according to a recent ASUG survey!  As the experts on SAP Business Warehouse, we have found that one very typical problem is a poorly designed data model. 


Therefore, we have spent a lot of time preparing a series of guides based on SAP Best Practices and our own experience as IT Consultants to help you build better, more robust SAP BW Data Modeling guides. 

Learn More About SAP BW Aggregates

 

In our latest guide, Modeling Aggregates, you will find all you need to know to:

 

 

  • Define the Need for Aggregates.

  • Understand what an Aggregate is.

  • Learn how Aggregates can enhance system perform.

  • Learn how to use Aggregates to supercharge SAP reporting performance.

  • Learn why other performance management techniques are also required to fully exploit aggregates.

  • Understand the impact of data granularity on your performance.

  • When and how to partition a table for aggregate performance.

  • Learn which table spaces need to be maintained.

  • Learn when to use automated aggregate creation tools and when to do it manually and some rules of thumb to figure it out.

  • How to choose the dimensions for your aggregates.

  • Choosing the fact you want to measure and include in the aggregate.

  • Know what you cannot do with an aggregate.

 

This is One of Many Advanced Data Modeling Concepts

 

As you can see, there are a lot of issues to keep in mind when modeling aggregates.  You may find that our other SAP BW modeling guides are also required to fully understand and build a high performance data model. 

If you are an old hand at Entity Relationship Modeling, you will especially appreciate knowing the difference between ERD and Star Schemas, which is not always easy. 

Finally, we would like to recommend, as part of increasing your understanding of data warehouse concepts, the criticality of proper naming conventions, which we have found can make or break a project.

 

Of course, we recommend you grab a copy of SAP BW Aggregates Data Modeling eBook by clicking the button.

 

 

 

People who read this also read:

Discover How to Model SAP BI Integrated Planning Scenarios

5 Lessons Learned In SAP BW Data Modeling

Get SAP BW Data Modeling Guide Part 1

Infocube Dimensional Modeling

Get SAP BW Data Modeling Key Figures Guide

 

1 Key Tip When Upgrading from SAP BW 3.X to BW 7.X [Checklist]

Understanding Embedded Systems vs SAP HANA

8 Secrets to SAP Enabled Spend Performance Management

 

Thanks