Remodeling InfoProviders

You want to modify an InfoProvider that data has already been loaded into. Remodeling allows you to modify the structure of the object without losing data.

There are various possible reasons for modifying an InfoProvider that already contains data:

• You want to replace an InfoObject in an InfoProvider with another similar InfoObject. For example, you have created an InfoObject and now you want to replace it with an InfoObject from BI Content.

• The structure of your company has changed. This means that InfoObjects have to be compounded differently.

Before starting remodelling, you should make sure of the following:

• Process chains that run periodically and affect the InfoProvider in question must be stopped until remodelling is completed.

• There must be enough table space on the database.

• After remodeling, you need to check which BW objects (such as transformation rules and MultiProviders) connected to the InfoProvider have been deactivated. You need to reactivate these objects manually. Remodeling invalidates any existing BEx queries on the InfoProvider. You need to manually adapt these to the remodeled InfoProvider. If you have deleted an InfoObject, you have to remove it from the query.

A remodeling rule is a collection of modifications to your InfoProvider, which you perform in one go.

You have the following options during remodeling:

For characteristics:

• Add and Replace with:

  • Constant

  • Attribute of an InfoObject belonging to the same dimension

  • Value of a different InfoObject belonging to the same dimension

  • Customer exit (for user-specific coding)

• Delete

For key figures:

• Add:

  • Constant

  • Customer exit (for user-specific coding)

• Replace with:

  • Customer exit (for user-specific coding)

• Delete

Units cannot be replaced or deleted. This avoids having key figures without the corresponding units in the InfoCube.