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.

Peter Scott, Traxion Consulting, Inc.

Published: 08 Sep 2005

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.

Dig Deeper on SAP Business Warehouse

Related Q&A from Peter Scott

Potential SAP BW interview questions

Learn some potential interview questions for a position in SAP BW from BW reporting expert Peter Scott. Continue Reading

Can I change the InfoProvider that a query uses?

Is it possible to change the cube used by a BW query? We have a number of identical cubes representing a quarter's history data. Rather than build a ... Continue Reading

Help! My BEx report is rounding up values

SearchERP

Review of global supply chains a delicate undertaking

A federal review of vital global supply chains such as semiconductors will likely produce a 'carrot/stick approach' to change, ...

Call to review critical supply chains praised, questioned

The Biden administration is requiring federal agencies to conduct a review of critical supply chains, dividing analysts on what ...

SAP cloud migration effort enters new, accelerated phase

With strong cloud growth already on the books and the new Rise program enticing customers to S/4HANA Cloud, 2021 could be the ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Microsoft ignites Apache Cassandra Azure service

Microsoft rolled out a series of enhancements for the company's cloud data efforts, including updates to Azure Cosmos DB and a ...

Airbyte set to advance open source data integration platform

The CEO of a data integration startup explains how he is looking to grow the technology and community behind the vendor’s open ...

Open source database migration guide: How to transition

Open source database transitions have been on the rise as they prove to be worthy competitors to commercial database options, but...

SearchAWS

Is construction Amazon's next target for disruption?

Amazon has already made inroads into the construction industry and experts speculate that there will be more to come. ...

Amazon's impact on publishing transforms the book industry

Amazon changed the way we publish, purchase and read books. Publishing experts said they expect more industry disruption to come.

How Amazon and COVID-19 influence 2020 seasonal hiring trends

Retail and logistics companies must adapt their hiring strategies to compete with Amazon and respond to the pandemic's effect on ...

SearchBusinessAnalytics

Gartner emphasizes augmented analytics in new Magic Quadrant

Augmented intelligence features and value are what separate leading BI platforms from the rest, Gartner analyst Rita Sallam said ...

Qlik analytics platform keeps focus on active intelligence

With new data catalog capabilities and enhanced SAP connectors, Qlik continues its focus on the concept of active intelligence to...

Top 8 business intelligence challenges and how to handle them

BI teams face various technical and project management challenges on deployments. Here are the top BI challenges, with advice on ...

SearchContentManagement

8 business benefits and challenges of video conferencing

Remote work necessitates software such as video conferencing software. Consider both the business benefits and the challenges ...

Document management vs. content management: How they differ

The sheer number of acronyms involved in enterprise content can get confusing. Let's break down the differences between content ...

5 benefits of enterprise content management (ECM)

ECM is a hefty investment, so it's a good idea to evaluate all the benefits before making a purchase. Understand how ECM benefits...

SearchHRSoftware

Lawsuit challenges Amazon's treatment of Black employees

Amazon is facing a lawsuit from a corporate employee who details inappropriate behavior of co-workers and broad allegations ...

Top 5 components of a workplace mental health strategy

Promoting mental health in the workplace requires creating an empathetic and stigma-free culture for employees. Learn five ...

5 assets working mothers bring to the workplace

Mothers are an important -- and often undervalued -- sector of the workforce and offer a number of assets. Learn why HR and ...

target function

Manufacturing analytics puts raw materials to the test

Book excerpt: Production Planning and Control with SAP ERP

Get the most out of SAP BusinessObjects Web Intelligence, Xcelsius