A - B - C - D - E - F - G - H - I - L - M - O - P - R - S - T - U - W

A

ABAP code, generating   1

application database

configuring connections   1

Applications

Siebel Enterprise Contact Center Analytics   1

Siebel Enterprise Sales Analytics   1

Siebel Enterprise Workforce Analytics   1

Siebel Financial Analytics

   1

Siebel Strategic Sourcing Analytics   1

Siebel Supply Chain Analytics   1

attributes

historically significant attributes, identifying   1


Back to top


B

backing up

development repository   1

business adapters, creating and modifying

about   1


Back to top


C

calendar

fiscal calendar, loading   1

fiscal month, configuring   1

fiscal week, configuring   1

Fiscal_months.csv and the Fiscal_weeks.csv files, using   1

code lookup

about   1

code mappings   1

codes mapplets   1

IA_CODES table   1

sessions for lookups, configuring   1

common initialization workflow

files   1

running   1

configuration guidelines

choosing where to transform an object   1

documenting all changes   1

configuration project, planning

configuration guidelines   1

data warehouse configuration stages   1

extract mapping, configurable objects in   1

gap analysis   1

gap analysis, beginning   1

gap analysis, preparing for   1

gap analysis, resolving   1

gap-analysis process roles   1

load mapping, configurable objects in   1

populating guidelines   1

post-load mapping, configurable objects in   1

reporting area, configurable objects in   1

scoping your project, about   1

configuring

application database connections   1

configuration requirements, determining   1

data warehouse and staging tables, gathering information about   1

date parameters for parameter files   1

information tasks, documentation referral   1

installation configuration, process of defining   1

PowerCenter variable names for installation   1

source systems and database platforms, determining requirements   1

conformed dimensions

entities, cross-referencing   1

universal source, configuring for   1

cross-module configuration, performing

codes lookup   1

conformed dimensions, configuring   1

dimension keys, resolving   1

document, local, and group currencies, working with   1

domain values, working with   1

extracts, configuring   1

loads, configuring   1

Oracle 11i, configuring for   1

records, filtering and deleting   1

slowly changing dimensions, changing   1

stored lookups, configuring   1

currencies

configuring, about   1

currency code, configuring for Oracle 11i   1

document amount, codes, and exchange rates, provided by source   1

document currency amount, source provides   1

document, local, and group currencies, working with   1

document-to-group and local-to-group currency exchange rates, supplying   1

European Monetary Union currencies, handling   1

exchange rate type, configuring   1

exchange rates, extracting from a custom table   1

three currency amounts provided by source   1


Back to top


D

data

attributes, incorporating into the data model   1

classifying additional data   1

extension columns, types of   1

storing additional data overview   1

data extract

filtering   1

data model

attributes, incorporating into the data model   1

data, integrating from sources without prepackaged business adapters   1

dates, incorporating additional   1

extension column, determining type used for attributes   1

metrics, incorporating additional   1

metrics, storing additional   1

stored additional attributes   1

table, determining type for attributes   1

data warehouse

information, gathering   1

schema control tables, creating   1

data, integrating additional

aggregate table format   1

business adapters, creating and modifying   1

codes mapping, creating   1

create new tables, using existing tables   1

derive mapping, creating   1

dimension table format   1

extract mapping, creating an   1

fact table format   1

incremental table format   1

load control table format, for dimension tables   1

load control table format, for fact tables   1

load mapping, creating   1

new tables, creating   1

overview   1

profile table, creating using domain values   1

staging table format   1

table formats   1

database

parameter, configuring for the source system   1

performance, optimizing   1

database access

application database connections, configuring   1

data types   1

database performance, optimizing   1

relational database connections, replacing   1

repository connections, modifying   1

database platforms

requirements, determining   1

SAP R/3 source system   1

Universal Business Adapter, using   1

database table

about creating   1

databases

physical location and configuration requirements   1

Dates.txt file   1

Dates_XXXX_XXXX.csv files   1

deploying stored procedures   1

derive mapping

creating   1

development repository, creating

backing up development repository   1

copying required data files   1

data warehouse schema control tables, creating   1

empty repository, creating and configuring   1

module workflows, importing   1

repository and repository server, modifying   1

rollback segments, modifying   1

SAP R/3 repository, registering packages for   1

seed data, creating   1

Siebel Analytics Web, setting up   1

stored procedures, deploying   1

Dimension Key ID, configuring   1

dimension keys

additional or custom table, configuring lookup for   1

