Your SAP Resource  »  Publications  »  SAP Experts  »  BI Expert Online

Log In  |  Help

BI Expert

SAP BI/BW/BusinessObjects
concepts, technology, and
best practices

Part of the
SAP Experts
knowledgebase

Subscribe/Renew Now

Browse by Category  |  Advanced Search »

Go

Home

Knowledgebase Overview

Article Index  |  PDF

Free Sample Article

Frequently Asked Questions

Downloads

Webinars

BI 2011 Conference

SAP Insider Event Calendar

SAP Experts Knowledgebases

About Us

Contact Us

Knowledgebase  »  Volume 5 (2007)  »  Issue 7 (July and August)

Avoid Full Data Reload
Use Reverse Loading to Substitute InfoCube Characteristic Values  Print

by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss Group Ltd., Israel

Become familiar with a method for substituting InfoCube characteristic values that avoids a full data reload: reverse loading.

Categories: ABAP, Data Management, ETL

BI/BW, BW, Extraction, Transformation, and Loading, IT

Key Concept

A characteristic is an object that presents the elementary dimension component in the BW star schema model such as customer, product, company, or sales organization. Key figures of an InfoCube relate to characteristics that supply additional information to each key figure.

Many business scenarios, such as updating inconsistent data, require you to substitute InfoCube characteristic values. In this article, I’ll discuss a technique that involves a reverse load. See my July/August 2007 BW Expert article “Avoid Full Data Reload: Use Selective Deletion to Substitute InfoCube Characteristic Values” for steps outlining the procedure of selective deletion and for a table outlining when you might want to use each technique.

Would you like to see the full version of this article?

If you are an electronic license holder to BI Expert, please click here to log in.

If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the BI Expert online knowledgebase — click here to see the available subscription options.

Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team.

Isn't your SAP implementation worth world-class information support?

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
BI Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.