A - B - C - D - E - F - H - I - J - L - M - N - O - P - Q - R - S - T - U - V - W

A

action links

about   1

quotation marks, about   1

testing   1

alignments dimension, configuring   1

ANSI NULL option, setting   1

Attribute Analysis, configuring for   1

Back to top

B

bridges

architecture   1

overview   1

setting up transactional database   1

browsers

settings, configuring   1

bulkload mode, error while creating a custom session   1

Back to top

C

change capture filter

using   1

circular hierarchy exceptions, about and example   1

CME analytics applications

dashboards and pages   1

data requirements   1

order management analytics, about   1

predictive scores, developing and deploying   1

complex products defined   1

configuring

DAC client   1

DAC config.bat   1

DAC metadata repository   1

email recipients in DAC client   1

Siebel Data Warehouse database   1

SSE role   1

consumer sector

See Consumer Sector Analytics Security Settings

Cost List exceptions

See also Understanding Siebel Data Warehouse Exceptions

about and example   1

Cost lists, using to display   1

products without a cost list   1

currency, diagnosing translation issues   1

customizing

data warehouse, ETL process concepts   1

Siebel Data Warehouse   1

templates   1

Back to top

D

DAC

Design view   1

DAC config.bat

configuring   1

DAC metadata repository

configuring   1

DAC query functionality   1

DAC server

server monitor icon   1

dashboards

CME dashboards and pages   1

consumer sector dashboards and pages   1

custom labels, editing in   1

customizing, about   1

forecasting charts, enabling   1

views, adding   1

data flow

Online Analytical Processing (OLAP) database, about and diagram   1

data import

syndicated data loading, overview   1

data loading

See also Life Sciences Data Loading Issues with Siebel Data Warehouse

Siebel Analytics for Life Sciences, issues when loading   1

troubleshooting, Informatica and data loading issues   1

Data Warehouse

See Analytics Product Licensing

data warehouse

architecture   1

database connections   1

overview   1

Data Warehouse Application Console

user interface   1

Data Warehouse Application Console (DAC)

about   1

configuring on UNIX   1

Current Run tab   1

Database Connections tab   1

Design view   1

distributing metadata   1

editable lists   1

Email Recipients tab   1

ETL preferences   1

Execute view   1

executing ETLs   1

Execution Plans tab   1

handling ETL failures   1

Indices tab   1

Informatica Servers tab   1

logging in   1

main toolbar   1

menu bar   1

navigation tree   1

preview functionality   1

process life cycle   1

right-click menu   1

Run History tab   1

Setup view   1

Subject Areas tab   1

System Properties tab   1

Table Groups tab   1

Tables tab   1

Task Definitions tab   1

upgrading   1

Data Warehouse Application Console (DAC) client

configuring   1

Data Warehouse Application Console (DAC) system properties

setting up   1

database connection

ODBC   1

database connections

transactional, creating   1

database connections, creating

DB2 installations, creating database connections for   1

Oracle installation, creating database connections for   1

data-level security

about   1

implementing   1

DB Library Options setting, modifying   1

DB2

database connections, creating for   1

Siebel Data Warehouse requirements   1

Siebel Data Warehouse, cannot connect to   1

Delete triggers

creating   1

dimensions

alignments dimension, configuring   1

pharmaceuticals, configuring dimensions specific to   1

positions dimension, configuring   1

product costs, configuring   1

products dimension, configuring   1

Back to top

E

eBusiness Applications

See Siebel Partner Relationship Management Analytics Security Settings See Responsibilities and Data-Level Visibility in Workforce Analytics Applications See Responsibilities and Data-Level Visibility in Sales Analytics Applications

email notification, Outlook error when sending post session email   1

Enterprise Manager, error displayed after installing ODBC driver   1

environment variables

setting on UNIX   1

setting up on Windows   1

errors

See Troubleshooting the Siebel Data Warehouse

ETL History view, using to view the history of the ETL processes and statuses   1

