Home > Ask the SAP software/management Experts > SAP BW reporting Questions & Answers > Using ODS objects for reporting purposes in BW
Ask The SAP Expert: Questions & Answers
EMAIL THIS

Using ODS objects for reporting purposes in BW

Peter Scott EXPERT RESPONSE FROM: Peter Scott

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 30 November 2006
Our BW team uses ODS objects for most reporting purposes, which causes our database to grow at an alarming -- and probably unsustainable -- rate. Query performance is terrible, since many of these ODS objects are around 30 million rows in size -- yes, really 30 million. The team feels that they must use ODSs as they record data at the line-item level rather than at a more aggregated level.

Is there a better way to store and report on such detailed information? Personally, I feel that they are using BW in the manner which they used Business Objects and have applied the same logic. We really need to move them away from such large objects.


>
Usually, it is recommended that all reporting occur off of InfoCubes, as performance will be better. It is still necessary at times to look at line item details, but you're going to have performance issues, as you've identified.

There are many architectural considerations to your question as you may want to look at how you've modeled your data and how you have rolled up InfoProviders from a level of ODS objects to InfoCubes and again up to MultiCubes. With the right data architecture, you can push most reporting to a cube level and use jump targets or report-report-interfacing to access line item data is a controlled manner when required.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
SAP BW reporting
Negative project totals query in BW reporting
Web application template printing enhancements in SAP BW reporting
How to locate screenshots of SAP BW
Is there a reporting procedure for MultiCubes?
Training will help in creating a business case for SAP BW
Move from data warehousing to SAP BW with ABAP skills
Potential SAP BW interview questions
Learn the basics of reporting with SAP BW 3.5
Secure an Info Cube in SAP BW
Formatting a BW Query in a Web template the same as in BEx Analyzer

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SAP White Paper Topics
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts