Data is only valuable when you can extract insights. Siebel provides comprehensive reporting and analytics capabilities to transform your CRM data into actionable business intelligence.
Form Reports: Detail view of single record (e.g., invoice)
Page 118
๐ Standard Reports
Out-of-the-Box Reports
Siebel eCommunications includes 200+ pre-built reports ready to use immediately.
Sales Reports
Pipeline Report: Opportunities by stage and sales rep
Forecast Report: Revenue forecast by period
Win/Loss Analysis: Closed opportunities with reasons
Activity Report: Sales activities by rep and account
Quota Attainment: Performance vs. targets
Service Reports
Open SR Report: All open service requests by priority
SLA Compliance: SLA met vs. breached
Resolution Time: Average time to resolve by category
Agent Performance: SRs handled per agent
Customer Satisfaction: Survey results and CSAT scores
Marketing Reports
Campaign Performance: Responses, leads, ROI
Lead Source Analysis: Lead volume by source
Conversion Funnel: Lead to opportunity to customer
Email Analytics: Open rates, click rates, unsubscribes
๐ก Tip: Start with standard reports and customize them rather than building from scratch. Saves time and follows best practices.
Page 119
โถ๏ธ Running Reports
How to Run a Report
Navigate to: Site Map โ Reports โ [Report Category]
Select desired report from list
Click Run Report button
Set parameters (date range, filters, grouping)
Choose output format (HTML, PDF, Excel, CSV)
Click OK to generate
View results in browser or download file
Report Parameters
Common Parameters:
โข Date Range: Last Month, This Quarter, Custom dates
โข Owner: Specific user or All users
โข Status: Active, Closed, All
โข Organization: Filter by business unit
โข Product: Filter by product line
โข Custom Filters: Account type, revenue range, etc.
Output Formats
HTML
Interactive viewing in browser
โ Sortable columns, clickable links
PDF
Formatted document for printing
โ Professional appearance, secure
Excel
Spreadsheet for further analysis
โ Pivot tables, formulas, charts
CSV
Raw data for imports
โ Lightweight, universal compatibility
Page 120
๐จ Creating Custom Reports
Report Builder Interface
Siebel's Report Builder provides a wizard-driven interface for creating custom reports without coding.
Report Creation Steps
Select Data Source: Choose Business Component (e.g., Account, Opportunity)
Choose Fields: Select columns to include in report
Add Calculations: Sum, Count, Average, Min, Max
Set Grouping: Group by owner, region, product, etc.
Define Sorting: Order results by field(s)
Apply Filters: Limit records (e.g., Status = Active)
Format Layout: Headers, footers, fonts, colors
Save and Test: Name report and run sample
Example: Monthly Sales by Rep
Data Source: Opportunity BC Fields: Owner, Opportunity Name, Revenue, Close Date Filter: Status = "Closed Won" AND Close Date = This Month Group By: Owner Calculations: SUM(Revenue), COUNT(Opportunities) Sort: Owner ascending Output:
Rep Name | Opportunities | Total Revenue
Smith, John | 15 | $450,000
Jones, Mary | 12 | $380,000
...
Page 121
๐ Advanced Reporting Techniques
Calculated Fields
Create custom calculations within reports:
Average Deal Size: SUM(Revenue) / COUNT(Opportunities)
Growth %: ((This Period - Last Period) / Last Period) ร 100
Cross-Object Reporting
Pull data from related objects in single report:
Opportunity Report with Account Data:
Opportunity.Name
Opportunity.Revenue
Account.Name
Account.Industry
Account.Annual Revenue
Primary Contact.Full Name
Primary Contact.Email
Sub-Reports
Embed detail reports within summary reports:
Parent: Accounts grouped by industry
Child: For each account, show all opportunities
Benefit: Comprehensive view in single report
Page 122
๐ฐ Oracle BI Publisher & Current Query Reporting Architecture
Reporting Architecture: Extraction vs Rendering
In enterprise Siebel CRM deployments, reporting operates as a two-tier decoupled process:
Data Extraction Layer (Siebel Object Manager & Integration Objects): Siebel extracts structured CRM records into an XML data payload based on the Current Active Query (PDQ or user filter) and the bound Integration Object (IO).
Layout & Rendering Layer (BI Publisher): BI Publisher merges the XML data payload with RTF or XSL-FO templates to produce formatted PDF, Excel, or HTML documents. In training and administrative environments without a standalone BIP server cluster, administrators inspect template metadata and IO field mappings directly in the Siebel UI, while operational exports are executed via native CSV/text capabilities.
1. Current Query Reports (Out-of-the-Box Examples)
Current Query reports generate outputs based dynamically on whatever dataset the user is currently viewing in their active applet. The core enterprise examples include:
โข aclist (Account List): Bound to Integration Object BIP Accounts - Current Query
โข cntlist (Contact List): Bound to Integration Object BIP Contacts - Current Query
โข oplist (Opportunity List): Bound to Integration Object BIP Opportunity List - Current Query
2. Integration Object (IO) Search Specifications
Critical Architectural Rule: When generating a report, the records included are determined by the active query filter and the Integration Object's Search Specification, NOT merely by which row is highlighted in the UI.
If an IO defines a search specification (e.g., [Status] = 'Active'), records not satisfying the IO rule will be filtered out even if displayed in the applet.
Selecting a single row and clicking Report will still export all rows matching the active query unless the report definition explicitly specifies single-record form mode.
3. Template & Layout Inspection in Siebel UI
Administrators inspect and configure reporting metadata via Site Map → Administration - BI Publisher Reports → Reports - Templates:
Template Definitions: Upload, download, and review RTF/XSL-FO template files.
View Associations: Map report templates to specific screens and views (e.g., associating aclist with Account List View).
Integration Component Fields: Verify which Business Component fields are mapped to XML tags.
4. Operational Reporting & Direct Data Export
For day-to-day analytics, ad-hoc lists, and external auditing without layout rendering overhead, Siebel Open UI provides native Menu → Export:
Scope: "All Rows in Current Query" exports the complete active dataset with 100% record fidelity.
Columns: "Visible Columns" exports the exact grid layout customized by the user.
Page 123
๐ Interactive Dashboards
Dashboard Overview
Dashboards provide at-a-glance views of key metrics with interactive charts and tables. Users can drill down for details.
Dashboard Components
Chart Applets
Bar/Column Charts
Line/Area Charts
Pie/Donut Charts
Gauge Charts
Funnel Charts
Data Applets
List Applets
Form Applets
KPI Tiles
Summary Tables
Trend Indicators
Dashboard Examples
Sales Manager Dashboard:
Pipeline value by stage (funnel chart)
Forecast vs. quota (gauge chart)
Top 10 opportunities (list)
Win rate trend (line chart)
Activities this week (KPI tile)
Service Manager Dashboard:
Open SRs by priority (bar chart)
SLA compliance % (gauge)
SRs at risk (list)
Resolution time trend (line chart)
Customer satisfaction (KPI tile)
Page 124
๐ฏ Key Performance Indicators (KPIs)
What are KPIs?
KPIs are measurable values that demonstrate how effectively an organization is achieving business objectives. Siebel tracks and displays KPIs in real-time.
Real-time analytics display current data without manual refresh, critical for contact centers and sales floors.
Real-Time Use Cases
Contact Center Wallboards: Live display of call queue, wait times, agents available
Sales Leaderboards: Current day/week/month rankings update as deals close
Service Metrics: Open SRs, SLAs at risk, backlog by priority
Campaign Tracking: Email open rates, clicks, conversions as they happen
Implementation
Auto-Refresh Configuration:
โข Interval: 30 seconds, 1 minute, 5 minutes
โข Trigger: Time-based or event-based
โข Scope: Full page or specific applet
โข Performance: Balance freshness vs. server load
โ ๏ธ Performance Consideration: Real-time dashboards with many users can impact database performance. Use caching and optimize queries.
Page 126
๐ Data Visualization Best Practices
Choosing the Right Chart Type
Bar/Column Charts: Compare values across categories
Example: Revenue by product line, SRs by priority
Line Charts: Show trends over time
Example: Quarterly revenue growth, daily SR volume
Pie Charts: Show proportional breakdown (use sparingly)
Example: Market share by competitor, SRs by type
Funnel Charts: Visualize conversion process
Example: Sales pipeline stages, lead conversion funnel
Gauge Charts: Show progress toward goal
Example: Quota attainment, SLA compliance %
Visualization Guidelines
Keep It Simple: Avoid cluttered charts with too many data points
Use Color Purposefully: Green = good, Red = bad, consistent meanings
Label Clearly: Axis labels, legends, data point values
Choose Appropriate Scale: Start Y-axis at zero for fair comparison
Limit Pie Slices: Maximum 5-7 slices, combine others into "Other"
Page 127
โฐ Scheduling and Distribution
Automated Report Delivery
Schedule reports to run automatically and email results to recipients. No manual intervention required.
Schedule Configuration
Open report definition
Click Schedule button
Set frequency:
Daily (weekdays only or every day)
Weekly (specify days: Mon, Wed, Fri)
Monthly (1st, 15th, or last day)
Quarterly
Set time: 7:00 AM (before business hours)
Choose output format: PDF, Excel
Add recipients: email addresses or distribution lists
Set subject line and message
Save schedule
Common Scheduled Reports
Daily: Open SRs by priority โ Service managers Weekly: Sales activity summary โ Sales VPs Monthly: Revenue by product โ Finance team Quarterly: Customer satisfaction โ Executive team
๐ก Best Practice: Include date range in subject line Example: "Weekly Sales Report - Oct 25-31, 2025"
Page 128
๐ Report Security and Access Control
Data Security in Reports
Reports respect Siebel's security model. Users only see data they have permission to access.
Security Layers
Report Visibility: Which reports appear in user's menu
Data Visibility: Which records user can see in report
Field Visibility: Which columns are displayed
Report Execution: Who can run vs. schedule vs. modify reports
Access Control Examples
Sales Rep:
โข Sees: Own opportunities only
โข Cannot see: Colleague opportunities or manager overrides
Sales Manager:
โข Sees: Own team's opportunities
โข Cannot see: Other teams' opportunities
Sales VP:
โข Sees: All opportunities in region
โข Cannot see: Other regions without permission
Sensitive Data Protection
โ ๏ธ Protect Confidential Information:
Mask credit card numbers (show last 4 digits only)
Redact social security numbers
Hide salary and compensation data
Restrict access to financial reports
Audit report execution (who ran what, when)
Page 129
๐ค Data Export Capabilities
Export Options
Users can export data from any list applet for offline analysis or data migration.
Click summary data to see underlying details. Essential for investigating issues and opportunities.
Drill-Down Levels
Level 1: Total Company Revenue: $50M
โ (Click to drill down) Level 2: By Region: North $20M, South $18M, West $12M
โ (Click South) Level 3: By Rep in South: Smith $6M, Jones $5M, Brown $4M...
โ (Click Smith) Level 4: Individual Opportunities for Smith
Common Drill-Down Paths
Geographic: Company โ Region โ Territory โ Rep โ Account
Product: Total โ Product Line โ Product โ SKU โ Customer
Time: Year โ Quarter โ Month โ Week โ Day
Organizational: Company โ Division โ Department โ Team โ Individual
๐ก Use Case: Executive sees revenue down in South region. Drills to see it's concentrated in Florida territory. Drills further to identify rep turnover caused the dip. Takes corrective action (hire, reassign accounts).
Page 135
๐ Report Governance
Managing Report Sprawl
Without governance, organizations end up with hundreds of redundant, outdated reports that confuse users.
Reports containing personal data must comply with privacy regulations.
GDPR Compliance
Data Minimization: Only export necessary fields
Retention: Don't store exported reports longer than needed
Anonymization: Mask PII when possible
Consent: Verify customer consent for data processing
Audit Trail: Log who accessed what personal data
Right to Erasure: Reports must reflect deleted customer data
Data Masking Example
Full Data (Admin only):
Name: John Smith
Email: john.smith@email.com
Phone: (555) 123-4567
SSN: 123-45-6789
Credit Card: 4532-1234-5678-9012
Masked Data (Standard user):
Name: John S****
Email: j***@email.com
Phone: (555) ***-**67
SSN: ***-**-6789
Credit Card: ****-****-****-9012
Compliance Reporting
Generate reports for regulatory compliance:
Data access audit (who viewed customer records)
Consent status report
Data retention compliance
Breach notification logs
Page 139
๐ฏ Report ROI and Adoption
Measuring Report Value
Track report usage to understand which reports provide value and which to retire.
Usage Metrics
Run Frequency: How often report is executed
Unique Users: Number of distinct users running report
Avg Execution Time: Performance indicator
Export Rate: % of runs that are exported (high = valuable)
Dashboard Placement: Featured on home pages?
Adoption Strategies
Training: Show users how to run and interpret reports
Templates: Provide pre-built reports for common needs
Self-Service: Empower users to create own reports
Mobile Access: Enable reports on smartphones/tablets
Alerts: Push critical metrics to users proactively
Gamification: Leaderboards for sales teams
Report Retirement Criteria
Candidates for Retirement:
โข No runs in last 90 days
โข < 3 unique users
โข Owner left company
โข Duplicate of another report
โข Data source no longer exists
โข Regulatory requirement expired
Page 140
๐ฑ Mobile Reporting
Reports on Mobile Devices
Modern CRM users need access to reports on smartphones and tablets while traveling or away from desk.
Mobile-Optimized Design
Responsive Layout: Adapts to screen size
Touch-Friendly: Large buttons, easy navigation
Simplified Views: Key metrics only, not cluttered
Offline Capable: Download reports for offline viewing
Fast Loading: Minimize data transfer
Mobile Dashboard Example
Sales Manager Mobile View:
Today's Activities: 5 (tap to see details)
Open Opportunities: $2.4M
Pipeline This Quarter: $8.1M
Team Quota Attainment: 87%
[Chart: Revenue Trend - Last 30 Days]
๐ก Best Practice: Design mobile-first. Create concise mobile dashboards, then expand for desktop rather than trying to shrink desktop reports to mobile.