exception reports

See also Understanding Siebel Data Warehouse Exceptions

additional exceptions, list of   1

circular hierarchy exceptions, about and example   1

cleansing the data, process and diagram   1

ETL History view, using to view the history of the ETL processes and statuses   1

exception report components, list of   1

exception, fixing   1

exchange rate exceptions, about   1

Exchange Rate view, using to diagnose currency translation issues   1

executing the report, cleansing steps   1

invalid hierarchy exceptions, about   1

List of Values exceptions   1

List of Values view, using to compare values with Siebel Data Warehouse   1

exchange rate exceptions, about   1

Exchange Rate view, using to diagnose currency issues   1

execution plans

pruning   1

tailoring   1

Back to top

F

filters for security groups, about   1

Finance Analytics application

logical table sources, disabling   1

logical table sources, updating   1

metadata translation strings, externalizing   1

security settings   1

Full_Extract_Siebel_DW, error returned by Informatica   1

Full_Load_Siebel_DW

error when running   1

Full_Load_Siebel_DW_Facts, error message when executing   1

Back to top

H

Healthcare Analytics

security settings   1

hierarchical relationships, invalid hierarchy exceptions, about   1

home page

content, customizing   1

customizing, about   1

path argument, determining   1

Back to top

I

importing

Siebel Industry Applications seed data   1

Incentive Compensation Analytics, turning on   1

Informatica

creating custom workflows   1

installing patches on UNIX   1

license files, updating on UNIX   1

Informatica client software

Enable Data Code Pages Validation, checking if conditions met   1

Informatica Metadata Reporter (IMR)

error when running, probable cause   1

Informatica patches installation   1

Informatica PowerCenter

installation wizard   1

Informatica repository

configuring   1

configuring in DAC   1

configuring in Workflow Manager   1

creating   1

dropping   1

pointing to   1

restoring   1

upgrading   1

verifying configuration   1

Informatica Repository Server

installing on UNIX   1

registering   1

starting   1

Informatica Server

installing on other than default location   1

installing on UNIX   1

registering   1

setting up   1

starting   1

starting on UNIX   1

stopping on UNIX   1

Informatica Server and repository, configuring

Unicode mode, configuring under Windows   1

Windows, setting up Informatica service under   1

Informatica Service, unable to start on Windows   1

initialization blocks

checking execution order   1

position and organization initialization variables   1

security information, and   1

installation

data warehouse installation and configuration process   1

database connectivity   1

Informatica patches   1

Informatica PowerCenter   1

Informatica Server, installing on other than default directory   1

Java SDK   1

Java SDK and drivers   1

JDBC drivers   1

Siebel Analytics Applications installation process task list   1

Teradata patch   1

Usage Accelerator   1

wizard, Siebel Analytics Applications   1

Insurance Analytics

security settings   1

IP address

virtual IP address, creating   1

virtual IP address, testing   1

Back to top

J

Java SDK

installation   1

JDBC drivers

installation   1

Back to top

L

language packs

installing   1

licensing

product licensing   1

List of Values

exceptions, about and example   1

view, using to compare values with the Siebel Data Warehouse   1

localization packs

installing   1

LOVs, adding   1

LS dimension tables, supported incremental updates (table)   1

Back to top

M

metadata object level security

repository groups   1

Web Catalog groups   1 ,  2

Web Catalog security   1 ,  2

metadata strings

externalizing   1

metadata, Siebel Analytical applications

Attribute Analysis, configuring for   1

dashboard forecasting charts, enabling   1

metadata, Siebel Industry applications

alignments dimension, configuring   1

Analytics applications, about metadata requirements   1

CME dashboards and pages   1

CME data requirements   1

consumer sector dashboards and pages   1

consumer sector data requirements   1

dimensions, configuring specific to pharmaceuticals   1

Finance Analytics applications, disabling logical table sources   1

Finance Analytics applications, externalizing metadata translation strings   1

