Siebel Analytics

							               Siebel Analytics 7.5.2



Oct 17, 2008        (C) Mahindra British Telecom 2003   1
Siebel Analytics Components
  • Siebel Analytics Admin Tool

  • Siebel Analytics Client

  • Siebel Analytics Catalog Manager

  • Siebel Analytics Web Portal




  Oct 17, 2008     (C) Mahindra British Telecom 2003   2
Siebel Analytics Architecture
                                                                        Siebel Analytics
                                                                        Web Portal

                             Internet, Intranet, LAN, WAN

                                                                        Server Machine
                                        Web Server - IIS

                                       Security Model
                                       Business Model
                                                                        Siebel Analytics
                                   SQL Generation Engine                Admin Tool
  Siebel Analytics
     Repository                      Computation Engine
                                       Query Caching
                              Multi Database Query Processing



                           SQL                                           OLAP
   Oct 17, 2008   Oracle               XML           Informix     DB2
                              (C)
                           Server Mahindra British Telecom 2003          Server    3
    Siebel Analytics Admin Tool




Oct 17, 2008   (C) Mahindra British Telecom 2003   4
Siebel Analytics Admin Tool
  • Used by Siebel Analytics Server Administrator
  • For creating and editing Siebel Analytics
    repositories
  • Creating users/groups and setting privileges
  • Managing jobs
  • Managing caching and sessions
  • Creating and managing variables




  Oct 17, 2008    (C) Mahindra British Telecom 2003   5
Siebel Analytics Repository
  • File that maintains the metadata for the Siebel
    Analytics Server
  • Metadata contains
     – Logical schemas
     – Physical schemas
     – Physical - Logical mapping
     – Logical - Presentation mapping
     – Hierarchy definitions
     – Security information

   Oct 17, 2008     (C) Mahindra British Telecom 2003   6
Siebel Analytics Repository
  • Repository structure
    The Siebel Analytics Administration Tool displays
    repositories in three layers:
        • Physical Layer
        • Business Model and Mapping Layer
        • Presentation Layer




  Oct 17, 2008    (C) Mahindra British Telecom 2003   7
Repository




  Oct 17, 2008   (C) Mahindra British Telecom 2003   8
Physical Layer
 • Maintains physical database connection and schema
   information.
 • Can add/import database objects in this layer.
 • Primary key and Foreign key relationships between
   tables are defined here




  Oct 17, 2008    (C) Mahindra British Telecom 2003   9
Physical Layer
                                                Database




                                               Connection Pool
                                               Catalog Folder
                                               Schema Folder

                                                Physical Column

                                               Primary Key
                                               Physical Table

  Oct 17, 2008   (C) Mahindra British Telecom 2003                10
Business Model & Mapping Layer

   • The business logic and the mappings to the
     physical database objects.
   • Can define the dimensions and the hierarchical
     levels.
   • Can add logical columns using the expression
     builder given in the column mappings.




   Oct 17, 2008     (C) Mahindra British Telecom 2003   11
Business Model &Mapping Layer
                                            Subject Area




                                            Dimension Hierarchy




                                            Parent Level
                                            Level Key
                                            Level Attribute

                                            Logical Table
                                                  Logical Column
   Oct 17, 2008   (C) Mahindra British Telecom 2003
                                                 Logical Table Key   12
Presentation Layer
  • Contains view of data seen by end users
  • Displays information organized as subject areas
  • Provides simplification or customization of
    business model and mapping layer
     – Suppress unwanted table columns
     – Represent opp_closed_rev as “Opportunity
       Closed Revenue” : Definitions in business
       terms



  Oct 17, 2008     (C) Mahindra British Telecom 2003   13
Presentation Layer

                                     Subject Area




                                     Presentation Table




                                      Presentation Column




  Oct 17, 2008   (C) Mahindra British Telecom 2003          14
               Siebel Analytics Client




Oct 17, 2008         (C) Mahindra British Telecom 2003   15
Siebel Analytics Client
  • Tool to issue SQL to Siebel Analytics server
  • Normally used as a testing tool
  • Used by Siebel personnel




  Oct 17, 2008     (C) Mahindra British Telecom 2003   16
