| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Analytics Server Administration Guide
Introduction to Siebel Analytics Server Administration Guide
What's New in Siebel Analytics Server Administration Guide, Version 7.7
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
Analytics Administration Tool User Interface Components
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—Repository 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
Editing, Deleting, and Reordering Objects in the Repository
Displaying and Updating Row Counts for Tables and Columns
Setting Up a Siebel Analytics Server Repository
About Repository Structure in the Administration Tool
Process of Setting Up a Repository
Creating a New Analytics Repository File
Creating and Administering the Physical Layer in a Repository
Process of Creating the Physical Layer by Importing a Physical Schema
Process of Creating the Physical Layer for a Multidimensional Data Source
Creating a Database Object in the Physical Layer
Specifying SQL Features Supported by a Database
Creating a Connection Pool for All Data Sources
Setting Up Additional Connection Pool Properties for an XML Data Source
Setting Additional Connection Pool Properties for a Multidimensional Data Source
Creating and Administering Physical Tables
Creating and Administering General Properties for a Physical Table
Creating and Administering Columns and Keys in a Physical Table
Adding and Administering Hierarchies in the Physical Layer for a Multidimensional Data Source
Setting Physical Table Properties for an XML Data Source
Creating Physical Layer Folders
Using a Variable to Specify the Name of a Catalog or Schema
Setting Up Display Folders in the Physical Layer
Defining Physical Foreign Keys and Joins
Defining Physical Foreign Keys or Complex Joins with the Joins Manager
Defining Physical Joins in the Physical Diagram
Creating and Administering the Business Model and Mapping Layer in a Repository
Creating Business Model Objects
Creating and Administering Logical Tables
Adding or Editing Logical Table Sources
Specifying a Primary Key in a Logical Table
Editing Foreign Keys for a Logical Table
Creating and Administering Logical Columns
Setting Default Levels of Aggregation for Measure Columns
Associating an Attribute with a Level in Dimension Tables
Creating and Administering Logical Table Sources (Mappings)
Creating or Removing a Logical Table Source
Defining Physical to Logical Table Mappings
About Dimensions and Hierarchical Levels
Process of Creating and Administering Dimensions
Creating Dimension Levels and Keys
Creating Dimensions Automatically
Setting Up Dimension-Specific Aggregate Rules for Logical Columns
Setting Up Display Folders in the Business Model and Mapping Layer
Defining Logical Joins with the Joins Manager
Defining Logical Joins with the Business Model Diagram
Identifying Physical Tables That Map to Logical Objects
Creating and Maintaining the Presentation Layer in a Repository
Creating the Presentation Layer in the Repository
Working with Presentation Catalogs
Working with Presentation Tables
Working with Presentation Columns
Using the Alias Tab of Presentation Layer Dialog Boxes
Completing Setup and Managing Repository Files
Process of Completing the Setup for a Repository File
Saving the Repository and Checking Consistency
Add an Entry in the NQSConfig.INI File
Start the Siebel Analytics Server
Test and Refine the Repository
Importing from Another Repository
Querying and Managing Repository Metadata
Constructing a Filter for Query Results
Merging Siebel Analytics Repositories
Creating an Analytics Multiuser Development Environment
Business Scenario for Analytics Multiuser Development
Setting up an Analytics Multiuser Development Environment
Making Changes in an Analytics Multiuser Development Environment
Setting Up a Developer's Machine for Analytics Multiuser Development
Changing Metadata in an Analytics Multiuser Development Environment
Merging Metadata Changes Into the Source Repository
Setting Up Disconnected Analytics
Disconnected Analytics Architecture (Server and Laptop)
Installing Siebel Disconnected Analytics
Process of Creating and Deploying Disconnected Analytics Applications
Creating and Testing the SQL Anywhere Database Tables
Design the Table Schema for the Disconnected Analytics Application
Write the DDLs to Create the Local Database Tables
Creating and Testing Local Database Tables
Creating the Disconnected Analytics Repository
Create the Physical Layer of the Disconnected Analytics Repository
Create the Business Model and Mapping Layer of the Disconnected Repository
Create the Presentation Layer of the Disconnected Repository
Testing the Disconnected Repository
Creating the Disconnected Web Catalog
Defining Sourcing Reports for Disconnected Analytics
Defining Data Sets for Disconnected Analytics
Creating the Disconnected Application Configuration File
Creating the Application Configuration File for Disconnected Analytics
Preparing Disconnected Analytics Applications for Deployment
Testing and Deploying Siebel Disconnected Analytics
Testing Disconnected Analytics Applications
Testing the Installation Processes
Installing an Application Using Disconnected Analytics Application Manager
Installing a Disconnected Analytics Application Silently
Deleting Disconnected Analytics Applications
Administration Tool Utilities and Expression Builder
Copy Business Model with Presentation Catalog
Generating Documentation of Repository Mappings
Setting Up Aggregate Navigation
Specify the Aggregate Levels for Each Source
Create Dimension Sources for Each Level of Aggregated Fact Data
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
Administering Direct Insertion for Usage Tracking
Collecting More Detailed Information About Queries
Server Configuration and Tuning
Query Caching in Siebel Analytics Server
About the Analytics Server Query Cache
Monitoring and Managing the Cache
Purging Cache Programmatically
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 the Analytics Server Repository
Using the Analytics Variable Manager
Initializing Dynamic Repository Variables
Initializing Session Variables
Creating and Editing Initialization Blocks
Tasks Using the Initialization Block Dialog Box—Variable Tab
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
Managing Query Execution Privileges
Using XML as a Data Source for Analytics
Using the Siebel Analytics Server XML Gateway
Siebel Analytics Server XML Gateway Example
SELECT Query Specification Syntax
Rules for Queries with Aggregate Functions
Usage Tracking Data Descriptions and Using the Log File Method
Create Table Scripts for Usage Tracking Data
Loading Usage Tracking Tables with Log Files
Description of the Usage Tracking Data
Pharma Analytics Administration Reference
Sourcing Reports for Pharma Analytics
| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Analytics Server Administration Guide, Version 7.7 Published: 11 March 2004 |