Finance Analytics applications, updating logical table sources   1

Pharma customer demographics, configuring subject area   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales Analytics, about metadata requirements   1

Pharma sales effectiveness, configuring subject area   1

positions dimension, configuring   1

predictive scores, developing and deploying   1

product costs dimension, configuring   1

products dimension, configuring   1

Microsoft Outlook

closes when finishing ETL process, probable cause   1

error when sending post session email   1

Back to top

N

NQHOST setup, verifying for Pharma Field Analytics Client   1

Back to top

O

ODBC

creating database connections   1

OLAP

 1

Online Analytical Processing database

about   1

Data Warehouse, data flow into   1

Online Transaction Processing database

Online Analytical Processing database, differences from   1

OPB_OBJECT_LOCKS Informatica session deadlocked, probable cause   1

Oracle

database connections, creating for   1

mappings hang, probable cause   1

Siebel Data Warehouse requirements   1

order management analytics, about   1

organization-based security

initialization variables   1

position-based security, changing from   1

Outlook

closes when finishing ETL process, probable cause   1

error when sending post session email   1

Back to top

P

parameter files

copying   1

parent-child relationship, circular hierarchy exceptions   1

performance

components configured to optimize performance   1

Pharma

customer demographics, configuring subject area   1

medical education effectiveness, configuring subject area   1

objectives achievement, configuring subject area   1

product categories, configuring subject area   1

promotional effectiveness, configuring subject area   1

sales effectiveness, configuring subject area   1

Pharma Field Analytics Client, verifying NQHOST setup   1

Pharma Sales Analytics

alignments dimension, configuring   1

dimensions, configuring specific to pharmaceuticals   1

metadata requirements, about   1

Pharma customer demographics, configuring subject area   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales effectiveness, configuring subject area   1

positions dimension, configuring   1

product costs dimension, configuring   1

products dimension, configuring   1

security settings   1

position-based security

initialization variables   1

organization-based security, changing to   1

positions dimension, configuring   1

predictive analytics metadata

predictive scores, developing and deploying   1

product costs dimension, configuring   1

product licensing   1

products dimension, configuring   1

Back to top

Q

Query Analyzer, can not open after installing ODBC driver   1

Back to top

R

RDBMS error message, probable cause   1

Refresh_Extract_Siebel_DW

error returned by Informatica   1

reports

custom labels, editing   1

responsibilities

access in Siebel Analytics   1

integrated security, about   1

Siebel ERM Analytics, and data-level visibility   1

user responsibilities, checking   1

user responsibilities, registering new responsibility   1

Back to top

S

S_MSG table, adding custom translations   1

Sales Analytics

dashboard forecasting charts, enabling   1

schema definitions

transactional database, updating   1

Schemas

upgrading   1

SDE_RecordLoadStart session fails, probable cause   1

SDEINC_RecordExtractStart session fails, probable cause   1

security

CME security settings   1

consumer sector security settings   1

data-level security, about   1

data-level security, implementing   1

default security settings   1

filters for security groups, about   1

initialization blocks and security   1

metadata object level security (repository groups), about   1

metadata object level security (Web Catalog groups), about   1

operational applications security   1 ,  2 ,  3

position and organization initialization variables   1

repository table joins, configuring   1

responsibilities and access in Siebel Analytics   1

responsibilities, integrated security for   1

security group, changing to organization-based   1

security levels, about   1

Siebel ERM Analytics security settings   1

Siebel Finance Analytics security settings   1

Siebel Pharma Sales Analytics security settings   1

Siebel PRM Analytics security settings   1

Siebel Sales Analytics security settings   1

Siebel Usage Accelerator Analytics security settings   1

user responsibilities, checking   1

user responsibilities, registering new responsibility   1

Web Catalog security   1 ,  2

seed data

importing   1

Siebel Industry Applications seed data, importing   1

server components, installation requirements

See also General Guidelines for Setting Up Siebel Data Warehouse

Siebel Data Warehouse, about   1

setting up

DAC system properties   1

Siebel Analytics Applications

bridges, overview   1

installation and configuration flow   1

installation and configuration process task list   1

installation process   1

installation wizard   1

installing, UNIX   1

overview   1

UNIX, deploying   1

upgrading   1

Siebel Analytics applications, configuring

action links with quotation marks, about   1

action links, about   1

action links, testing   1

browser settings, configuring   1

dashboards, adding views   1

home page and dashboards, about customizing   1

home page content, customizing   1

home page, determining path argument   1

Incentive Compensation Analytics, turning on   1

optional Siebel Analytics applications, accessing   1

Pharma Field Analytics Client, verifying NQHOST setup   1

process   1

Siebel operational applications, about integrating within   1

Siebel operational applications, completing initialization   1

Siebel Web Extension, configuring to work with   1

virtual IP address, creating   1

virtual IP address, testing   1

Siebel Analytics Charts

custom labels, editing in dashboards   1

initialization blocks, checking execution order   1

local seed data, importing   1

localization packs, installing   1

LOV, adding   1

metadata strings, externalizing   1

S_MSG table, adding custom translations   1

Siebel Analytics seed data, updating for non-English locales   1

Siebel Financial Service metadata import files, about   1

string translations, adding for metadata   1

translation tables, process of maintaining   1

Web catalog strings, about translating   1

Siebel Analytics for Life Sciences

data loading issues   1

LS dimension tables, supported incremental updates (table)   1

Siebel Analytics Presentation layer

process of maintaining translation tables   1

Siebel Analytics repository

externalizing metadata strings   1

repository groups, security   1

table joins, configuring   1

Siebel Analytics seed data

updating for non-English locales   1

Siebel CME Analytics applications

dashboards and pages   1

data requirements   1

predictive scores, developing and deploying   1

security settings   1

Siebel Communications, Media, and Energy Analytics

See Communications, Media, and Energy (CME) Analytics Security Settings

Siebel Consumer Sector Analytics applications

consumer sector dashboards and pages   1

consumer sector data requirements   1

security settings   1

Siebel Data Warehouse

architecture   1

architecture components   1

customizing   1

database parameters and requirements   1

database, configuring   1

DB2 requirements   1

deployment configuration   1

operating system, driver, connectivity requirements   1

Oracle requirements   1

overview   1

SQL server-specific requirements   1

tables, creating   1

templates for customizations   1

Teradata requirements   1

upgrading   1

Siebel ERM Analytics

responsibilities and data-level visibility   1

Siebel Finance Analytics applications

logical table sources, disabling   1

logical table sources, updating   1

metadata translation strings, externalizing   1

security settings   1

Siebel Financial Service metadata import files, about   1

Siebel Healthcare Analytics

security settings   1

Siebel Industry Applications

alignments dimension, configuring   1

Analytics applications, about metadata requirements   1

CME dashboards and pages   1

CME data requirements   1

CME security settings   1

consumer sector dashboards and pages   1

consumer sector data requirements   1

consumer sector security settings   1

dimensions, configuring specific to pharmaceuticals   1

Finance Analytics applications, disabling logical table sources   1

Finance Analytics applications, externalizing metadata translation strings   1

Finance Analytics applications, updating logical table sources   1

Pharma customer demographics, configuring subject area   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales Analytics, about metadata requirements   1

Pharma sales effectiveness, configuring subject area   1

positions dimension, configuring   1

predictive scores, developing and deploying   1

product costs dimension, configuring   1

products dimension, configuring   1

seed data, importing   1

Siebel Financial Services security settings   1

Siebel Pharma Sales security settings   1

Siebel Usage Accelerator Analytics security settings   1

Siebel Insurance Analytics

security settings   1

Siebel Operational Applications

dashboards, adding views   1

home page content, customizing   1

home page path argument, determining   1

initialization, completing   1

security   1 ,  2 ,  3

