Table of Contents
- Title and Copyright Information
- Preface
-
Part I Administer Oracle Analytics Server
-
1
Introduction to System Administration in Oracle Analytics Server
- What Are the System Administration Tasks?
- Get Started to Manage the System
- What Is the Logical System Architecture?
- Key Directories
- What Are the System Administration Tools?
- Access the Console in Oracle Analytics Server
- Access the Classic Administration Page
- Download, Install, and Start the Client Tools for Oracle Analytics Server
- Oracle Analytics Publisher Integration
- About Oracle Fusion Middleware Feature Support in Oracle Analytics Server
-
1
Introduction to System Administration in Oracle Analytics Server
-
Part II Manage Your Installation
-
2
Start and Stop Your System
- About Managing Processes
- Conditions to Start the System
- Start and Stop the System on Windows
- Use Commands to Start, Stop, and View Status of Processes
- Use Fusion Middleware Control to Start and Stop System Component Processes
- Use Fusion Middleware Control to Start and Stop Java Components
- Use Oracle WebLogic Server Administration Console to Start and Stop Java Components
- 3 Take Snapshots and Restore
-
4
Perform Common Administration Tasks
- Typical Workflow of Common Administration Tasks
- Configure a Virus Scanner
- Register Safe Domains
- Add Custom Knowledge for Data Enrichment
- Set Up Social Channels For Sharing Visualizations
- Set Up a Public Container to Share Visualizations
- Delete Unused Datasets
- Monitor Users and Activity Logs
- Run Test SQL Queries
- Apply Custom Logos and Dashboard Styles
- Enable Custom Java Script for Actions
- Switch to a Different Language
- About Advanced Configuration Options
- Configure System Settings Using Console
- Manage Content
- Enable Users to Export to Excel
-
2
Start and Stop Your System
-
Part III Scale and Deploy for High Availability and
Performance
- 5 Scale Your Deployment
- 6 Deploy for High Availability
-
7
Manage Performance Tuning and Query Caching
- Monitor Service Levels
- About Query Performance Tuning
-
Set Performance Parameters in Fusion Middleware
Control
- Use Fusion Middleware Control to Disallow Semantic Model Updates
- Use Fusion Middleware Control to Set the User Session Log-Off Period
- Use Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables
- Use Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table View
- About the BI Server Query Cache
- Configure Query Caching
- Monitor and Manage the Cache
- Strategies for Using the Cache
- Cache Event Processing with an Event Polling Table
- Configure the Data Source Cache
- Manage Presentation Services Cache Settings
- Improve Web Client Performance
- Optimize Performance by Setting the JVM Heap Size
- Improve Performance when Downloading Large Reports
- Capture Metrics Using the Dynamic Monitoring Service
-
Part IV Resolve Issues
-
8
Diagnose and Resolve Issues
- What Diagnostic Tools Are Available?
- Collect Diagnostic Bundles
- View and Configure Diagnostic Log Files
- Understand Diagnostic Log Files and Log Configuration Files
- Manage the Query Log
- Log Information in Oracle Analytics Presentation Services
- Use ODBC/JDBC Procedures to Obtain BI Server Diagnostics
-
9
Track Usage
- About Tracking Usage
- Understand the Usage Tracking Tables
- Typical Workflow for Tracking Usage
- Set Up Usage Tracking
- Specify the Usage Tracking Database
- Set Usage Tracking Parameters
- Recommended Configuration Settings for Usage Tracking using SQL Server
- Analyze Usage Tracking Data
- Manually Set Up Direct Insertion to Collect Information for Usage Tracking
-
8
Diagnose and Resolve Issues
-
Part V Configure Oracle Analytics Server
- 10 Use Tools to Manage and Configure the System
- 11 Use Scripts to Manage Oracle Analytics Server Instances
- 12 Configure Connections to External Systems
- 13 Configure Presentation Setting Defaults
- 14 Configure Map and Spatial Information
- 15 Configure Time Zones
-
16
Localize Oracle Analytics Server
- What Is Localization?
- Localize Presentation Services
- Localize Data Visualization
-
Set the Current Locale in the Oracle BI
Server
- Set Locale Parameters on the Oracle BI Server
- Understand How the Error Message Language Is Determined
- Set the Language for Components of the Oracle BI Server
- Modify the Language of the User Interface for the Model Administration Tool
- Troubleshoot the Current Locale in the Oracle BI Server
- Ensure That Text for Oracle BI Server Utilities Is Displayed in the Correct Language
- Modify the Semantic Model When the Underlying Oracle Database NLS_CHARACTERSET Is Non-Unicode
- Localize Metadata Names in the Semantic Model
-
Support Multilingual Data
- What Is Multilingual Data Support?
- What Is Lookup?
- What Is Double Column Support?
- Design Translation Lookup Tables in a Multilingual Schema
- Create Logical Lookup Tables and Logical Lookup Columns
- Create Physical Lookup Tables and Physical Lookup Columns
- Support Multilingual Data in Essbase Through Alias Tables
- Enable Lexicographical Sorting
- 17 Configure Currency Options
- 18 Manage How Content Is Indexed and Searched
- 19 Configure and Manage the Presentation Catalog
-
Part VI Advanced Configuration Settings
-
20
Configure and Manage Analyses and
Dashboards
- Manage Dashboards
- Perform General Configuration Tasks for Analyses
-
Configure for Display and to Process Data in
Views
- Manually Configure for Data in Views
- Manually Configure Graphs and Gauges
- Manually Change Alternating Bar Color
- Manually Configure for Interactions in Views
- Configure for Prompts
-
Manually Change Presentation Settings
- Manually Change Presentation Setting Defaults
- Manually Create Custom Links in Presentation Services
- Enable the Ability to Create Links to Dashboard Pages
- Configure an Alternate Toolbar for Oracle Analytics Server Publisher
- Enable the Ability to Export Dashboard Pages to Oracle Analytics Server Publisher
- Modify the Table of Contents for PDF Versions of Briefing Books
- Configure a Custom Download Link for the Smart View Installer
- Validate and Block Queries in Analyses
- Specify View Defaults for Analyses and Dashboards
- Configure for Write-back in Analyses and Dashboards
- Add Custom Knowledge for Data Enrichment
- Customize the User Interface
-
21
Configure and Manage Agents
- How Are Agents Used?
- Enable and Customize Content Delivery Through Agents
- How Do Antivirus Software and Privileges Affect Agents?
- Configure Settings that Affect Agents
- Manage the Types of Devices that Deliver Content
- Monitor Active Agent Sessions
- 22 Configure Advanced Options for Maps and Spatial Information
- 23 Configure Resource Availability and URL Generation
- 24 Use Custom Scripts to Curate Your Data
-
20
Configure and Manage Analyses and
Dashboards
- Part VII Manage the Life Cycle
- Part VIII Reference Information
-
A
Certification Information
- Certification - Supported Data Sources
- Certification - Supported Data Types
- Certification - Repository Creation Utility (RCU) Databases
- Certification - Supported Browsers
- Certification - Clients
- Certification - Identity Servers and Access
- Certification - Interoperability
- Certification - Systems
- Certification - Web Servers
- B Frequently Asked Questions
- C Troubleshooting
- D Advanced Configuration Reference
- E Map User Interface Labels with Configuration File Elements
-
F
Configuration File Settings
- Configuration Files
-
NQSConfig.INI File Configuration Settings
- About Parameters in the NQSConfig.INI File
- Repository Section Parameters
- Multitenancy Section Parameters
-
Query Result Cache Section Parameters
- ENABLE
- DATA_STORAGE_PATHS
- MAX_ROWS_PER_CACHE_ENTRY
- MAX_CACHE_ENTRY_SIZE
- MAX_CACHE_ENTRIES
- POPULATE_AGGREGATE_ROLLUP_HITS
- USE_ADVANCED_HIT_DETECTION
- MAX_SUBEXPR_SEARCH_DEPTH
- DISABLE_SUBREQUEST_CACHING
- CACHE_FILE_BUFFER_SIZE
- GLOBAL_CACHE_STORAGE_PATH
- MAX_GLOBAL_CACHE_ENTRIES
- CACHE_POLL_SECONDS
- CLUSTER_AWARE_CACHE_LOGGING
-
General Section Parameters
- LOCALE
- SORT_ORDER_LOCALE
- SORT_TYPE
- CASE_SENSITIVE_CHARACTER_COMPARISON
- NULL_VALUES_SORT_FIRST
- DATE_TIME_DISPLAY_FORMAT
- DATE_DISPLAY_FORMAT
- TIME_DISPLAY_FORMAT
- WORK_DIRECTORY_PATHS
- WORK_FILE_COMPRESSION_LEVEL
- ENABLE_COLUMNAR_STORAGE_FOR_WORK_FILE
- WORK_DIRECTORY_SIZE_GLOBAL_LIMIT
- MAX_WORK_FILE_SIZE_PERCENT
- VIRTUAL_TABLE_PAGE_SIZE
- USE_LONG_MONTH_NAMES
- MEMORY_COMPACT_PERIOD_IN_SECONDS
- USE_LONG_DAY_NAMES
- USE_UPPERCASE_MONTH_NAMES
- USE_UPPERCASE_DAY_NAMES
- UPPERCASE_USERNAME_FOR_INITBLOCK
-
Security Section Parameters
- DEFAULT_PRIVILEGES
- PROJECT_INACCESSIBLE_COLUMN_AS_NULL
- IGNORE_LDAP_PWD_EXPIRY_WARNING
- MAX_AUTHENTICATION_TIME
- INIT_BLOCK_LOG_TIME_THRESHOLD
- NUM_INIT_BLOCK_THREADS_PER_USER
- SSL
- SSL_CERTIFICATE_FILE
- SSL_PRIVATE_KEY_FILE
- SSL_PK_PASSPHRASE_FILE
- SSL_PK_PASSPHRASE_PROGRAM
- SSL_VERIFY_PEER
- SSL_VERIFY_SERVERS
- SSL_VERIFY_CLIENTS
- SSL_CA_CERTIFICATE_DIR
- SSL_CA_CERTIFICATE_FILE
- SSL_TRUSTED_PEER_DNS
- SSL_INTERNAL_CA_CERTIFICATE_FILE
- SSL_INTERNAL_TRUSTED_PEER_DNS
- SSL_WEBSERVER_CA_CERTIFICATE_FILE
- SSL_WEBSERVER_TRUSTED_PEER_DNS
- SSL_CERT_VERIFICATION_DEPTH
- SSL_CIPHER_LIST
-
Server Section Parameters
- READ_ONLY_MODE
- MAX_SESSION_LIMIT
- MAX_REQUEST_PER_SESSION_LIMIT
- SERVER_THREAD_RANGE
- SERVER_THREAD_STACK_SIZE
- DB_GATEWAY_THREAD_RANGE
- DB_GATEWAY_THREAD_STACK_SIZE
- HTTP_CLIENT_THREAD_RANGE
- HTTP_CLIENT_THREAD_STACK_SIZE
- MAX_EXPANDED_SUBQUERY_PREDICATES
- MAX_QUERY_PLAN_CACHE_ENTRIES
- MAX_QUERY_PLAN_CACHE_ENTRY_SIZE
- MAX_DRILLDOWN_INFO_CACHE_ENTRIES
- MAX_DRILLDOWN_QUERY_CACHE_ENTRIES
- INIT_BLOCK_CACHE_ENTRIES
- CLIENT_MGMT_THREADS_MAX
- DEFAULT_JOBQUEUE_SIZE_PER_THREAD
- MAX_COLUMNS_IN_SELECT
- MAX_LOGICAL_DIMENSION_TABLES
- MAX_LOGICAL_FACT_TABLES
- MAX_LOGICAL_MEASURES
- MAX_SET_OPERATION_BLOCKS
- DEFAULT_DB_MAX_EXEC_TIME
- QUERY_LIMIT_WARNING_INSTEAD_OF_ERROR
- RPC_SERVICE_OR_PORT
- LISTEN_ADDRESS
- LISTEN_PORT
- ENABLE_DB_HINTS
- PREVENT_DIVIDE_BY_ZERO
- CLUSTER_PARTICIPANT
- DISCONNECTED
- VARIABLE_VALUE_LIMIT
- EVALUATE_SUPPORT_LEVEL
- FMW_SECURITY_SERVICE_URL
- FMW_SECURITY_SERVICE_MAX_NUMBER_OF_CONNECTIONS
- FMW_SECURITY_SERVICE_MAX_NUMBER_OF_RETRIES
- ENABLE_NUMERIC_DATA_TYPE
- ENDECA_SERVLET_URL
- High Availability Parameters
- Dynamic Library Section Parameters
-
Usage Tracking Section Parameters
- ENABLE
- DIRECT_INSERT
- STORAGE_DIRECTORY
- CHECKPOINT_INTERVAL_MINUTES
- FILE_ROLLOVER_INTERVAL_MINUTES
- CODE_PAGE
- PHYSICAL_TABLE_NAME
- CONNECTION_POOL
- INIT_BLOCK_TABLE_NAME
- INIT_BLOCK_CONNECTION_POOL
- BUFFER_SIZE
- BUFFER_TIME_LIMIT_SECONDS
- NUM_INSERT_THREADS
- MAX_INSERTS_PER_TRANSACTION
- JOBQUEUE_SIZE_PER_INSERT_THREADPOOL_THREAD
- THROW_INSERT_WHEN_JOBQUEUE_FULL
- SUMMARY_STATISTICS_LOGGING
- SUMMARY_ADVISOR_TABLE_NAME
- Query Optimization Flags Section Parameters
- Aggregate Persistence Section Parameters
- JavaHost Section Parameters
- Datamart Automation Section Parameters