Posted on 2007-07-26
Last Modified: 2013-12-08
Hi Experts,

I'm an Oracle developer. Curious to learn SAP BW. What best site for white papers, artcles to start with basics of SAP BW. Your help is greatly rewarded.

Thank you,
Question by:victory_in
    LVL 6

    Assisted Solution

    Depends on exactly what you're looking for.
    the SDN at is a good place to start. White papers also available at Only real downside is that you need a user.
    You can ofcourse ask questions HERE.
    And I tend to like for some of the "straight forward" stuff, as SAP and the SDN tends to "sugarcoat" everything or make it barely legible in their descriptions.

    the REALLY huge question is: Do you know what SAP is ? Because BW is more or less just a set of programs for a default SAP installation. Being an Oracle developer, I would assume so. Which again begs the oroginal question: What exactly are you looking for ?
    LVL 63

    Accepted Solution


    Author Comment


    Am I loking for basic BW stuff. What is infocube, infosource, infoobjects, star shema, update rules, transfer rules. I know all of these. But just would like to know more on this. Just want to switch over to SAP.

    Thanks gentlemen
    LVL 6

    Assisted Solution

    IRK... That's like asking a mechanic "how does a car work". Thre's really a lot of stuff in all of this. It's far too complex to put into a few statements.

    I'd recommend getting the BW courses avaiable near you. SAPBI (introduction, and BW310, BW340 and BW350. This should not only answer your questions, but also make you able to administer and create reports in a BW system.

    A "shortlist" of he basics of a BW application:

    An infocube is a subset of data that has been loaded into the system containing lots of information available to view from various "angles" (or sides if you want to keep the cube thingy going for you). The data can this way be presented fast and uniformely and still be available in specific layouts. R3 reports can do this TOO, but they take time to build, and you need to build one everytime it's requested (usually). The data is "layered" in the cube by assinging it dimensions (sides), and defining the contents by creating aggregates of the data. Data is loaded as "objects" (infoobjects) from a source (infosource, usually an R3 system, but this can be anything that contains business relevant data) and then transformed to "fit" in the cubes.... Well, that's not how it TECHNICALLY happens, but it's the best way to explain it WITHOUT getting technical.
    There are lmits to what you can put, how much you can put etc. Some limits are set by order of importance. Old data may turn obsolete in a hurry (who needs LAST months sales report, anyway ? A summery of the numbers is enough) when they're replaced. However, "overloading" the cubes is still a huge problem, and can cause bad data representation, performance issues, and will often get half the sales reps and board of directors on your ass if things aren't performing as expected.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    I showed you how to use console view (HERE ( -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
    Note: You must have administrative privileges in order to create/edit Sharing Rules. ( (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now