Bookshelf Home | Contents | Index | Search | PDF |
AAbs math function, about 1 Acos math function, about 1 Administration Tool See also Online and Offline Repository Modes Cache Manager, changing column order 1 Cache Manager, selecting columns to display 1 Edit menu, described 1 File menu, described 1 Help menu, described 1 icons and symbols (table) 1 join diagrams, setting default window size 1 keyboard shortcuts (table) 1 main window, repository parts described 1 Manage menu, described and functions (table) 1 Oracle BI Server, using to shut down 1 preferences, setting general preferences 1 repository components 1 repository objects, adding or editing 1 repository objects, setting permissions 1 repository objects, specifying appearance in alphabetical order 1 row counts, about updating for tables and columns 1 scrolling speed, setting 1 toolbar functions 1 Tools menu, described 1 View menu, described 1 Window menu, described 1 Administration Tool, using to shut down server 1 aggregate expression builder dialog aggregate fact table creating and example, about 1 aggregate functions about 1 aggregate queries, about 1 alternative syntax 1 Avg aggregate function, about 1 AvgDistinct, calculating average mean 1 baseline columns, computing aggregates 1 BottomN, about ranking the lowest n values 1 Count (*) (CountStar), about counting number of rows 1 Count, about calculating the number of rows 1 CountDistinct, about adding distinct process to COUNT 1 display function, reset behavior 1 First, about selecting first returned value 1 GroupByColumn, about specifying logical columns 1 GroupByLevel, about setting up aggregate navigation 1 LAST, about selecting last returned value 1 Max, about calculating maximum value 1 measure columns, computing aggregates 1 Median, about calculating the median value of rows 1 Min, about calculating the minimum value 1 NTILE, about determining the rank of a value 1 Percentile, about calculating a percent rank 1 PeriodAgo, about 1 PeriodToDate, about 1 Rank, about calculating the rank for each value 1 StdDev, about returning standard deviation 1 Sum, about calculating 1 SumDistinct, about calculating sum by adding distinct values 1 TopN, about ranking the highest n values 1 aggregate navigation, setting up See also About Aggregate Navigation aggregate levels, specifying for each source 1 aggregate table definitions, about and navigation 1 aggregate table fragments, about and example 1 aggregated fact data, creating dimension sources for each level 1 fragment content, specifying 1 WHERE clause filter, about and example 1 aggregate table fragments about and example 1 about configuring a repository to use fragments 1 aggregate table content, specifying 1 physical joins for virtual table, constructing 1 physical layer table, defining with a Select Statement 1 SQL virtual table content, creating 1 aggregate tables aggregate table definitions, about and navigation 1 performance, about using to improve 1 alias table about 1 aliases Alias tab, using 1 Allow direct database requests for all, overriding (procedure) 1 Allow populate queries for all, overriding (procedure) 1 analyzing the cache ASCII string function, about 1 Asin math function, about 1 Ask DBMS button, using to change Feature table entries 1 Atan math function, about 1 Atan2 math function, about 1 authentication cache, about disabling 1 authentication options See also Authentication Options authentication, about 1 authentication, order of 1 database authentication, about using and procedure 1 external table authentication, about 1 external table authentication, setting up 1 LDAP authentication, about 1 LDAP authentication, setting up 1 logging level, setting 1 Oracle BI Server internal authentication, about 1 Oracle BI Server user IDs and passwords, about and storage of 1 password, changing 1 USER session system variable, defining for LDAP authentication 1 authenticator about 1 custom authentication, about 1 definition 1 Avg aggregate function, about 1 AvgDistinct aggregate function, about 1 Bbaseline column behavior with aggregate functions 1 example 1 Between SQL logical operator, about 1 Bit_Length string function, about 1 BottomN aggregate function, about 1 Browse dialog box about using 1 querying for an object 1 selecting an object in 1 synchronizing an object in the query results list with the tree control list 1 business model definition 1 Business Model and Mapping layer about creating and maintaining 1 Business Model and Mapping layer, setting up logical table sources (mappings), setting up 1 table sources content definitions, creating 1 Business Model and Mapping layer, working in See also Defining Logical Joins business model, about working with 1 business model, creating (procedure) 1 logical columns, creating 1 logical table source 1 logical tables, about working with 1 measure, associating with a level in dimension 1 measure, removing the association 1 physical to logical mapping, defining 1 repository, about setting up and working in 1 business models See also Working with Presentation Catalogs copy business model with presentation catalog utility 1 diagram, about using to create joins 1 diagram, displaying 1 understanding 1 Ccache behavior in offline mode 1 behavior in online mode 1 disabling 1 enabling 1 purging 1 purging when switching between repositories 1 cache authentication, about disabling 1 cache hits description of 1 information about 1 cache information, viewing 1 Cache Manager about and opening 1 column order, changing 1 columns, selecting columns to display 1 global cache information, displaying 1 option settings (table) 1 purging cache 1 view and save SQL call 1 cache persistence time setting 1 cache sharing, SAGetSharedRequestKey, using 1 cache storage cache data storage directories 1 cache entry, controlling max number of rows 1 query caching, disabling query caching 1 query caching, enabling query caching 1 query caching, sharing with Presentation Server 1 Cache, Manage menu option, described 1 cache, monitoring and managing caching attributes, setting for physical tables (procedure) 1 disabling caching for the system, about 1 event polling tables, configuring 1 physical tables, about caching and persistence timing 1 Calculation Wizard, about 1 Calculation Wizard, setup 1 calendar date/time functions Current_Date, about returning 1 Current_Time, about 1 Current_TimeStamp, about 1 Day_Of_Quarter, about 1 DayName, about 1 DayOfMonth, about 1 DayOfWeek, about 1 DayOfYear, about 1 Hour, about 1 Minute, about 1 Month, about 1 Month_Of_Quarter, about 1 MonthName, about 1 Now, about 1 Quarter_Of_Year, about 1 Second, about 1 TimestampAdd, about 1 TimeStampDiff, about 1 Week_Of_Quarter, about 1 Week_Of_Year, about 1 Year, about 1 Cast conversion function, about 1 catalog folders Dynamic Name tab, sorting entries 1 Dynamic Name tab, specifying the session variable to use 1 Dynamic Name tab, unassigning a session variable 1 Ceiling math function, about 1 Char string function, about 1 Char_Length string function, about 1 character literals, about 1 check global consistency options when saving 1 checking in changes changes, making available and saving to disk 1 Check In Changes dialog box, about using and tasks 1 checkpoints described 1 chronological keys about 1 client tools, connectivity to 1 cluster information, viewing cache information, viewing 1 Cache view, about and columns described (table) 1 Request window (Session view), columns described (table) 1 Session window (Session view), columns described (table) 1 Session window, columns described (table) 1 Status view, about and columns described (table) 1 Cluster Manager See also Using the Cluster Manager cache information, viewing 1 Cache view, about and columns described (table) 1 graphical user interface, described 1 managing clustered servers (procedure) 1 performance considerations 1 refreshing and setting interval, (procedure) 1 scheduler, activating (procedure) 1 Session view, Request window (Session view) columns described (table) 1 Session view, Session and Request window, described 1 Session view, Session window columns described (table) 1 Status view, about and columns described (table) 1 stopped or offline, note about starting 1 using, about 1 Cluster Server See also Using the Cluster Manager about 1 analytics ODBC data source name, about configuring 1 cache information, viewing 1 Cluster Controller and Oracle BI Server, starting from the Command window 1 installing 1 managing clustered servers (procedure) 1 master server, about 1 NQClusterConfig.INI file, about copying to Config directory 1 parameters, setting in the NQClusterConfig.INI file 1 parameters, setting in the NQSConfig.INI file 1 performance considerations 1 primary Cluster Controller, about 1 secondary Cluster Controller, about 1 slave server, about 1 startup process overview 1 stopped or offline, note about starting 1 Cluster, Manage menu option, described 1 column mapping logical columns to physical columns, mapping 1 removing column mapping 1 Command window, starting Cluster Controller and Oracle BI Server 1 complex joins about 1 logical complex joins, about and complex joins 1 logical complex joins, creating 1 Concat string function, about 1 conditional expressions CASE (if), about and syntax 1 CASE (Switch), about and syntax 1 connection pool about 1 creating and configuring, about 1 creating or editing 1 dialog box, fields described 1 persist connection pool property, setting up 1 persist connection pool, assigning (procedure) 1 connectivity client tools and data sources, connectivity to 1 metadata, importing 1 ODBC data source names, configuring 1 query and reporting tools, about using 1 consistency check repository, checking for consistency 1 setting up 1 single object, checking for consistency 1 Consistency Check Manager about checking repository or objects for consistency 1 about passing consistency check 1 consistency, checking repository for 1 consistency, checking single object for 1 inconsistencies, copying messages 1 inconsistencies, correcting 1 messages, definitions 1 setting up 1 setting up, about 1 consistency, checking repository for 1 consistency, checking single object for 1 conversion functions Cast, about changing the data type to another data type 1 VALUEOF(), about using the function in an expression builder 1 copy business model with presentation catalog utility, about and procedure 1 Cos math function, about 1 Cot math function, about 1 Count (*)/CountStar aggregate function, about 1 Count aggregate function, about 1 CountDistinct aggregate function, about 1 create view function, about 1 cube metadata alias-SQL file, executing 1 alias-SQL output file, about 1 deploying 1 import files, creating 1 input file, about 1 materialized query tables (MQTs), guidelines 1 objects, conversion rules, about 1 objects, mapping, about 1 output files, about 1 XML file, importing 1 Current_Date calendar date/time function, about 1 Current_Time calendar date/time function, about 1 Current_TimeStamp calendar date/time function, about 1 DData Mining Adapter See also Using the Data Mining Adapter configuring (procedure) 1 In-Process Data Mining Adapter API, about 1 In-Process Data Mining Adapter API, sample implementation 1 In-Process Data Mining Adapter API, using ValueOf( ) expression 1 operation modes 1 data modeling business model, understanding 1 objectives of 1 data sources connectivity to 1 DATA_STORAGE_PATHS parameter, using to specify query cache storage 1 database authentication Oracle BI Delivers, about 1 database hints See also Setting Up Database Authentication database objects that accept objects (table) 1 hints, creating (procedure) 1 index hint, about 1 Leading hint, about 1 performance considerations 1 SQL comment markers, about entering 1 usage examples 1 using, about 1 database object creating manually in the Physical layer 1 database hints, database objects that accept hints (table) 1 ODBC type, about assigning if database type undetermined 1 Database system function, about 1 database type, restoring default entries for 1 Database types multidimensional data source, automatically assigning 1 relational data source, automatically assigning 1 databases See also Setting Up Database Authentication authentication, about using and procedure 1 configuring, tuning, and indexing, importance 1 database hints, about using 1 datetime literals, about 1 Day_Of_Quarter calendar date/time function, about 1 DayName calendar date/time function, about 1 DayOfMonth calendar date/time function, about 1 DayOfWeek calendar date/time function, about 1 DayOfYear calendar date/time function, about 1 DB2 1 DB2 Cube Views Generator about 1 alias-SQL output file, about 1 cube metadata input file, about 1 errors, list of 1 import files, creating 1 metadata objects, conversion rules, about 1 metadata objects, mapping, about 1 output files, about 1 output, about 1 running 1 SAMetaExport.exe, parameters of 1 troubleshooting 1 DCOM, changed client/server communication method 1 decimal literal, about 1 default client/server communication method, changed from DCOM to TCP/IP 1 Degrees math function, about 1 deleting alias 1 column mapping 1 initialization block 1 measure, removing the association 1 presentation tables 1 presentation tables column (procedure) 1 table as a logical table source 1 dimension keys creating 1 dimension level counts automatically creating 1 creating automatically 1 creating automatically (procedure) 1 dimension levels creating 1 dimensional hierarchies measures, about 1 sample hierarchy rollups, about and diagram 1 star and snowflake models, about 1 dimensional hierarchy grand total levels, about 1 grand total levels, example 1 grand total, example 1 level attributes, about 1 level- based measure calculations, setting up 1 level keys, about 1 level-based measure calculations, about 1 level-based measure calculations, example 1 levels, about creating 1 time dimension, about 1 dimensional level general properties, defining 1 primary key, adding 1 dimensional models about 1 sample hierarchy rollups, about and diagram 1 single table model, about and creating 1 understanding 1 dimensional schemas about and advantages 1 fact table, about 1 star schema 1 dimensions about 1 about cubes from a multidimensional data source 1 automatically creating 1 creating 1 creating (procedure) 1 creating and administering 1 creating automatically 1 creating automatically (procedure) 1 hierarchies, about 1 note, about including the key column in the dimension 1 dimensions, defined and example 1 dimension-specific aggregation rules columns, specifying for 1 setting up, about 1 display functions example 1 reset behavior 1 DISPLAYNAME system session variable, about 1 dragging and dropping logical tables 1 driving table about specifying 1 caution, about specifying when creating a Business Model Diagram 1 caution, about specifying when creating a logical complex join 1 caution, about specifying when creating a logical foreign key 1 caution, specifying and query optimization 1 controlling and tuning performance, about 1 DSN connection See Getting Users to Connect to the Server Dynamic Name tab entries, sorting 1 session variable, specifying 1 session variable, unassigning 1 dynamic repository variables See also Understanding and Creating Repository Variables about 1 example 1 initializing 1 dynamically loadable authenticator framework about 1 definition 1 EEdit menu, described 1 EMAIL system session variable, about 1 entity-relationship (E-R) models about 1 queries that perform historical analysis, performance of 1 Estimate Levels logical level counts, populating automatically (procedure) 1 event polling table cache event processing, about 1 configuring 1 CREATE TABLE statements, sample event polling table 1 making the polling table active 1 Oracle BI Event Table utility, identifying and using 1 overview 1 physical databases, setting up 1 populating, about 1 repository, making changes to 1 troubleshooting 1 using 1 Exp math function, about 1 Export logical keys option, about using with parameterized SQL queries 1 Expression Builder dialog boxes about using 1 accessing 1 Aggregate Content folder, about 1 Constraints folder, about 1 Dimensions folder, about 1 example (diagram) 1 expression, building (procedure) 1 Expressions folder, about 1 Functions folder, about 1 Logical Tables folder, about 1 navigating within the expression builder 1 Operators folder, about 1 Repository Variables folder, about 1 Session Variables folder, about 1 setting up example 1 toolbar (table) 1 Types folder, about 1 expression literals character literals, about and expressing 1 datetime literals, about and formats 1 decimal, about and expressing 1 floating point, about and expressing 1 integers, about and expressing 1 numeric literals, about 1 Extensible Markup Language See Using XML as a Data Source for the Oracle BI Server external table authentication about 1 setting up 1 Externalize Strings utility, about and starting 1 FFeature table entries, changing using Ask DBMS 1 File menu, described 1 filter See also Managing Query Execution Privileges complex filter, about constructing 1 constructing a filter to view all databases references in a business model 1 constructing a filter to view all Presentation layer columns mapped to a logical column 1 query results, constructing a filter for 1 First aggregate function, about 1 floating point literal, about 1 Floor math function, about 1 foreign keys logical foreign key, creating 1 note, about importing from an Oracle database 1 primary key, relationship with 1 fragmentation content about 1 multicolumn content descriptions example 1 parallel content descriptions example 1 single column range-based predicates example 1 single column value-based predicates example 1 unbalanced parallel content descriptions example 1 fragmented data, about and example 1 FROM clause syntax, about 1 functions Ggrand total dimension hierarchy example 1 grand total levels about 1 example 1 granularity, defined 1 graphical user interface GROUP BY clause query behavior with and without 1 syntax, about 1 GROUP system session variable, about 1 GroupByColumn aggregate function, about 1 GroupByLevel aggregate function, about specifying dimension levels 1 groups, working with See also Authentication Options about 1 groups, about creating and example 1 LDAP authentication, configuring 1 LDAP, about importing users and groups 1 member hierarchies, viewing in the Query Repository dialog box 1 member hierarchies, viewing in the Security Manager 1 predefined Administrators group, about 1 privileges example (diagram) 1 privileges, about granting and examples 1 repository, adding a new group to 1 repository, importing LDAP users and groups into 1 user privileges and group privileges example (diagram) 1 HHelp menu, described 1 HIDD_A_KEY 1 hierarchies about 1 hierarchies, about dimensional hierarchies 1 hierarchy physical cube table, dimension name (definition) 1 physical cube table, dimension unique name (definition) 1 physical cube table, time dimension (definition) 1 physical cube table, type of hierarchy (definition) 1 hierarchy, defined and example 1 Hour calendar date/time function, about 1 HTML tables example 1 XML Gateway, accessing by 1 IIBM Cube Views about 1 about using with Oracle BI 1 alias-SQL file, executing 1 deploying cube metadata 1 materialized query tables (MQTs), guidelines 1 XML file, importing 1 ibot, definition 1 icons, described (table) 1 IfNull conversion function, about 1 importing metadata 1 metadata, about connecting using an ODBC connection 1 users and groups using LDAP 1 XML data using ODBC 1 In SQL logical operator, about 1 IndexCol conversion function, about 1 IndexCol conversion function, about 1 indexing, about index hint instructions 1 INI file NQClusterConfig.INI file, setting parameters for Cluster Server 1 NQSConfig.INI file, tuning parameters 1 NSQConfig.INI file, adding an entry 1 initialization blocks associating with repository variables, about 1 associating with session variables, about 1 associating with variables, about 1 blocks, removing 1 caution, about opening Initialization Block dialog box in online mode 1 data source and connection pool, selecting (procedure) 1 dynamic repository variables, initializing 1 initialization block execution order, setting 1 name and schedule, assigning (procedure) 1 note, about number of columns different from number retrieved 1 Oracle BI Server, re-initializing 1 session variables, initializing 1 using with variables, about 1 variables, removing association 1 variables, removing execution precedence 1 variables, reordering 1 In-Process Data Mining Adapter API about 1 column values, specifying 1 configuring (procedure) 1 sample implementation 1 ValueOf( ) expressions, using 1 Insert string function, about 1 integers literals, about 1 Is Null SQL logical operator, about 1 JJobs, Manage menu option, described 1 join diagrams, setting default window size 1 Joins Manager joins, about using to create 1 Joins, Manage menu option, described 1 Kkey symbol, described 1 keyboard shortcuts (table) 1 LLast aggregate function, about 1 LDAP See Setting Up LDAP Authentication Leading hint, about 1 Left string function, about 1 Length string function, about 1 level attributes about 1 level keys about 1 level-based measure calculations about 1 example 1 setting up 1 levels general properties, defining 1 hierarchy, about 1 primary key for, adding 1 levels, working with grand total levels, example 1 level-based measure calculations, setting up 1 Lightweight Directory Access Protocol (LDAP) authentication, about 1 authentication, setting up 1 LDAP authentication, configuring 1 logging level, setting 1 passwords and storage, about 1 repository, importing LDAP users and groups into 1 USER session system variable, defining for LDAP authentication 1 users and groups, about using to import 1 Like SQL logical operator, about 1 literals, expressing (list of) 1 Load all objects option, about selecting 1 Locate string function, about 1 LocateN string function, about 1 log files NQServer.log and NQCluster.log, about opening and examining 1 See Implementing the Cluster Server Log math function, about 1 log viewer utility log records, interpreting 1 running (procedure) 1 using, about 1 Log10 math function, about 1 logging levels individual users, enabling 1 levels described (table) 1 log viewer utility, interpreting the log records 1 log viewer utility, using 1 override with session variable 1 user's logging levels disabling 1 setting 1 logical business models bridge tables, identifying 1 dimensional models, understanding 1 single table model, about and creating 1 Logical Column dialog box measure, associating with a level in a dimension 1 measure, removing the association 1 logical columns creating or editing, about 1 creating, about 1 creating, procedure 1 logical column, unmapping from its source 1 logical complex join, creating 1 logical foreign key, creating 1 logical object, displaying all that map to physical tables 1 Logical Table dialog box foreign key, editing 1 key, specifying 1 new logical table source, adding 1 logical table joins See also Defining Logical Joins about 1 Business Model Diagram, displaying 1 creating, about 1 driving table, about specifying 1 driving table, about specifying and query optimization 1 driving table, controlling and tuning performance 1 logical complex join, creating 1 logical foreign key, creating 1 logical object, displaying physical tables that map to 1 logical table sources removing a table as a source 1 Replace Wizard, using to replace tables or columns 1 setting up, about 1 Where clause filter, using to constrain physical tables 1 logical table sources, editing 1 logical tables creating by dragging and dropping 1 creating explicitly 1 creating, ways to 1 foreign key, editing 1 key, specifying 1 new logical table source, adding 1 working with, about 1 LOGLEVEL system session variable, about 1 Lower string function, about 1 Mmain window, repository parts described 1 Manage menu, described and functions (table) 1 Marketing, Manage menu option, described 1 MASTER_SERVER parameter, about 1 materialized views Summary Advisor, about using with 1 using, about 1 math functions, list of 1 Mavg running aggregate function, about 1 Max aggregate function, about 1 measure dimension, associating with 1 dimension, removing the association 1 measure column behavior with aggregate functions 1 default aggregation rule, specifying a 1 example 1 measure column, specifying a default aggregation rule 1 Median aggregate function, about 1 member counts updating (procedure) 1 viewing (procedure) 1 member hierarchies Query Repository dialog box, using to view 1 Security Manager, viewing in 1 metadata, deployment join constraints, defining 1 materialized views, creating 1 process, about 1 query workload, creating 1 SQL, executing 1 trace file, analyzing (procedure) 1 trace file, generating (procedure) 1 metadata, exchanging information, finding 1 with databases 1 metadata, importing about 1 connections, about 1 Min aggregate function, about 1 Minute calendar date/time function, about 1 Mod math function, about 1 modes See Making Changes to a Repository Month calendar date/time function, about 1 Month_Of_Quarter calendar date/time function, about 1 MonthName calendar date/time function, about 1 More tab joins diagrams, using to set default window size 1 scrolling speed, using to set 1 MSUM running aggregate function, about 1 multi-database joins, about 1 multidimensional dimensions for a cube from a multidimensional data source 1 multidimensional data source Ask DBMS, about availability of 1 physical layer, creating 1 physical schema, importing 1 multiuser development creating, about 1 history, about viewing and deleting 1 history, guidelines for deleting 1 history, viewing (procedure) 1 local changes, merging 1 making changes, about 1 metadata, changing and testing 1 pointer to shared directory, about 1 pointer to shared directory, setting up (procedure) 1 projects, checking in 1 projects, checking out 1 projects, checking out (procedure) 1 projects, creating 1 projects, creating (procedure) 1 , 2 setting up environment, about 1 shared network directory 1 NNow calendar date/time function, about 1 NQClusterConfig.INI file, setting parameters for Cluster Server 1 NQCMD access, disallowing 1 nQCmd.exe cache seeding, running for 1 nQLogViewer utility log records, interpreting 1 query log file, using to view 1 NQSConfig.INI centrally managing values 1 NQSConfig.INI file entry, adding an 1 tuning parameters, about 1 NQServer.log, and NQCluster.log, about opening and examining 1 NTile aggregate function, about 1 numeric literals, about 1 OObject Type option, using to create virtual physical tables 1 Octet_Length string function, about 1 ODBC calls from client applications, list of 1 client tools and data sources, about providing connectivity to 1 connection, about physical metadata imports 1 data source names, configuring 1 metadata, importing 1 query and reporting tools, about connecting with 1 offline mode cache invalidation, implications for 1 repository, opening in 1 one-to-many relationships, about primary key-foreign key relationship (diagram) 1 online mode cache invalidation, implications for 1 changes, making available and saving to disk 1 Check In Changes dialog box, about using and tasks 1 repository, opening in 1 opaque view about deploying 1 best practice, Oracle BI repository 1 definition 1 deleting, guidelines for 1 deploying 1 deploying (procedure) 1 redeploying, guidelines for 1 undeploying 1 undeploying (procedure) 1 Options dialog box, using to set general preferences 1 Oracle BI Event Tables utility, about and starting 1 Oracle BI Server See also About the Cluster Server automatic startup, configuring for 1 connecting to, about 1 fails to start 1 nonlocal files, about accessing 1 note, about changing repository in online mode and attempting to stop server 1 password, changing 1 repository variable initialization blocks, re-initializing 1 starting 1 UNIX, running the shutdown script 1 UNIX, running the startup script 1 user ID, changing 1 user IDs and passwords, about and storage of 1 Windows, configuring for automatic startup 1 Windows, shutting down from a Windows command prompt 1 Windows, shutting down from Services 1 Windows, starting from Services 1 Oracle BI Server Administrator account, about and password 1 group, about 1 Oracle BI Server XML Gateway See Using the Oracle BI Server XML Gateway Oracle database note, about importing foreign keys from 1 Oracle Database Metadata Generator cube metadata input file, about 1 errors, list of 1 import files, creating 1 metadata objects, conversion rules for 1 metadata objects, conversion rules, about 1 metadata objects, mapping, about 1 metadata objects, validation rules for 1 output files, about 1 output, about 1 running 1 SAMetaExport.exe, executing 1 SAMetaExport.exe, parameters of 1 troubleshooting 1 Oracle database, stored procedures, using 1 Oracle Dimension Exporter about 1 Oracle dimensions about 1 ORDER BY clause, about 1 Pparallel content descriptions, examples and discussion 1 password changing 1 Oracle BI Server administration account 1 Percentile aggregate function, about 1 performance database hints, about resulting in better query performance 1 server configuration and tuning 1 permissions See also Setting Permissions for Repository Objects adding or editing 1 limiting queries by filtering (procedure) 1 limiting queries by maximum run time (procedure) 1 limiting queries by number of rows received (procedure) 1 , 2 limiting queries by objects (procedure) 1 limiting queries by time periods (procedure) 1 repository objects, about setting for 1 physical column, creating or editing 1 physical database model, understanding aggregate navigation, about setting up 1 primary-key-foreign key relationships, about and diagram 1 physical databases analyzing 1 dimensional schemas, about and advantages 1 dimensional schemas, about star schema 1 entity-relationship (E-R) schemas, about 1 entity-relationship (E-R) schemas, performance for queries for historical analysis 1 identifying contents 1 types of 1 understanding 1 Physical Diagram command, about using 1 displaying 1 editor, about using to specify multi-database joins 1 foreign key join or complex join, defining 1 physical joins, about defining 1 physical joins See also About Physical Joins about 1 complex joins, about 1 fragmented data, about and example 1 Joins Manager, using to define 1 multi-database joins, about 1 note, about imported key and foreign key joins 1 primary key and foreign key relationships, about 1 tip, about avoiding unnecessary joins 1 physical joins, defining in the Physical Diagram 1 Physical layer creating and maintaining, about 1 queries, specifying types of sent to a database 1 Physical layer catalogs, creating 1 Physical layer schemas, creating 1 Physical layer, creating manually 1 Physical layer, described 1 Physical layer, working in See also Creating or Changing Connection Pools column mapping, removing 1 connection pool, creating or editing 1 database hints, about 1 database hints, database objects that accept hints (table) 1 database type, restoring default entries for 1 Feature table entries, changing using Ask DBMS 1 logical columns, mapping to physical columns 1 physical joins, defining with the Joins Manager 1 query type, locating 1 schema folders, working with 1 XML data source, setting properties for 1 physical schemas importing from ODBC (procedure) 1 importing, about 1 physical tables creating or editing 1 overview 1 Physical Table dialog box, completing Columns and Keys tabs 1 virtual physical tables, creating using the Object Type option 1 XML data source, setting properties for 1 Pi math function, about 1 populate privilege overriding database property 1 PORTALPATH system session variable, about 1 Position string function, about 1 Power math function, about 1 preferences Cache Manager, changing column order 1 Cache Manager, selecting columns to display 1 general preferences, setting 1 join diagrams, setting default window size 1 repository objects, specifying appearance in alphabetical order 1 scrolling speed, setting 1 presentation catalogs Alias tab, using 1 caution, about moving columns into presentation catalog folders 1 copy business model with presentation catalog 1 creating (procedure) 1 Presentation Catalog dialog box, described 1 presentation tables, deleting 1 table, reordering in the Presentation layer 1 tables, sorting in alphanumeric order 1 working in, about 1 presentation columns Alias tab, using 1 creating (procedure) 1 editing (procedure) 1 Presentation Column dialog box, described (table) 1 working with, about 1 Presentation Layer nested folders in Oracle BI Answers 1 Presentation layer about creating 1 about creating and maintaining 1 Presentation Layer dialog box, using the Alias tab 1 Presentation layer, creating See also Guidelines For Designing a Repository business models, copying to the Presentation layer 1 columns, about removing unneeded or unwanted 1 logical keys, about exporting in the Presentation Catalog 1 presentation columns, renaming 1 Presentation layer repository layer, about 1 Presentation layer, setting up presentation column, creating 1 presentation column, deleting 1 presentation column, editing 1 Presentation layer, working in See also Using the Alias Tab of Presentation Layer Dialog Boxes Alias tab, using 1 Presentation Catalog dialog box, described 1 presentation catalogs, about working in 1 Presentation Column dialog box, described (table) 1 presentation column, reordering 1 presentation columns, working with 1 Presentation layer, about and example 1 Presentation Tables dialog box, described (table) 1 presentation tables, creating 1 presentation tables, deleting 1 presentation table, reordering 1 presentation tables Alias tab, using 1 column, deleting 1 creating (procedure) 1 presentation column, reordering 1 Presentation Tables dialog box, described (table) 1 primary key foreign key, relationship with 1 specifying 1 primary key-foreign key relationship about and diagram 1 PRIMARY_CONTROLLER parameter, about 1 privileges query privileges, about controlling and activities 1 Project, Manage menu option, described 1 QQuarter_Of_Year calendar date/time function, about 1 queries aggregate functions, rules for 1 database, specifying types sent to 1 Leading hint, about using to build the join order 1 query caching, enabling to improve performance 1 query privileges, controlling and activities 1 query type, locating 1 query caching advantages of 1 cache event processing with an event polling table 1 cache hits, description of 1 cache hits, information about 1 cache management strategy, choosing 1 Cache Manager, about and opening 1 Cache Manager, options settings (table) 1 cache storage, configuring 1 cache strategies 1 cost of caching, about 1 disabling for system 1 disabling query caching 1 enabling query caching 1 global cache information, displaying 1 improve performance, enabling to 1 invalidation after offline repository changes 1 note, about query references with different persistence times 1 parameters to control query caching, location of 1 Presentation Server, sharing with 1 purge cache options 1 purging cache 1 refresh interval, setting for XML data sources 1 suite of queries, about running 1 user IDs, initializing cache entries for 1 query environment, administering See also Server Configuration and Tuning Oracle BI Server, shutting down in UNIX 1 Oracle BI Server, shutting down in Windows 1 Oracle BI Server, starting in UNIX 1 Oracle BI Server, starting in Windows 1 query log, administering 1 server, about connecting to 1 usage tracking, administering 1 query execution privileges 1 query log, administering about 1 file size, controlling 1 log viewer utility, interpreting the log records 1 log viewer utility, using 1 logging levels described (table) 1 setting a user's 1 logging system, configuring 1 user's logging levels disabling 1 query log, setting logging levels 1 query repository new object, creating (procedure) 1 procedure 1 Query Repository dialog box about using 1 member hierarchies, using to view 1 new query, requesting 1 parent of an object 1 searching for object based on name 1 Show Qualified Name 1 type of object 1 Query Repository Filter dialog box about and accessing 1 filter, constructing 1 filter, constructing to view all database references in a business model 1 query specification (SELECT statement), about 1 query tool, about connecting with 1 RRadians math function, about 1 Rand math function, about 1 RandFromSeed math function, about 1 Rank aggregate function, about 1 RCOUNT running aggregate function, about 1 refresh interval, setting for XML data sources 1 Rename Wizard, about and starting 1 Rename Wizard, using to rename Presentation layer and Business Model and Mapping layer tables and columns 1 Repeat string function, about 1 Replace string function, about 1 Replace Wizard, about and starting 1 reporting tool, about connecting with 1 repositories comparing repositories 1 comparing, turning off Compare Mode 1 importing from 1 LDAP authentication, configuring 1 LDAP, importing users and groups into 1 making changes to and implications for cache 1 merging repositories, about and process 1 merging version of Oracle BI repository (procedure) 1 new group, adding to 1 new user, adding to 1 synchronizing and updating (procedure) 1 repository Oracle BI Delivers, setting up 1 Repository Documentation utility, about 1 utility, running (procedure) 1 repository file options when saving 1 save options 1 Repository Import Wizard, about and using 1 repository mode changes, making available and saving to disk 1 Check In Changes dialog box, about using and tasks 1 Load all objects option, about selecting 1 note, editing while repository is being loaded 1 offline mode, opening repository in 1 online mode, opening repository in 1 repository objects alphabetical order, specifying in 1 permissions, adding or editing 1 permissions, setting 1 permissions, sorting columns 1 repository variables See also Using the Variable Manager about 1 cache purging considerations 1 dynamic repository variables, about 1 dynamic repository variables, example 1 static repository variables, about 1 static repository variables, example 1 static repository variables, using in an expression 1 static repository variables, using in expression builder 1 uses for static repository variables 1 repository variables, creating (procedure) 1 repository, managing metadata See also Constructing a Filter for Query Results complex filter, about constructing 1 note, about constructing more than one filter 1 query results, constructing a filter for 1 repository, setting up Administration Tools, repository components in 1 connection pool, about creating and configuring 1 data source, about defining 1 new repository, creating 1 NQSConfig.INI file, adding entry 1 Oracle BI Server, about starting 1 physical schemas, about importing 1 saving, checking consistency, and correcting errors 1 testing and refining, about 1 user community, about publishing to 1 REQUESTKEY system session variable, about 1 Right string function, about 1 RMAX running aggregate function, about 1 RMIN running aggregate function, about 1 rollover, described 1 Round math function, about 1 row count updating for tables and columns 1 row counts displaying 1 updating 1 row counts in physical layer, displaying 1 Row-Wise Initialization about and example 1 variable with a List of Values, initializing 1 RSUM running aggregate function, about 1 running aggregate functions about 1 Mavg, about calculating a moving average 1 MSUM, about calculating a moving sum 1 RCOUNT, about counting number of input records 1 RMAX, about showing the maximum values of a set of records 1 RMIN, about showing the minimum values based on a set of records 1 RSUM, about calculating a running sum 1 SSA system subject area about 1 sample scripts, locating and example 1 schema folders schema object, creating 1 schemas See also Process of Creating the Physical Layer from Relational Data Sources physical schemas, about importing 1 physical schemas, importing from ODBC (procedure) 1 scrolling speed, setting 1 Second calendar date/time function, about 1 SECONDARY_CONTROLLER parameter, about 1 security See also Authentication Options group privileges, about granting and examples 1 groups, about creating and example 1 groups, about working with 1 LDAP authentication, configuring 1 LDAP, about importing users and groups 1 member hierarchies, viewing in the Query Repository dialog box 1 member hierarchies, viewing in the Security Manager 1 Oracle BI Server administration account password 1 Oracle BI Server Administrator account, about 1 predefined administrators group 1 privileges example (diagram) 1 repository, adding a new group to 1 repository, adding new user to 1 repository, importing LDAP users and groups into 1 user accounts, about working with 1 user privileges and group privileges example (diagram) 1 Security Manager See also Working with Groups member hierarchies, using to view 1 Security, Manage menu option, described 1 SELECT list syntax about and syntax 1 FROM clause syntax, about 1 GROUP BY clause syntax, about 1 ORDER BY clause syntax, about 1 WHERE clause syntax, about 1 SELECT statement about and basic syntax 1 conditional expressions, list of 1 queries and aggregate functions, rules for 1 query specification 1 Select list syntax 1 SQL logical operators 1 usage notes 1 WHERE clause 1 server configuration and tuning See also Server Configuration and Tuning aggregate tables, about using 1 databases, importance of configuring, tuning, and indexing 1 NQSConfig.INI parameters. about using for tuning 1 query caching, about enabling to improve performance 1 server session management See Server Configuration and Tuning Session Manager See also Server Session Management active query, killing 1 disconnecting a user from a session 1 Session Window fields (table) 1 session, viewing 1 update speed, controlling 1 using, about 1 session variables See also Using the Variable Manager about 1 initializing, about 1 nonsystem session variables, about using 1 row-wise initialization, about and example 1 security sensitive 1 system session variables, about using 1 system session variables, table of 1 using for authenticating users 1 virtual physical databases 1 session variables, creating (procedure) 1 Sessions, Manage menu option, described 1 shutting down Oracle BI Server UNIX, shutting down server 1 Windows, shutting down from a command prompt 1 Windows, shutting down from Services 1 Sign math function, about 1 Sin math function, about 1 single table model, about and creating 1 SKIN system session variable, about 1 snowflake models, about dimensional hierarchies 1 Sort Objects tab, using to specify repository objects in alphabetical order 1 sorting columns alphabetical 1 chronological 1 lexicographical, defining 1 SQL 92 functions datetime literals, about 1 NTILE function, about 1 SQL FROM clause syntax, about 1 SQL functions aggregate functions, about 1 calendar date/time functions, about 1 conversion functions, about 1 datetime literals, about 1 expression literals, about 1 NTILE function, about 1 running aggregate functions 1 string functions, about 1 system functions, about 1 SQL logical operators, list of 1 SQL queries, about selecting the Export logical keys option 1 SQL statement database hints, about 1 database hints, creating 1 database objects that accept hints (table) 1 SQL syntax and semantics conditional expressions, list of 1 queries and aggregate functions, rules for 1 Select list syntax 1 Select statement, about and basic syntax 1 Select usage notes 1 SQL logical operators 1 SQL WHERE clause syntax, about 1 Sqrt math function, about 1 star schema about 1 dimensional hierarchies, about 1 static repository variables See also Understanding and Creating Repository Variables about 1 example 1 expression builders, using in 1 expression, using in 1 StdDev aggregate function, about 1 STORAGE_DIRECTORY parameter user tracking log files, selecting an output location for 1 string functions about 1 Abs, about calculating the absolute value 1 Acos, calculates the arc cosine of a numerical expression 1 ASCII, about converter single character string to 1 Asin, about calculating the arc sine of a numerical expression 1 Atan, about calculating the arc tangent of a numerical expression 1 Atan2, about calculating the arc tangent of y/x 1 Bit_Length, about returning length in bits 1 Ceiling, about rounding a noninteger numerical expression 1 Char, about converting a numerical value 1 Char_Length, about returning length in number of characters 1 Concat, about forms of function 1 Cos, about calculating the cosine of a numerical expression 1 Cot, about calculating the cotangent of a numerical expression 1 Degrees, about converting an expression from radians to degrees 1 Exp, about sending the value e to the power specified 1 Floor, about rounding a noninteger numerical expression 1 Insert, about inserting a character string 1 Left, about returning characters from the left of a string 1 Length, about returning the length in number of characters 1 Locate, about returning the numerical position of the character_expression1 1 LocateN, about returning the numerical position of the character_expression1 1 Log, about calculating the natural logarithm of an expression 1 Log110, about calculating the base 10 logarithm of an expression 1 Lower, about converting a character string to lower case 1 Mod, about dividing the first numerical expression 1 Octel_Length. about returning the bits in base 8 units 1 Pi, about returning the value of pi 1 Position, about returning the numerical position of the character_expression1 1 Power, about taking the first numerical expression to the power specified 1 Radians, about converting from degrees to radians 1 Rand, about returning a pseudo-random number 1 RandFromSeed, about returning a pseudo-random number from a seed value 1 Repeat, returns a specified expression n times 1 Replace, about replacing specified characters 1 Right, about returning a specified number of characters from the right of the string 1 Round, about rounding a numerical expression to n digits 1 Sign, about returning a value of 1, -1, or 0 1 Sin, calculated the sine of a numerical expression 1 Sqrt, about calculating the square root of the numerical expression argument 1 Substring, about creating a new string starting from a fixed number 1 Tan, about calculating the tangent of a numerical expression 1 TrimBoth, about stripping specified leading and trailing characters 1 TrimLeading, about stripping specified leading characters 1 TrimTrailing, about stripping specified trailing characters 1 Truncate, about truncating a decimal number 1 Upper, about converting a character string to uppercase 1 Substring string function, about 1 Sum aggregate function, about 1 SumDistinct aggregate function, about 1 symbols, described (table) 1 system session variables, about and LDAP authentication 1 SQL functions, about 1 variables, about and external table authentication 1 System subject area about 1 Ttable sources content definitions, creating 1 tables event polling table, identifying 1 one-to-many relationship, about and diagram 1 tables, sorting in alphanumeric order 1 Tan math function, about 1 TCP/IP, client/server communication method changed 1 text strings, using the Externalize Strings utility to translate 1 time dimension chronological key, selecting 1 chronological key, sorting 1 time series functions about 1 AGO 1 Expression Builder, using in 1 TODATE 1 TimestampAdd calendar date/time function, about 1 TimeStampDiff calendar date/time function, about 1 toolbar docking 1 on/off, toggling 1 Tools menu, described 1 TopN aggregate function, about 1 TrimBoth string function, about 1 TrimLeading string function, about 1 TrimTrailing string function, about 1 troubleshooting event polling table 1 Oracle BI Server fails to start 1 Truncate math function, about 1 Turn Off Compare Mode, enabling 1 UUNIX shutting down the Oracle BI Server 1 starting the Oracle BI Server 1 Update Physical Layer wizard, about and starting 1 Upper string function, about 1 usage tracking log files sample scripts, locating and example 1 usage tracking data (table) 1 usage tracking, administering See also Server Session Management about and example 1 file naming conventions, about and example 1 note, about error accessing usage tracking output file 1 output file, about and schema described (table) 1 output file, column behavior in 1 output file, format of 1 output location, selecting 1 performance considerations, about and checkpoints described 1 user community, about publishing to 1 user ID, changing for the Oracle BI Server 1 user interface components Edit menu, described 1 File menu, described 1 Help menu, described 1 icons and symbols (table) 1 keyboard shortcuts (table) 1 main window, described 1 Manage menu, described 1 toolbar functions, described 1 Tools menu, described 1 View menu, described 1 Window menu, described 1 User system function, about 1 USER system session variable, about 1 USER_LOG_FILE_SIZE parameter, using to control query log file size 1 users See also Managing Query Execution Privileges Administration account, about and password 1 LDAP, using to import users 1 new user, adding to repository 1 user accounts, about 1 utilities copy business model with presentation catalog utility, about and procedure 1 Externalize Strings utility, about and starting 1 log viewer utility, interpreting the log records 1 log viewer utility, using 1 Oracle BI Event Tables utility, about and starting 1 VVALUEOF( ) conversion function, about 1 ValueOf( ) expressions, using 1 Variables, Manage menu option, described 1 variables, using dynamic repository variables, about and example 1 nonsystem session variables, about using 1 session variables, about 1 static repository variables, about and example 1 static repository variables, using variables in expression builders 1 system session variables, about and LDAP authentication 1 system session variables, about using 1 system session variables, table of 1 system variables, about and external table authentication 1 Variable Manager, about and classes of variable 1 View menu, described 1 virtual physical tables, creating using the Object Type option 1 WWEBGROUPS system session variable, about 1 Week_Of_Quarter calendar date/time function, about 1 Week_Of_Year calendar date/time function, about 1 WHERE clause filter, about and example 1 syntax, about 1 Window menu, described 1 Windows NT and 2000 Administrator account, about and Oracle BI Server Administrator account 1 NT and 2000, user ID to access nonlocal files 1 ODBC data source names, configuring 1 Oracle BI Server, configuring for automatic startup 1 shutting down Oracle BI Server from a command prompt 1 shutting down Oracle BI Server from Services 1 starting Oracle BI Server from Services 1 wizards Calculation wizard, about 1 Calculation wizard, setup 1 Rename Wizard, about and starting 1 Replace Wizard, about and starting 1 Repository Import Wizard, about and using 1 Update Physical Layer Wizard, about and starting 1 workspace, Administration Tool Presentation Catalog dialog box, about using Presentation Table tab 1 Presentation Tables dialog box, about using Columns tab 1 XXML 1 XML data source Ask DBMS, about availability of 1 connection pool properties, setting 1 physical table, setting properties for 1 properties, about setting 1 query output format settings, specifying 1 refresh interval, setting 1 XML Gateway See also Using the Data Mining Adapter about using 1 example 1 example, more complex 1 HTML tables, accessing 1 HTML tables, example 1 XML data, importing using the XML Gateway 1 XML examples 1 XML ODBC database type See also Using XML ODBC example 1 importing XML data 1 XML data sources, about accessing 1 XML examples 1 XML, using as a data source See also Using the Data Mining Adapter about 1 example, more complex 1 HTML tables, accessing 1 HTML tables, example 1 importing data using the XML Gateway 1 XML examples 1 XML Gateway example 1 XML Gateway, about using 1 XML URL, locating 1 XPath expressions, support of 1 XSL transformation files (XSLT), support of 1 XMLA multidimensional data source, importing 1 physical layer, creating 1 YYear calendar date/time function, about 1 |
Oracle® Business Intelligence Server Administration Guide | Copyright © 2007, Oracle. All rights reserved. | |