Telecom Operator/Africa Context | Lab 5

📊 Lab 5: Run Operational Reports and Build Home KPI Tiles

Estimated time: 20 minutes

Goal

Learn how operational teams execute BI Publisher reports from live Siebel views, filter dataset criteria using saved queries, and personalize dashboard KPI tiles on the user Home page.

Prerequisites

  • Login: TRAINEE00 through TRAINEE09 (10 Trainees, Password is the same as Username: e.g. TRAINEE00 / TRAINEE00)
  • Application: Siebel eCommunications or Siebel Call Center
  • Existing records in Service Requests and Accounts (from previous labs)

Exercise 1: Filter and Save an Operational Report Query

Define Target Report Dataset

  1. Navigate to Site Map → Service Requests → All Service Requests (or Accounts).
  2. Press F9 to activate Query mode.
  3. In the Status column, type: Closed (or Open depending on what you want to report).
  4. In the application menu bar, click Query → Save Query As...
  5. Enter Query Name: Weekly Telecom Service Operations
  6. Click OK and press Enter to execute the query.
  7. Confirm that the list displays the filtered subset of records.

✅ Success Check: Saved Query is created and active in the query dropdown.

Exercise 2: Generate a BI Publisher / XMLP Report

Run Standard Report from Application Toolbar

  1. With your active list view on screen, locate the Reports button on the top application banner (printer icon or File → Run Report).
  2. Click Reports to open the Run Report dialog box.
  3. Review the available registered reports:
    • Service Request Detail (XMLP) or Service Request List (XMLP)
    • Account Summary (XMLP)
    • Opportunity Pipeline Summary (XMLP)
  4. Select the desired report template and choose output format: PDF (or Excel).
  5. Click Submit (or Run).
  6. The Siebel XMLP Integration Service extracts XML data via the Integration Object (e.g. Account (XMLP)) and renders the formatted document.
  7. Download or view the generated report.

✅ Success Check: Report executes successfully and opens the formatted output document.

Exercise 3: Personalize Home Page Dashboard with KPI Tiles

Customize Home Workspace

  1. Navigate to the Home tab / screen in the top navigation bar.
  2. Locate the Edit Layout (or gear icon / Personalize) button at the top-right of the Home page.
  3. In the layout personalization dialog:
    • Select applets to display: My Open Service Requests, My Opportunities, and Calendar / Activities.
    • Adjust row and column positions so your primary service metric is in the top-left tile.
  4. Click Save (or Done) to apply your personal dashboard layout.
  5. Verify your Home page now provides real-time counts and direct drilldowns into operational queues.

Mermaid: Data Extraction to Executive Dashboard

flowchart LR
  A[Siebel BC: S_SRV_REQ] --> B[Integration Object: Service Request XMLP]
  B --> C[BI Publisher Reporting Engine]
  C --> D[Formatted PDF / Excel Output]
  A --> E[Personalized Saved Query]
  E --> F[Home Page KPI Dashboard Tile]

Lab Summary

What You Learned

  • ✅ Build and persist complex operational query criteria as Saved Queries
  • ✅ Trigger BI Publisher XMLP reports directly from live transactional views
  • ✅ Export CRM data into structured PDF executive briefs
  • ✅ Configure personal Home page dashboard layouts with operational KPI tiles