SAP BI Online Training

SAP Business Objects Business Intelligence 4.2 

➤ Data warehousing/Dimensional modeling / SCHEMA

➤ Database Concepts needed for Data warehousing

➤ SAP BW 7.5 Concepts

➤ BOBI 4.2 Architecture

➤ Universe Design Tool

➤ Information Design Tool

➤ Web intelligence 4.1

➤ Crystal Reports for Enterprise

➤ Dashboard Design Tool

➤ Administration

➤ Widgets

➤ Webi-rich Client

➤ Query as Web service

➤ OLAP EDITION,BO Analysis MS EXCEL,MS PPT

➤ Business Objects Explorer 4.2

➤ BI Workspace

➤ Information Steward

➤ Security Implementation

➤ OLAP Universe

➤ Import Wizard\Publishing Wizard

➤ Business View Manager

➤ Live Office Reporting

➤ BO-SAP Integration/Edge Series

➤ BO-SAP HANA Integration

➤ BO BI Certification Guidelines

➤ SAP BO BI 4.0 Launch pad

Data warehousing/Dimensional modelling/ SAP BW 7.4 Concepts

OLTP vs. OLAP

• Types of OLAP
• Multi-Dimensional Modelling Of SAP BW 7.4
• SAP BW 7.3 Cubes, DSO’s ,Multi Providers, Info sets
• Business Explorer (Bex) Queries in BW 7.3 system as Data sources
• Data Flow in BW 7.3 and Activating Business Content Cube

Database Concepts needed for Data warehousing

• Joins & Cardinality
• Views/Materialized Views
• Date/Time Functions

BOBI 4.2 Architecture

• Architectural overview
• Client tier components
• Application tier components
• Intelligence tier
• Processing tier
• Data tier
• Security management
• Information

Universe Design Tool (UDT)

• Understanding Business Objects Universes
• Creating the Course Universe
• Building the Universe Structure
• Creating Dimension Objects
• Creating Measure Objects
• Resolving Loops in a Universe
• Resolving SQL Traps
• Using List of Values
• Applying Restrictions on Objects
• Using @Functions with Objects
• Using Hierarchies
• Deriving Tables & Indexes
• Working with Aggregate Awareness
• Designing Advanced Objects
• Creating Predefined Condition
• LOVs & Joins
• Securing Universes
• Implementing Universe Life Cycle Management
• Maintaining & Optimizing Universes
• Creating Universe from Other Data sources
• Designing Universes on SAP HANA tables and views
• Designing Universes on SAP HANA for COPA scenario, Sales Scenario, Procurement Scenarios

Information Design Tool (IDT)

• Understanding Business Objects Universes
• Creating the Course Universe
• Building the Universe Structure
• Creating Dimension Objects
• Creating Measure Objects
• Resolving Loops in a Universe
• Resolving SQL Traps
• Using List of Values
• Applying Restrictions on Objects
• Using @Functions with Objects
• Using Hierarchies
• Deriving Tables & Indexes
• Working with Aggregate Awareness
• Designing Advanced Objects
• Creating Predefined Condition
• LOVs & Joins
• Securing Universes
• Implementing Universe Life Cycle Mgmt
• Maintaining & Optimizing Universes
• Creating Universe from Other Data sources
• Designing Universes on SAP HANA tables and views
• Designing Universes on SAP HANA for COPA scenario, Sales Scenario, Procurement Scenarios

Web I Rich Client

• Understand concepts of Web intelligence
• Create Web Intelligence documents with Queries
• Restrict data returned by a query
• Design a report
• Enhance the presentation of data in reports
• Creation of Web intelligence report with auto scheduling
• Creation of Corporate dashboard for Supply chain management/Banking Domain
• Format a report
• Calculate data with formulas and variables
• Use multiple data sources
• Analyse data
• Manage and share Web Intelligence documents
• Work with Advanced Query techniques
• Work with calculation contexts
• Create formulas with character & date string functions
• Use “If” logic
• Work with additional reporting techniques
• Create hyperlinks
• Designing WEBI reports based on BEX query as Source.
• Designing WEBI Reports Based on SAP HANA UNX universes.

Crystal Reports 2013/Enterprise

• Planning a Report
• Selecting Records
• Formatting a Report
• Representing Data Visually
• Distributing Reports
• Creating Basic Formulas
• Organizing Data on a Report
• Applying Section Formatting
• Applying Conditional Reporting
• Using the Repository
• Using Report Templates
• Creating Formulas
• Building Parameterized Reports
• Summarizing Data with Cross-Tabs
• Using Report Sections
• Managing Reports
• Presenting Data Visually
• Add hyperlinks to a report
• Depreciation Forecast.
• Designing Crystal reports i reports Based on BEX query as Source
• Designing Crystal reports Reports Based on SAP HANA UNX universes

Dashboard

• Creating a Model
• Adding Interactivity to a Model
• Creating a Connected Model
• Connect to Crystal Reports data and create Dashboard
• Connect to Web intelligence report data
• Create Dashboard
• Connect to Business Objects Universes
• Using Query as a web service and create Dashboard
• Use Live Office data and create Dashboard
• Use other connectivity components and create Dashboard
• Designing Dashboard reports Based on BEX query as Source using QUERY BROWSER
• Designing Dashboard reports Based on SAP HANA UNX universes QUERY BROWSER

