Is there a reporting procedure for MultiCubes?

Learn reporting best practices for Operational Data Stores (ODS), InfoCubes, and MultiCubes from SAP BW and BW reporting expert Peter Scott.

Peter Scott, Traxion Consulting, Inc.

Published: 28 Dec 2005

What is the procedure for reporting on MultiCubes?

The reporting procedure isn't any different, at least not from the perspective of an InfoProvider. Operational Data Stores (ODS), InfoCubes, and MultiCubes can all be accessed from the Query Designer. From a back-end perspective it is quite easy to link two or more existing cubes into a MultiCube definition.

Dig Deeper on SAP Business Warehouse

Key figures and web templates in SAP BI Can you use a key figure as a navigational attribute in SAP BI/BW? What about precalculated web templates in BI/BW reporting?

BEx (Business Explorer) In the SAP Business Information Warehouse (BW), BEx (Business Explorer) is the reporting tool used to work with data in the BW database.

How to convert a BW report from BEx format to a WAD template I have a problem when passing a portal user ID to a BW report. I am displaying the BW report not by WAD template but with a BEx query string. How do I convert the BEx format to a WAD template?

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

BEx reporting training material Expert Jay Narayanan offers resources for BEx and BW reporting materials.

Quiz: BW reporting Advance your BW reporting skills with this quiz from SAP BW expert Peter Scott. Learn how to optimize reports and produce results to help business intelligence.

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

Epicor ERP system focuses on distribution

Companies like Jergens Industrial Supply are favoring purpose-built ERP systems like Epicor Prophet 21 for distributors over ...

Digital transformation strategy: 6 steps for success

The failure rate of digital transformation is high, but a smart and detailed strategy can vastly improve the outcome of your ...

Top 7 manufacturing challenges for 2020

Growing supply chain complexity, emerging next-gen technologies and other compelling forces will continue to challenge 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

Amazon cloud database and data analytics expand

AWS expands its Redshift data warehouse capabilities including managed storage and query acceleration at the re:Invent 2019 ...

Vendors move away from open source database software licensing

While open source is a key to success for many database vendors, it can also potentially lead to a competitive threat from a ...

Oracle looks to grow multi-model database features

Decade after decade, Oracle continues to be relevant in the database market as it pivots to include an expanding list of ...

SearchAWS

Overcome these VMware Cloud on AWS migration challenges

Plan ahead for a VMware-to-AWS cloud migration with this breakdown on common challenges organizations face during the move to ...

New AWS cost management tool, instance tactics to cut cloud bills

AWS users like Lyft and Salesforce have figured out how to keep their cloud costs as low as possible, and a new cloud management ...

A complete guide to AWS re:Invent 2019

AWS re:Invent is one of the biggest cloud and IT events of the year. Use this AWS conference guide to get the latest news and ...

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Augmented intelligence features and an in-warehouse data prep tool highlight Sisense's latest update, its second since acquiring ...

Operation Fistula uses data to treat childbirth injuries

Aided by an analytics stack developed by Exasol, nonprofit Operation Fistula is working to end obstetric fistula in targeted ...

Automated tools broaden the future scope of data science

Automated data science tools may make their way into the data science process, but are unlikely to ever be able to do everything ...

SearchContentManagement

New capabilities added to Alfresco Governance Services

The updates are intended to secure electronically stored information residing across different locations in light of recent ...

Top 5 Office 365 skills for SharePoint administrators

Microsoft SharePoint administrators need to branch out in their Office 365 skill set to support products tightly integrating with...

Box cloud content management helps simplify digital work

Box currently has three main areas of focus: integration with enterprise applications, content security and collaboration. The ...

SearchHRSoftware

3 keys to employee engagement measurement

Far too many organizations and their HR departments conduct employee engagement measurement in a way that does more harm than ...

Cornell researchers call for AI transparency in automated hiring

Researchers at Cornell University want vendors to disclose how automated hiring systems are making hiring recommendations. They ...

Why reducing hiring bias isn't easy

Because people may harbor hidden biases, diversity and inclusion initiatives can be difficult to execute. Take an in-depth look ...

Is there a reporting procedure for MultiCubes?

Learn reporting best practices for Operational Data Stores (ODS), InfoCubes, and MultiCubes from SAP BW and BW reporting expert Peter Scott.

Dig Deeper on SAP Business Warehouse

Related Q&A from Peter Scott

Web application template printing enhancements in SAP BW reporting

Using ODS objects for reporting purposes in BW

Negative project totals query in BW reporting

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

Epicor ERP system focuses on distribution

Digital transformation strategy: 6 steps for success

Top 7 manufacturing challenges for 2020

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

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

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchAWS

Overcome these VMware Cloud on AWS migration challenges

New AWS cost management tool, instance tactics to cut cloud bills

A complete guide to AWS re:Invent 2019

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Why reducing hiring bias isn't easy

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.