© 2010 SAP AG Page 1 Topic: Creation of InfoObject Catalogs and InfoObjects Exercise 1 Create and activate the InfoObject Catalogs. Then create and activate two Key Figures (Revenue, Sales Quantity) and Characteristics (Material Group, Material). 1.1 Create and activate an InfoObject Catalog for key figures with the technical name "KNNN" and description "NNN Key Figures" in your Infoarea (NNN). Navigate to the Data Warehousing Workbench: Modeling by either double clicking it the navigation menu or entering RSA1 in the command field. Click on InfoObjects on the leftmost navigation panel, locate the InfoArea named (e.g., MU7 below) and expand it to show the lower level InfoAreas. SAP BI Data Modeling Scenario The Bike Company has developed a data model to support sales Time 30 min planning and reporting. They are ready to create InfoObjects for use in building InfoProviders (DataStore Object and InfoCube) to hold the sales data. Objectives The student will create and activate InfoObject Catalogs to organize the sales planning and reporting InfoObjects. Then the student will create and activate a subset of the InfoObjects needed for sales planning and reporting. Building the DataStore Object and InfoCube follow in subsequent exercises. © 2010 SAP AG Page 2 Scroll down in the InfoArea until you locate your InfoArea (NNN). Right click it and select Create InfoObject Catalog. Enter KNNN and NNN Key Figures for the technical name and description and select Key Figure as the InfoObject Type. Then click Create. © 2010 SAP AG Page 3 Click Activate to activate your Key Figure InfoObject Catalog. Notice that the InfoObject Catalog appears as part of your InfoArea. It is empty but a prerequisite to create your own InfoObjects 1.2 © 2010 SAP AG Page 4 In your Key Figure InfoObject Catalog KNNN, create and activate the Revenue and Sales Quantity Key Figures using the information provided in the table below. Technical Name Description Type/Data Type Unit/currency REVNNN NNN Revenue (Bike Company) Amount 0Currency QTYNNN NNN Sales Quantity (Bike Company) Quantity 0Base_Uom Right click your Key Figures InfoObject Catalog, and select Create InfoObject. Enter REVNNN and NNN Revenue (Bike Company) for the technical name and description. Then click the checkmark to execute. The Key Figure definition appears in the rightmost panel. On the first tab (Type/unit), leave the defaults of Amount and Currency. Then type 0CURRENCY in the Unit/currency field. This will allow values to be stored in different currencies, which is important since the Bike Company sales data occurs in local currency. Currency is an InfoObject itself, which means that OLAP navigation can be performed by currency later on. The leading "0" in 0CURRENCY indicates that it is an InfoObject delivered by SAP. You may, optionally, click on the Aggregation and Additional Properties tabs to view, but not change, the default settings. © 2010 SAP AG Page 5 Click Save to save the Key Figure properties. Then click Activate to make it available for use. Alternatively, you can click Activate and your Key Figure will be saved as part of the process. If the activation is successful, the Version and Object Status will show your key figure as active and executable. You will also see your key figure appear in your Key Figures InfoObject Catalog. If not, refresh the InfoObjects tree. Repeat the steps above to create and activate your second key figure, QTYNNN. © 2010 SAP AG Page 6 1.3 Create and activate an InfoObject Catalog for Characteristics with the technical name "CNNN" and description "NNN Characteristics" in your Infoarea (NNN). Use the process detailed in 1.1, entering CNNN and NNN Characteristics as the technical name and description and being sure to choose Characteristic as the InfoObject Type. 1.4 In your Characteristic InfoObject Catalog CNNN, create and activate the Material Group (Bike Company) and Material (Bike Company) Characteristics using the information provided in the tables below. Tab Field Entry/Selection General Characteristic MGNNN Long Description NNN Material Group (Bike Company) Data Type Char Length 9 Conversion Routine Blank Master Data Text Table Properties Short text exists Texts language dependent Application Component ZNNN © 2010 SAP AG Page 7 InfoArea NNN Hierarchy Attributes Tab Field Entry/Selection General Characteristic MANNN Long Description NNN Material (Bike Company) Data Type Char Length 18 Output 18 Conversion Routine MATN1 Master Data Text Table Properties Short text exists Texts language dependent Application Component ZNNN InfoArea NNN Hierarchy Attributes Display Base Unit of Measure – 0BASE_UOM Navigational Division - 0DIVISION Navigational Material Group - MGNNN Display Transfer Price – MU0TRPRI Right click your Characteristic InfoObject Catalog, and select Create InfoObject. Enter MGNNN and NNN Material Group (Bike Company) for the technical name and description, then execute. © 2010 SAP AG Page 8 On the General tab, specify CHAR as the Data type with a length of 9. Remove ALPHA as the conversion routine. This guarantees that leading digits "0" and trailing blanks will not be eliminated when storing the data. Click the Master data/texts tab and make sure that the Master Data checkbox is selected. Then choose the desired Text Table properties and enter ZNNN and NNN as the Application Component and InfoArea. This guarantees that the InfoObject will occur in your Application Component in the loading process. © 2010 SAP AG Page 9 Activate your Characteristic and you will see it listed in your Characteristic InfoObject Catalog. Follow similar steps to those above for creating the Material Characteristic and completing its General and Master data/texts information. Make sure to replace the ALPHA conversion routine with MATN1 on the General tab. © 2010 SAP AG Page 10 Click on the Attribute tab and enter the four attributes of your Material Characteristic: 0BASE_UOM, 0DIVISION, MGNNN, and MU0TRPRI. Click the pencil in the Navigation attribute column for 0DIVISION and MGNNN to change these attributes from Display to Navigation. This will enable Division and Material Group to be OLAP Attributes in reporting. Enter Division and Material Group as the Navigation attribute descriptions. © 2010 SAP AG Page 11 Activate your Material Characteristic and note that it is added to your Characteristic Catalog.