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

Resistance to all-in cloud ERP systems is large

For many enterprises, ERP and HCM deployments may take the path of hybrid deployments, a trend that is supported by Hewlett ...

Postmodern ERP countered by continued appeal of single suite

The loosely coupled enterprise applications that Gartner predicted may indeed be here, but integration and data integrity ...

SaaS ERP systems can include hidden costs

Cloud hype tells us that SaaS ERP systems are less expensive to run than on-premises systems, but experts warn of hidden costs ...

SearchOracle

Breaking down AI-infused Oracle Autonomous Cloud services

Oracle offers AI-infused cloud services for analytics, application development, application and data integration, data management...

Oracle Autonomous Database Cloud gets transaction processing

Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and ...

The future of SPARC/Solaris is cloudy -- in multiple ways

Cutbacks by Oracle have put the future of SPARC and Solaris in doubt, but the vendor says it's still committed to the ...

SearchDataManagement

Containers key for Hortonworks alliance on big data hybrid

Hortonworks is joining with Red Hat and IBM to work together on a hybrid big data architecture format that will run using ...

Big data tooling rolls with the changing seas of analytics

Hadoop data tooling is expanding. A view holds that Hadoop is moving from alternate data warehousing to a full-fledged big data ...

Graph processing gives credit analysis firms an edge

A graph database startup's parallel loading, processing and querying combine to deliver real-time data for fintech firms that ...

SearchAWS

Centralize AWS account management with native SSO tool

Some third-party tools have longer track records, but AWS SSO offers an appealing alternative as a native service to handle cloud...

Assess, manage AWS costs with third-party tools

An ecosystem of third-party products augment AWS' vast portfolio of cloud services, including cost management tools. Dig into ...

Weave AWS CodePipeline into serverless app deployment

CodePipeline brings a number of benefits to serverless app development and deployment, including the elimination of mundane tasks...

SearchBusinessAnalytics

Self-service analytics tools hand BI power to business users

Self-service BI software opens the door to wider analytics uses in organizations. This handbook compares top self-service tools ...

Tableau vs. Power BI vs. Qlik: How the BI rivals stack up

Tableau, Power BI and Qlik Sense offer similar self-service BI functionality, consultant Rick Sherman says. But he points to some...

Tibco analytics capabilities get upgrade in Spotfire X

New Tibco AI and natural language processing functions in the soon-to-be-released Spotfire X look to create a simpler and faster ...

SearchCRM

Adobe acquisition of Marketo could shake up industry

Adobe looking to acquire Marketo could also be a ploy to incite a bidding war for Marketo from its holding company, Vista Equity,...

HubSpot products expand reach into enterprise

HubSpot's VP of products details the newest HubSpot enterprise-level offerings, as well as HubSpot's new video tool. Also: A ...

HubSpot enterprise edition unveiled

In addition to releasing enterprise-level systems, HubSpot unveiled a CMS tool for companies to build and customize websites, and...

SearchContentManagement

New rules for WCM tools enhance the search experience

WCM used to mean platforms for webpages viewed on desktops. Today, it's morphing into digital experiences, and it taps AI as well...

AI-assisted image and video search is next content frontier

You can search text, but it's harder to catalog images and video. New tools are automating those processes at the enterprise ...

Box AI strategy looks to give users AI development tools

Box wants to be the hub of its enterprise users' software and AI content ecosystems with integrations and partnerships ranging ...

SearchHRSoftware

At HR Technology Conference, Walmart says virtual reality works

Virtual reality may be on the cusp of mainstream adoption for HR. It provides an engaging learning experience for employees, ...

AI, data analytics, recruiting tech among HR priorities, leaders say

Leaders from Johnson & Johnson, The Walt Disney Co. and other giants weighed in at HR Tech 2018 on top priorities, such as tech ...

New Sierra-Cedar HR Systems Survey uncovers lack of tech adoption data

At the HR Technology Conference, Sierra-Cedar's survey investigated why tracking HR software adoption is important and how HRIS ...

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.