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

Unit4 ERP cloud vision is impressive, but can it compete?

With the upcoming Unit4 ERPx, the Netherlands-based vendor is again demonstrating its ambition to challenge the market leaders in...

Five keys to using ERP to drive digital transformation

Digital transformation is critical to many companies' success and ERP underpins that transformation. Here's a look at how to make...

Panorama Consulting's report talks best-of-breed ERP trend

The top ERP vendors offer distinct capabilities to customers, paving the way for a best-of-breed ERP approach, according to ...

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

MongoDB Atlas Online Archive brings data tiering to DBaaS

MongoDB's online archive service gives organizations the ability to automatically archive data to lower-cost storage, while still...

Ataccama automates data governance with Gen2 platform update

Data management vendor Ataccama adds new automation features to its Gen2 platform to help organizations automatically discover ...

IBM to deliver refurbished Db2 for the AI and cloud era

IBM has a tuned-up version of Db2 planned, featuring a handful of AI and machine learning capabilities to make it easier for ...

SearchAWS

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

New Amazon grocery stores run on computer vision, apps

Amazon dives deeper into the grocery business with its first 'new concept' grocery store, driven by automation, computer vision ...

Amazon's sustainability initiatives: Half empty or half full?

Amazon's public perception and investment profile are at stake as altruism and self-interest mix in its efforts to become a more ...

SearchBusinessAnalytics

Big data streaming platforms empower real-time analytics

Data streaming processes are becoming more popular across businesses and industries. Read on to see how streaming platform ...

Coronavirus quickly expands role of analytics in enterprises

While NLP and embedded BI were expected to be key analytics trends, the effect of the pandemic on enterprises' takeup of ...

Event streaming technologies a remedy for big data's onslaught

Event streaming is emerging as a viable method to quickly analyze in real time the torrents of information pouring into ...

SearchContentManagement

How a content tagging taxonomy improves enterprise search

Creating an enterprise taxonomy can help users more easily find the content they need when searching through files in a content ...

Compare information governance vs. records management

Information governance focuses on the framework a business must follow for managing information, while records management focuses...

5 best practices to complete a SharePoint Online migration

Moving from an on-premises system to SharePoint Online offers businesses new capabilities, such as Power Suite and site analytics...

SearchHRSoftware

Internal talent marketplaces bloom as workforce changes

In this sluggish economy, employers are turning to internal talent marketplaces to connect employees to short-term projects.

HR can't afford to overlook systemic inequity -- here's why

Katherine Giscombe, organizational psychologist and management consultant, argues that firms need to address systemic inequity ...

Understand workplace COVID-19 contact tracing issues, methods

COVID-19 contact tracing for offices, businesses, restaurants and other workplaces is a challenge for employers. Here is a look ...

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

Please create a username to comment.