Skip to main content

Posts

Major Difference between SAP BI 7.0 and SAP BW 3.5

1) Administrator Workbench is renamed as Data Warehousing Workbench. 2) There are additional modeling options available at left hand side panel in transaction RSA1 as shown below. The additions are 'DataSources' and 'Open Hub Destination'. 3) The functions of the InfoPackage tree are fully covered by process chains. 4) Process Chains are used instead of Event Collector. 5) The 'Remodelling' transaction help you add Key Figures and Characteristics in a Infocube while handling historical data effectively. 6) Infocubes can be included in Infosets. 7) Transformation is used instead of update and transfer rules. 8) ODS objects have been renamed as DataStore Objects. 9) You can access objects till InfoPackage directly from InfoCube as shown below.

Important BI Links.

1. The 60 Character Restriction for BW Data Models - Blog :      https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/15362 2. BEX Query Designer - SAP Library :        http://help.sap.com/saphelp_nw04/helpdata/en/9d/76563cc368b60fe10000000a114084/frameset.htm 3. Attribute change run - Blog :    https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13726 4. SAP Standard Reports in R/3 - Wiki :          https://wiki.sdn.sap.com/wiki/display/ERPLO/SAP+Standard+Reports 5. BI Content for Inventory Management - SAP Library :       http://help.sap.com/saphelp_nw70/helpdata/en/fb/64073c52619459e10000000a114084/frameset.htm
BI E-files SAP BW related E-Files at your service.... you can add more in comments Process Chain Architecture @ http://rapidshare.com/files/241711058/02_01_pc_architecture_func.ppt Process Chains Error Handling @ http://rapidshare.com/files/241711017/02_03_pc_monitoring_error_handling.pdf Data EXchange @ http://rapidshare.com/files/241710491/04_1_Data_Exchange.pdf Data EXchange with BI @ http://rapidshare.com/files/241710456/04_2_Data_Exchange_with_BW.pdf BI JObs Monitoring & Admin @ http://rapidshare.com/files/241710389/05_Monitoring_and_Administration.pdf BI Data Modeling @ http://rapidshare.com/files/241710955/1_datamodel.ppt SAPPIRE - 2008 - BO @ http://rapidshare.com/files/241711288/2008_05_SAPPHIRE_US_OR3276.pdf SAPPIRE - 2008 - BO @ http://rapidshare.com/files/241711220/2008_05_SAPPHIRE_US_OR3354.pdf SAPPIRE - 2008 - BO @ http://rapidshare.com/files/241711337/2008_05_SAPPHIRE_US_OR3382.pdf ABAP Certification @ http://rapidshare.com/files/241711949/ABAP_CERTIFICATION_QUESTIO...

Quick Tip! How to Copy Process Chains

Everybody who creates process chains comes to a point at which they want to copy a process chain. There are many reasons: because copying makes it quicker, you want to make only small changes from an existing chain to another, or you want to test a process chain and modify it to look at different scenarios without having to destroy the original.

Overcome Challenges with Unit of Measure Conversion During Transformations

Unit of measure (UoM) conversion functionality can add significant flexibility and enhanced analysis capabilities. Instead of having to create custom ABAP programs, you can use the new standard functionality in SAP NetWeaver BW 7.0. Here are the steps to implement UoM conversions in transformations Key Concept Unit of measure (UoM) conversion refers to the act of converting quantity key figure values into other units of measure for analysis purposes. For example, orders might be taken and stored in UoMs, such as each, case, and pallet. If you try to add the values without regard for UoM, the total is meaningless. To provide a meaningful sales total, you must convert the values from the multiple source UoMs to one common UoM for analysis. The UoM conversion functionality within SAP NetWeaver BW provides this capability. Unit of measure (UoM) conversion has always cause challenges in BI reporting. Unlike currency conversion, which applies a common multiplier to various key figure...

20 Uses for ABAP on BW Projects

20 Uses for ABAP on BW Projects  : ABAP programmers who are familiar with BW will be assets to most projects. However, their focus, with a few exceptions, will move from report creation to data preparation and preprocessing functions. Figure  (below) shows areas within the standard BW architecture where you might use ABAP: Six places during extraction, including creating custom DataSources, enhancing DataSources, and data selection in InfoPackages Six places during staging, including currency/units of measure conversions, transfer routines, and update rules Four places during reporting, including generating system-entered variables and the report/report interface You also have four other opportunities in BW to use ABAP: Open Hub Service transformations, building authorization values, process chains, and virtual InfoCubes with services That's a total of 20 ways you can use ABAP to enhance the operation and utility of your BW system.

MULTIPROVIDER

A Multiprovider is a type of Infoprovider that contains data from a number of Infoproviders and makes it available for Reporting Purposes. The Multiprovider doesn't contains any data. Its data comes entirely from the info providers on which it is based. These infoproviders are connected to one another by a Union operation. Infoproviders and Multiproviders are the objects or views that are relevant for reporting. A Multiprovider allows you to run reports using several infoproviders that is, it is used for creating reports on more than one infoprovider at a time. In BI 7 Version Multiproviders can be created using Infocube(Both Physical/Virtual) ,DSO,Infoobject,Infoset,Aggregation Level. In a Multiprovider, every characteristic in each of the infoprovider involved must corresponds to exactly or navigation attribute( where these are available) If it is not clear, at the Multiprovider definition stage, you have to specify to which infoobject you want to assign the charact...