Ask the Expert

How to change the characteristics of an SAP InfoCube

I have a requirement to change the values of a characteristic in an SAP InfoCube (i.e., source/product/customer/valid week).

The above data is the format we feed to the InfoCube, but our client wants to change the values in the source column. If anyone calls and says we cannot source the product from this for this valid week, the client needs the ability in the InfoCube to change the source value.

I know this is not standard with SAP InfoCubes, but do you know of any roundabouts to achieve this? Can we use virtual InfoCubes to manipulate the data in the cube and save back to the cube?

    Requires Free Membership to View

This requirement looks more like an online transaction processing (OLTP) application requirement which cannot be done easily in SAP BW. Since SAP BW is a data warehousing system, changes to transaction data need to be generated from the source system. This is the best way of designing and using SAP BW applications. You may try to see if the source can be made a time dependent master data of product to get this accomplished. If not, providing an application in the source system and loading data from this source is the best solution.

This was first published in March 2010

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: