SAP Business Objects Training

We hire working Professionals with high relative domain experience. They are good at technical skills and communication skills.

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

For information on saving excel files to the cms, consult the saving objects directly to the cms topic in the bi launch pad help. bex queries are queries created using the sap bex query designer, based on SAP Business Objects Training info cubes in a sap bi tutorials .

Bex queries retrieve the metadata from the data source. you use web intelligence to connect to a bex query by using a bi consumer services connection, and retrieve data via the bex query for reporting purposes. you create, edit and refresh documents and reports based on bex queries using the web intelligence applet interface or sap business objects tutorial launched from the bi launch pad. in the web intelligence html interface, you can view and refresh documents, but not edit them. web intelligence automatically maps data from the bex query to hierarchies, attributes, dimensions and measures as in universe-based hierarchical queries.

Direct access into a sap bex query (through a bics connection) does not allow you to rename, modify, or add metadata. you do not create a universe for bex queries. to view sap business objects online training reports, edit, or refresh reports, you can use any of the web intelligence interfaces are the web intelligence html interface , the web intelligence applet interface , the web intelligence rich client downloaded and installed from the sap business objects online training launch pad and web intelligence rich client installed as a component of the sap business objects suite. for data sources based on bex queries, sap business warehouse (bw) characteristics are mapped to dimension objects in web intelligence. depending on the SAP Business Objects Training characteristic data type, these dimensions have a specific type assigned . although you have defined a bw characteristic in the sap bw online training as a numerical data type , bw treats the characteristic as a text character string . consequently, when it is used in a web intelligence document, it is treated as a text character string .

the SAP Business Objects Training calculation depends heavily on the layout of the data requested (for example, the order in which characteristics are requested, if the result line is switched on or off, and #) and could therefore be misinterpreted. to avoid those misinterpretations, these calculations are automatically switched off. they might not work correctly within the sap online courses client tools . it is not feasible to filter them out, as the knowledge about the calculations are not exposed through the interface, therefore the sap business objects online training query designer should make sure that those calculations are not used. if you switch on the mdx-flag in the bex query designer, the usage of those calculations is checked. the bex query decimal number definition is not consumed in web intelligence. use the formatted value instead if you need to keep the exact decimal setting in your report. you can also apply the decimal setting in the table and chart of your report. do not define variables on default values inSAP Business Objects Training queries. the variables will be prompted without an effect on the bex query. instead, define the default value in the filter. not supported.

The or operator is not supported from some olap data sources such as bex queries, and olap .unx universes on the top of microsoft analysis services and oracle essbase. the SAP Business Objects Training data synchronization of the same object from the same source is based on the internal key of the value of these objects. measures which aggregate with the sum function, aggregate the sum in web intelligence. other types of measure aggregation are delegated. when a variable is defined to support the complex selection, there is no equivalent. this is limited to range SAP Business Objectives Training selection. not supported, these are removed from the bex query. the filter will be ignored, or, if a variable is used, the variable prompt will display, but the user response is ignored. move any restriction based on a variable into the filter zone in order for it to be taken into account for reporting. it is not possible to show an overall SAP Business Objects Training hierarchy out of an axis hierarchy. the characteristics, hierarchies, and key figures that make up the hierarchy are retained. lower level sap bo tutorials nodes are always shown after the main node. We also provide SAP HR training , SAP MM training .