database joins, using   1

Dimension Key ID, configuring   1

dimension key resolution, using a lookup   1

resolving   1

documentation

additional   1

domain values

domain value conversion process, understanding   1

domain value set, configuring   1

domain value set, extending   1

importance, understanding   1

information, documentation referral   1

working with   1


Back to top


E

European Monetary Union currencies

EXP_CURR_CONVERSION_TRANSFORM Expression Transformation, using   1

flat file, using to supply exchange rates   1

handling   1

extract mapping

configurable objects   1

extracts, configuring

about   1

data extract, filtering   1

extracting additional data, about   1

extracting data from new source table   1

extracting new data from existing source table   1

workflow sessions, disabling   1


Back to top


F

features, new   1

fiscal calendar

fiscal month, configuring   1

fiscal week, configuring   1

Fiscal_months.csv and the Fiscal_weeks.csv files, using   1

loading   1


Back to top


G

gap analysis

about   1

beginning   1

gap-analysis process roles   1

populating guidelines   1

preparing for   1

resolving   1

guidelines

configuration   1


Back to top


H

historically significant attributes

identifying   1


Back to top


I

importing

module workflow into the repository   1

initial and incremental loads

about modifying session parameters   1

initialization workflows

common initialization workflow files   1

common initialization workflow, running   1

fiscal calendar, loading   1

initial and incremental loads, modifying session parameters   1

source-specific main workflows, working with   1

working with, about   1

initializing and populating

application database connections, configuring   1

common initialization workflow files   1

common initialization workflow, running   1

data parameters, configuring for parameter files   1

data types   1

database parameter, configuring for the source system   1

database performance, optimizing   1

fiscal calendar, loading   1

initial and incremental loads, modifying session parameters   1

initialization workflows, about working with   1

post-load processing workflows, about working with   1

relational database connections, replacing   1

repository connections, modifying   1

source-specific main workflows, working with   1

installing

configuration requirements, determining   1

configuration, process of defining   1

data warehouse and staging tables, gathering information about   1

database table, creating   1

development repository, process of creating   1

PowerCenter   1

PowerCenter variable names for installation   1

Siebel Analytics   1

Siebel Enterprise Analytic Applications   1

Siebel Enterprise Analytic Applications repository, setting up   1

source systems and database platforms, determining requirements   1


Back to top


L

load mapping

configurable objects   1

loads, configuring

about   1

objects, joining in the Staging Area   1

Source Adapter mapplet. creating   1


Back to top


M

module workflows

importing into the repository   1

modules

information, documentation referral   1

multimodule workflows

about building   1

multimodule workflow, creating   1

nonreusable worklets, editing   1

post-load processing incremental workflow, creating   1

post-load processing initial workflow, creating   1

process of building   1


Back to top


O

objects

joining in Staging Area   1

Oracle 11i

Customers Dimension table, mapping source customer hierarchies to   1

group currency code, configuring   1

last extract date, modifying   1

Oracle Flex fields, incorporating   1

Organization ID, setting   1

process of configuring Siebel Financial Analytics for   1

process of configuring Siebel Strategic Sourcing Analytics for   1 ,  2

process of configuring Siebel Supply Chain Analytics for   1

product categories, configuring   1

Siebel Enterprise Sales Analytics, configuring for   1

Source ID, modifying   1


Back to top


P

parameter files

configuring date parameters for   1

PeopleSoft

process of configuring for Siebel Financial Analytics   1

PeopleSoft Trees   1

performance

database performance, optimizing   1

platforms

See Determining Source Requirements

platforms supported

documentation referral   1

populating

application database connections, configuring   1

common initialization workflow files   1

common initialization workflow, running   1

data parameters, configuring for parameter files   1

data types   1

database parameter, configuring for the source system   1

fiscal calendar, loading   1

guidelines   1

initial and incremental loads, modifying session parameters   1

initialization workflows, about working with   1

optimizing database performance   1

post-load processing workflows, about working with   1

relational database connections, replacing   1

repository connections, modifying   1

source-specific main workflows, working with   1

post-load mapping

configurable objects   1

PowerCenter

information, documentation referral   1

installing   1

PowerCenter variable names for installation   1

PowerMart

information, documentation referral   1

primary extract and delete mapping

delete and primary extract sessions, enabling   1

particular source, deleting records from   1

record reject flag. configuring   1

source-archived records, deletion configuration   1

working with   1


Back to top


R

record deletion flag

configuring   1

record reject flag

configuring   1

records

deleting records from a particular source   1

record deletion flag, configuring   1

record reject flag, configuring   1

source-archived records, deletion configuration   1

records, filtering and deleting

about   1

primary extract and delete mappings, understanding   1

primary extract and delete mappings, working with   1

relational database

connections, replacing   1

release, new features   1

reporting area

configurable objects   1

repository

copying required data files   1

data warehouse schema control tables, creating   1

development repository, backing up   1

empty repository, creating and configuring   1

module workflows, importing   1

repository and repository server, modifying   1

repository connections, modifying   1

rollback segments, modifying   1

SAP R/3 repository, registering packages for   1

seed data, creating   1

Siebel Enterprise Analytic Applications repository, setting up   1

stored procedures, deploying   1

resources

additional   1

rollback segments

modifying   1


Back to top


S

SAP R/3

process of configuring for Siebel Financial Analytics   1

Siebel Enterprise Sales Analytics, configuring for   1

Siebel Financial Analytics, ETL for   1

SAP R/3 repository

registering packages for   1

SAP R/3 source system

ABAP, code, generating   1

profile, creating   1

seed data

creating   1

Siebel Analytics

installing   1

Siebel Analytics Web

setting up   1

Siebel Enterprise Analytic Applications

installing   1

repository, setting up   1

Siebel Enterprise Contact Center Analytics

Benchmarks and Targets table, setting up   1

configuring flags for   1

Contact Representative Snapshot table, setting up   1

Contact Status Type columns, about configuring for   1

dates and times, configuring   1

dimension key resolution   1

dimension table, loading   1

Event Type columns, about configuring for   1

excluding representative data   1

fact table, loading   1

overview   1

Representative Activities table, setting up   1

Siebel Enterprise Sales Analytics

currency and quantity grain   1

multiple products, about tracking   1

Oracle 11i, process of configuring for   1

overview   1

Sales Order Dates, about   1

SAP R/3, process of configuring for   1

Siebel Enterprise Workforce Analytics

domain values and CSV worksheet files   1

domain values and CSV worksheet files, configuring   1

overview   1

Payroll table, about aggregating   1

Payroll table, aggregating   1

Workforce Operations, about configuring for Oracle 11i   1

Workforce Operations, process of configuring for Oracle 11i   1

Workforce Payroll, process of configuring for Oracle 11i   1

Siebel Financial Analytics

ETL for SAP R/3   1

overview,   1

PeopleSoft Trees   1

process of configuring Oracle 11i for   1

process of configuring PeopleSoft for   1

process of configuring post-load processing for   1

process of configuring SAP R/3 for   1

Siebel Strategic Sourcing Analytics

configuring date parameter file for SAP R/3   1

configuring Siebel Business Analytics repository for SAP R/3   1

domain values and CSV worksheet files   1

overview   1

post-load processing, configuring expenses for   1

process of aggregating tables for   1

process of configuring Oracle 11i for   1 ,  2

process of configuring universal source for   1

universal source, configuring expenses   1

Siebel Supply Chain Analytics

overview   1

process of aggregating tables for   1

process of configuring Oracle 11i for   1

SAP R/3 inventory transfer process   1

slowly changing dimensions, configuring

about   1

currencies, configuring   1

effective dates   1

historically significant attributes, identifying   1

Type I changing dimension   1

Type II slowly changing dimension   1

Type II slowly changing dimensions, enabling   1

Source Adapter mapplet

creating   1

source systems

database parameter, configuring for   1

requirements, determining   1

SAP R/3 source system   1

Universal Business Adapter, using   1

source-archived records

deletion configuration   1

source-specific main workflows

working with   1

Staging Area

joining objects   1

staging tables

gathering information   1

stored lookups

configuring   1

stored procedures

deploying   1

system requirements

supported platforms, documentation referral   1


Back to top


T

Time.txt file   1

Time_am and Time_pm.csv files   1

Timespan.txt file   1


Back to top


U

Universal Business Adapter

using   1

universal source

conformed dimensions, configuring   1

process of configuring Siebel Strategic Sourcing Analytics for   1

Siebel Strategic Sourcing Analytics, configuring expenses   1


Back to top


W

workflow sessions

disabling   1

workflows

common initialization workflows files   1

common initialization workflows, running   1

fiscal calendar, loading   1

initialization workflows, about working with   1

module workflows, importing into the repository   1

post-load processing workflows, about working with   1

Back to top

Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide, Version 7.8.3