DATAWAREHOUSING

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.