Data Modeling Advice: Where Do I Put My Sales Area Data?

  • by Ned Falk, Senior Education Consultant, SAP
  • June 1, 2003
How you break up your sales area data into dimensions will have an effect on performance.

Dear BW Expert;

I don’t know enough about modeling SAP-specific entities. For example, should sales area (organization, division, distribution) be in a dimension by itself or associated with customer?

BW Consultant

Data modeling is a discipline that affects both end users and back-end system administrators. Do it poorly, and your users might not get their data. Or, they might get the intended data, but it will be retrieved so slowly that they might not wait for it.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

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.