7/28/2019 Difference Between BI 3.X and BI 7.X

1/2

These are all the difference between 3.5 and 7.0 version

SAP BW 7.0 is called SAP BI and is one of the components of SAP NetWeaver 2004s. There aremany differences between them in areas like extraction, EDW, reporting, analysis administrationand so forth. For a detailed description, please refer to the documentation given on help.sap.com.

1. No Update rules or Transfer rules (Not mandatory in data flow)2.Instead of update rules and Transfer rules new concept introduced called transformations.3. New ODS introduced in additional to the Standard and transactional.4. ODS is renamed as DataStore to meet with the global data warehousing standards.

And lot more changes in the functionalities of BEX query designer and WAD etc.5. In Infosets now you can include Infocubes as well.6. The Re-Modeling transaction helps you adding new key figures and characteristics andhandles historical data as well without much hassle. This facility is available only for info cube.7. The BI accelerator (for now only for infocubes) helps in reducing query run time by almost afactor of 10 - 100. This BI accl is a separate box and would cost more. Vendors for these wouldbe HP or IBM.8. The monitoring has been improved with a new portal based cockpit. Which means you wouldneed to have an EP guy in your project for implementing the portal ! :)

9. Search functionality has improved!! You can search any object. Not like 3.510. Transformations are in and routines are passe! Yes, you can always revert to the oldtransactions too.

+++++++

****In 3.5 the dataflow will be like this,Source System-->Datasource-->PSA-->Transfer Rules-->Info SOurce-->update Rules---> DataTarget

In 7.0 the dataflow like this,Source System-->Datasource-->PSA-->Transformation(Data Transfer Process) --> Data Target

****In BI7.0 ,BI ACCELERATOR will be there to handle a huge volume of data handling process

*****In BW 3.5 the INFOSET can be created by use of ODS and INFOOBJECT .

In BI 7.0 the INFOSET can be created by use of ODS, INFOCUBE and INFO OBJECT .

****In BW 3.5 PSA is optional, by use of this we can load data or directly we can move data todatatarget.

In BI 7.0 PSA is must , by use of this only we can move data.

****In BW 3.5 we are using Start routine, Transfer Routine, Update routine, Conversion routine,Return Table

In BI 7.0 these are the routines used, Start routine, End routine, Expert routine

7/28/2019 Difference Between BI 3.X and BI 7.X

2/2

Following are the difference between BW & BI.

1. In Infosets now you can include Infocubes as well.2. The Remodeling transaction helps you add new key figure and characteristics and handleshistorical data as well without much hassle. This is only for info cube.3. The BI accelerator (for now only for infocubes) helps in reducing query run time by almost afactor of 10 - 100. This BI accl is a separate box and would cost more. Vendors for these wouldbe HP or IBM.4. The monitoring has been imprvoed with a new portal based cockpit. Which means you wouldneed to have an EP guy in ur project for implementing the portal ! :)5. Search functionality hass improved!! You can search any object. Not like 3.56. Transformations are in and routines are passe! Yess, you can always revert to the oldtransactions too.7. The Data Warehousing Workbench replaces the Administrator Workbench.8. Functional enhancements have been made for the DataStore object:New type of DataStore objectEnhanced settings for performance optimization of DataStore objects.9. The transformation replaces the transfer and update rules.10. New authorization objects have been added

11. Remodeling of InfoProviders supports you in InformationLifecycle Management.12 The Data Source:There is a new object concept for the Data Source.Options for direct access to data have been enhanced.From BI, remote activation of Data Sources is possible in SAP source systems.13.There are functional changes to the Persistent Staging Area (PSA).14.BI supports real-time data acquisition.15 SAP BW is now known formally as BI (part of NetWeaver 2004s). It implements the EnterpriseData Warehousing (EDW). The new features/ Major differences include:a) Renamed ODS as DataStore.b) Inclusion of Write-optmized DataStore which does not have any change log and the requestsdo need any activation

c) Unification of Transfer and Update rulesd) Introduction of "end routine" and "Expert Routine"e) Push of XML data into BI system (into PSA) without Service API or Delta Queuef) Intoduction of BI accelerator that significantly improves the performance.g) Load through PSA has become a must. I am not too sure about this. It looks like we would nothave the option to bypass the PSA Yes,16. Load through PSA has become a mandatory. You can't skip this, and also there is no IDoctransfer method in BI 7.0. DTP (Data Transfer Process) replaced the Transfer and Update rules.

Also in the Transformation now we can do "Start Routine, Expert Routine and End Routine".during data load.New features in BI 7 compared to earlier versions:i. New data flow capabilities such as Data Transfer Process (DTP), Real time data Acquisition(RDA).

ii. Enhanced and Graphical transformation capabilities such as Drag and Relate options.iii. One level of Transformation. This replaces the Transfer Rules and Update Rulesiv. Performance optimization includes new BI Accelerator feature.v. User management (includes new concept for analysis authorizations) for more flexible BI enduser authorizations.