Siebel Analytics Client
  Features Supported
  • View Schema : Tables and related columns
  • Enter SQL : Issue SQL query to server
  • View SQL Query List : View SQL queries
    executed




  Oct 17, 2008    (C) Mahindra British Telecom 2003   17
Siebel Analytics Catalog Manager




Oct 17, 2008   (C) Mahindra British Telecom 2003   18
Catalog Manager
  • Tool for web catalog management
  • Performs offline management of Siebel Analytics
    web catalog
  • Used by web administrators
  • Must be installed on a secure machine




  Oct 17, 2008    (C) Mahindra British Telecom 2003   19
Catalog Manager - Use
  •   Rename and delete web catalog content
  •   Move and copy content within web catalogs
  •   Move and copy content between web catalogs
  •   Upgrading Siebel Analytics applications to new
      versions without losing changes




  Oct 17, 2008      (C) Mahindra British Telecom 2003   20
Catalog Manager




  Oct 17, 2008   (C) Mahindra British Telecom 2003   21
     Siebel Analytics Web Portal




Oct 17, 2008   (C) Mahindra British Telecom 2003   22
Siebel Analytics Web Portal
  •   Dashboards
  •   Siebel Answers
  •   Siebel Delivers
  •   Web Admin




  Oct 17, 2008      (C) Mahindra British Telecom 2003   23
     Siebel Analytics Dashboards




Oct 17, 2008   (C) Mahindra British Telecom 2003   24
Dashboards
 • End user interface for viewing created requests
 • Dashboards are user specific and default dashboard can
   be set for the user.
 • Users use pre-configured dashboards or create them
 • Contains references to saved Siebel Answer
   requests, Active-X objects, HTML Text, links
   to documents, and embedded content such
   as images, charts, and tables.
 • Dashboards are saved in folders within the
   Siebel Analytics Web Catalog.
  Oct 17, 2008     (C) Mahindra British Telecom 2003   25
Dashboards
  • Dashboard contains pages, columns and sections
  • Pages are displayed as tabs across the dashboards
  • Pages contain columns
  • Columns contain the sections
  • Requests are contained in sections
  • End users with ADMIN rights can create
    dashboards
  • Managed by Web Administrators through
    “Admin” link on the dashboard

  Oct 17, 2008     (C) Mahindra British Telecom 2003    26
Analytics Dashboard




  Oct 17, 2008   (C) Mahindra British Telecom 2003   27
          Siebel Analytics Answers




Oct 17, 2008    (C) Mahindra British Telecom 2003   28
Siebel Analytics Answers
  • Thin client browser-based access to the Siebel
    Analytics Server for end users
  • Used for creating requests
  • Intuitive, information-driven interface
  • Provides charting, formatting, calculation, and
    drilldown features.




  Oct 17, 2008     (C) Mahindra British Telecom 2003   29
Siebel Answers




  Oct 17, 2008   (C) Mahindra British Telecom 2003   30
               Siebel Delivers




Oct 17, 2008     (C) Mahindra British Telecom 2003   31
Siebel Delivers
  • Siebel Delivers
     – Proactively monitors and delivers timely and
       actionable intelligence
     – To the right people
     – On the devices of their choice : E-mail, Pager,
       PDA or mobile phone




  Oct 17, 2008     (C) Mahindra British Telecom 2003     32
Siebel Delivers




  Oct 17, 2008   (C) Mahindra British Telecom 2003   33
    Siebel Analytics Web Admin




Oct 17, 2008   (C) Mahindra British Telecom 2003   34
Web Admin
 •   Maintenance of users/groups
 •   Managing access privileges
 •   Dashboard maintenance
 •   Management of personal/shared folders
 •   Managing the sessions




  Oct 17, 2008     (C) Mahindra British Telecom 2003   35
Web Admin




  Oct 17, 2008   (C) Mahindra British Telecom 2003   36