SAP BI BO BW

BO/BI – SAP BUSINESS OBJECTS / BUSINESS INTELLIGENCE

Within SAP Business Objects BI solutions, the SAP Business Objects administration curriculum demonstrates how you can increase the flexibility and scalability of your key business processes and lower TCO. Curriculum paths include the development and administration of the SAP Business Objects Edge Business Intelligence (BI) and SAP Business Objects Enterprise software. The SAP Business Objects business intelligence (BI) solutions curriculum can help you simplify the way your decision makers use information,…

SAP Business Objects Web Intelligence

• BI launch pad: What’s new in 4.1
• Customizing BI launch pad
• Creating Interactive Analysis documents with queries
• Restricting data returned by a query
• Types of filters
• Designing Interactive Analysis reports
• Enhancing the presentation of data in reports
• Formatting reports
• Calculating data with formulas and variables
• Using multiple data sources
• Analyzing data
• Managing and sharing Interactive Analysis documents
• Reporting from Other Data Sources
• Accessing corporate information with Web Intelligence
• Understanding how universes allow you to query databases using everyday business terms.
• Managing documents
• Creating Web Intelligence Documents with Queries
• Modifying a document’s query
• Using prompts to restrict data
• Using complex filters
• Displaying data in tables and charts
• Presenting data in free-standing cells
• Enhancing the Presentation of Reports
• Using breaks, calculations, sorts and report filters
• Ranking data to see top or bottom values
• Using alerters to highlight information
• Organizing a report into sections
• Copying data to other applications
• Alternative Query Techniques Using Combined Queries Using Sub-Queries
• Creating a Query based on another Query
• Character and Date String Functions Using the character string functions Concatenating different data types Using date functions
• Using If Logic
• Grouping data using If() logic
• Using If() to modify calculation behavior
• Advanced Reporting Features Formatting breaks
• Creating custom sorts
• Displaying document data in free-standing cells
• Alternative Query Techniques
• Defining Combined Query Types Using Combined Queries
• Using Sub-Queries
• Creating a Query on a Query
• Character and Date String Functions Understanding Character Strings
• Linking to documents and URLs in Web Intelligence
• Create the reports on top of Sap BEX queries

Business Intelligence / Business Warehouse

Data Warehousing (Data Warehousing Workbench)

Data Modelling

Info Objects

• Characteristics
• Key Figures

Data Flow (Transformation, InfoSources, DataSources)

• Dataflow in BI
• Transformation Process
• Datasource and Infosources 3.X
• Emulated Datasources 3.X

InfoProvider (InfoCubes, MultiProviders, VirtualProvider, DataStore Objects, InfoSets, InfoObjects, Direct Access)

• Infocubes
• DSOs
• Virtual Providers
• Multiproviders and BI Infoset
• Direct Access

Performance Tuning (Aggregates,Query Performance,BI Accelerator)

• Aggregates
• Query Performance
• BI Accelerator

Scheduling & Monitoring (Process Chains, Real Time Data Acquisition,Data Load Monitor)

• Process chains
• RDA

Meta Data (Meta Data Repository,Remodeling Toolbox,BI Content)

• Meta Data Repository
• BI Content
• Remodeling Toolbox 

Source Systems (UD Connect, Service API, Flat File, DB Connect) & DTP

• Service API
• Flat File, BI Infosource and DTP (TBW 10 Unit 4 Page 260-318)
• DB Connect