BW-Overview: Overview of the BW structure, overview of the SAP data warehousing strategy, business content, integration with my SAP workplace.
Administrator workbench: Maintaining the BW system landscape, metadata management for info objects and master data tables, transferring data, scheduler, and monitor.
Definition of the user environment: Roles, authorization.
Data Modelling in BW
Architecture of BW Server:
Multidimensional data models: Data modeling
The sap BW data model: Different types of data in BW, info objects: characteristic and key figures, master data: attributes, texts, hierarchies, info cubes, extended BW star schema, technical implementation.
Data flow in BW and extracting data from my SAP components: Functions in the administrator workbench, source systems, infosources, replicating data sources, defining transfer rules, update rules, data flow display, extraction methods, scheduler, monitor.
Extracting data from other data sources: Third party tools, files interface (flat file uploads), data marts.
Production support: Organizing loading processes (schedule, grouping, event controlling). PSA functions, BW statistics, aggregates, and infocube maintenance.
Operational data store: Operation data stores objects (ODS objects), data staging in the ODS. maintaining ODS requests, using the ODS for reporting.
Data modeling - Additional topics: Remote cubes multicubes, tracking history, additional modeling concepts.
Authorizations in BW: Role, classes of authorization object for administration and reporting. authorization objects, authorization, reporting objects, authorization variables.
Business content: Business content components, role based and industry-based content, installing business content, transport connection. SAP demo cubes.
Business Explorer
Introduction to BW reporting: Methodology of the SAP business information warehouse, reporting structure in SAPBW.
Working with business content queries in the bexbrowser: Working with the hex browser, queries in business content, managing the contents of the bexbrowser, hex on the u-eb.
Getting started with the bex analyzer: Creating a query, changing a query, navigating through the analysis, filtering data, adding text elements.
Working with key figures and characteristic: Calculate key figures, properties of key figures, currency translation, and properties of characteristics, restricted key figures, hierarchies, attributes, variables, and global and local structures.
Query properties: Properties of queries, inserting, moving and deleting queries, detaching and refreshing queries.
Exception and condition: Integrating an exception in to a query result by specifying an except ion.
Bexmap: the GIS of SAP B\V: The concept of the bex map geographical information system in SAP BW, using geo -relevant characteristics to define queries, integrating a map in to a work book, designing a map in the bex analyzer.
Special topics: Settings in the bex analyzer, creating templates, integrating templates in the workbooks, sheet protection functions, page formatting in workbook.
Reporting Management
Business content; roles and authorizations: Business content component, role and industry — specific business content, activating business content, roles and authorization, transport Connection.
Report agent: Using exception reporting, exception reporting in the background and subsequent processing, printing in the background.
Complex reporting: Result set query-definition and use, concept and architecture of the report /report interface, BBS integration in to BW. using drill- through, query/query. query/ODS objects, query/OLTP, infoset query.
Bexmap: Concept and architecture of the bexmap, bexmap-integration into BW. static and dynamic geo characteristics.
Web Publishing
BW front end architecture &ITS: Describe the architecture and components of the BW front end, and how they interact, explain how BW is accessed using internet, describe the different components and items of the web publishing process carry out all the necessary steps, from the query building to web reporting.
HTML and WEB reporting components: Create HTML files, explain the role of the web publisher in the BW web reporting environment explain what an object is work with HTML objects.
Web wizard: Use the web wizard to create HTML pages
Bexweb: Explain how the bex web in the BW acts as a counter part to the work place.
WAD: Web Application Designer, Web Items, I views
Extraction Mechanism
Data Extraction overview: The extraction process, types of extractors, enhancements to extractors (overview), delta management for extractors (overview), business content.
LIS data extraction: Linking r/3 information structures to BW, filling info cubes using the delta update method.
Lo data extraction: BW customizing cockpit, comparing LO extraction with LIS extraction, converting data extraction from LIS to LO method.
CO-PA: Controlling and profitability Analysis.
Tools for generic data extraction: Data sources for master data, data sources for transaction data, extraction types, class system -overview, data sources for classification data (special features).
Enhancing business content: Enhancing data sources for transaction data, master data and texts. Enhancing data with the function enhancements of the service API, overview of the options in OLTP data enhancement.
Special topics: delta management: Concept, technology, and implementation of delta management in SAP BW, delta management for applications.
Excurses: OLTP access via remote cubes: Technology and implementation of data access using remote cubes.
Currency translation: Overview currency translation in BW. maintance and usage of translation keys, overview currency settings in the BW IMG, special and related topics.
|
about us 
