Posted on 2007-07-26
Medium Priority
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
  • 2

Assisted Solution

Twisteddk earned 600 total points
ID: 19582414
Depends on exactly what you're looking for.
the SDN at http://sdn.sap.com is a good place to start. White papers also available at service.sap.com Only real downside is that you need a user.
You can ofcourse ask questions HERE.
And I tend to like www.sapfans.com 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

SysExpert earned 900 total points
ID: 19582420

Author Comment

ID: 19583250

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

Assisted Solution

Twisteddk earned 600 total points
ID: 19588928
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

612 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