DATAWAREHOUSING(DWH)

What is dwh?what is dwh concept?
DWH is defined as the following-
a)maintaing database
b)analyzing database
c)controlling database
d)updating database
DATABASE is meant for bulk of data which can be analyzed,maintained,controlled and updated by using the concept of DWH.
DWH concept defined as maintaining the historical and the current data for a long period into data base,,,(10yrs,100yrs,...)....
eg: Banking sector,,,,suppose a person gone to a bank and asked to print his proceedings on his passbook of past 1yr then at the counter the bank employee cannot access all the 1yr information of that particular employee,BCOZ the bank maintains only 3 to 4 months of data of a particular employee in the server and remaining data will be in the hard copy like documents which can be in any godown,,,,it means that for maintaining only a one persons data of only 1yr is difficult in this sector,,just think how can we maintain   millions of ppls of data,,..so for this kind of process we use DATAWAREHOUSING concept,,..
TO maintain HISTORICAL AND CURRENT DATA we have many tools in market like
COGNOS,INFORMATICA,HYPERION,ORACLE BI,DBA,SIEBEL,,ETC....but only one tool that gives END TO END SOLUTION FOR DATAWAREHOUSING is SAP BI/BW.
This SAP BI/BW GIVES END TO END IMPLEMENTATION FOR THE DATAWAREHOUSING
CONCEPT,,,..............

INTRODUCTION

hello frnds,,...i m posting my 1st update..

so lets start.......................................................................................SAP stands for SYSTEMS APPLICATIONS AND PRODUCTS IN DATA PROCESSING.

SAP TREE :

Overview of SAP History and BW/BI Evolution

In a SAP life we are full time user/developer of SAP and we have spent lot of time in understanding the components and features of SAP but in this competitive environment I don't know how many people tried to know about the history of SAP. This blog is to help those who are interested to know the history but caught with hectic schedule where they don't find time for their analysis. Here I have compiled several points as easy reckoner to know the history.SAP Enterprise Resource Planning is a product of SAP AG, which is a German based company headquartered at Walldorf. The primary objective is to develop standard application software for real-time business processing
In 1972, the SAP was founded by five former IBM employees.Dietmar Hopp,
 Hans-Werner Hector,
 Hasso Plattner,
Klaus E. Tschira,
Claus Wellenreuther
The SAP is an acronym of German language description, Systemanalyse und Programmentwicklung which means System Analysis and Program Development. After some time the acronym was changed as Systeme, Anwendungen und Produkte in der Datenverarbeitung which means Systems, Applications and Products in Data Processing.
In 1973, the first product SAP R/1 solution based on Mainframe was launched. In 1979, SAP launched SAP R/2 as a result of intensive examination of SAP's IBM database and dialog control system.In 1992, SAP followed the trend from mainframe (R/2) computing to client-server architectures (R/3). The development of SAP's internet strategy with mySAP.com redesigned the concept of business processes.
Note: 'R' stands for real-time data processing.
SAP BW/BI history:

In 1997, the first version of SAP product for reporting, analysis and data warehousing was launched and the product was termed as "Business Warehouse Information System".

Evolution of SAP BW/BI:

Name	Version	Release
BIW	1.2A	Oct-1998
BIW	1.2B	Sep-1999
BIW	2.0A	Feb-2000
BIW	2.0B	Jun-2000
BIW	2.1C	Nov-2000
Name Change, BIW to BW
BW	3.0A	Oct-2001
BW	3.0B	May-2002
BW	3.1	Nov-2002
BW	3.1C	Apr-2004
BW	3.3	Apr-2004
BW	3.5	Apr-2004
Name Change, BW to BI
BI	7	July-2005	BIW => Business Warehouse Information System.

BW => Business Warehouse

BI => Business Intelligence.

We everyone is sticked to the incremental change of version change with enhanced features so always the name change is confusing for us.

Even several SAP BW consultant posted question to know the difference between SAP BW and SAP BI. There is no definite definition for the name change it's just like a normal version change with some addition/modification.

Still the confusion remains how to name the current product, the below SAP blog content helps in certain extent for the clarification.

In 2008, SAP used the term "Business Intelligence" to refer

Ø  SAP BusinessObjects BI solutions and also

Ø  SAP NetWeaver BI.

In order to remove confusion, the term Business Intelligence is now associated only with the solutions from the SAP BusinessObjects portfolio.

So SAP NetWeaver Business Intelligence (BI) is no longer used and instead we refer by,

Ø  SAP NetWeaver Business Warehouse (BW) ,

Ø  SAP Business Explorer (SAP BEx) and

Ø   SAP NetWeaver BW Accelerator (BWA)

SAP BI

HAI FRIENDS,
im SHAIK MUDASSAR working in SAP BI domain as a BI developer,,im here to contribute my best of knowledge for everyone,,i hope i can help u all by my skills via this blogg,,.here im going to deliver knowledge about SAP BI technology in which i would love to cover all the things that u ppl are not aware,,this blog can be usefull for both freshers and employees i hope so,, i can make a good and best stuff here,,join my blog and view my postings updates daily from me and capture it and make a valuable for it....
SAP BI----
In the first session I will cover the following things for u ppl,....
INTRODUCTION
DATAWAREHOUSING
FUNCTIONS OF DWH
OLTP
OLAP
DESIGN FLOW FOR OLTP
DESIGN FLOW FOR OLAP
BASICS FOR DWH
SCHEMA
STARSCHEMA
EXTENDED STAR SCHEMA
DESIGN FLOW FOR ESS
IMPLEMENTATION OF ESS INTO BW/BI
MODELLING
DATA SOURCES
SOURCE SYSTEMS
INFOPROVIDERS
DATA TARGETS
INFOOBJECTS
OHD(OPENHUBDESTINATION)
BI WORKBENCH.