SAP BusinessObjects Data Services Tutorial

Sap Businessobjects

Sujets

• Jobaria
• Tutoriel
• Target Earth
• Schéma quinaire
• Dimension à évolution lente
• Arms

Informations

• Publié par: Machung
• Nombre de lectures: 911
• Langue: English
• Poids de l'ouvrage: 1 Mo

Extrait

SAP BusinessObjectsData Services Tutorial SAP BusinessObjects Data Services XI 3.2 SP1 (12.2.1)Copyright © 2009 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. 2009-10-24Contents Chapter 1 Introduction 11 Audience and assumptions.......................................................................12 SAP BusinessObjects information resources............................................12 Tutorial objectives......................................................................................14 Tutorial prerequisites.................................................................................15 Preparation for this tutorial...................................................................15 Environment required...........................................................................15 Tutorial setup........................................................................................16 Tutorial structure23 Exiting the tutorial25 To exit the tutorial25 To resume the tutorial...........................................................................26 Chapter 2 Product Overview 27 Product features28 components..................................................................................29 Using the product.......................................................................................31 System configurations...............................................................................32 Windows implementation.....................................................................33 UNIX...........................................................................33 The Designer window................................................................................33 SAP BusinessObjects Data Services objects............................................35 Object hierarchy...................................................................................36 Object-naming conventions..................................................................40 New terms..................................................................................................40 Section summary and what to do next......................................................42 SAP BusinessObjects Data Services Tutorial 3Contents Chapter 3 Defining Source and T arget Metadata 43 Logging in to the repository.......................................................................44 To log in to the Designer44 Defining a datastore...................................................................................45 To define a datastore for the source (ODS) database..........................46 To define a for the target database......................................48 Importing metadata....................................................................................49 To import metadata for ODS source tables .........................................49 To import for target tables.....................................................50 Defining a file format..................................................................................50 To define a file format...........................................................................51 New terms..................................................................................................53 Summary and what to do next...................................................................53 Chapter 4 Populating the SalesOrg Dimension from a Flat File 55 Objects and their hierarchical relationships...............................................57 Adding a new project.................................................................................57 To add a new project............................................................................57 Adding a job...............................................................................................58 To add a new batch job........................................................................58 Adding a work flow.....................................................................................58 To add a work flow................................................................................60 About data flows........................................................................................60 Adding a data flow61 Defining the data flow...........................................................................63 Validating the data flow66 Addressing errors.................................................................................67 Saving the project......................................................................................68 Executing the job.......................................................................................68 4 SAP BusinessObjects Data Services TutorialContents To execute a job...................................................................................68 About deleting objects...............................................................................70 New terms..................................................................................................71 Summary and what to do next...................................................................71 Chapter 5 Populating the T ime Dimension Using a T ransform 73 Retrieving the project.................................................................................74 To open the Class_Exercises project...................................................75 Adding the job and data flow.....................................................................75 To add the job and data flow................................................................75 Defining the time dimension data flow.......................................................75 To specify the components of the time data flow.................................76 To define the flow of data76 To define the output of the Date_Generation transform.......................77 To define the output of the query..........................................................78 Saving and executing the job....................................................................80 Summary and what to do next...................................................................80 Chapter 6 Populating the Customer Dimension from a Relational T able 83 Adding the CustDim job and work flow......................................................85 To add the CustDim job........................................................................85 To add the work flow..............................................................85 Adding the CustDim data flow...................................................................85 To add the CustDim data flow object....................................................85 Defining the data flow.................................................................85 To bring the objects into the data flow..................................................86 To define the query...............................................................................86 Validating the CustDim data flow...............................................................87 To verify that the data flow has been constructed properly..................87 Executing the CustDim job........................................................................88 SAP BusinessObjects Data Services Tutorial 5Contents Using the interactive debugger..................................................................89 To set a breakpoint in a data flow.........................................................89 To use the interactive debugger...........................................................90 To set a breakpoint condition................................................................91 Summary and what to do next...................................................................91 Chapter 7 Populating the Material Dimension from an XML File 93 Adding MtrlDim job, work and data flows..................................................95 To add the MtrlDim job objects.............................................................95 Importing a document type definition.........................................................95 To import the mtrl.dtd............................................................................95 Defining the MtrlDim data flow...................................................................95 To add the objects to the data flow.......................................................96 To define the details of qryunnest96 Validating the MtrlDim data flow................................................................98 To verify that the dat