Help! My BEx report is rounding up values

Traxion Consulting, Inc.

Hi Peter,
We have a cube "CO-OM-CCA: Statistical Key Figures 0CCA_C03" updated with data from R/3. The key figures used here are the quantity entered last (ZQQTYLAST), stock quantity (QUANT_AVRG) and quantity (QUANTITY). We have data for some of the cost centers, for example, the stock quantity as 7.5 or 5.5.

But the BEx report is rounding up these values to 8 and 5 -- the BW report is not giving decimals. Can you help...

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.

me determine the exact values in the BEx report?

You can define display settings for a key figure from the properties menu. From the query designer, right-click on a key figure in the columns pane and choose properties. Under "number of decimal places," choose 0. Repeat this step for the other key figures and then re-execute your query.

If you have defined custom templates in the BEx Analyzer, you may have to change the Excel settings for the columns to show more decimals as well. Usually, however, it's just the properties setting in the query designer that is limiting the display.

This was last published in May 2005

Related Q&A from Peter Scott

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

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

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