Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide
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
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
Understanding Dimensional Models
Online and Offline Repository Modes
Checking the Consistency of a Repository or a Business Model
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
Setting Up and Working with a Repository
Components of a Repository in the Administration Tool
Business Model and Mapping Layer
The Steps to Setting Up a Repository
Importing the Physical Schemas
Create and Configure the Connection Pool
Define Join Conditions on the Physical Schema
Creating the Presentation Layer
Save Repository, Check Consistency, and Correct Any Errors
Add an Entry in the NQSConfig.INI File
Start the Siebel Analytics Server
Test and Refine the Repository
Constructing a Filter for Query Results
Working in a Repository's Presentation Layer
Working with Presentation Catalogs
Working with Presentation Tables
Working with Presentation Columns
Using the Alias Tab of Presentation Layer Dialog Boxes
Working in a Repository's Physical Layer
Using the Physical Table Dialog Box
Defining Physical Joins with the Joins Manager
Defining Physical Joins in the Physical Table Diagram
Working in a Repository's Business Model and Mapping Layer
Business Model and Mapping Layer Objects
Working with Logical Table Sources (Mappings)
Defining Logical Joins with the Joins Manager
Defining Logical Joins with the Business Model Diagram
Showing Physical Tables That Are Sources of Logical Objects
Administration Tool Utilities and Expression Builder
Copy Business Model with Presentation Catalog
Setting Up Aggregate Navigation
Specify the Aggregate Levels for Each Source
Create Dimension Sources for Each Level of Aggregated Fact Data
Dimension-Specific Aggregation Rules
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
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
Collecting More Detailed Information About Queries
Server Configuration and Tuning
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
Displaying Global Cache Information
About the Refresh Interval for XML Data Sources
Connectivity and Third-Party Tools
Configuring Siebel Analytics ODBC Data Source Names (DSNs)
Third-Party Tools and Relational Datasource Adapters
Using Variables in a Repository
Using System Session Variables
Using Nonsystem Session Variables
Initializing Dynamic Repository Variables
Initializing Session Variables
Creating and Editing Initialization Blocks
Tasks Using the Initialization Block Dialog Box—Variable Tab
Initialization When the Siebel Analytics Server Starts
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
Importing Users and Groups from LDAP
Operating System Authentication
Siebel Analytics Server Internal Authentication
Bypassing Siebel Analytics Server Security
Using the Siebel Analytics Server XML Gateway
Siebel Analytics Server XML Gateway Example
SELECT Query Specification Syntax
Rules for Queries with Aggregate Functions
Sample Scripts and Load Procedures for Usage Tracking Data
Locating the Sample Scripts for Usage Tracking Data
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 23 June 2003 |