Query as Web service

• Configuring the QWS with BO System
• Creating Web service report from Universes
• Creating WSDL reports
• Using WSDL reports in external application

BO Analysis 4.2

• Creating Analysis Workspace using OLAP EDITION, BO analysis MS EXCEL,MS PPT.
• Using Charts to Visualize Data
• Selecting Members to Display in Crosstabs and Charts
• Sorting, Filtering, and Ranking Data
• Highlighting Exceptions

BO Explorer 4.2

• Creating Information Spaces based on SAP HANA Analytical view, Spread sheets, UNX Universes.
• Exploring the data Based on Information Spaces.

Widgets

• Installing BI Widgets
• Using BI Widgets to Access BI Content
• Working with widgets
• BI Widgets Content Authoring Guidelines
• Auto refresh of Widgets

Security Implementation

• Creating Secured users & group
• Creation secured connections
• Creation of Secured objects
• Creation of security at Table, Column & row level
• Creation of secured restriction set and mapping to users or groups

OLAP Universe

• Creation of OLAP Universe by connecting to an Info cube
• Updating the OLAP Universe (Cube)
• Creating the Custom Hierarchies in OLAP Universes.
• Accessing multiple info cubes to create an OLAP Universe

Live Office Reporting

• Describe the benefits of using Live Office
• Connect to the repository
• Navigate the Live Office menu
• Insert charts, crosstabs, and fields from a Crystal report
• Insert report parts from a Web Intelligence document
• Insert a new query based on a Universe
• Insert Live Office objects into an email
• Navigate and refresh Live Office objects
• Enable consolidated prompts
• Set refresh settings for objects
• Set parameter binding
• Take a snapshot
• Save Live Office documents to the repository
• Open and view Live Office documents from the repository

SAP WEBI/Dashboard Reporting

• Creation of Web intelligence reports using Info cube & BW Query

You cannot combine queries when the number of objects in the query results and the data types of those objects is not identical. For example, you cannot combine a query then returns Year with a query that returns Year and Revenue, or combine a query that returns Year with a query that returns Revenue. You must also pay attention to the semantics of your combined queries.

When you refresh an SAP BI Training Online report with prompts, lists of values for the prompts appear in a flat list without multiple columns. While it is possible to combine a query that returns Year with a query that returns Region, if both dimensions are of the same data type, the result – a mixed list of years and regions – is unlikely to be meaningful. Typically, if your first Sap BI Training Online query contains a Year dimension, your second query also contains a dimension that returns a list of years. The order of execution in a combined query is crucial in determining the final result.

In such SAP BI online training case, the first result to be calculated is the intersection between Combined Query n and Combined Query n + 1. The next result is the intersection between the first result and the result of Combined Query n + 2. Query execution continues in this way through all the queries in the relationship. By default, each time you add a combined query, it is combined at the initial combination level with existing queries. Each added query extends the list of combined queries. If your SAP BI online training database directly supports the type of combined query you wish to execute, the script generated from the query contains the combination operators directly. Multiple queries return data to the report and this data is then resolved into the same result generated by a database-level combined query. In this SAP BI Training Course case, the order of precedence depends on the order of precedence defined in the database. SAP ABAP Training Query filters are defined on the SAP online course training query; they limit the data retrieved from the data source and returned to the document.

The first value declared must be lower than the second value. Use the Except operator to retrieve data of SAP BI online training that corresponds to one value and excludes another. For example, to retrieve customers who have only a fixed telephone number and no mobile telephone number, create the filter [Account Type] ‘Fixed’ Except ‘Mobile’. The Except operator is more restrictive than Different from or Not in list. For example, an SAP BI online training report that returns customers and that includes the filter [Lines] Different from ‘Accessories’ excludes all sales records where the item sold is part of the ‘Accessories’ line. If the same customer of online SAP HR training has purchased Accessories and non-Accessories items, the customer still appears in the report, but their SAP BW Online Training spending total includes only non-Accessories sales. If the filter is [Lines] Except ‘Accessories’, only customers who have bought no accessories are included in the report. Predefined filters make the specific data you most typically need for reports permanently available. They are created by an SAP BI online training administrator and saved with the universe. Predefined filters often contain complex expressions that require detailed knowledge of the database structure.

Including predefined SAP BI online training filters on the universe means you don’t need to create the same custom filters every time you create a new document based on the same universe. You cannot view the parts of predefined filters or edit predefined filters. Quick filters allow you to quickly define the values you want to retrieve for a specific result object without launching the Filter Editor. You create custom query filters to limit document data to information corresponding to a specific business question or the business information needs of a specific group of users. For example, you can create custom filters to retrieve SAP BI online training sales results data for specific dates, products, or services, or to view customer information only for customers who are high wage earners or who live in a particular region. When selecting from a list of SAP SD online course values in a query, items in the list can appear either as a single or multi-column list or a hierarchy, depending on the object. In a multi-column list, additional columns provide related values to the main value. In a hierarchical list, values appear in an SAP BI online training hierarchical relationship.