SAP BI

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.

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  : 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.

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...

Prerequisites n the InfoObject maintenance, the indicator with hierarchies is set for the characteristic to show that the characteristic is allowed to have hierarchies. A source system must be assigned to the InfoSource for master data. If you want to load hierarchies from external systems, you must also maintain the Metadata. Procedure 1.Select the InfoSource tree from the Administrator Workbench. 2.Select the master data InfoSource for the InfoObject, to which you want to load the hierarchy. 3.Choose Assign DataSource from the context menu, and select the source system, from which you want to load the hierarchy. 4.Choose the function Create InfoPackage from the context menu .Give the InfoPackage a description. 5.Choose the pushbutton Hierarchies from the possible data types. You get a list of all the hierarchies that are available in the source system for this InfoObject. 6.On the tabstrip Hierarchy Selection, select the hierarchy that you want to load into the Bus...

Prerequisites In the InfoObject maintenance, the indicator with hierarchies is set for the relevant characteristic, meaning that the characteristic can have hierarchies. Procedure Step 1: Select the InfoObject tree in the Administrator Workbench. If you have assigned the characteristic to an InfoObject catalog, select the corresponding InfoObject catalog for an InfoArea. If the characteristic does not belong to an InfoObject catalog, select the Not Assigned Nodes InfoArea and the Not Assigned Characteristics InfoObject catalog. Step 2: Select the characteristic for which you want to create a hierarchy, choose the context menu with the right mouse button, and then Create hierarchy. Step 3: In the dialog box, enter the technical hierarchy name, or the hierarchy version if applicable, the time-reference, and at least one short description of the hierarchy. Confirm your entries. You come to the screen Maintain hierarchies. You can now define your hierarchy here. Creating Nodes and Leaves...

Definition A hierarchy is a method of displaying a characteristic structured and groupedaccording to individual evaluation criteria.A BW hierarchy has the following properties: Hierarchies are created for basic characteristics (characteristics containing master data).The characteristic 0COSTCENTER is an example. Hierarchies are stored in master data tables. They are also similar to master data, and can therefore be used and modified in all InfoCubes. You can define several hierarchies for a single characteristic. A hierarchy can have a maximum of 98 levels. You can load hierarchies from the R/3 system, or from a flat file. You can also create andchange hierarchies manually in the BW system. Use: Hierarchies are used in two main ways: 1. Firstly, the structured display of characteristic values (tree display) in a presentation hierarchy. 2.Secondly, selecting a defined quantity of characteristic values as a selection of hierarchy nodes. Structure A hierarchy consists of nodes. A node can...