📊 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:
TRAINEE00throughTRAINEE09(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
- Navigate to Site Map → Service Requests → All Service Requests (or Accounts).
- Press F9 to activate Query mode.
- In the Status column, type:
Closed(orOpendepending on what you want to report). - In the application menu bar, click Query → Save Query As...
- Enter Query Name:
Weekly Telecom Service Operations - Click OK and press Enter to execute the query.
- 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
- With your active list view on screen, locate the Reports button on the top application banner (printer icon or File → Run Report).
- Click Reports to open the Run Report dialog box.
- Review the available registered reports:
Service Request Detail (XMLP)orService Request List (XMLP)Account Summary (XMLP)Opportunity Pipeline Summary (XMLP)
- Select the desired report template and choose output format: PDF (or Excel).
- Click Submit (or Run).
- The Siebel XMLP Integration Service extracts XML data via the Integration Object (e.g.
Account (XMLP)) and renders the formatted document. - 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
- Navigate to the Home tab / screen in the top navigation bar.
- Locate the Edit Layout (or gear icon / Personalize) button at the top-right of the Home page.
- In the layout personalization dialog:
- Select applets to display:
My Open Service Requests,My Opportunities, andCalendar / Activities. - Adjust row and column positions so your primary service metric is in the top-left tile.
- Select applets to display:
- Click Save (or Done) to apply your personal dashboard layout.
- 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