Siebel Analytics Server Administration Guide


How This Guide Is Organized

Revision History

Back to top

Overview of the Siebel Analytics Server

The Siebel Analytics Server and Business Modeling

Siebel Analytics Server Features

Siebel Analytics Server in the Decision Support Environment

Siebel Analytics Server and the Data Warehouse

Siebel Analytics Server Components

Back to top

Data Modeling

Understanding the Business Model

Understanding the Physical Database Model

Primary Key-Foreign Key Relationships

Knowing the Contents of the Physical Database

Knowing the Aggregate Table Definitions

Logical Business Models

Understanding Dimensional Models

Back to top

Administration Tool Basics

User Interface Components

Online and Offline Repository Modes

Checking the Consistency of a Repository or a Business Model

Checking In Changes

Setting Preferences

Using the Options Dialog Box—General Tab

Using the Options Dialog Box—Sort Objects Tab

Using the Options Dialog Box—Cache Manager Tab

Using the Options Dialog Box—More Tab

Setting Permissions for Repository Objects

Displaying and Updating Row Counts for Tables and Columns

Using the Browse Dialog Box

Back to top

Setting Up and Working with a Repository

Components of a Repository in the Administration Tool

Physical Layer

Business Model and Mapping Layer

Presentation Layer


Context-Sensitive Menus

The Steps to Setting Up a Repository

Creating a New Repository

Importing the Physical Schemas

Create and Configure the Connection Pool

Define Join Conditions on the Physical Schema

Create the Business Model

Creating the Presentation Layer

Save Repository, Check Consistency, and Correct Any Errors

Add an Entry in the NQSConfig.INI File

Create the Data Source

Start the Siebel Analytics Server

Test and Refine the Repository

Publish to User Community

Synchronizing Repositories

Managing Repository Metadata

Constructing a Filter for Query Results

Comparing Repositories

Merging Repositories

Back to top

Working in a Repository's Presentation Layer

Presentation Layer Objects

Working with Presentation Catalogs

Working with Presentation Tables

Working with Presentation Columns

Using the Alias Tab of Presentation Layer Dialog Boxes

Back to top

Working in a Repository's Physical Layer

Physical Layer Objects

Working with Databases

Working with Connection Pools

Working with Catalog Folders

Working with Schema Folders

Working with Physical Tables

Using the Physical Table Dialog Box

Specifying a Primary Key

Working with Physical Columns

About Physical Joins

Defining Physical Joins with the Joins Manager

Defining Physical Joins in the Physical Table Diagram

Using Database Hints

Back to top

Working in a Repository's Business Model and Mapping Layer

Business Model and Mapping Layer Objects

Working with Business Models

Working with Logical Tables

Working with Logical Columns

Working with Logical Table Sources (Mappings)

Working with Dimensions

Creating a Dimension

Working with Levels

About Logical Joins

Defining Logical Joins with the Joins Manager

Defining Logical Joins with the Business Model Diagram

Specifying a Driving Table

Showing Physical Tables That Are Sources of Logical Objects

Back to top

Administration Tool Utilities and Expression Builder

Utilities and Wizards

Time Series Wizard

Synchronize Aliases

Replace Wizard

Copy Business Model with Presentation Catalog

Siebel Analytics Event Tables

Execute UDML

Query Statistics

Externalize Strings

Rename Wizard

Update Physical Layer Wizard

Repository Documentation

Expression Builder

Back to top

Setting Up Aggregate Navigation

About Aggregate Navigation

Specify the Aggregate Levels for Each Source

Create Dimension Sources for Each Level of Aggregated Fact Data

Specify Fragmentation Content

Dimension-Specific Aggregation Rules

Aggregate Table Fragments

Back to top

Administering the Query Environment

Starting the Siebel Analytics Server

Starting the Server from the Services Applet in Windows

Configuring the Server for Automatic Startup in Windows

Running the Siebel Startup Script in UNIX

Changing the User ID in Which the Siebel Analytics Server Runs

If the Server Fails to Start

Shutting Down the Server

Shutting Down the Server from the Services Applet in Windows

Shutting Down the Server from a Command Prompt in Windows

Running the Siebel Analytics Server Shutdown Script in UNIX

Shutting Down the Server Using the Administration Tool

Getting Users to Connect to the Server

Administering the Query Log

Administering Usage Tracking

Selecting an Output Location

Performance Considerations

Collecting More Detailed Information About Queries

Server Session Management

Server Configuration and Tuning

Back to top

Query Caching

About the Query Cache

Query Cache Architecture

Configuring Query Caching

Monitoring and Managing the Cache

Strategies for Using the Cache

Cache Event Processing with an Event Polling Table

Setting Up Event Polling Tables on the Physical Databases

Making the Event Polling Table Active

Populating the Siebel Analytics Server Event Polling Table

Troubleshooting Problems with an Event Polling Table

Making Changes to a Repository

Using the Cache Manager

Displaying Global Cache Information

Purging Cache

About the Refresh Interval for XML Data Sources

Back to top

Connectivity and Third-Party Tools

Configuring Siebel Analytics ODBC Data Source Names (DSNs)

Third-Party Tools and Relational Datasource Adapters

Importing Metadata

ODBC Conformance Level

Back to top

Using Variables in a Repository

Using the Variable Manager

Using Repository Variables

About Session Variables

Using System Session Variables

Using Nonsystem Session Variables

Creating New Variables

About Initialization Blocks

Initializing Dynamic Repository Variables

Initializing Session Variables

Creating and Editing Initialization Blocks

Tasks Using the Initialization Block Dialog Box—Variable Tab

Default Initializer

Initialization When the Siebel Analytics Server Starts

Execution Precedence

Back to top

Clustering Siebel Analytics Servers

About the Cluster Server Feature

Components of the Cluster Server Feature

Implementing the Cluster Server Feature

Chronology of a Cluster Operation

Using the Cluster Manager

Viewing Cluster Information

Managing Clustered Servers

Performance Considerations

Back to top


Security Manager

Working with Users

Working with Groups

Importing Users and Groups from LDAP

Authentication Options

Operating System Authentication

LDAP Authentication

External Table Authentication

Database Authentication

Siebel Analytics Server Internal Authentication

Order of Authentication

Bypassing Siebel Analytics Server Security

Query Execution Privileges

Back to top

Using XML as a Data Source


Locating the XML URL

Using the Siebel Analytics Server XML Gateway

Siebel Analytics Server XML Gateway Example

Accessing HTML Tables

Using the Data Mining Adapter


XML ODBC Example

XML Examples





Back to top

SQL Reference

SQL Syntax and Semantics

SELECT Query Specification Syntax

SELECT Usage Notes

SELECT List Syntax

Rules for Queries with Aggregate Functions

SQL Logical Operators

Conditional Expressions

SQL Reference

Aggregate Functions

Running Aggregate Functions

String Functions

Math Functions

Calendar Date/Time Functions

Conversion Functions

System Functions

Expressing Literals

Back to top

Sample Scripts and Load Procedures for Usage Tracking Data

Locating the Sample Scripts for Usage Tracking Data

Extracting to Oracle

Extracting to DB2

Extracting to SQL Server

Description of the Usage Tracking Data

Back to top

 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003