HI , I AM SRINIVAS , ( 8121985889 , trainersrinivas@gmail.com ).

Co-ordinator for  class room ,online trainings and IT Job consultant.

We Can provide online and class room trainings for CCNP

Huge openings for Freshers & Experienced .

For better career growth and enhance u r skills Business (BO)  training is the right choice .

We support u tecihnically strong in hands-on and getting job by making u as a software professional.

For outstation candidates we can guide in getting hostel facilities and assist in getting job according to their  academic qualification.

We also provide trainings in SAP (all modules) , Datawarehousing tools ,hardware & networking ,  CCNA ,VMWARE , UNIX/LINUX Admin , AS/400 System administration , DB2 UDB DBA , SAN , dataware housing , SAP; ,SAS , MAINFRAMES,AS/400,WEBSPHERE ADMIN ,WEBLOGIC ADMIN.

Course contents

BO-XIR2/R3

Introduction to OLAP systems

Need of OLAP systems

Benefits of OLAP systems

Different types of OLAP systems

Introduction to Business Objects

• Architecture of Business Object XIR3
• ODBC connectivity between different types of Databases and BO Administrator

Universe Design using BOXIR2/R3 Administrator

·         Enterprise mode (CMS)

• Stand alone mode (No CMS)

              Connection type:

• Secured
• Shared
• personal

• Identification of table types,
• Joins (inner, left outer, right outer )
• Data type conversion on join conditions
• Cardinality creation
• Table Derivation from same type of tables using Union Operator
• Detection of the loops in Universe
• Loops resolving for avoid Chesmtraps, Fan Traps:

• Creation of Aliases

·         Creation of Contexts based on    reporting requirements

• Creation of Shortcut joins

              Creation of Classes and objects:

·         Define the classes for end user requirements

·         Creation of objects

• Dimensions for Analysis
• Details with associate Dimensions
• Measures at detail level and summarized level

·         Global filters creation at Universe Level

·         Working with standalone filters

• @Aggregate awareness for same type of measures
• @concatenation function creation
• @measure function using Measure objects

• Aggregate Navigation for Incompatible Objects

Global Hierarchies for scope of Analysis

Check Integrity

Desktop Intelligence:

Introduction to query panel

Request generation in query panel

Local filter creation at reporting level using List of Values

Cascading filters using Logical Operators like AND, OR

Reports generation:

Ad-hoc reports

Standard reports

Two-dimensional reports

Multidimensional reports

• List reports: Horizontal reports, vertical reports
• Breaks creation on list reports
• Master-Detail reports
• Chart reports

                Line chart, bar chart, pie-chart, etc.

• Cross-tab reports
• Group reports
• Defining Rank on report
• Assign Filter on report
• Assign alert on report
• Variables Creation at report level

Slices and dices

Analysis of business user requirements

Generation of reporting requirements

• Saving reports in different formats: HTML, PDF, Excel, MS Word
• Generate the using predefined templates, user defined templates
• Generate the reports using predefined sql without developing model
• Generate the reports directly from the flat files, Excel sheets
• Formatting the reports
• Internal process explanation at server level

Ø  Drilling Analysis:

·         Drill through, drill down, drill up, and drill by

Ø  Post production of the report

Ø  Introduction to web intelligence rich client:

• Generate different types of reports same as like desktop intelligence

Ø  Introduction to Java Info view

• Generate different types of reports using web intelligence document same as like desktop Intelligence

• Saving Request for end user analysis for one click actions or saving report on PC

Ø  Dashboard Reports for multiple requirements

• My Dashboards
• Corporate Dashboards
• Creation of tabs for multiple Dashboards
• Dashboards using free form, docking, predefined templates.

•  Post production of the reports

Crystal Reports:

Ø  Introduction to Crystal Reports

Ø  Working with different data sources like Oracle, MS-Access, ADO.net, Excel, etc

Ø  Explanation on Design view

Ø  Report header

Ø  Page header

Ø  Page detail

Ø  Report footer

Ø  Page footer

Ø  Selection of the Database

Ø  Define relationship between tables

Ø  Report generation

Ø  Blank report:

List report, cross tab report, chart reports

Ø  Report wizard:

 List report, cross tab report, chart reports

Ø  Cross tab wizard:

§  Cross tab reports

§  Chart reports: Line chart, Bar chart, Pie-chart

Ø  Mailing Label wizard

Ø  OLAP cube report wizard

Ø  Organizing the report:

• Adding filters, sorting the data, grouping the data
• Cascading filters creation using logical operators
• Chart reports: Line chart, Bar chart, Pie-chart

Ø  work shop

·         Formulas creation

·         SQL Expression Development

·         Parameters Creation (static, dynamic)

·         Special field’s utilization

·         Woking with alerters

·         Saving reports in different formats like PDF, HTML, Excel Sheet, etc.

·         Generates the reports from Business Objects environment

·         Export Crystal Reports To Java Infoview

Xcelcius:

Ø