Logo

DATAWAREHOUSING

BOXI / R3 CONTENT INTRODUCTION:

  • Datwarehouse concepts
  • Difference between Versions 5.x/6/5/XI  R1, R2, R3
  • Business objects XIR3 Suite
  • Extendibility of Business objects XIR3 (Introduction to BO- SAP Intergration/Dashboard/Xcelsius/Query as Web Service)
  • Role of Business objects in Data warehousing real time life cycle.

Designer:

  • Understanding how universes allow users to query databases using their everyday business terms
  • Creating an ODBC connection to the course database
  • Creating a universe
  • Populating the universe structure
  • Defining joins in a universe
  • Understanding classes and objects
  • Creating classes and objects
  • Understanding measure objects
  • Working with LOVs in Designer
  • Creating a cascading LOV
  • Resolving loops using aliases
  • Resolving loops using shortcut joins
  • Resolving loops using contexts
  • Resolving chasm traps
  • Resolving fan traps
  • Restricting the data returned by objects
  • Using @ Functions
  • Working with hierarchies
  • Using derived tables
  • Creating links between universes
  • Setting access restrictions on a universe
  • Documenting universes
  • Deploying and maintaining universes

Advanced Designer:

  • Use your universe design and Business Objects Universe Designer knowledge to solve Business problems
  • Define aggregate awareness
  • Apply aggregate awareness to objects
  • Combine database functions in objects
  • Construct relative data-time objects
  • Create complex predefined conditions
  • Work with advanced LOVs
  • Work with advanced join syntaxes
  • Define connection and user credential parameters
  • Work with Central Management Server (CMS) universe security
  • Move content from development to production
  • Maintain universe design
  • Work with OLAP universes

Desktop Intelligence:

  • Introduction to desktop intelligence
  • Report Creation
  • Publishing the report
  • Report conversation (desktop) to (Webi)

Webi Reporting:

  • Accessing information with Web Intelligence
  • Understanding how universes allow you to query database using everyday business terms
  • Understanding Web Intelligence core functionalities
  • Creating a document in the Web Intelligence Rich Client
  • Viewing a Web Intelligence document in Info View
  • Building a simple query
  • Modifying a document query
  • Working with query properties
  • Restricting data with query filters
  • Modifying a query with a predefined query filter
  • Applying a single-value query filter
  • Using prompts to restrict data
  • Using complex filters
  • Working in the Report Panel
  • Displaying data in tables and charts
  • Using breaks and cross tabs
  • Formatting break, calculations, and report filters
  • Formatting breaks and cross tabs
  • Using default and custom sorts
  • Ranking data to see top or bottom values
  • Using alerter to highlight information
  • Organizing a report into sections
  • Copying data to other applications
  • Preparing document for PDF and print
  • Document formatting
  • Formatting charts
  • Understanding formulas and variables
  • Understanding how Web Intelligence calculates data
  • Creating formulas and variables to calculate data
  • Adding a new query using a personal data provider
  • Creating multiples queries in a document
  • Synchronizing data with merged dimensions
  • Analyzing the data cube
  • Drilling into the data
  • Setting Web Intelligence drill options
  • Exporting documents from the Rich Client
  • Accessing Info View
  • Managing documents in Info View
  • Scheduling a Web Intelligence document
  • Setting Info View preference

Advanced Webi reporting:

  • Using combined queries
  • Using sub-queries
  • Creating a query based on another query
  • Changing data sources
  • Understanding the impact of the query drill on performance
  • Understanding calculation contexts
  • Redefining calculation context
  • Using character string functions
  • Using the replace( ) function
  • Using the right ( ) function
  • Using the Substring ( ) function
  • Using the Pos ( ) function
  • Using If ( ) to group data
  • Using data tracking
  • Using additional report function
  • Understanding the options for creating hyperlinks in Web Intelligence
  • Creating hyperlinks in the different Web Intelligence interfaces

Webi rich client:

  • Web Intelligence Rich Client general preferences
  • To create a new document in Web Intelligence Rich Client without Universe
  • To select a universe in Web Intelligence Rich Client
  • How does Web Intelligence generate combined queries?
  • Scope of analysis
  • Levels of scope of analysis
  • To set the scope analysis

Query as Web service:

  • Usage of Query as web service
  • How to configure and use
  • Viewing the Universe and Webi reports using web service
  • Viewing the Crystal XCelsius reports using web service

Introduction to Dashboard:

Creating Dashboards

Contents:

What is Dashboard Builder?
Creating an Analytic based on a Universe Query

Creating a Corporate Dashboards folder

Creating a pie chart based on sales of product lines

  • Selecting data for the pie chart
  • Saving your pie chart

Creating a bubble chart that compares product line sales to Revenues

  • Selecting data for the bubble chart
  • Saving your bubble chart

Scheduling an Analytic Refresh

  • Scheduling a refresh on your bubble chart

Designing a Corporate Dashboard

  • Analytics in dashboards
  • Set the dashboard preferences
  • Creating a dashboard
  • Add a text analytic to the dashboard

Creating a speedometer gauge that shows profit margins

  • What is a speedometer?
  • Getting Started Creating Dashboards
  • Selecting the data for the speedometer

Creating a dashboard tab that contains analytics

Creating a dashboard sub tab with web page and viewer analytics

  • Creating a sub tab
  • Adding a web page analytic to the sub tab
  • Adding a viewer to the dashboard sub tab
  •  

Data source Migration:

  • Migrating reports and data sources
  • Migration options
  • Modifying the migration setting

Import Wizard / Report Conversation:

  • Using Import wizard
  • Creating of BIAR
  • MIGRATING The BO objects from one CMS TO ANOTHER CMS
  • Migrating the objects from one domain to another (dev/stage/Prod)

Publishing:

  • Publish the Webi report between different CMS
  • Publish the converted reports (deski to webi) to destination servers
  • Publishing the repository objects

CMC/CCM/CMS:

  • Introduction of Window and web based Central management in BOXIR3
  • Roles and responsibilities of Contents of CCM/CMS/CMC
  • When to use CCM/CMS/CMC
  • Detail description of contents of CCM/CMS/CMC
  • Case study

Note : The duration of the course is 30 sessions one hour each.