Loading Hierarchies

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 Business Information Warehouse.

7.It is possible to create a hierarchy as a sub-tree, provided there is already a hierarchy under the specified technical key, and this hierarchy contains the root nodes of the hierarchy that you want to load.

Note : Use the other tabstrips to determine the update parameters, and schedule the InfoPackage.

Result

The hierarchy structure and the node texts/intervals are loaded. The structure information and the hierarchy texts are stored in the Business Information Warehouse.

You are now able to edit the hierarchy. You must activate it so that it can be used in reporting

NOTE: When you upload hierarchies, the system carries out a consistency check, making sure that the hierarchy structure is correct. Error messages are logged in the Monitor.

Comments

Step by Step guide on BADI with Filter implementation

Step 1 à Before implementing filter objects to a BADI. We need to deactivate all the implementation for that BADI. Go to SE18 (BADI definition) and from there navigate to all BADI implementation to view all the active implementations for that BADI Select the BADI implementations listed on the screen and deactivate the implementation. Once done, return back to the initial screen of SE18 and proceed with next step. Step 2 à go to SE18 – BADI Definition screen and change the existing BADI definition that we created in the earlier tutorial. Select the FILTER –DEPENDENT check box under the TYPE section. This will open up the FILTER TYPE field for inputs. And do an F1 on the FILTER TYPE field. Click on the F4 on the FILTER TYPE field name and enter some search criteria to find a relevant data element. And click on the continue button Select the data element from the list to set up your filter and hit enter. Click on the save butto...

Create Data Source in SAP

Data Sources are extraction structure. Data Sources are used to extract data from various source system. In the below steps, we will see how to create a data source using a SAP table VBAK. 1) Execute transaction RSO2 2) Enter data source name to be created 3) Press Create 4) Enter description of the data source 5) Enter the name of table or view on which data source has to be created. Data Source can also be created using a View, Info set or a Function Module. 6) Save the data source 7) Execute RSO2 again and click Change 8) Select VBELN field as selection 9) Save the Data Source 11) To check whether data is getting extracted, execute transaction RSA3 12) Enter the name of data source as shown below and press 'Extraction' 13) An information message will appear stating no. of records fetched 14) Additional button 'Display list' will appear, press button 15) Select one of the data packet and double click to get records fetched 16) Data Source is ready to be used!

Introduction to SAP Hierarchies

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

SAP BI

Search This Blog