Achieve More Flexible Reports Using Time Distribution in Update Rules

  • by Gary Nolan, SAP BI Strategic Architect, Sapiex Associates LLC
  • November 1, 2005
Discover how you can use time distribution in update rules to combine data with differing levels of granularity. Step through the configuration for time distribution and familiarize yourself with the concept via examples.
Key Concept
Time distribution allows you to change granularity of data and allocates data equally across time periods. This enables you to report on monthly data as if it were daily data.

You cannot combine two different data sources with different time characteristics. For example, say you load daily sales data from R/3 with a time characteristic of 0CALDAY into a sales analysis InfoCube. Management needs you to combine this sales data with data from another non-SAP R/3 source that provides only monthly sales data.

This creates a challenge when viewing data at the daily level because you must disaggregate the monthly data to daily values to create a daily analysis of both types of data. It is difficult to manually disaggregate data. You could attempt to create a custom start routine in the update rules to allocate the monthly data across days, but there is a much easier and more efficient way.

Gary Nolan

Gary Nolan is an SAP NetWeaver BW-certified consultant and author of Efficient SAP NetWeaver BW Implementation and Upgrade Guide and Efficient SAP NetWeaver BI Implementation and Project Management. Gary specializes in gathering and evaluating requirements, configuring SAP NetWeaver BW, and providing project management, performance management, and data architecture and data modeling expertise. A former platinum consultant with SAP America, Inc., Gary has more than 20 years of SAP experience, working with SAP NetWeaver BW since version 1.2B.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.