How to change the characteristics of an SAP InfoCube

An SAP user is looking to change the values of a characteristic in an SAP InfoCube and wants to know if it's possible to use virtual InfoCubes to manipulate the data.

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....

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

This was last published in March 2010

Dig Deeper on Business Objects and SAP business intelligence

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Jay Narayanan

Sizing hardware for SAP BW applications

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

Should we install SAP BW on the same server running SAP R/3 4.7?

Find out if a department running SAP R/3 4.7 needs an additional server to install SAP Business Information Warehouse (SAP BW). Continue Reading

Choosing an SAP BI/BW database for InfoCube data

An administrator wants to know which databases in SAP BI/BW are best for data stored in an InfoCube. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

Workday to acquire Adaptive Insights for $1.55 billion

Workday says its acquisition of Adaptive Insights, a financial planning and modeling system, will save it two years of ...

Oracle claims it can cut ERP system migration costs by 30%

A migration can cost millions, but Oracle believes its new automation and integration tools can significantly reduce the cost of ...

Key enterprise accounting software features and benefits

To find the best enterprise accounting software, businesses must outline specific criteria and compare those criteria against ...

SearchOracle

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

Oracle 18c features give DBAs incremental database capabilities

Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but ...

Cloud workloads see gradual uptake, but miles to go for databases

A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying ...

SearchDataManagement

Hortonworks cloud options grow via Google, Microsoft, IBM

Hortonworks now supports Google Cloud Storage and has also broadened cloud deals with Microsoft and IBM, aiming to increase cloud...

Evolving data integration strategies target new analytics needs

Most companies don't have a shortage of data, but it's often stored in siloed systems or inconsistent formats -- problems that ...

What goes into a customer analytics data integration framework

Customer data integration is a minefield for IT teams to navigate. But incorporating a set of core technical functions into an ...

SearchAWS

Use service-linked IAM roles to simplify user permissions

While AWS IAM enables control over a cloud environment, it can become a management nightmare. Automate part of this process via ...

Don't overestimate the benefits of serverless computing

It's natural to be curious about new technologies, but the hype around serverless computing far outweighs its practical ...

AWS low-code strategy hones in on back-end services

AWS has yet to unveil a native and general-purpose low-code platform, but some of its services, such as Lex and Sumerian, seem to...

SearchBusinessAnalytics

Data-driven strategy grooms dog care franchise for growth

Camp Bow Wow is growing its day care and boarding business for dogs with the help of a data-driven approach that's powered by a ...

Tableau acquisition of MIT AI startup aims at smarter BI software

Tableau acquires AI startup Empirical Systems in a plan to provide users with automated data modeling capabilities and enable ...

Choosing the right data discovery platform for the enterprise

Obviously, cost and scalability factor into data discovery platform buying decisions, but other features, like visualizations and...

SearchCRM

Banking blockchain part of Pega Infinity platform reboot

This Pipeline podcast features a not-so-serious Q&A with Pegasystems CMO Tom Libretto covering Journey albums, blockchain hype ...

Adobe-Microsoft partnership adds key integrations

Adobe brings its Document Cloud to Microsoft Office 365 and Dynamics 365, making it easier for licensees of both to quickly ...

Data migration software coming for SAP CRM

At Sapphire Now, SAP unveiled C/4HANA, a suite of applications that brings together ERP and CRM. To make it easier to switch, ...

SearchContentManagement

SharePoint hub sites raises migration questions among users

In the newest rev of SharePoint Online, what used to be sub-sites are now new freestanding sites. This change and others may ...

Cloud DAM platforms vs. on premises for digital asset management

Learn about digital asset management and how cloud DAM democratizes media management and delivery across the enterprise while ...

Box workflow gets upgrade with Progressly purchase

Box is hoping to upgrade its workflow capabilities by adding the startup Progressly to its team, while also still partnering with...

SearchHRSoftware

News roundup: TriNet software targets professional services

New specialized products include TriNet software for professional services, QuickBooks payroll for contractors and a ...

AI can reduce workplace bias, says CEO of leading HR group

AI technology may help HR reduce workplace bias, according to Johnny Taylor, president and CEO of the Society for Human Resource ...

How to create an effective employee retention plan

The unemployment rate is low, and your workers are likely being courted by other companies. Here's how to create retention ...

Related Resources

Dig Deeper on Business Objects and SAP business intelligence

Related Q&A from Jay Narayanan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.