Introduction to OLAP systems
Need of OLAP systems
Benefits of OLAP systems
Different types of OLAP systems
Introduction to Business Objects
- Architecture of SAP- Business Object XIR3.1/4.0
- ODBC connectivity between different types of Databases and SAP-BOE
Universe Design using SAP-BOXIR3.1/R4.0 UDT (Universe Designer Tool)
Working with quick design and manual design mode.
- Enterprise mode (CMS)
- Stand alone mode (No CMS)
Connection type:
- Secured
- Shared
- Personal
Working with tables, views and synonyms
Design universe diagram:
- 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 Chesm traps, 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
Custom Hierarchies for scope of Analysis
Check Integrity
Working with LOV’s
Working with cascading LOV’s
Organize the connections
Working with derived tables
Working with universe linking
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 or BI Launch Pad
- 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
- Working with crystal reports enterprise.
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:
- Introduction to Xcelcius
- Generate the reports in different types of the chart formats using Excel sheet data
- Generate Flash player repots using Shock wave flash player (SWF) for analysis
- Chart reports using dimensions and measures
- Line chart, bar chart, pie-chart, 3d-chart, etc.
- Formatting the reports in different styles
- Defining the ranges for labels
- Creation of the container for multiple requests
- Creation of tabs on containers.
- Generate the requests for containers
- Post production of the reports
Project Explanation with real time requirements
- Development of business requirements specifications(BRS)
- Development of reporting requirement specifications(RRS)
- Working with Live Office in Excel sheet from Crystal Reports and Web intelligent Reports in Xcelcius
- Generate reports in MS-Office tools using Live Office.
SAP Integration:
- Connect BO administrator to SAP BIW.
- Import dimensions and key figures to BOE.
- Create Global filters in Universe Designer.
- Introduction to Java Infoview.
- Generate reports from Web Intelligent Document.
- Generate reports from Web Rich client
- Introduction to Analytics.
- Query Scheduling and Optimization.
- Introduction to Corporate Analytics.
- Develop my Dashboards and Corporate Dashboards.
- Integrate SAP BIW with Crystal Reports.
- Develop Cross Tab Reports and Chart Reports.
- Working with analytics
- Working with central management console (CMC)
- create users and user groups
- set privileges to the users
- create servers and administer them
- Working with CCM( central configuration managers)
- Introduction to Business View Manager.
- Introduction to Query as a Web service.
- Working with crystal reports enterprise