By
Published: 12 Mar 2010
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?
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.
Dig Deeper on SAP business intelligence
An SAP user is looking to assess the hardware requirements for an SAP BW application and wants to know what the parameters are of sizing hardware for...
Continue Reading
What is the difference between data on SAP R/3 and data on SAP BW?
Continue Reading
Wondering how to choose between a career in SAP Basis and a career in SAP BI? Learn how to evaluate jobs based on your skills.
Continue Reading