Using a replacement path variable to create a formula

Learn how to use a replacement path variable to create a formula, with advice from BW expert Peter Scott.

Traxion Consulting, Inc.

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.

How can I use the value of the variable in the selection parameter (user input) in creating a formula?

You can do so with a replacement path variable, where you incorporate the user input value to be incorporated into the calculated key figure formula. For instance, by allowing a user to enter an interest rate on the query selection screen, that will be used as an operand.

This was last published in September 2005

Related Q&A from Peter Scott

Web application template printing enhancements in SAP BW reporting

Enhance SAP BW report printing for Web application templates by using the advice in this expert response by Peter Scott. Continue Reading

Using ODS objects for reporting purposes in BW

ODS objects support detailed information for reporting needs but can cause query performance issues. Peter Scott considers the options for BW ... Continue Reading

Negative project totals query in BW reporting

In this expert response, Peter Scott exposes how to query only negative projects in SAP BW reporting. 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

Acquisition gives ERP public sector firm Tyler a data cloud

Tyler Technologies, a firm solely focused on government verticals and public sector ERP, has added data-as-a-service capability ...

Blockchain adoption must overcome hurdles

Blockchain applications are not yet widespread, but here are three business models that will be affected and three hurdles to ...

Santa Fe's ERP implementation project fix stirs debate

ERP implementation projects may be IT's most challenging, something the city of Santa Fe, N.M., found out. City officials needed ...

SearchOracle

Collaborate 18 to track progress of Oracle cloud database, apps

The Collaborate 18 conference will shine a light on Oracle cloud adoption and migration issues, and on the impact that such moves...

Oracle Autonomous Database debut heralds new cloud hopes

It wasn't the first in the cloud computing space, but Oracle is all in now. Key to the effort is a new Autonomous Database ...

Oracle cloud services aim to pull users out of IT comfort zone

Oracle has gone all-in on cloud computing and expanded its line of cloud services in the hopes users will make the jump. But ...

SearchDataManagement

GDPR data protection edicts make good data governance a must

The European Union's new GDPR law puts the onus on companies to ensure that their data governance and management practices enable...

GDPR rules can spur broader steps to protect sensitive data

Companies need to make compliance with GDPR's requirements on managing personal data a priority, but they should also work to ...

Data integrity protection spurs greater security spending

As hacking, ransomware and malware attacks mount, companies place big data protection and integrity among the primary reasons for...

SearchAWS

Amazon FreeRTOS aims to simplify, secure IoT deployment

Operational technology teams have been slow to update microcontroller software due to safety and logistics concerns, but Amazon ...

Test your knowledge of GDPR rights and AWS data protection

Is your enterprise GDPR-compliant? Take this quick quiz to test your knowledge of the EU regulation, as well as relevant AWS data...

Support for Node.js in AWS Lambda slowly, but surely, evolves

Developers who need the latest version of Node.js for a serverless platform might turn to Lambda rivals to meet that need. But ...

SearchBusinessAnalytics

Cambridge Analytica-Facebook case shows need for ethical data mining

Ethical data collection practices are becoming even more important, as cases like Cambridge Analytica's misuse of Facebook data ...

Rethinking analytics processes spurs enterprise innovation

By taking a fresh look at the makeup of their analytics organizations, enterprises can innovate their business models and take ...

Diversified data sets for analytics deliver top results

Analytics teams should focus on data diversity to ensure that their projects deliver the most meaningful insights -- but they ...

SearchCRM

Measure your digital marketing ROI, keep your job

Oracle customers weigh in on executive's hypothesis that analytics can now prove ROI of the martech stack -- or soon will -- and ...

Oracle CX Cloud adds AI tools for B2C, B2B customers

Oracle announces infusion of its Adaptive Intelligent apps into several CX Cloud products and promises more to come, with sales, ...

Marketing automation platforms merge CRM and content

Building a martech stack includes a main automation hub such as Marketo, Eloqua, HubSpot or Pardot. Then comes the hard part: ...

SearchContentManagement

How a digital transformation process helped curb reliance on paper

By moving on from paper, the North Carolina Court System and the Texas Animal Health Commission were able to accommodate ...

Intelligent information management is ready for AI, blockchain

A panel discussion at AIIM 2018 looked at how AI, cloud and blockchain will disrupt the intelligent information management space.

SharePoint 2019 on premises the talk of SharePoint Fest D.C.

This episode of the Pipeline podcast breaks down SharePoint users' concerns about data migration, on-premises version support, ...

SearchHRSoftware

Video interview platforms make headway against consumer tech

Some recruiters prefer the familiarity of popular video tools, like FaceTime and Skype, but they may be missing out on the rich ...

Workday payroll system covers Minnesota healthcare network

A big physicians group affiliated with the University of Minnesota Medical School opted for a Workday cloud payroll system to ...

Federal HR seeks corporate simplicity, says its new chief

Federal HR has a new reformer, Jeff Pon, the director of the U.S. Office of Personnel Management. He wants to modernize federal ...

Related Resources

Dig Deeper on SAP business warehouse

Related Q&A from Peter Scott

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.