Siebel Analytics, about integrating within   1

Siebel ERM Analytics security settings   1

Siebel PRM Analytics security settings   1

Siebel Sales Analytics security settings   1

Siebel Operational Applications, integration with

data types   1

Siebel Industry Applications seed data, importing   1

Siebel Pharma Sales Analytics applications

alignments dimension, configuring   1

dimensions, configuring specific to pharmaceuticals   1

metadata requirements, about   1

Pharma customer demographics, configuring subject area   1

Pharma medical education effectiveness, configuring subject area   1

Pharma objectives achievement, configuring subject area   1

Pharma product categories, configuring subject area   1

Pharma promotional effectiveness, configuring subject area   1

Pharma Sales effectiveness, configuring subject area   1

positions dimension, configuring   1

product costs dimension, configuring   1

products dimension, configuring   1

security settings   1

Siebel PRM Analytics

data-level visibility   1

portal-based analytics dashboard mapping   1

role-based analytics dashboard mapping   1

security group, changing to organization-based   1

subject area mapping   1

subject area visibility   1

Siebel Sales Analytics

dashboard forecasting charts, enabling   1

responsibilities and data-level visibility   1

Siebel Transaction Database

connection error   1

Cost lists, displaying   1

Siebel Transactional database

importing locale seed data   1

Siebel transactional database

Siebel Data Warehouse, differences from   1

Siebel Usage Accelerator Analytics

security settings   1

Siebel Web Extension

configuring to work with   1

virtual IP address, creating   1

virtual IP address, testing   1

SIF files

importing   1

verifying SIF patch   1

simple products defined   1

SQL

SQL files as execution type   1

SQL Server

DB Library Options setting, modifying   1

Siebel Data Warehouse requirements   1

SSE role

creating   1

stored procedures

creating   1

string translations

adding for metadata   1

subject areas

pruning   1

SWE

See Process of Configuring Siebel Analytics with Siebel Web Extension (SWE)

syndicated data

importing, overview   1

system preferences

See also Understanding Siebel Data Warehouse Exceptions

Back to top

T

table groups

pruning   1

Teradata

activating join indexes   1

code page file property, setting   1

configuration checklist, Windows   1

creating and dropping tables   1

data warehouse requirements   1

Hosts file, setting up   1

installation   1

installation checklist for UNIX   1

installing patches on UNIX   1

loader control files, copying   1

setting up Hosts file on UNIX   1

Test entry   1

translation tables

process of maintaining   1

troubleshooting

Data Warehouse Application Console (DAC)   1

Informatica and data loading issues   1

Siebel Data Warehouse installation   1

Unicode   1

UNIX installation   1

Back to top

U

Unicode

custom labels, editing in dashboards   1

deploying Informatica and Siebel Data Warehouse in   1

initialization blocks, checking execution order   1

local seed data, importing   1

localization pack, installing   1

LOV, adding   1

metadata strings, externalizing   1

S_MSG table, adding custom translations   1

Siebel Analytics seed data, updating for non-English locales   1

Siebel Financial Service metadata import files, about   1

string translations, adding for metadata   1

translation tables, process of maintaining   1

Web catalog strings, about translating   1

Unicode mode

Windows, configuring under   1

UNIX

deploying Siebel Analytics Applications   1

updating license files   1

URL

dashboards, configuring for   1

home page, configuring for   1

Usage Accelerator

installing   1

Usage Accelerator Analytics security settings   1

user responsibilities

checking   1

new responsibility, registering   1

Back to top

V

views, adding to dashboards   1

virtual IP address

creating   1

testing   1

Back to top

W

Web Catalog groups

metadata object security   1

Siebel Analytics applications, security in   1 ,  2

Web Catalog strings

about translating   1

Windows

Informatica Server, setting up under   1

Unicode mode, configuring under Windows   1

workflows

error message when executing on the Informatica Server Manager, probable cause   1

Server Manager error message, probable cause   1

Back to top