Siebel Customer-Centric Enterprise Warehouse Installation And .
Siebel Customer-CentricEnterprise WarehouseInstallation andConfiguration GuideVersion 7.8.3September 2005
Siebel Systems, Inc., 2207 Bridgepointe Parkway, San Mateo, CA 94404Copyright 2005 Siebel Systems, Inc.All rights reserved.Printed in the United States of AmericaNo part of this publication may be stored in a retrieval system, transmitted, or reproduced in any way,including but not limited to photocopy, photographic, magnetic, or other record, without the prioragreement and written permission of Siebel Systems, Inc.Siebel, the Siebel logo, UAN, Universal Application Network, Siebel CRM OnDemand, and other Siebelnames referenced herein are trademarks of Siebel Systems, Inc., and may be registered in certainjurisdictions.Other product names, designations, logos, and symbols may be trademarks or registered trademarks oftheir respective owners.PRODUCT MODULES AND OPTIONS. This guide contains descriptions of modules that are optional andfor which you may not have purchased a license. Siebel’s Sample Database also includes data related tothese optional modules. As a result, your software implementation may differ from descriptions in thisguide. To find out more about the modules your organization has purchased, see your corporatepurchasing agent or your Siebel sales representative.U.S. GOVERNMENT RESTRICTED RIGHTS. Programs, Ancillary Programs and Documentation, deliveredsubject to the Department of Defense Federal Acquisition Regulation Supplement, are “commercialcomputer software” as set forth in DFARS 227.7202, Commercial Computer Software and CommercialComputer Software Documentation, and as such, any use, duplication and disclosure of the Programs,Ancillary Programs and Documentation shall be subject to the restrictions contained in the applicableSiebel license agreement. All other use, duplication and disclosure of the Programs, Ancillary Programsand Documentation by the U.S. Government shall be subject to the applicable Siebel license agreementand the restrictions contained in subsection (c) of FAR 52.227-19, Commercial Computer Software Restricted Rights (June 1987), or FAR 52.227-14, Rights in Data—General, including Alternate III (June1987), as applicable. Contractor/licensor is Siebel Systems, Inc., 2207 Bridgepointe Parkway, SanMateo, CA 94404.Proprietary InformationSiebel Systems, Inc. considers information included in thisdocumentation and in Siebel Online Help to be ConfidentialInformation. Your access to and use of this Confidential Informationare subject to the terms and conditions of: (1) the applicable SiebelSystems software license agreement, which has been executed andwith which you agree to comply; and (2) the proprietary andrestricted rights notices included in this documentation.
ContentsSiebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide 1Chapter 1: What’s New in This ReleaseChapter 2: Overview of Installing and Configuring theSiebel Customer-Centric Enterprise WarehouseInstalling the Siebel Customer-Centric Enterprise Warehouse19Initializing and Populating the Siebel Customer-Centric Enterprise WarehouseConfiguring the Siebel Customer-Centric Enterprise WarehouseAdditional Resources202022Chapter 3: Planning Your Warehouse Configuration ProjectData Warehouse Configuration he23Extract Mapping 24Load Mapping 25Post-Load Processing MappingReporting Area 26About Scoping Your Configuration ProjectGap Analysis252626Preparing for Gap Analysis 26Beginning Gap Analysis 27Roles Involved in the Gap-Analysis ProcessConfiguration Guidelines2829Chapter 4: Installing the Siebel Customer-CentricEnterprise Warehouse EnvironmentProcess of Defining Your Installation Configuration31Determining Configuration Requirements 31Gathering PowerCenter Information 32Gathering Information About Your Data Warehouse and Staging TablesDetermining Source Requirements 37Creating the Database Tables 3836Process of Installing PowerCenter and the Siebel Customer-Centric EnterpriseWarehouse 39Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.33
Contents Installing the Java SDK 39Setting the Environment Variable for the Java SDK 39Installing PowerCenter 40Installing the Siebel Business Analytics Platform 40Installing Siebel Customer-Centric Enterprise Warehouse and Enterprise ApplicationsMoving the Shell Repository File 41Process of Creating the Development Repository4042Modifying the Rollback Segments 42Creating and Configuring an Empty Siebel Business Analytics RepositoryRegistering Packages for the SAP R/3 Repository 44Modifying the PowerCenter Server Configuration 44Starting the PowerCenter Server 45Importing Application Workflows into the Repository 45Backing Up the Development Repository 47Moving the Required PowerCenter Server Data Files 47Creating the Data Warehouse Schema Control Tables 47Deploying Stored Procedures 49Creating the Seed Data 4943Moving the Required Siebel Customer-Centric Enterprise Warehouse Files50Chapter 5: Initializing and Populating the Siebel CustomerCentric Enterprise WarehouseLoading and Refreshing the Siebel Customer-Centric Enterprise WarehouseDatabase Types for Data Warehouse ObjectsModifying the Repository ConnectionsOptimizing Database PerformanceAbout Working with WorkflowsLoading Your Fiscal Calendar525555About the Initialization WorkflowInitialization Workflow Files52565759About the Source-Specific Main Workflows60About Modifying Session Parameters for Initial and Incremental LoadsConfiguring the Date Parameters for Parameter Files63Configuring the Database Parameter for the Source SystemConfiguring the Database Parameter for Post-Load ProcessingAbout Working with Post-Load Processing Workflows461646565Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.351
Contents Restarting the Extract, Transform, and Load Process66About Improving the Query Performance of Siebel Customer-Centric EnterpriseWarehouse 67About Analyzing Data Warehouse Tables for Optimal ETL PerformanceAbout the Table Analyze Utility6768Process of Configuring the Table Analyze Utility68Setting the Environment Variable for the JDBC drivers 68Setting the Database Connection Information for the Table Analyze UtilitySetting the Program Parameters for the Table Analyze Utility 70Moving the Table Analyze Utility Files 71Setting the Environment Variable for the OctopusUtils.jar File 71Creating the Encrypted Password File for the Table Analyze Utility 72Configuring the Table Analyze Utility for UNIX 72Running the Table Analyze Utility 73About Creating Command Tasks 7469Chapter 6: Configuring the Siebel Business AnalyticsRepository for Siebel Customer-CentricEnterprise WarehouseConfiguring the Siebel Business Analytics Repository ConnectionsCustomizing Time Dimensions7577Setting Up Additional Time Series Metrics for Siebel Customer-Centric EnterpriseWarehouse 78Setting Up Additional Dimension Tables for Siebel Customer-Centric EnterpriseWarehouse 79Merging Siebel Business Analytics Repositories79About Siebel Business Analytics Repository VariablesWeb Catalog Configuration VariablesAbout User Authentication8282About the Security or Visibility ConfigurationAbout the Group Variable808386About the Period Ago Keys for Siebel Customer-Centric Enterprise Warehouse87About Configuring Usage Tracking for Siebel Customer-Centric Enterprise Warehouse87About the Incremental Deployment of the Siebel Business Analytics RepositorySiebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.3875
Contents Chapter 7: Deploying Multiple Siebel Customer-CentricEnterprise Warehouse ApplicationsAbout Building Multi-Application Workflows for the Siebel Business Analytics89Process of Building Multi-Application Workflows for the Siebel Business AnalyticsCreating the Multi-Application Workflow Shell 90Creating the Post-Load Processing Initial Workflow 91Creating the Post-Load Processing Incremental WorkflowEditing the Nonreusable Worklets 928991Siebel Business Analytics Workflows and Dependent Worklets93SAP Dimensions Extract Worklet 94SAP Dimensions Load Worklet 95SAP Facts Extract Worklet 96SAP Facts Load Worklet 98Oracle 11i Dimensions Extract Worklet 101Oracle 11i Dimensions Load Worklet 102Oracle 11i Facts Extract Worklet 103Oracle 11i Facts Load Worklet 104Universal Dimensions Extract Worklet 105Universal Dimensions Load Worklet 106Universal Fact Extract Worklet 107Universal Fact Load Worklet 108Post-Load Processing Initial Worklet 109Post-Load Processing Incremental Worklet 110About Incremental Deployment110Setting Up Incremental Deployment111About Deploying Source Systems with Universal Source Systems for IncrementalDeployment 112Configuring Mutually Exclusive Source Systems for Incremental Deployment113Configuring Nonmutually Exclusive Source Systems for Incremental Deployment115Chapter 8: Configuring Common Components of the SiebelCustomer-Centric Enterprise WarehouseConfiguring Extracts117Disabling Workflow Sessions 118Extracting Additional Data 118Filtering the Data Extract 120Setting Up the Delimiter for Source FilesConfiguring Loads121Joining Objects in the Staging Area6121122Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.3
Contents Creating a Source Adapter MappletFiltering and Deleting Records123124About Primary Extract and Delete Mappings Process 124About Working with Primary Extract and Delete Mappings 126Configuring Slowly Changing Dimensions130About Identifying Historically Significant Attributes 130Type I and Type II Slowly Changing Dimensions 131Enabling Type II Slowly Changing Dimensions (SCDs) 135About Document, Local, and Group Currencies136Source System Provides Three Currency Amounts 137Source System Provides Document Amount, Codes, and Exchange Rates for Local andGroup Currencies 137Source System Provides the Document Currency Amount 138Process for Configuring Currencies138Supplying Document-to-Group and Local-to-Group Currency Exchange RatesExtracting Exchange Rates from a Custom Table 139Configuring the Exchange Rate Type 140Configuring Currency Code for Oracle 11i 141Handling European Monetary Union (EMU) Currencies139141Using the Flat File to Supply EMU Exchange Rates 141About the EXP CURR CONVERSION TRANSFORM Expression Transformation to SupplyEMU Exchange Rates 142About Stored LookupsCodes Lookup147147Configuring Extension Column Code Description LookupsAbout Resolving Dimension Keys149Resolving the Dimension Key Using Lookup 150Configuring the Dimension Key ID 151Configuring Lookup in Additional or Custom TablesResolving the Dimension Key Using Database JoinsAbout Domain Values149152153154About the Domain Value Conversion Process 154About the Importance of Domain Values 157About Extending the Domain Value Set 158Configuring the Domain Value Set with CSV Worksheet Files159Configuring the Domain Value Set Using PowerCenter DesignerConfiguring Conformed Dimensions160161Configuring Conformed Dimensions for Universal Source161Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.37
Contents Defining Services at the Package or Component Level 162About Cross-Referencing Entities in the Siebel Customer-Centric Enterprise Warehouse162Limiting the Entities Cross-Referenced in IA XRF ENTITIES 163About Specifying Correct Entity Cross-References in Flat File Uploads 164Chapter 9: Configuring Siebel Customer-Centric EnterpriseWarehouse for Oracle 11iConfiguring the Group Currency Code for Oracle 11iAbout Adding Oracle Flex Fields to the Data ModelSetting the Organization ID167167168Mapping Source Customer Hierarchies to the Customers Dimension TableConfiguring Product CategoriesModifying the Source ID169171172Modifying the Last Extract Date173Chapter 10: Storing, Extracting, and Loading AdditionalDataOverview of Storing, Extracting, and Loading Additional Data175About Classifying Additional Data 175Types of Extension Columns 176About Adding More Attributes to the Data Model178Determining the Type of Table to Use for Attributes 178Determining the Type of Extension Column to Use for AttributesStoring Additional Attributes in the Data Warehouse 181About Adding More Metrics to the Data Model184Storing Additional Metrics in the Data WarehouseAdding More Dates to the Data Model179184186About Integrating Data from Source Systems Without Prepackaged Business Adapters187About Extracting Universal Source Data 187Universal Source Flat File Template 188Load Process for Universal Source Data 189Chapter 11: Integrating Additional DataOverview of Integrating Additional DataTable Formats8191191Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.3
Contents Fact Table Format 192Load Control Table Format for Fact Tables 193Dimension Table Format 194Load Control Table Format for Dimension TablesAggregate Table Format 196Incremental Table Format 197Staging Table Format 197Creating New Tables195198Using Existing Tables to Create New Tables 200Creating a Profile Table Using Domain Values 202Creating New MappingsCreatingCreatingCreatingCreating203an Extract Mapping 203a Load Mapping 206a Codes Mapping 210a Derive Mapping 212About Creating and Modifying Business Adapters213Process of Creating and Modifying Business AdaptersCreating a New Business Component 213Modifying a Business Component 214Creating a New Source Adapter 215Modifying Source Adapter Expression Transformations213215Chapter 12: Checklist for Configuring Siebel CustomerCentric Enterprise Warehouse ApplicationsChecklist for Initializing Siebel Customer-Centric Enterprise Warehouse219Checklist for Configuring the Siebel Enterprise Contact Center Analytics220Checklist for Configuring the Siebel Enterprise Sales Analytics221Checklist for Configuring the Siebel Enterprise Workforce AnalyticsChecklist for Configuring the Siebel Financial Analytics224225Checklist for Configuring the Siebel Strategic Sourcing AnalyticsChecklist for Configuring the Siebel Supply Chain Analytics228231Chapter 13: Configuring Siebel Enterprise Contact CenterAnalyticsOverview of Siebel Enterprise Contact Center Analytics233About the Dimension Key Resolution Process for Universal SourceLoading the Dimension Table234234Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.39
Contents Loading the Fact Table234About Configuring the Event Type Columns235About Configuring Contact Status Type ColumnConfiguring Dates and Times237238Setting Up the Representative Activities Table238Setting Up the Contact Representative Snapshot TableSetting Up the Benchmarks and Targets Table240241Configuring Flags for Siebel Enterprise Contact Center Analytics242Excluding Representative Data from the Contact Representative Aggregate Tables forPost-Load Processing 244Chapter 14: Configuring Siebel Enterprise Sales AnalyticsOverview of Siebel Enterprise Sales Analytics247Process of Configuring Siebel Enterprise Sales Analytics for SAP R/3248Configuring the Booking Flag Calculation in the Sales Order Lines Table 248About Tracking Attribute Changes in Bookings 250Tracking Multiple Attribute Changes in Bookings 251Configuring the Booking Flag Calculation in the Sales Schedule Lines Level 252Configuring Early and Late Tolerances for Shipments 254Configuring the Sales Invoice Extract 255Configuring Order Types for Backlog Calculations 255Accounting for Negative Values in Orders, Invoices, and Picks 256Configuring the Date Parameters for the SAP R/3 Parameter File 257Process of Configuring Siebel Enterprise Sales Analytics for Oracle 11iConfiguring Sales Order Lines Data Storage 258About Tracking Attribute Changes in Bookings 259Tracking Multiple Attribute Changes in Bookings 261Configuring Sales Schedule Lines Data Storage 262Configuring Early and Late Tolerances for Shipments 264Configuring Sales Invoice Lines Data Storage 265Configuring Different Types of Backlog Calculations 265Configuring Order Types for Backlog Calculations 266Accounting for Negative Values in Orders, Invoices, and Picks257267Process of Aggregating Siebel Enterprise Sales Analytics Tables268About Configuring the Sales Invoice Lines Aggregate Table 268Configuring the Sales Invoice Lines Aggregate Table 270About Configuring the Sales Order Lines Aggregate Table 273Configuring the Sales Order Lines Aggregate Table 27410Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.3
Contents About Tracking Multiple Products for Siebel Enterprise Sales Analytics278Adding Dates to the Order Cycle Time Table for Post-Load Processing279About Configuring the Backlog Period Date for Siebel Enterprise Sales AnalyticsConfiguring the Backlog Period Date for Siebel Enterprise Sales AnalyticsAbout the Grain at Which Currency Amounts and Quantities Are StoredAbout the Sales Order Dates281283284285Domain Values and CSV Worksheet Files for Siebel Enterprise Sales Analytics287Configuring Siebel Supply Chain Analytics for Siebel Enterprise Sales AnalyticsConfiguring Siebel Financial Analytics for Siebel Enterprise Sales Analytics288289Chapter 15: Configuring Siebel Enterprise WorkforceAnalyticsOverview of Siebel Enterprise Workforce Analytics291About Configuring Workforce Operations for Oracle 11i292Process of Configuring Workforce Operations for Oracle 11i292Configuring the Employees Dimension for U.S. Statutory ComplianceConfiguring the Jobs Dimension for U.S. Statutory Compliance 296Enhancing Existing Mappings for U.S. Statutory Compliance 298Configuring Address Types for Workforce Profile 299Configuring Phone Types for Workforce Profile 299Modifying the Derive Flag for Workforce Profile 300Modifying the Snapshot Extract Date for Workforce Profile 301Process of Configuring Workforce Payroll for Oracle 11iModifying the Workforce Payroll Filters 302Improving ETL Performance for Workforce Payroll293301302About Aggregating the Payroll Table for Siebel Enterprise Workforce AnalyticsAggregating the Payroll Table for Siebel Enterprise Workforce Analytics303303Domain Values and CSV Worksheet Files for Siebel Enterprise Workforce Analytics304Configuring Domain Values and CSV Worksheet Files for Siebel Enterprise WorkforceAnalytics 305Chapter 16: Configuring Siebel Financial AnalyticsOverview of Siebel Financial Analytics309Process of Configuring Siebel Financial Analytics for Oracle 11iExtracting Data Posted at the Detail-Level for Oracle 11i310311Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.311
Contents Mapping Siebel General Ledger Analytics Account Numbers to Group Account Numbers312Filtering Extracts Based on Set of Books ID for Siebel General Ledger Analytics 313Configuring Siebel General Ledger Analytics Transaction Extracts 314Configuring General Ledger Cost Of Goods Extract 315Configuring the General Ledger Account Hierarchies 315Loading Hierarchies for Siebel General Ledger Analytics 316Configuring the General Ledger Balance ID 319Configuring AP Balance ID for Siebel Payables Analytics 320Configuring AR Balance ID for Siebel Receivables Analytics and Siebel ProfitabilityAnalytics 320Configuring the AR Adjustments Extract for Siebel Receivables Analytics 321Configuring the AR Schedules Extract 322Configuring the AR Cash Receipt Application Extract for Siebel Receivables Analytics 322Configuring the AR Credit-Memo Application Extract for Siebel Receivables Analytics 323About the Customer Costs Lines and Product Costs Lines Tables for Siebel ProfitabilityAnalytics 324Configuring the Customer Costs Lines and Product Costs Lines Tables for SiebelProfitability Analytics 324Extract, Transform, and Load for SAP R/3325Fact Table ETL Process for Header-Level Sales Data for SAP R/3 326About Fact Table ETL Process for Detail-Level Information for SAP R/3 328Siebel General Ledger Analytics Information for Nonsales Transactions for SAP R/3Process of Configuring Siebel Financial Analytics for SAP R/3329329Extracting Data Posted at the Header Level for SAP R/3 329Configuring the Group Account Number Categorization for Siebel General Ledger Analytics330Configuring the Transaction Types for Siebel Financial Analytics 331Configuring the General Ledger Account Hierarchies 332Configuring Hierarchy ID in Source Adapter for Siebel General Ledger Analytics 334Configuring the Siebel General Ledger Analytics Balance Extract 335Configuring the Siebel Payables Analytics Balance Extract 336Configuring the Customer Costs Lines and Product Costs Lines Tables for SiebelProfitability Analytics 337Configuring the Siebel Receivables Analytics Balance Extract 338About PeopleSoft Trees in Siebel Financial Analytics339Process of Configuring Siebel Financial Analytics for PeopleSoft 8.4340Customizing the PeopleSoft Tree Names 340Importing PeopleSoft Trees Into the PowerCenter Repository 341Configuring the Group Account Number Categorization for Siebel General Ledger Analytics342Configuring the Primary Ledger Name for Siebel General Ledger Analytics 34312Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.3
Contents Configuring the Primary Ledger Name for Siebel Payables Analytics 343Configuring the Primary Ledger Name for Siebel Receivables Analytics 344Configuring the Primary Ledger Name for Siebel Profitability Analytics 344Process of Configuring Siebel Financial Analytics for Post-Load ring345Aging Buckets for Siebel Receivables Analytics 345the History Period for the Invoice Level for Siebel Receivables Analytics 346Aging Buckets for Siebel Payables Analytics 346the History Period for the Invoice Level for Siebel Payables Analytics 347347Chapter 17: Configuring Siebel Strategic Sourcing AnalyticsOverview of Siebel Strategic Sourcing Analytics349Process of Configuring Siebel Strategic Sourcing Analytics for Oracle 11i350Configuring the Handling of Currency Types 350Configuring the Region Name 350Configuring the State Name 351Configuring the Country Name 352Configuring the Make-Buy Indicator 352Extracting Particular Purchase Order Records 353Configuring the Purchase Organization Hierarchy 354Configuring the Siebel Business Analytics Repository for Siebel Strategic SourcingAnalytics 354Process of Configuring Siebel Strategic Sourcing Analytics for SAP R/3Configuring the Siebel Business Analytics Repository for SAP R/3Configuring the Date Parameters for the SAP R/3 Parameter File355355356About Configuring Siebel Strategic Sourcing Analytics for Universal Source357Process of Configuring Siebel Strategic Sourcing Analytics for a Universal Source358Configuring the Preferred Merchant Flag 359Configuring the Customer Billable Indicator 359Configuring the Receipts Indicator 360Configuring Expense Payment Types 360Configuring the Default Expense Distribution Percentage 361Configuring Lookup Dates for Currency Conversion 361Configuring the Siebel Business Analytics Repository for Siebel Strategic SourcingAnalytics 362Configuring Expenses for Post-Load ProcessingConfiguring the Extraction of Invoice Details363364Process of Aggregating Siebel Strategic Sourcing Analytics Tables364Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.313
Contents About Configuring the Purchase Receipts Aggregate Table 365Configuring the Purchase Receipts Aggregate Table 366About Configuring the Purchase Cycle Lines Aggregate Table 370Configuring the Purchase Cycle Lines Aggregate Table 371Domain Values and CSV Worksheet Files for Siebel Strategic Sourcing Analytics375Chapter 18: Configuring Siebel Supply Chain AnalyticsOverview of Siebel Supply Chain Analytics377Process of Configuring Siebel Supply Chain Analytics for Oracle 11iConfiguring the Bill of Materials Explosion 378Configuring the Left Bound and Right Bound Calculation OptionConfiguring Quantity Types for Product Transactions 384About Configuring the Handling of Currency Types 385Configuring the Region Name 385Configuring the State Name 386Configuring the Country Name 386Configuring the Make-Buy Indicator 387Process of Aggregating Siebel Supply Chain Analytics Tables378382388About Configuring the Inventory Balance Aggregate Table 388Configuring the Inventory Balance Aggregate Table 389About Configuring the Product Transaction Aggregate Table 390Configuring the Product Transaction Aggregate Table 391About the SAP R/3 Inventory Transfer Process for Siebel Supply Chain AnalyticsIndex14Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.3393
1What’s New in This ReleaseWhat’s New in Siebel Customer-Centric Enterprise WarehouseInstallation and Configuration GuideThe Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide replaces theSiebel Customer-Centric Enterprise Warehouse Implementation Guide.Table 1 lists changes described in this version of the documentation to support Release 7.8.3 of thesoftware.Table 1. What’s New in Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide, Version 7.8.3TopicDescriptionChapter 6, “Configuring the SiebelBusiness Analytics Repository forSiebel Customer-Centric EnterpriseWarehouse”Added chapter. This chapter explains how to configure theSiebel Business Analytics repository for the Siebel CustomerCentric Enterprise Warehouse applications.Chapter 7, “Deploying MultipleSiebel Customer-Centric EnterpriseWarehouse Applications”Added chapter. This chapter provides instructions fordeploying multiple applications for the Siebel CustomerCentric Enterprise Warehouse.Chapter 9, “Configuring SiebelCustomer-Centric EnterpriseWarehouse for Oracle 11i”Added chapter. This chapter provides configurationinformation that is specific to Oracle 11i applications.Chapter 16, “Configuring SiebelFinancial Analytics”Added chapter. This chapter combines the previous SiebelFinancial Analytics applications of Siebel General LedgerAnalytics, Siebel Payables Analytics, Siebel ReceivablesAnalytics, and Siebel Profitability Analytics.Process of Configuring the TableAnalyze Utility on page 68Added a process that explains how to configure the TableAnalyzer Utility to analyze tables.Setting Up the RepresentativeActivities Table on page 238Added a procedure that explains how to set up theRepresentative Activities table.Setting Up the ContactRepresentative Snapshot Table onpage 240Added a procedure that explains how to set up the ContactRepresentative Snapshot table.Setting Up the Benchmarks andTargets Table on page 241Added a procedure that explains how to set up theBenchmarks and Targets table.Process of Configuring SiebelEnterprise Sales Analytics for SAPR/3 on page 248Added a process that explains how to configure SiebelEnterprise Sales Analytics for SAP R/3.Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.315
What’s New in This Release Table 1. What’s New in Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide, Version 7.8.3TopicDescriptionProcess of Aggregating SiebelEnterprise Sales Analytics Tables onpage 268Added a process that explains how to aggregate SiebelEnterprise Sales Analytics tables.Domain Values and CSV WorksheetFiles for Siebel Enterprise SalesAnalytics on page 287Added a section that lists the CSV worksheet files and thedomain values for Siebel Enterprise Sales Analytics.Process of Configuring WorkforcePayroll for Oracle 11i on page 301Added a process that explains how to configure WorkforcePayroll for Oracle 11i.Aggregating the Payroll Table forSiebel Enterprise WorkforceAnalytics on page 303Added a procedure that explains how to set aggregate thePayroll table for Siebel Enterprise Workforce Analytics.Domain Values and CSV WorksheetFiles for Siebel Enterprise WorkforceAnalytics on page 304Added a section that lists the CSV worksheet files and thedomain values for Siebel Enterprise Workforce Analytics.Mapping Siebel General LedgerAnalytics Account Numbers toGroup Account Numbers onpage 312Added a section that explains how to map Siebel GeneralLedger Analytics Accounts to Group Account Numbers.Configuring the Customer CostsLines and Product Costs Lines Tablesfor Siebel Profitability Analytics onpage 324Added a procedure that explains how to configure SiebelProfitability Analytics for Oracle 11i.Configuring the Group AccountNumber Categorization for SiebelGeneral Ledger Analytics onpage 330Added a section that explains how to configure the FinancialStatement Item Categorization for SAP R/3.Configuring the Customer CostsLines and Product Costs Lines Tablesfor Siebel Profitability Analytics onpage 337Added a procedure that explains how to configure SiebelProfitability Analytics for SAP R/3.About PeopleSoft Trees in SiebelFinancial Analytics on page 339Added a section that describes PeopleSoft Trees and explainshow they are used in Siebel Financial Analytics.Process of Configuring SiebelFinancial Analytics for Post-LoadProcessing on page 345Added a process that explains how to configure SiebelFinancial Analytics for post-load processing.Process of Configuring SiebelFinancial Analytics for Post-LoadProcessing on page 345Added a process that explains how to configure SiebelFinancial Analytics for post-load processing.16Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide Version 7.8.3
What’s New in This Release Table 1. What’s New in Siebel Customer-Centric Enterprise Warehouse Installation andConfiguration Guide, Version 7.8.3TopicDescriptionProcess of Configuring SiebelStrategic Sourcing Analytics for SAPR/3 on page 355Added a process that explains how to configure SiebelStrategic Sourcing Analytics for SAP R/3.Configuring Expenses for Post-LoadProcessing on page 363Added a process that explains how to aggregate Sie
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide Version 7.8.3 Contents 8 Defining Services at the Package or Component Level 162 About Cross-Referencing Entities in the Siebel Customer-Centric Enterprise Warehouse 162 Limiting the Entities Cross-Referenced in IA_XRF_ENTITIES 163
Downloading and Installing the Siebel Mobile Application Container (Siebel App). 4-20 Using the Siebel Mobile Archive MAA File (Administrator Task) . 4-21 Setting Up the Host Server for Siebel Mobile . 4-21 Configuring the Siebel Mobile Application Container (Siebel App) on an iOS Device . 4-22 Clearing the Application Cache for .
Siebel CRM Pricing Prices in USA-Dollar (USD) License Price Software Update License & Support Licensing Metric Minimum Siebel CRM General Siebel Advanced Market Development Funds 500 110.00 Application User Siebel Anywhere 200 44.00 Application User Siebel Server Sync - Microsoft Exchange Server 120 26.00 Application User Siebel Content Publishing 120
How Siebel CRM Desktop Handles a Microsoft Outlook Task 56 How Siebel CRM Desktop Handles a Microsoft Outlook Email Message 56 How Siebel CRM Desktop Handles Items If the User Removes the Siebel CRM Desktop Add-In 57 How a User Can Link a Siebel CRM Record to a Microsoft Outlook Record 58 Chapter 5: How Siebel CRM Desktop Synchronizes Data
Thomas M. Siebel . Aspenia. 79. 2018. Thomas M. Siebel is Chairman and CEO of C3 IoT. He previously founded Siebel Systems and the Thomas and Stacey Siebel Foundation, which cre ated the Siebel Energy Institute in 2015. 097-108 Siebel-ing 79 SCENARIO.indd 98 11/06/18 15.01
Siebel Systems Corporate Overview . Data SCM ERP Partner Data SalesSales Data Custom. A Customer-Centric Enterprise empowers employees with customer data and insight through end-to-end . Shift To Include Customer Centric Model Product-Centric Source: Harvard Business Review, and Siebel
- PowerCenter 7 (Informatica etl august 2005) Siebel : - Siebel Datawarehouse developer (june 2005) - Siebel EIM Workshop (23rd june 2003) - Siebel 7 EAI (October 2002) - Siebel 7 Core Consultant (April 2002) - Siebel 2000 EAI (march 20
12 Siebel eFinance for Teller Connector to IBM WebSphere Business Component Composer Guide Version 7.0, Rev. H Siebel Teller Architecture The Siebel Connector for Teller extends the functionality of the Siebel Connector for IFX XML to provide Teller-specific data exchange between Siebel and other systems.
4 PEI SPECIFIC CURRICULUM OUTCOMES FRAMEWORK: GRADE 2 General Curriculum Specifi c Curriculum Outcomes Outcomes Students will be expected to Reading and Viewing GCO 4: Students will be expected to select, read, and view with understanding a range of literature, information, media, and visual texts. (Transitional)
