Symbols | Numerics | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
Symbolsadding to report scripts, (1) terminating reports, (1) in names in scripts and formulas, (1) enclosing member names, (1) (2) in application and database names, (1) in dimension and member names, (1) in ESSCMD commands, (1) in header information, (1) in report scripts, (1) terms in scripts and formulas, (1) (2) # (pound sign) in array and variable names, (1) inserting into empty fields, (1) (2) (3) instead of #MISSING, (1) performance and, (1) #MISSING values, (1) (2) (3) (4) averages and, (1) calculations and, (1) CLEARDATA command, (1) defaults for, (1) effects on calculation order, (1) (2) (3) (4) setting behavior for, (1) disabling, (1) during calculations, (1) formatting in reports, (1) inserting into empty fields, (1) (2) parents and, (1) performance and, (1) replacing with text, (1) sorting data with, (1) specifying in data source, (1) testing for, (1) viewing with Personal Essbase, (1) #NOACCESS value, (1) $ (dollar signs) in array and variable names, (1) $ fields, (1) $ALT_NAME setting, (1) as codes in data source, (1) (2) in names in scripts and formulas, (1) defining member consolidations, (1) in unary operations, (1) (2) (3) as delimiters in logs, (1) in calculation scripts, (1) (2) in names, (1) in names in scripts and formulas, (1) in report scripts, (1) in calculation scripts, (1) in dimension and member names, (1) in formulas, (1) in names in scripts and formulas, (1) (2) indicating negative numeric values in fields, (1) report scripts, (1) as codes in data source, (1) (2) as delimiters in logs, (1) in application and database names, (1) in names in scripts and formulas, (1) (2) used as wildcard, (1) as codes in data source, (1) (2) in application and database names, (1) (2) in member names, (1) in names in scripts and formulas, (1) (2) defining member consolidations, (1) in unary operations, (1) (2) (3) member consolidation, (1) as file delimiter, (1) displaying in reports, (1) in application and database names, (1) (2) (3) in data fields, (1) in formulas, (1) in header records, (1) in member combinations, (1) in names in scripts and formulas, (1) (2) suppressing in reports, (1) (2) , to return member name as a string, (1) in application and database names, (1) (2) in names in scripts and formulas, (1) .EQD files(EQD), (1) as codes in data source, (1) (2) in application and database names, (1) in names in scripts and formulas, (1) (2) defining member consolidations, (1) in unary operations, (1) (2) (3) /* */ character pairs, (1) (2) // (double slashes) in report scripts, (1) as delimiters in logs, (1) in application and database names, (1) (2) in formulas, (1) in names in scripts and formulas, (1) (2) :: (double colons) in formulas, (1) end a calculation script, (1) end ENDIF statement, (1) in application and database names, (1) (2) in calculation scripts, (1) (2) in ESSCMD syntax, (1) in names in scripts and formulas, (1) (2) in application and database names, (1) (2) in names in scripts and formulas, (1) (2) in application and database names, (1) in dimension and member names, (1) in names in scripts and formulas, (1) in report scripts, (1) in application and database names, (1) in names in scripts and formulas, (1) formulas and, (1) in formulas, (1) inserting in formulas, (1) overview, (1) in application and database names, (1) used as wildcard, (1) in dimension and member names, (1) in names in scripts and formulas, (1) (2) @ABS function, (1) @ALLANCESTORS function, (1) @ANCEST function, (1) @ANCESTORS function, (1) @ANCESTVAL function, (1) @ATTRIBUTEBVAL function, (1) @ATTRIBUTESVAL function, (1) @ATTRIBUTEVAL function, (1) (2) (3) @AVG function, (1) @CALCMODE function, (1) @CHILDREN function, (1) @COMPOUND function, (1) @COMPOUNDGROWTH function, (1) @CONCATENATE function, (1) @CORRELATION function, (1) @COUNT function, (1) @CURGEN function, (1) @CURLEV function, (1) @CURRMBR function, (1) @CURRMBRRANGE function, (1) @DECLINE function, (1) @DESCENDANTS function, (1) @DISCOUNT function, (1) @EXP function, (1) @FACTORIAL function, (1) @GEN function, (1) @GENMBRS function, (1) @GROWTH function, (1) @IALLANCESTORS function, (1) @IANCESTORS function, (1) @ICHILDREN function, (1) @IDESCENDANTS function, (1) (2) @ILSIBLINGS function, (1) @INT function, (1) @INTEREST function, (1) @IRDESCENDANTS function, (1) @IRR function, (1) @IRSIBLINGS function, (1) @ISACCTYPE function, (1) @ISANCEST function, (1) @ISCHILD function, (1) @ISDESC function, (1) @ISGEN function, (1) @ISIANCEST function, (1) @ISIBLINGS function, (1) @ISICHILD function, (1) @ISIDESC function, (1) @ISIPARENT function, (1) @ISISIBLING function, (1) @ISLEV function, (1) @ISPARENT function, (1) @ISSAMEGEN function, (1) @ISSAMELEV function, (1) @ISSIBLING function, (1) @ISUDA function, (1) @LEV function, (1) @LEVMBRS function, (1) @LIST function, (1) @LN function, (1) @LOG function, (1) @LOG10 function, (1) @LSIBLINGS function, (1) @MATCH function, (1) @MAX function, (1) @MAXRANGE function, (1) @MAXS function, (1) @MAXSRANGE function, (1) @MDANCESTVAL function, (1) @MDPARENTVAL function, (1) @MDSHIFT function, (1) @MEDIAN function, (1) @MEMBER function, (1) @MERGE function, (1) @MIN function, (1) @MINRANGE function, (1) @MINS function, (1) @MINSRANGE function, (1) @MOD function, (1) @MODE function, (1) @MOVAVG function, (1) @MOVMAX function, (1) @MOVMED function, (1) @MOVMIN function, (1) @MOVSUM function, (1) @MOVSUMX function, (1) @NAME function, (1) to return member name as a string, (1) @NEXT function, (1) @NEXTS function, (1) @NPV function, (1) @PARENT function, (1) @POWER function, (1) @PRIORS function, (1) @RANGE function, (1) @RANK function, (1) @RDESCENDANTS function, (1) @RELATIVE function, (1) @REMAINDER function, (1) @REMOVE function, (1) @ROUND function, (1) @RSIBLINGS function, (1) @SANCESTVAL function, (1) @SHIFT function, (1) @SHIFTMINUS function, (1) @SHIFTPLUS function, (1) @SIBLINGS function, (1) @SLN function, (1) @SPARENTVAL function, (1) @SPLINE function, (1) @STDEV function, (1) @STDEVP function, (1) @STDEVRANGE function, (1) @SUBSTRING function, (1) @SUM function, (1) @SUMRANGE function, (1) @SYD function, (1) @TRUNCATE function, (1) @UDA function, (1) @VARIANCE function, (1) @VARIANCEP function, (1) @VARPER function, (1) (2) (3) (4) @XRANGE function, (1) in application and database names, (1) (2) in names in scripts and formulas, (1) in application and database names, (1) (2) in names in scripts and formulas, (1) as delimiters in logs, (1) in array and variable names, (1) in dimension and member names, (1) in report scripts, (1) in dimension and member names, (1) in names in scripts and formulas, (1) (2) in application and database names, (1) (2) as character in headings, (1) as codes in data source, (1) (2) as delimiters in logs, (1) in names in scripts and formulas, (1) - (hyphens, dashes, minus signs) as codes in data source, (1) (2) in data fields, (1) in dimension and member names, (1) in member names, (1) in names in scripts and formulas, (1) in report scripts, (1) defining member consolidations, (1) in unary operations, (1) (2) (3) in application and database names, (1) (2) in dimension and member names, (1) Numericscalculating, (1) excluding in time balances, (1) formatting in reports, (1) (2) including in time balances, (1) replacing with labels, (1) 4GT enabling for performance, (1) A.A files, (1) A, average time balance codes in data source, (1) abnormal shutdown. See exception logs @ABS function, (1) absolute values, (1) application-level settings, (1) assigning/reassigning user, (1) (2) checking information about, (1) concurrent, (1) controlling, (1) (2) (3) (4) (5) data sources, (1) replicated partitions and, (1) defining global levels, (1) getting started tips, (1) global levels, (1) internal structures optimizing, (1) (2) levels defined in filters, (1) linked objects, (1) local, (1) locked data blocks, (1) matrix-style, (1) multi-user, (1) outlines, (1) partitioned databases, (1) (2) (3) troubleshooting, (1) remote databases, (1) restricting, (1) Server Agent, (1) setting database, (1) Access databases. See SQL databases Access DBs setting, (1) access levels, (1) Hyperion Download Center, (1) Hyperion Solutions Web site, (1) Information Map, (1) online help, (1) accessors, data mining, (1) (2) account reporting values, (1) partitions and, (1) users, (1) aggregate storage, (1) calculating first/last values in, (1) (2) (3) calculating time period averages, (1) calculating variance for, (1) calculation passes for, (1) creating, (1) currency applications, (1) description, (1) flipping values in, (1) in an aggregate storage database, (1) setting, (1) setting member properties in data source, (1) time balance members in, (1) two-pass calculations and, (1) unary operations in, (1) usage overview, (1) checking for, (1) accumulation of values, (1) activating, disabled users, (1) setting properties, (1) ad hoc calculations, (1) ad hoc currency reporting, (1) attribute associations, (1) when to use, (1) See also building; creating; defining alias tables to outlines, (1) (2) aliases to calculation scripts, (1) comments to calculation scripts, (1) comments to dimensions, (1) comments to report scripts, (1) dimensions and members, (1) dimensions to outlines, (1) performance considerations, (1) (2) restructuring and, (1) dynamically calculated members to calculations, (1) equations to calculation scripts, (1) (2) (3) formulas to calculation scripts, (1) (2) (3) (4) formulas to oulines, (1) header information, (1) headers to data sources, (1) (2) headings to reports, (1) (2) (3) (4) as children of specified parent, (1) as siblings of lowest level, (1) as siblings with matching strings, (1) build methods, (1) guidelines for, (1) through header information in the data source, (1) to dimensions, (1) (2) (3) (4) to member fields, (1) (2) (3) (4) to outlines, (1) members to report scripts, (1) in precise combinations, (1) with common attributes, (1) page breaks to reports, (1) (2) prefixes or suffixes to fields, (1) records to data sources, (1) (2) (3) shared members to outlines, (1) (2) caution for placing, (1) titles to reports, (1) values to empty fields, (1) variables to formulas, (1) variables to report scripts, (1) (2) (3) (4) consolidation codes in data source, (1) (2) prerequisite for, (1) setting member consolidation properties, (1) defining member consolidations, (1) member consolidation, (1) unary operations, (1) adjusting column length, (1) adding to Enterprise View, (1) described, (1) Administration Services Console described, (1) retrieving data, (1) Administration Services. See Essbase Administration Services administration tools, Unicode enabled, (1) administrative accounts, (1) (2) partitions and, (1) controlling partitioned updates, (1) getting started with Analytic Services, (1) maintenance routines, (1) maintenance tasks, (1) minimizing downtime, (1) user-management tasks, (1) (2) (3) AFTER report command, (1) agent event logs. See Analytic Server logs agent log, encoding, (1) agent logs. See Analytic Server logs AGENTLOGMSGLEVEL setting, (1) AGENTTHREADS setting, (1) defined, (1) precalculating, (1) aggregate storage, (1) aggregation process, (1) Attribute Calculations dimension, (1) building dimensions, (1) cache, (1) parallel calculation threads, (1) calculating databases, (1) converting rules files from block storage, (1) creating applications, databases, and outlines, (1) MaxL example, (1) process, (1) data source differences, (1) (2) databases, calculating, (1) loading data, (1) MaxL data load process, (1) outline factors affecting values, (1) retrieval tools, (1) retrieving data, (1) rules file differences, (1) (2) security, (1) support for MDX queries, (1) tablespaces, (1) aggregate storage aggregation cache size of, (1) size of, (1) aggregate storage databases, (1) accounts dimension, (1) attribute calculation dimension, (1) attribute dimension, (1) compared to block storage, (1) configuration settings, (1) converting block storage databases to aggregate storage, (1) creating, (1) creating a write-back partition, (1) database creation, (1) developing formulas, (1) displaying application and database information, (1) inherent differences of, (1) lock and send to, (1) member consolidation properties, (1) member storage types, (1) non-accounts dimensions, (1) optimizing pageable outlines, (1) outline validation, (1) pageable outlines, (1) partitioning, (1) physical storage definition, (1) ragged hierarchies, (1) reducing memory usage, (1) restructuring, (1) using formulas, (1) write back, (1) writing back data, (1) using dimension build, (1) using loaded outline, (1) outline files for, (1) outline files for, (1) defined, (1) selection, (1) aggregate storage databases, (1) database values, (1) defined, (1) executing, (1) defined, (1) materialization of, (1) performing, (1) saving selection, (1) setting maximum number of threads to Analytic Server, (1) setting number of threads to Analytic Server, (1) AIX servers. See UNIX platforms .ALG files, (1) association rules, (1) clustering, (1) creating new, (1) decision tree, (1) Naive Bayes, (1) neural network, (1) about, (1) training, (1) in header records, (1) in rules files, (1) clearing contents, (1) copying, (1) described, (1) importing/exporting, (1) including in report scripts, (1) introducing, (1) maximum per outline, (1) removing from outlines, (1) renaming, (1) reserved generation names in, (1) setting as current with Outline Editor, (1) setting the current alias table, (1) Unicode samples, (1) updating, (1) adding to calculation scripts, (1) adding to report scripts, (1) caution for, (1) aggregate storage databases compared to block storage databases, (1) allowing changes, (1) build methods and, (1) creating, (1) attribute dimension build example, (1) parent-child dimension build example, (1) defined, (1) displaying in reports, (1) duplicate generation fields and, (1) limits for name size, (1) multiple, (1) caution for partitions, (1) shared members and, (1) sorting members by, (1) specifying for Dynamic Time Series members, (1) with embedded blanks, (1) @ALLANCESTORS function, (1) ALLINSAMEDIM report command, (1) @ALLOCATE function, (1) calculation examples, (1) (2) (3) (4) calculation functions, (1) example, (1) Allow Application to Start option, (1) Allow Commands option, (1) Allow Connects option, (1) Allow Updates option, (1) ALLSIBLINGS report command, (1) alphabetizing members, (1) $ALT_NAME setting, (1) alter application (MaxL), (1) (2) (3) (4) (5) (6) (7) alter database (MaxL), (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) alter group (MaxL), (1) alter system (MaxL), (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) alter system clear logfile (MaxL), (1) alter system shutdown (MaxL), (1) alter tablespace (MaxL), (1) alter user (MaxL), (1) (2) (3) (4) (5) (6) altering. See changing; editing in calculation scripts, (1) (2) in names, (1) in names in scripts and formulas, (1) in report scripts, (1) analysis, (1) defining objectives, (1) example, (1) getting started tips, (1) optimizing, (1) single-server applications, (1) (2) adding to Enterprise View, (1) AGTSVRCONNECTIONS, (1) application startup, (1) changing system password for, (1) client requests and, (1) communicating with clients, (1) crashes, recovering from, (1) (2) disconnecting users, (1) ports, (1) displaying software version number, (1) free space recovery for, (1) (2) getting information about, (1) initial connection and disconnection, (1) installing multiple instances on (UNIX), (1) installing multiple instances on (Windows), (1) interruptions, (1) loading data from, (1) logging errors, (1) logging out of, (1) moving data sources to, (1) properties, viewing, (1) quitting, (1) retrieval buffers, (1) securing, (1) SERVERTHREADS, (1) setting number of threads to use, (1) setting to Unicode mode, (1) shutting down, (1) starting, (1) from Administration Services, (1) Analytic Server errors, (1) active transactions and failures, (1) allocating storage, (1) caches used, (1) changing settings, (1) components, (1) compressing data, (1) cross-platform compatibility, (1) customizing, (1) error handling, (1) locking procedure, (1) setting isolation levels, (1) (2) specifying data compression, (1) starting, (1) Analytic Server logs, (1) analyzing with Log Analyzer, (1) contents described, (1) deleting, (1) deleting on restart, (1) delimiters, (1) disk space and, (1) example, (1) message categories, (1) setting messages logged, (1) viewing, (1) Analytic Servers, viewing, (1) architecture, (1) development features described, (1) fundamentals, (1) getting started tips, (1) starting, (1) unsupported functions in Hybrid Analysis, (1) Analytic Services client. See clients Analytic Services kernel, linked reporting objects and, (1) Analytic Services Server Agent. See Server Agent Analytic Services Unicode File Utility, (1) (2) allocations, (1) ratios, (1) trend analysis, (1) guidelines, (1) @ANCEST function, (1) ancestor/descendant relationships defining calculation order for, (1) ancestor-descendant relationships, (1) @ANCESTORS function, (1) checking for, (1) currency conversions and, (1) defined, (1) new members with no, (1) ANCESTORS report command, (1) @ANCESTVAL function, (1) anchoring dimensions, (1) in report scripts, (1) in rules files, (1) data cells, (1) databases, (1) partitions, (1) .APB files, (1) directory, (1) function calls, (1) Unicode enabled, (1) .APP files, (1) security file information, (1) migrating to Unicode mode, (1) preparing for migration to Unicode mode, (1) Unicode mode, creating, (1) application description size limits, (1) Application Designer permission, (1) (2) application directory, (1) (2) application event logs. See application logs. application files, (1) Application Log Viewer. See Log Viewer analyzing with Log Analyzer, (1) calculation time, (1) contents described, (1) deleting, (1) deleting on restart, (1) delimiters, (1) dimensions calculated, (1) disk space and, (1) dynamic calculator cache usage, (1) dynamically calculated members, (1) example, (1) last row committed, (1) message categories, (1) setting messages logged, (1) viewing, (1) viewing contents, (1) aggregate storage databases, (1) Application Programming Interface. See API minimum database access settings, (1) setting, (1) application servers, used with Administration Server, (1) application startup, results of, (1) See also partitioned applications components, (1) copying, (1) creating, (1) for Personal Essbase, (1) on client, (1) creating aggregate storage applications, (1) currency conversions and, (1) data distribution characteristics, (1) (2) deleting, (1) described, (1) designing partitioned, (1) scenarios for, (1) designing single-server, (1) (2) developing, (1) process summarized, (1) implementing global security, (1) inaccessible, (1) interruptions, (1) loading, (1) automatically, (1) with related database, (1) logging errors, (1) maintaining, (1) migrating across servers, (1) name size limits, (1) naming rule, (1) non-Unicode mode, (1) OLAP, (1) overview, (1) choosing when not to use, (1) when to use, (1) creating backups for, (1) redefining information for, (1) to UNIX platforms, (1) renaming, (1) sample, (1) size considerations, (1) starting, (1) all opened, (1) before backup, (1) when transactions are running, (1) storing, (1) Unicode-mode, (1) Unicode-mode, defined, (1) viewing, (1) information about, (1) log contents, (1) properties, (1) about, (1) specifying, (1) locks, (1) privileges to groups, (1) skip properties, (1) APPLYOTLCHANGEFILE command, (1) ARBORPATH, (1) .ARC files, (1) archive files, (1) restoring from, (1) ARCHIVE.LST file, (1) data, (1) data targets, (1) changing shared, (1) defined, (1) defining, (1) Dynamic Time Series members in, (1) linked partitions, (1) mapping to specific, (1) replicated partitions, (1) transparent partitions, (1) Areas page (Partition Wizard), (1) currency conversions, (1) missing values and, (1) performing on fields, (1) performing on members, (1) prerequisite for, (1) report scripts, (1) specifying in data source, (1) (2) data blocks, (1) position of fields in rules file, (1) dimensions in outlines, (1) members in dense dimensions, (1) (2) members in outlines, (1) (2) (3) declare data variables, (1) usage example, (1) declaring, (1) naming, (1) ASC flag to ORDERBY report command, (1) ascending sort order, (1) applying to output, (1) members in outlines, (1) ASCII characters, ignored in data loads, (1) assets, (1) access levels to linked objects, (1) aliases to members, (1) (2) (3) filters to users and groups, (1) global access, (1) to users and groups, (1) properties to dimensions, (1) (2) (3) properties to members, (1) (2) values to member combinations, (1) values to variables, (1) variance reporting properties, (1) automatically, (1) example rules file, (1) through dimension build, (1) calculation scripts with outlines, (1) databases with calculation scripts, (1) members with report scripts, (1) multilevel attribute dimensions, (1) parents with members, (1) association rules algorithms, (1) as codes in data source, (1) (2) in application and database names, (1) in names in scripts and formulas, (1) (2) used as wildcard, (1) entering in report scripts, (1) usage, (1) changing headings, (1) dynamically calculating values, (1) overriding groupings, (1) asymmetric reports, (1) creating, (1) defined, (1) formatting, (1) symmetric reports vs., (1) calculation scripts, (1) calculations, (1) data loads, (1) dimension builds, (1) report scripts, (1) in dimension and member names, (1) in names in scripts and formulas, (1) (2) attaching to databases. See connections See also linked reporting objects limiting size, (1) removing, (1) saving, (1) viewing in Application Manager, (1) field type, (1) lost in cut or copy and paste, (1) requirements, (1) Attribute Calculations dimension accessing members from, (1) aggregate storage, (1) changing member names, (1) instead of consolidation symbols, (1) instead of member formulas, (1) members, default, (1) properties of, (1) retrieving multiple members from, (1) ATTRIBUTE command, (1) comparison with standard dimensions, (1) creating in Outline Editor, (1) defining in dimension build, (1) generation or level reference numbers, (1) overview, (1) prefixes and suffixes, (1) preventing creation, (1) (2) (3) building and associating, (1) outline design, (1) restructuring, (1) summary of dimension building rules, (1) using to avoid redundancy, (1) defining using rules files, (1) position in rules file, (1) using in report scripts, (1) example, (1) in header records, (1) in rules files, (1) ATTRIBUTE report command, (1) usage, (1) @ATTRIBUTEBVAL function, (1) advantages, (1) as values resulting from formulas, (1) automatically, (1) through dimension build, (1) associating aliases through dimension build, (1) changing default member names, (1) described, (1) duplicate values, (1) accessing calculated data, (1) Analytic Services functions, (1) Attribute Calculations dimension, (1) default calculation, (1) examples, (1) multiple calculations, (1) performance considerations, (1) process, (1) using attributes in formulas, (1) calculation dimension on ggregate storage databases, (1) calculation functions, (1) date type, (1) changing the member name format, (1) duplicate values, (1) defined, (1) design considerations, (1) in formulas with two-pass calculations, (1) mapping in partitions, (1) member name format, (1) member names, (1) defined, (1) defining ranges, (1) duplicate values, (1) ranges, (1) on aggregate storage databases, (1) process for defining manually, (1) querying in MDX, (1) shared member design approach, (1) standard dimension design approach, (1) text type, (1) time-dependent values, (1) types, (1) alternative design approach, (1) feature comparison, (1) setting, (1) using in partitions, (1) @ATTRIBUTESVAL function, (1) @ATTRIBUTEVAL function, (1) (2) (3) ATTRPROD.RUL file, (1) .ATX files, (1) audience for this guide, (1) automating routine operations, (1) average clustering ratio, viewing, (1) average time balance property, (1) average time balances specified in data sources, (1) Attribute Calculations dimension, (1) determining with formulas, (1) (2) setting time balances, (1) @AVG function, (1) Attribute Calculations dimension, (1) changing name, (1) axes (in MDX queries), (1) BB, time balance codes in data source, (1) detecting Analytic Server as, (1) running Analytic Server as, (1) calculation scripts, (1) calculations, (1) data loads, (1) dimension builds, (1) report scripts, (1) aggregate storage, (1) by exporting, (1) cautions for, (1) files to back up, (1) overview, (1) preparing, (1) in application and database names, (1) (2) in names in scripts and formulas, (1) cautions for, (1) export method, (1) file list, (1) file system method, (1) restoring after system failures, (1) restoring from, (1) security, (1) adding to report scripts, (1) terminating reports, (1) .BAS files, (1) associations, (1) attribute formulas, (1) attributes, (1) Basic databases. See Demo Basic database; Sample Basic database basic equations, (1) .BAT files, (1) batch files, (1) and ESSCMD scripts, (1) report scripts and, (1) running, (1) batch mode, (1) command-line syntax for, (1) creating scripts for, (1) dynamic calculations and, (1) error-handling, (1) importing and calculating, (1) printing reports, (1) updating SQL scripts, (1) file-name extensions and, (1) MaxL, (1) overview, (1) syntax, (1) updating outlines, (1) when to use, (1) batch processing time, (1) BEFORE report command, (1) BEGINARCHIVE command, (1) aggregate storage applications and, (1) partitioned applications and, (1) benefits of Analytic Services, (1) ESSCMD files, (1) bitmap cache, effects from parallel calculation, (1) described, (1) estimating block size, (1) specifying, (1) bitmap dimensions, (1) bitmap, calculator cache, (1) adding values to, (1) in data source, (1) in rules file, (1) block calculation mode, (1) converting block storage rules files to aggregate storage, (1) unique calculation features, (1) compared to aggregate storage, (1) BLOCKHEADERS report command, (1) (2) .BND files, (1) attribute dimension type, (1) changing default member names, (1) described, (1) duplicate values, (1) functions, in formulas, (1) (2) Boolean expressions, (1) for select/reject criteria, (1) entering in report scripts, (1) (2) order of operation, (1) precedence, (1) upper limits, (1) usage, (1) bottom-up calculation, (1) transparent partitions, (1) calculations, (1) defined, (1) in dimension and member names, (1) in names in scripts and formulas, (1) (2) in application and database names, (1) (2) in names in scripts and formulas, (1) BRACKETS report command, (1) overriding, (1) re-enabling brackets, (1) sharing members, (1) browser for editing objects, (1) comparing actual to budgeted, (1) example database for forecasting, (1) generating and loading new, (1) partitioned applications and, (1) variance reporting and, (1) aggregate storage data loads, (1) (2) default, (1) enabling, (1) buffers, (1) described, (1) retrieval buffer, (1) retrieval sort buffer, (1) build methods, (1) as children of specified parent, (1) as sibling with matching strings, (1) as siblings of lowest level, (1) bottom-up ordering, (1) at different generations, (1) (2) defined, (1) defining parent-child relationship, (1) description, (1) null processing, (1) supported for associating attributes, (1) top-down ordering, (1) valid field types, (1) build models, creating data mining, (1) (2) about, (1) BUILDDIM command, (1) calculation scripts, (1) restrictions, (1) syntax for, (1) calculation scripts in Calculation Script Editor, (1) database outline, (1) development process for, (1) example for, (1) prerequisites for, (1) dimensions, (1) dynamically. See dynamic builds prerequisites, (1) with data sources, (1) (2) (3) (4) (5) with dynamically calculated members, (1) with rules files, (1) dynamic calculations, (1) multiple roll-ups, (1) free-form, (1) with API function calls, (1) shared members dynamically, (1) (2) (3) (4) checklist for creating, (1) Cdescribed, (1) enabling, (1) aggregate storage cache, (1) as storage units, (1) described, (1) disabling, (1) locking memory for, (1) managing, (1) optimizing read/writes, (1) outline paging, optimizing, (1) size of, aggregate storage, (1) data cache, (1) data file cache, (1) fine-tuning, (1) index cache, (1) overview, (1) viewing statistics, (1) when changes take effect, (1) block ordering and, (1) currency conversions, (1) dynamic calculations and, (1) dynamically calculated members and, (1) for database calculation, (1) Intelligent Calculation and, (1) (2) (3) partitioned applications and, (1) CALC AVERAGE command, (1) CALC COL command. See CALCULATE COLUMN command CALC command, (1) dynamically calculated members and, (1) for database calculation, (1) Intelligent Calculation and, (1) (2) (3) (4) CALC FIRST command, (1) CALC LAST command, (1) CALC ROW command. See CALCULATE ROW command calculation order, (1) displaying completion notices with, (1) examples, (1) generating statistical information, (1) grouping formulas and dimensions, (1) overriding default calculation order, (1) two-pass calculations, (1) (2) (3) (4) (5) calc scripts. See calculation scripts CALC TWOPASS command, (1) CALCDEFAULT command, (1) CALCLINE command, (1) CALCLOCKBLOCK setting, (1) @CALCMODE function, (1) CALCMODE configuration setting, (1) CALCOPTFRMLBOTTOMUP setting, (1) checking parallel calculation status, (1) CALCPARALLEL command, (1) CALCTASKDIMS command, (1) CALCULATE COLUMN report command, (1) Calculate permissions, (1) calculate privilege, (1) filters and, (1) CALCULATE ROW report command, (1) (2) restrictions, (1) adding totals, (1) creating, (1) calculated data, (1) filtering, (1) calculated members in MDX, (1) calculated values vs. input values, (1) aggregate storage databases compared to block storage databases, (1) computation, (1) control, (1) declaring temporary variables for, (1) functions, custom-defined, (1) inserting in scripts, (1) iterating through, (1) macros, custom-defined, (1) specifying global settings, (1) for aggregate storage databases, (1) (2) calculation script calculations, (1) SET MSG, (1) checking syntax, (1) color-coding in, (1) described, (1) opening, (1) saving calculation scripts, (1) searching for members, (1) syntax auto-completion, (1) calculation script files, (1) calculation scripts, (1) aliases, (1) comments, (1) aggregate storage, (1) applying conditions, (1) associating with databases, (1) building in Calculation Script Editor, (1) calculating member formulas, (1) changing, (1) clearing databases after export, (1) color-coding in, (1) consolidating missing values in, (1) (2) in file system, (1) declaring variables in, (1) (2) as default, (1) execution access, (1) defining equations, (1) deleting, (1) dynamic calculations and, (1) (2) executing, (1) executing in background, (1) formulas in, (1) grouping formulas and dimensions, (1) (2) variables, (1) Intelligent Calculation and, (1) (2) (3) (4) migrating with applications, (1) names with special characters, (1) (2) performing multiple calculation passes, (1) permissions needed, (1) printing, (1) restrictions, (1) information messages after, (1) on partitioned applications, (1) saving, (1) checking, (1) guidelines, (1) troubleshooting, (1) UDAs and, (1) using formulas, (1) verifying syntax, (1) viewing application log contents, (1) See also calculation scripts; dynamic calculations account reporting values, (1) across multiple processors, (1) ad hoc, (1) adding formulas to, (1) (2) (3) (4) aggregate storage, (1) assigning constants, (1) assigning non-constant values, (1) associating with specific database, (1) accessing calculated data, (1) Attribute Calculations dimension, (1) default calculation, (1) described, (1) examples, (1) multiple calculations, (1) performance considerations, (1) process, (1) using attributes in formulas, (1) basic concepts, (1) block mode, (1) blocks with dirty status, (1) bottom-up, (1) calculation scripts vs., (1) caution for changing outlines and, (1) cell mode, (1) checking results of, (1) checklist for defining, (1) concurrent and memory usage, (1) currency conversions, (1) (2) (3) dates, (1) overriding, (1) setting, (1) defining global behavior, (1) defining order, (1) data blocks, (1) dimensions, (1) forward references and, (1) designing for optimal, (1) difference between actual and budgeted, (1) displaying completion notices, (1) displaying settings, (1) entire database, (1) executing for database, (1) executing in background, (1) extending capabilities, (1) first-time, (1) fixing unexpected results, (1) (2) handling missing and zero values, (1) Intelligent Calculation default setting, (1) locking blocks during, (1) members across multiple parents, (1) members in outlines, (1) members with different operators, (1) missing values and, (1) (2) (3) monitoring, (1) monthly assets, (1) multiple databases, (1) numeric precision, (1) operator precedence, (1) using dynamic calculations, (1) with attributes, (1) with calculation scripts, (1) with dynamic calculations, (1) (2) with Intelligent Calculation, (1) with interdependent values, (1) with two-pass calculations, (1) optimizing with search, (1) (2) parallel vs. serial, (1) partial list of members, (1) with replicated partitions, (1) with transparent partitions, (1) (2) performance and multi-users, (1) performance, with attributes, (1) performing multiple passes, (1) (2) period-to-date values, (1) (2) permission required to run, (1) preventing delays, (1) recovering, (1) relationships between members, (1) rolling averages, (1) default, (1) setting up two-pass, (1) (2) (3) shared members, (1) simulating, (1) single-server applications, (1) (2) (3) specified dimensions, (1) statistics, (1) stopping, (1) example, (1) with Intelligent Calculation, (1) testing, (1) top-down, (1) types described, (1) unique block storage features, (1) variance performance, (1) with a series of dimensions, (1) with a series of member formulas, (1) year-to-date values, (1) and parallel calculation, (1) as storage unit, (1) bitmap, (1) disabling, (1) maximum size, (1) optimizing, (1) overview, (1) sizing, (1) archiving operations, (1) calculations, (1) captures, (1) carriage return as file delimiter, (1) field type designation in header record, (1) improved for applications and databases, (1) report scripts, (1) setting for database, (1) CCONV TOLOCALRATE command, (1) CCTRACK setting, (1) cell calculation mode, (1) simultaneously in different databases, (1) annotating, (1) contents, (1) copying range of, (1) determining calculation order for, (1) (2) linking objects to, (1) mapping to targets, (1) removing linked objects, (1) returning unique values for, (1) (2) centralized data repositories, (1) .CFG files, (1) change logs, (1) restructuring and, (1) change logs. See outline change logs change logs. See outline change logs. affecting only outlines, (1) impacting restructures, (1) overriding incremental restructuring, (1) overwritten, (1) tracking outline, (1) viewing outline, (1) access privileges, (1) (2) (3) alias table names, (1) aliases, (1) Analytic Server kernel settings, (1) Analytic Server system password, (1) calculation scripts, (1) consolidations, (1) data values, (1) scope and precedence, (1) default storage properties, (1) dense and sparse storage, (1) headings in reports, (1) member combinations for linked objects, (1) outlines, (1) caution for, (1) dynamically, (1) with rules files, (1) passwords, (1) report layouts, (1) security settings, (1) character searches. See searches in calculation formulas, (1) character strings. See strings allowed in user names, (1) calculation scripts, (1) end-of-file markers and special, (1) forbidden at the beginning of a name, (1) formulas, (1) ignored in report extraction, (1) in array and variable names, (1) in application and database names, (1) in dimension names, (1) in member names, (1) in URLs, (1) numeric in member names, (1) quoting in scripts and formulas, (1) (2) valid in numeric data fields, (1) disk space, (1) forward references, (1) Calculation Script Editor, (1) check-out facility, (1) See also parent/child relationships adding as member of specified parent, (1) as only member (implied sharing), (1) calculation order for outlines, (1) checking for, (1) consolidation properties and, (1) currency conversions and, (1) defined, (1) rolling up, (1) shared member as, (1) in header records, (1) in rules files, (1) child processes, (1) @CHILDREN function, (1) described, (1) entering in report scripts, (1) usage, (1) with ESSCMD, (1) data to partition, (1) (2) (3) with ESSCMD, (1) dimension storage type, (1) (2) (3) (4) guidelines for, (1) for dynamic calculations, (1) members for column groupings, (1) members for dynamic calculations, (1) (2) members for report scripts, (1) (2) (3) from Dynamic Time Series, (1) with ATTRIBUTE command, (1) with Boolean operators, (1) with substitution variables, (1) with TODATE command, (1) with user-defined attributes, (1) with wildcards, (1) with WITHATTR command, (1) partition type, (1) (2) (3) (4) records, (1) values for dynamic calculations, (1) (2) disabled at server, (1) caution for sparse dimensions, (1) clearing data and, (1) Intelligent Calculation and, (1) partial calculations and, (1) CLEARALLROWCALC report ommand, (1) for database clearing, (1) performance and, (1) CLEARBLOCK DYNAMIC command, (1) (2) for database clearing, (1) CLEARDATA command, (1) for database clearing, (1) partitioned applications and, (1) performance and, (1) alias tables, (1) application and Analytic Server log contents, (1) caution, (1) in calculated columns, (1) (2) Intelligent Calculations and, (1) log contents, (1) member combinations, (1) values in transparent partitions, (1) aggregate storage database restructure, (1) CLEARLOGFILE setting, (1) CLEARROWCALC report command, (1) CLEARUPDATESTATUS command, (1) accessing linked objects and, (1) locale support, (1) Unicode-enabled, (1) caution for loading data from, (1) troubleshooting connections, (1) custom, (1) Unicode-mode, (1) caution for improper shutdown, (1) limitations, (1) recovering from improper shutdowns, (1) clients, (1) communicating with Analytic Server, (1) loading data from, (1) See also single-server applications client-server model, (1) See also exiting; quitting; stopping all opened, (1) before backup, (1) clustering algorithms, (1) clustering ratio, viewing, (1) .CNT files, (1) defined, (1) setting member properties, (1) COLHEADING report command, (1) in application and database names, (1) (2) in formulas, (1) in names in scripts and formulas, (1) (2) in calculation scripts, (1) in report scripts, (1) column calculation commands, (1) column formatting commands, (1) (2) (3) adding to calculated columns, (1) changing, (1) defined, (1) displaying, (1) for loading asymmetric columns, (1) multi-line, (1) names truncated, (1) repeating, (1) SQL data sources, (1) suppressing, (1) entering in report scripts, (1) column widths, (1) adjusting length, (1) defining as fields, (1) formatting, (1) formatting for data load, (1) (2) mapping specific fields only, (1) numbering, (1) ordering in data sources, (1) overriding grouping in reports, (1) parent-child data sources, (1) replacing empty fields with text, (1) symmetry in reports, (1) using attributes in, (1) combining fields. See joining fields command prompt, (1) See also ESSCMD; server console ESSCMD, (1) running batch files, (1) commands, (1) See also the names of the specific command calculation types listed, (1) caution for processing, (1) computation, (1) control, (1) declaring temporary variables for, (1) entering in ESSCMD scripts, (1) entering in report scripts, (1) ESSCMD syntax, (1) global calculation settings, (1) iterating through, (1) performance-related, (1) (2) (3) report formatting, (1) (2) (3) (4) (5) report output, (1) Server Agent, (1) as file delimiter, (1) displaying in reports, (1) in application and database names, (1) (2) (3) in data fields, (1) in formulas, (1) in header records, (1) in member combinations, (1) in names in scripts and formulas, (1) (2) suppressing in reports, (1) (2) re-enabling commas, (1) usage, (1) adding to dimensions, (1) adding to members, (1) calculation scripts, (1) report scripts, (1) storing, (1) returning from calculation scripts, (1) Commit Block setting, (1) Commit Row setting, (1) (2) (3) commits, (1) data loads failing and, (1) (2) (3) managing, (1) rollbacks and, (1) threshold adjustments with parallel calculation, (1) updating isolation level, (1) about, (1) caution for, (1) memory usage, (1) rollbacks and, (1) common currency, (1) communications protocols, (1) COMPACT command (Agent), (1) (2) compacting security file, (1) timestamps for outlines, (1) completion notices, (1) @COMPOUND function, (1) compounded interest, (1) @COMPOUNDGROWTH function, (1) checking compression ratio, (1) estimating block size, (1) fragmentation allowance, (1) optimal configuration, (1) overview, (1) specifying/changing, (1) checking, (1) improving, (1) compression type to use, (1) computing data relationships, (1) @CONCATENATE function, (1) concatenating fields, (1) concurrency, data, (1) concurrent calculations, (1) (2) overview, (1) conditional blocks, (1) conditional equations, (1) conditional operators, (1) (2) adding to report scripts, (1) (2) setting for ESSCMD, (1) configurable variables, (1) setting, (1) configuration files, (1) for aggregate storage databases, (1) activating change logs, (1) Analytic Server kernel settings and, (1) checking, (1) clearing logs, (1) creating multiple exception logs, (1) creating outline change logs, (1) currency calculations, (1) database calculations, (1) delimiting logs, (1) dense and sparse storage, (1) automatic, (1) determining optimal, (1) enabling incremental restructuring, (1) Intelligent Calculation, (1) logging spreadsheet updates, (1) files, (1) limits, (1) setting dimensions automatic vs manual, (1) (2) setting number of threads, (1) setting outline change file size, (1) viewing settings information, (1) connection passwords, (1) communications protocols, (1) databases with data cells, (1) Essbase Administration Services and, (1) losing between partitions, (1) preventing system failures, (1) (2) terminating, (1) consistency, data, (1) consistency. See data integrity aggregate storage databases, (1) changing, (1) default order, (1) defined, (1) excluding members from, (1) (2) fixing unexpected results, (1) (2) formulas vs., (1) levels within a dimension, (1) effects on calculation order, (1) (2) operators listed, (1) performance considerations, (1) restrictions, (1) specifying requirements for, (1) checklist for, (1) described, (1) supported on aggregate storage databases, (1) in calculations, (1) constants, in calculation scripts, (1) consulting services, (1) control characters, in report scripts, (1) control information, (1) conventions. See naming conventions conversions, (1) positive/negative values, (1) in data loads, (1) block storage databases to, (1) dates, (1) described, (1) process for, (1) coordinates (data values), (1) COPYAPP command, (1) COPYFILTER command, (1) See also duplicating; replicating applications, (1) base dimension members, (1) calculation scripts, (1) databases, (1) filters, (1) from data targets, (1) groups, (1) objects, (1) passwords to other OLAP Servers, (1) substitution variables, (1) users, (1) copying, alias tables, (1) @CORRELATION function, (1) correlation coefficient, calculating, (1) restoring and, (1) cost of goods, (1) example for allocating, (1) @COUNT function, (1) Attribute Calculations dimension, (1) changing name, (1) count, calculating, (1) currency applications, (1) (2) description, (1) usage overview, (1) country-specific data. See locales .CPL files, (1) exception logs for, (1) restructuring and, (1) transaction rollbacks and, (1) create application (MaxL), (1) create application as (MaxL), (1) Create Blocks on Equations option, (1) (2) create database (MaxL), (1) (2) (3) (4) (5) create database as (MaxL), (1) create filter (MaxL), (1) (2) (3) create function (MaxL), (1) create function command, (1) create location alias (MaxL), (1) create macro (MaxL), (1) create or replace macro (MaxL), (1) create or replace macro command, (1) create partition (MaxL), (1) Create/Delete Applications permission, (1) Create/Delete Users/Groups permission, (1) CREATEAPP command, (1) CREATELOCATION command, (1) CREATEVARIABLE command, (1) aggregate storage applications, databases, and outlines, (1) aggregate storage databases, (1) aliases, (1) for Personal Essbase servers, (1) new, (1) on client, (1) data blocks, (1) database backups, (1) database backups (aggregate storage), (1) database outlines, (1) guidelines for, (1) process, (1) properties of, (1) as optimized, (1) for Personal Essbase servers, (1) new, (1) on client, (1) reasons for splitting, (1) Dynamic Calc and Store members, (1) Dynamic Calc members, (1) fields, (1) fields by splitting, (1) for databases, (1) for partitioned databases, (1) syntax for, (1) to optimize performance, (1) with Formula Editor, (1) writing equations, (1) groups, (1) header records, (1) linked partitions, (1) linked reporting objects, (1) with Formula Editor, (1) outline change logs, (1) outline files, (1) outlines, for currency conversions, (1) for currency conversions, (1) new, (1) process summarized, (1) transparent, (1) replicated partitions, (1) (2) report scripts, (1) overview, (1) parts described, (1) rules files, process overview, (1) (2) scripts for batch processing, (1) shared members, (1) for different generations, (1) (2) non-leaf, (1) overview, (1) with Outline Editor, (1) with rules files, (1) shared roll-ups, (1) substitution variables, (1) text files, (1) transparent partitions, (1) two-dimensional reports, (1) (2) UDAs, (1) users, (1) creating with operators, (1) cross-dimensional members, in formulas, (1) cross-dimensional operator (->) inserting in formulas, (1) overview, (1) used in equations in dense dimensions, (1) cross-server migration, (1) (2) crosstab, defined, (1) .CSC files, (1) cube specification in MDX queries, (1) cubes, (1) CURCAT. See currency category field type CurCategory dimension, (1) @CURGEN function, (1) CURHEADING report command, (1) @CURLEV function, (1) CurName dimension, (1) CURNAME. See currency name field type ad hoc report, (1) converting, (1) defining country-specific, (1) calculation options, (1) defining categories of, (1) usage example, (1) formatting in reports, (1) overview, (1) sample, (1) structure of, (1) in header records, (1) in rules files, (1) usage overview, (1) aggregate storage databases compared to block storage databases, (1) currency conversion methodologies, (1) application structure, (1) base to local exchange, (1) calculating, (1) calculating in report scripts, (1) calculation command, (1) calculation methods, (1) databases required, (1) dynamic calculations and, (1) Intelligent Calculation and, (1) keeping local and converted values, (1) methodologies, (1) overview, (1) overwriting local values, (1) process for, (1) reporting, (1) sample applications, (1) suppressing in reports, (1) tagging dimensions for, (1) tracking, (1) troubleshooting, (1) contents of, (1) defined, (1) currency fields, (1) in header records, (1) in rules files, (1) defining, (1) description, (1) usage overview, (1) currency partitions, (1) overriding, (1) using to convert, (1) currency symbols, (1) currency type dimension, (1) @CURRMBR function, (1) @CURRMBRRANGE function, (1) CurType dimension, (1) function category, (1) using in formulas, (1) aggregate storage, (1) copying, (1) creating, (1) creating a Java class, (1) deleting, (1) input parameters, (1) installing Java classes, (1) Java requirements for, (1) memory considerations, (1) naming, (1) overview, (1) performance considerations, (1) registering, (1) removing, (1) scope, (1) security required, (1) updating, (1) using in calculations, (1) viewing, (1) aggregate storage, (1) copying, (1) creating, (1) deleting, (1) naming, (1) overview, (1) refreshing catalog, (1) removing, (1) scope, (1) updating, (1) using in calculations, (1) viewing, (1) Analytic Server, (1) Analytic Server kernel, (1) Din dimension and member names, (1) in member names, (1) in names in scripts and formulas, (1) in report scripts, (1) data, (1) calculated vs. input, (1) changing in aggregate storage databases , (1) clearing, (1) and LROs, (1) calculation command, (1) commands, (1) during restructure of aggregate storage database, (1) existing values, (1) in calculated columns, (1) (2) Intelligent Calculations, (1) computing relationships, (1) concurrency, (1) consistency, (1) controlling flow, (1) database files, (1) derived, (1) distribution characteristics, (1) (2) entering in data sources, (1) for backups, (1) into other forms, (1) methods, (1) using an output file, (1) using dynamic calculations, (1) with report scripts, (1) irrelevant, (1) aggregate storage databases, (1) described, (1) dynamic calculations and, (1) for testing purposes, (1) from external sources, (1) (2) (3) (4) from partitioned applications, (1) (2) (3) from rules files, (1) incrementally, (1) supported formats, (1) troubleshooting problems with, (1) unauthorized users and, (1) managing, (1) manipulating remote, (1) missing from partition target, (1) not associated with members, (1) partitioning guidelines, (1) (2) (3) pivoting, (1) previewing in Administration Services Console, (1) protecting, (1) after exporting, (1) after member name changes, (1) Dynamic Calc and Store members, (1) examples, (1) for Personal Essbase servers, (1) Intelligent Calculation and, (1) (2) two-pass calculations and, (1) using dynamic calculations, (1) referencing in dimensions, (1) (2) refreshing, (1) removing locks on, (1) restoring from backups, (1) retrieving in Administration Services Console, (1) rules files, (1) sharing, (1) across multiple sites, (1) (2) in partitioned databases, (1) (2) sorting for reports, (1) (2) (3) (4) in partitioned databases, (1) (2) partitioning and, (1) usage example, (1) time-sensitive, (1) transactions and redundant, (1) (2) validating, (1) by specifying coordinates, (1) in data targets, (1) in different perspectives, (1) in multidimensional databases, (1) defining objectives, (1) example, (1) getting started tips, (1) optimizing, (1) single-server applications, (1) (2) kernel component, (1) overview, (1) accessing locked, (1) as multidimensional arrays, (1) (2) calculating dirty, (1) caution for partial calculations, (1) concurrent calculations, (1) defining calculation order, (1) procedure, (1) calculations and, (1) categorizing, (1) checking structural integrity, (1) clearing values, (1) compressing, (1) creating from Intelligent Calculations, (1) definition, (1) exporting, (1) with committed access, (1) (2) with uncommitted access, (1) marking as clean/dirty, (1) (2) ordering, (1) overview, (1) removing, (1) removing locks on, (1) renumbering, (1) setting transactions for, (1) (2) two-dimensional example, (1) (2) updating, (1) as storage unit, (1) described, (1) fine-tuning, (1) checking compression ratio, (1) estimating block size, (1) fragmentation allowance, (1) optimal configuration, (1) overview, (1) specifying/changing, (1) data concurrency, (1) considerations, (1) data coordinates, (1) data extraction, (1) characters ignored, (1) exporting data, (1) defined, (1) for selecting members, (1) in Report Writer, (1) defined in data source, (1) defining columns as, (1) entering data, (1) reversing values in, (1) as storage unit, (1) described, (1) fine-tuning, (1) setting size, (1) allocating storage for, (1) caution for recovery and, (1) cross-platform compatibility, (1) definition, (1) list to backup, (1) opening, (1) setting maximum, (1) viewing, (1) assigning to users/groups, (1) copying, (1) defining, (1) deleting, (1) editing, (1) in calculated data, (1) inheritance and, (1) migrating, (1) overriding, (1) overview, (1) permissions, (1) renaming, (1) restrictions on applying, (1) saving, (1) viewing existing, (1) write access to database, (1) concepts, (1) relationships defined, (1) (2) checks failing, (1) committed access and, (1) fatal error handling, (1) isolation levels, (1) retaining duplicate data, (1) uncommitted access and, (1) validating, (1) aggregate storage databases compared to block storage databases, (1) error logs. See dataload.err file free-form, (1) order of files, (1) parent members, (1) defined, (1) described, (1) when to use, (1) stages, (1) data load buffer, (1) data locks, managing, (1) about, (1) Administration Services and, (1) aggregate storage databases compared to block storage databases, (1) creating new, (1) learning and, (1) training, (1) about, (1) specifying, (1) association rules algorithms, (1) build tasks, (1) clustering algorithms, (1) decision tree algorithms, (1) MaxL commands and, (1) Naive Bayes algorithms, (1) neural network algorithms, (1) preparing for, (1) regression algorithms, (1) results, viewing, (1) about, (1) specifying, (1) creating rules files, (1) defining header information, (1) displaying records, (1) loading data sources, (1) opening, (1) Data Preview Grid, (1) data redundancy overhead, (1) data repositories, (1) copying portions, (1) non-typical, (1) typical nature of data, (1) (2) replicated partitions and, (1) using transparent partitions, (1) dimension build, (1) aggregate storage data loads, (1) altering to build dimensions, (1) appending information to, (1) building dimensions, (1) (2) (3) (4) (5) changing outlines, (1) copying, (1) creating shared roll-ups from multiple, (1) debugging, (1) defined, (1) by build method, (1) for multiple partitions, (1) for replicated partitions, (1) entering data, (1) for dimension builds, (1) ignoring fields, (1) member fields, (1) overview, (1) with a rules file, (1) identifying, (1) load failing, (1) from Analytic Server, (1) in Data Prep Editor, (1) prerequisites, (1) troubleshooting problems, (1) (2) logging into, (1) losing connections to, (1) mapping information, (1) member names differing from targets, (1) members with no ancestor specified, (1) missing members, (1) numbering members, (1) opening, (1) order, (1) columns, (1) overview, (1) partitioning information for, (1) remote data retrievals and, (1) removing members, (1) derived data, (1) members, (1) partial sets, (1) selecting text or spreadsheet, (1) selecting valid, (1) selecting valid sources, (1) setting member properties, (1) specifying field type, (1) specifying shared areas, (1) supported, (1) updating changes to, (1) validating rules files from, (1) with different values, (1) with new member lists, (1) data storage property, setting, (1) data storage. See storage; Analytic Services kernel example, (1) procedure, (1) with Intelligent Calculation, (1) calculation commands, (1) clearing, (1) using the FIX command, (1) archiving, (1) changing data in, (1) changing outlines, (1) copying from, (1) defined, (1) for multiple partitions, (1) for partitions, (1) logging into, (1) losing connections to, (1) mapping information, (1) mapping members, (1) member names differing from source, (1) missing data, (1) partitioning information for, (1) propagating outline changes, process summarized, (1) specifying shared areas, (1) updating changes to, (1) viewing data in linked partitions, (1) data values, (1) See also missing values; range of values accumulating, (1) to member combinations, (1) to variables, (1) non-zero values and, (1) changing, (1) changing in replicated partitions, (1) comparing example, (1) compression and repetitive, (1) (2) distribution among dimensions, (1) (2) duplicating, (1) dynamically calculating, (1) (2) (3) entering in empty fields, (1) filtering, (1) flipping, (1) formatting in reports, (1) (2) identical, (1) in partitions, (1) inconsistent, (1) incorrect, (1) interdependent, (1) location, (1) looking up, (1) measuring, (1) member with no, (1) negative, (1) flipping, (1) variance as, (1) optimizing in sparse dimensions, (1) out of range, (1) for currency conversions, (1) placing retrieval restrictions, (1) (2) reading multiple ranges, (1) dynamically calculated, (1) (2) (3) (4) from other databases, (1) from remote databases, (1) (2) (3) retrieving for reports, (1) setting maximum rows allowed, (1) rolling up, (1) scaling, (1) truncating, (1) unexpected, (1) assigning #MISSING values to, (1) Intelligent Calculation and, (1) unknown, (1) variables as, (1) database administrators. See administrators simultaneously in different databases, (1) annotating, (1) contents, (1) copying range of, (1) determining calculation order for, (1) (2) linking objects to, (1) mapping to targets, (1) removing linked objects, (1) returning unique values for, (1) (2) database context, in MDX queries, (1) database design, attribute dimensions, (1) Database Designer permission, (1) (2) Database Designer privilege. See DB Designer privilege database directory, (1) backing up, (1) corruption and, (1) essential files, (1) on different operating systems, (1) database models, creating as a part of database design, (1) aggregate storage databases, (1) calculation scripts, (1) data sources, (1) linked reporting objects, (1) member select definitions, (1) outlines, (1) overview, (1) report scripts, (1) rules files, (1) security definitions, (1) spreadsheet queries, (1) database outlines. See outlines cache hit ratios, (1) retrieval buffer size, (1) retrieval sort buffer size, (1) using incremental, (1) See also data; partitioned databases remote, (1) aggregate storage, (1) aggregate storage compared to block storage, (1) annotating, (1) associating, with calculation scripts, (1) backing up, (1) development process for, (1) example for, (1) prerequisites for, (1) building an outline, (1) calculating multiple, (1) changing settings, scope and precedence, (1) checking, which databases are currently running, (1) checklist for analyzing, (1) configuring for calculation, (1) copying, (1) for Personal Essbase, (1) on client, (1) creating accounts for, (1) (2) (3) creating aggregate storage databases, (1) (2) creating alias for, (1) currency conversions and, (1) deleting, (1) described, (1) determining scope, (1) distributing. See partitioning exporting data from, (1) exporting methods, (1) fine tuning, (1) identifying data sources, (1) implementing common security, (1) implementing global security, (1) larger than 2 GB, exporting, (1) linking related, (1) loading applications with, (1) migrating across servers, (1) minimizing downtime, (1) mission-critical, (1) multidimensional defined, (1) naming rules, (1) non-contiguous portions in, (1) objects, (1) OLAP, (1) optimizing retrieval, (1) overview, (1) sample applications showing, (1) permission, (1) permissions, (1) planning prerequisites, (1) protecting data, (1) putting in archive or read-only mode, (1) rebuilding, (1) reducing size, (1) related information among, (1) reloading after porting, (1) removing dimensions, restructuring and, (1) removing partitions, (1) renaming, (1) resetting, (1) restoring from backups, (1) changing outlines and, (1) dynamic calculations and, (1) effects, (1) in partitioned applications, (1) Intelligent Calculation and, (1) (2) overview, (1) process described, (1) Sample Interntl, (1) Sample Xchgrate, (1) security backup, (1) with ESSCMD, (1) size, (1) size determinations, (1) slicing, (1) starting, (1) automatically, (1) taking out of archive or read-only mode, (1) testing design, (1) updating, (1) validating aggregate storage outlines, (1) viewing, (1) with differing dimensionality, (1) currency conversions and, (1) limitations, (1) partitioned applications and, (1) using to copy blocks, (1) DATAERRORLIMIT setting, (1) (2) using to debug data load problems, (1) example, (1) loading, (1) maximum errors logged, (1) renaming, (1) viewing, (1) DATALOAD.TXT file, (1) changing the member name format, (1) defined, (1) duplicate values, (1) changing in attribute dimensions, (1) described, (1) examples, (1) period-to-date values, (1) dates, in calculation formulas, (1) day-to-date calculations, (1) .DB files, (1) DB Designer privilege, (1) data files, (1) index files, (1) .DBB files, (1) .DBF files, (1) .DDM files, (1) .DDN files, (1) deadlocks, (1) deallocation (storage), (1) debugging data loads, (1) debugging tool, (1) decimal points, (1) DECIMAL report command, (1) (2) decision tree algorithms, (1) arrays, (1) @DECLINE function, (1) Default table (aliases), (1) updating during builds, (1) default tablespace, described, (1) application settings, (1) setting, (1) calculator cache, (1) consolidating missing values, (1) data cache size, (1) data file cache size, (1) data storage, (1) dimension properties, (1) dynamic builds, (1) error log locations, (1) index cache size, (1) Intelligent Calculation, (1) setting, (1) member selection for reports, (1) outline change log size, (1) time balance property, (1) variance reporting properties, (1) See also adding; creating; setting a single data value, (1) calculation order, (1) data blocks, (1) dimensions, (1) dynamically calculated values, (1) (2) forward references and, (1) calculation script as default, (1) calculations (checklist for), (1) columns as fields, (1) checklist for, (1) custom attributes, (1) data sources, (1) for multiple partitions, (1) for replicated partitions, (1) data storage properties, (1) for multiple partitions, (1) for partitions, (1) dimension properties, (1) (2) (3) caution for two-pass tags, (1) dimensions as flat, (1) dynamic calc properties, (1) filters, (1) global access levels, (1) member properties, (1) (2) (3) as label only, (1) members as label only, (1) (2) parent-child relationships, (1) partitioned areas, (1) linked, (1) multiple, (1) selection/rejection criteria, (1) (2) on multiple fields, (1) shared member properties, (1) (2) sort order, (1) two-pass calculations, (1) (2) UDAs, (1) definition files. See partition definition files security file, (1) defragmentation, security file, (1) DELAYEDRECOVERY setting, (1) delays, (1) DELETE command, (1) DELETEAPP command, (1) DELETEDB command, (1) DELETELOCATION command, (1) DELETELOG command, (1) DELETEVARIABLE command, (1) alias tables, (1) applications, (1) calculation scripts, (1) data blocks, (1) databases, (1) dimensions, and restructuring, (1) filters, (1) groups, (1) items from outlines, (1) linked objects, (1) locks, (1) logs, (1) members from data sources, (1) objects, (1) partitions, (1) spaces in fields, (1) substitution variables, (1) temporary files, (1) users, (1) DELIMITEDMSG setting, (1) DELIMITEDMSG to filter logs, (1) DELIMITER setting, (1) ~ (tildes) as default, (1) commas in numbers, (1) member lists, (1) report script commands, (1) (2) See also dimensions; sparse dimensions attribute design approach, (1) calculating values in, (1) (2) (3) dynamically calculating, (1) (2) (3) (4) implications for restructuring and, (1) (2) Intelligent Calculation and, (1) (2) referencing values in, (1) (2) reporting on, (1) selecting, (1) selection scenarios, (1) (2) (3) viewing member combinations, (1) (2) (3) (4) density, (1) derived data, (1) DESC flag to ORDERBY report command, (1) @DESCENDANTS function, (1) checking for, (1) currency conversions and, (1) defined, (1) moving, (1) selecting members, (1) usage, (1) applying to output, (1) members in outlines, (1) sort command, (1) analyzing database scope, (1) creating business models, (1) defining calculations, (1) defining consolidations, (1) defining dimension properties, (1) identifying data sources, (1) partitioning databases, (1) (2) selecting partition types, (1) attributes, (1) dimensions, (1) outlines, (1) designer permissions, (1) for optimal calculations, (1) (2) partitioned applications, (1) (2) (3) (4) scenarios for, (1) single-server applications, (1) (2) Desktop window. See Application Desktop window detail members, (1) data storage, (1) process summarized, (1) development servers, migrating from, (1) diagnostic information, (1) diagnostic tools, overview, (1) between attributes and UDAs, (1) between standard and attribute dimensions, (1) entering in report scripts, (1) usage, (1) checking error logs, (1) example, (1) maximum errors logged, (1) viewing, (1) aggregate storage, (1) aliases with attributes, (1) base dimension members with attributes, (1) attribute dimensions, (1) standard dimensions, (1) error logs. See dataload.err file. field types, (1) position of fields in rules file, (1) rules, (1) summary of rules for attribute dimensions, (1) formatting, (1) in data source, defined, (1) maximum length, (1) dimension order, and aggregate storage, (1) dimension properties, setting, (1) dimension type, setting, (1) dimension, as highest consolidation level, (1) dimensionality, in MDX (defined), (1) DIMENSIONBUILD.TXT file, (1) See also dense dimensions; sparse dimensions; attribute dimensions; standard dimensions; base dimensions adding, (1) adding comments to, (1) adding members, (1) (2) (3) (4) (5) guidelines for, (1) partitioned applications, (1) performance considerations, (1) (2) restructuring and, (1) applicable to business models, (1) arranging in hierarchies, (1) (2) associating formulas with, (1) described, (1) attribute vs standard, (1) defined, (1) building, (1) dynamically See dynamic builds prerequisites, (1) with dynamically calculated members, (1) with rules files, (1) calculating members in, (1) (2) calculating series of, (1) calculator cache and, (1) categorized, (1) clearing member combinations, (1) consolidation levels, (1) currency databases, (1) databases with different, (1) defined, (1) defining as flat, (1) defining properties, (1) (2) (3) caution for two-pass tags, (1) deleting and restructuring, (1) dense and sparse storage, (1) determining optimal configuration, (1) (2) (3) determining valid combinations, (1) fixing as constant, (1) getting member combinations, (1) (2) getting started with setting up, (1) grouping in calc scripts, (1) grouping in calculation scripts, (1) (2) handling missing values in, (1) identified in data source, (1) irrelevance across, (1) mapping fields to, (1) missing, (1) moving in outlines, (1) naming levels in current, (1) nesting, (1) non-specific, (1) on aggregate storage databases, (1) optimum order in outline, (1) ordering, (1) positioning in outlines, (1) predefined types described, (1) relationship among members, (1) (2) (3) (4) selection guidelines, (1) single-server models, (1) storage, (1) splitting, (1) alternative for attributes, (1) compared with attribute types, (1) described, (1) standard vs dynamic, (1) as specific type, (1) for currency conversion, (1) two-pass calculations and, (1) types, (1) DIMTOP report command, (1) cache memory locking and, (1) enabling, (1) overview, (1) API, (1) application, (1) database, (1) for calculation scripts, (1) for error logs, (1) error logs, (1) calculating blocks with, (1) clearing data and, (1) copying data and, (1) currency conversion and, (1) Intelligent Calculation and, (1) resulting from reloads, (1) disabled users, activating, (1) disabling member sort, (1) discarding records, (1) disconnecting users, (1) @DISCOUNT function, (1) discount, calculating, (1) copying databases to, (1) viewing information about, (1) aggregate storage, allocating, (1) allocating, (1) example, (1) Analytic Server logs and, (1) application logs and, (1) availability for restructuring, (1) block storage, allocating, (1) compressed block size, (1) data redundancy overhead, (1) fragmentation allowance, (1) checking, (1) conserving, (1) estimating, (1) for linked reporting objects, (1) with committed access, (1) with uncommitted access, (1) optimizing, (1) out of, (1) outline change logs and, (1) partitioned databases, (1) (2) with replicated partitions, (1) with transparent partitions, (1) unused and fragmented, (1) disk volumes, (1) allocation and, (1) backing up data on, (1) caution for specifying name only, (1) data storage and multiple, (1) deallocating, (1) index files and, (1) specifying, (1) updating storage settings, (1) display database (MaxL), (1) (2) display filter (MaxL), (1) display function (MaxL), (1) display group (MaxL), (1) display location alias (MaxL), (1) display macro (MaxL), (1) display system (MaxL), (1) (2) (3) display system (MaxL) to show available unused ports, (1) display user (MaxL), (1) (2) (3) display user in group (MaxL), (1) Analytic Server properties, (1) application information, (1) application properties, (1) changes to outlines, (1) in targets, (1) database, properties, (1) dynamically calculated members, (1) (2) field operations, (1) filters, (1) formulas, (1) informational messages, (1) (2) linked objects, (1) locked data, (1) member combinations, (1) (2) (3) (4) member names in reports, (1) members in outlines, (1) records, (1) replace operations, (1) selection/rejection criteria, (1) Server Agent commands, (1) software version, (1) distributed databases. See partitioning distribution (multidimensional models), (1) (2) applications. See partitioned databases; partitions; splitting, databases fields, (1) consolidation codes in data source, (1) (2) consolidation property, (1) modulus operations, (1) .DLL files, (1) DLSINGLETHREADPERSTAGE setting, (1) DLTHREADSPREPARE setting, (1) DLTHREADSWRITE setting, (1) DOCS directory, (1) conventions used, (1) Essbase Administration Services, (1) feedback, (1) ordering print documents, (1) structure of, (1) Hyperion Download Center, (1) Hyperion Solutions Web site, (1) documents, linking external, (1) in array and variable names, (1) converting to USD, (1) exchange rates, (1) enclosing member names, (1) in application and database names, (1) in dimension and member names, (1) in ESSCMD commands, (1) in header information, (1) in report scripts, (1) in terms in scripts and formulas, (1) terms in scripts and formulas, (1) double slashes (//) in report scripts, (1) downtime, (1) facilitating, (1) to a data target, (1) drop (MaxL), (1) drop application (MaxL), (1) drop database (MaxL), (1) drop filter (MaxL), (1) drop group (MaxL), (1) drop location alias (MaxL), (1) drop macro (MaxL), (1) drop user (MaxL), (1) D-T-D time series member, (1) (2) dummy parents, (1) DUMP command (Agent), (1) DUPGEN. See duplicate generation field type DUPGENALIAS. See duplicate generation alias field type DUPLEVEL. See duplicate level field type DUPLEVELALIAS. See duplicate level alias field type data, (1) generations, (1) duplicate generation alias field type arranging in rules files, (1) in header records, (1) in rules files, (1) nulls and, (1) duplicate generation field type arranging in rules files, (1) creating shared members, (1) in header records, (1) in rules files, (1) nulls and, (1) duplicate level alias field type arranging in rules files, (1) in header records, (1) in rules files, (1) nulls and, (1) arranging in rules files, (1) in header records, (1) in rules files, (1) nulls and, (1) sharing members, (1) data, (1) data values, (1) outlines, (1) as child of specified parent, (1) to dimensions with similar members, (1) to end of dimensions, (1) arranging fields, (1) bottom-up ordering, (1) (2) (3) creating shared members, (1) (2) for different generations, (1) (2) with rule files, (1) generation references and, (1) level references and, (1) members without specified ancestor, (1) parent-child references and, (1) (2) process summarized, (1) restrictions, (1) selecting build method, (1) (2) (3) selecting field types for, (1) validating rules files, (1) with data sources, (1) (2) (3) (4) (5) (6) with rules files, (1) Dynamic Calc and Store members adding to calculations, (1) adding to formulas, (1) clearing values, (1) creating, (1) currency conversions and, (1) dense dimensions and, (1) loading data into, (1) replicating, (1) reporting on, (1) retrieving values, (1) specifying in data source, (1) viewing, (1) adding to calculations, (1) adding to formulas, (1) and aggregate storage, (1) and sparse dimensions, (1) (2) and two-pass members, (1) Attribute Calculations dimension, (1) changing to stored member, (1) creating, (1) currency conversions and, (1) description, (1) effects on members, (1) loading data into, (1) overview, (1) reporting on, (1) retrieving values, (1) specifying in data source, (1) viewing, (1) dynamic calculations, (1) affects on performance, (1) asymmetric data, (1) Attribute Calculations dimension, (1) building, (1) calculation scripts and, (1) (2) choosing members, (1) defined, (1) dimensions with, (1) exporting data and, (1) formulas applied to members, (1) optimizing retrieval, (1) partitioned databases, (1) replicated partitions, (1) retrieving values, (1) (2) (3) (4) transparent partitions, (1) viewing application, (1) overview, (1) sizing, (1) summary of activity, (1) viewing usage information, (1) adding members to outlines, (1) (2) (3) generation references, (1) level references, (1) dynamic dimensions, level references, (1) Dynamic Time Series members, (1) (2) enabling/disabling, (1) generation names for, (1) in shared areas, (1) inserting in report scripts, (1) listed, (1) reporting on, (1) selecting, (1) specifying aliases for, (1) EE, expense property code in data source, (1) EAS directory, (1) EAS. See Essbase Administration Services East database, partitioning, (1) filters, (1) outlines, (1) report scripts, (1) security profiles, (1) calculation scripts and, (1) ESSCMD commands and, (1) report scripts and, (1) education services, (1) electronic mailboxes, (1) ELSE statement, (1) calculation scripts, (1) email alerts, (1) described, (1) preventing, (1) adding values to, (1) blank fields in rules file, (1) in data source, (1) defined, (1) indication in text files, (1) locale, (1) managing, (1) non-Unicode, (1) non-Unicode-mode application text files, (1) UTF-8, (1) described, (1) where required, (1) ENDARCHIVE command, (1) partitioned applications and, (1) values, (1) product/market shares, (1) range of values, (1) subsets of values, (1) data blocks, (1) subsets of values, (1) copying subsets of values, (1) currency conversions and, (1) (2) Intelligent Calculation and, (1) (2) (3) optimizing calculations with, (1) (2) entering in report scripts, (1) modifying headings, (1) interdependent formulas in, (1) member formulas in, (1) semicolons with, (1) syntax, (1) purpose of, (1) semicolons with, (1) syntax, (1) end-of-file markers, (1) end-of-line character, (1) ESSCMD commands, (1) example, (1) inserting in calculation scripts, (1) (2) Enterprise View, (1) See UNIX platforms; Windows platforms .EQD files, (1) in application and database names, (1) in dimension and member names, (1) in names in scripts and formulas, (1) in report scripts, (1) equations, (1) cross-dimensional operator and, (1) (2) crossdimensional operator and, (1) inserting in calculation scripts, (1) (2) (3) report scripts, (1) .ERR files, (1) .ERR files See also error log files error codes and numbers, (1) commands, (1) on Analytic Server kernel, (1) default directory for, (1) empty, (1) exception log, (1) loading, (1) maximum number of records in, (1) (2) (3) missing, (1) names and locations, (1) overview, (1) renaming, (1) record count, (1) error message categories, (1) error messages. See application logs, exception logs, and Analytic Server logs. calculation scripts, checking for in, (1) exception logs and, (1) fixing for dynamic builds, (1) formulas and, (1) formulas and dynamically calculated members, (1) formulas,checking for, (1) handling fatal, (1) matching member omitted, (1) MDX formulas,checking for, (1) mismatches, (1) pinpointing, (1) Report Extractor, (1) restructuring and, (1) storage allocation, (1) unknown member, (1) ESBBEGINREPORT function, (1) ESBENDREPORT function, (1) ESBREPORT function, (1) ESBREPORTFILE function, (1) .ESR files, (1) Essbase Administration Services application servers, (1) architecture, (1) connecting to, (1) deployment, (1) directory for files, (1) documentation, (1) overview of, (1) ports, (1) relational databases, (1) restructuring partitioned databases, (1) starting, (1) starting Analytic Servers from, (1) storage, (1) users, (1) described, (1) described, (1) dynamic calculator cache settings, (1) setting messages, added to Analytic Server logs, (1) (2) setting messages, added to application logs, (1) ESSBASE.LOG file, (1) backing up, (1) described, (1) filters and, (1) ESSBEGINREPORT function, (1) caution for processing commands, (1) checking structural integrity, (1) defined, (1) deleting logs, (1) entering commands, (1) loading update log files, (1) operational modes, (1) performance-related commands, (1) (2) (3) referencing files, (1) calculation scripts, (1) caution for pausing systems and, (1) in interactive mode, (1) isolation levels, (1) substitution variables, (1) transaction isolation levels, (1) data compression, (1) disk volumes, (1) starting, (1) applications, (1) databases, (1) prerequisites, (1) syntax, (1) viewing dynamic calculator cache activity, (1) writing script files, (1) stopping applications, (1) naming, (1) quotation marks in, (1) running, (1) sample, (1) within operating system batch files, (1) ESSCMD.EXE file, (1) ESSENDREPORT function, (1) ESSGBEGINREPORT function, (1) ESSGREPORTFILE function, (1) creating passwords using, (1) defining locales, (1) list of supported values, (1) requirement, (1) ESSREPORT function, (1) ESSREPORTFILE function, (1) ESSUTF8 utility, (1) ESTIMATEFULLDBSIZE command, (1) disk space, (1) disk space, for linked reporting objects, (1) Euro currency symbol, (1) overriding, (1) usage, (1) events, (1) Excel spreadsheets. See Spreadsheet Add-in exception error logs. See exception logs Exception Handler, location of writes, (1) exception logs, (1) contents described, (1) example, (1) names and locations, (1) overview, (1) overwriting, (1) saving, (1) viewing, (1) EXCEPTIONLOGOVERWRITE setting, (1) calculating options, (1) defining, (1) in currency applications, (1) usage example, (1) exclamation points (!), in names in scripts and formulas, (1) excluding members from consolidations, (1) (2) exclusive locks. See Write locks .EXE files, (1) execute calculation (MaxL), (1) (2) execute permission, (1) EXIT command (ESSCMD), (1) See also closing; quitting; stopping Analytic Server, (1) @EXP function, (1) described, (1) requirement, (1) specifying in data source, (1) expense vs. non-expense items, (1) explicit restructure, (1) exponentiation, (1) exponents, calculating, (1) columnar format, (1) partitioned applications and, (1) export data (MaxL), (1) export file, encoding, (1) export files, (1) export lro (MaxL), (1) exported data reloads, (1) (2) alias tables, (1) for backups, (1) in parallel, (1) into other forms, (1) recalculating, (1) using report scripts, (1) databases larger than 2 GB, (1) LROs, (1) aggregate storage databases compared to block storage databases, (1) for loading data, (1) (2) (3) (4) linking to cells, (1) prerequisites for loading, (1) supported, (1) characters ignored, (1) defined, (1) FF, first time balance code in data source, (1) @FACTORIAL function, (1) factorials, (1) restructuring and, (1) transaction rollbacks and, (1) False Boolean member name, changing default name, (1) fatal errors, (1) FEEDON report command, (1) fetches, (1) adding prefixes or suffixes to, (1) assigning to data fields, (1) changing case, (1) SQL data sources, (1) validating, (1) field operations, (1) field ordering for logs, (1) defined, (1) differences described, (1) dimension building properties, (1) dynamically referencing, (1) restrictions for rules files, (1) setting member properties, (1) (2) shared members, (1) (2) (3) (4) (5) caution for creating, (1) valid build methods, (1) adding prefixes or suffixes to values, (1) changing case, (1) clearing existing values, (1) concatenating multiple, (1) copying, in rules files, (1) creating, (1) by splitting, (1) defined, (1) defining columns as, (1) defining operations for rules files, (1) delimiters/separators. See file delimiters adding values to, (1) in data source, (1) in rules file, (1) replacing with text, (1) entering data, (1) excluding specific from data loads, (1) formatting rules, (1) in data sources, (1) joining fields, (1) manipulating in rules files, (1) changing case, (1) inserting text in empty fields, (1) replacing text strings, (1) specific only, (1) to member names, (1) moving, (1) naming, (1) position in rules file, (1) (2) removing spaces in, (1) reversing values in, (1) setting retrieval specifications, (1) size and optimal loads, (1) undoing operations on, (1) formatting rules, (1) in header information, (1) partition mapping files, (1) backing up databases with, (1) managing files with, (1) batch files, (1) calculation scripts, (1) error logs, (1) ESSCMD script files, (1) in ESSCMD, (1) linked reporting object files, (1) outline change files, (1) report scripts, (1) temporary files, (1) See also data files; rules files; text files attaching external to cells, (1) caution for recovery and, (1) compatibility across platforms, (1) copying across operating systems, (1) essential for Analytic Services, (1) implementing security for, (1) loading, (1) locating end-of-file markers, (1) logging dimension builds, (1) logging outline changes, (1) opening, (1) referencing in ESSCMD, (1) renaming with FTP, (1) restrictions for linking, (1) restructuring, (1) specifying size for linked, (1) (2) storing, (1) temporary for full restructures, (1) transferring compatible, (1) compatibility across platforms, (1) with long names, (1) Filter Access privilege, (1) MDX, example of, (1) AND relationship, (1) assigning to users/groups, (1) attribute functions and, (1) copying, (1) for databases, (1) for partitioned databases, (1) defined on seperate rows, (1) defining, (1) deleting, (1) editing, (1) in calculated data, (1) inheriting definitions, (1) (2) (3) insert into logs with DELIMITEDMSG, (1) migrating with applications, (1) on entire members, (1) on member combinations, (1) OR relationship, (1) overriding, (1) overriding in partitions, (1) overview, (1) permissions, (1) renaming, (1) restrictions on applying, (1) saving, (1) storage in security (.SEC) file, (1) using member set functions, (1) viewing existing, (1) write access to database, (1) allocating costs, (1) calculating product and market share, (1) comparing actual to budgeted expense, (1) containing time-sensitive data, (1) estimating sales and profits, (1) example for building, (1) forecasting values, (1) getting budgeted data values, (1) getting variance for actual to budgeted, (1) (2) loading new budget values, (1) calculations with, (1) described, (1) Intelligent Calculation and, (1) end-of-file markers, (1) example, (1) specifying in data source, (1) first-time calculations, (1) first-time users, (1) FIX/ENDFIX command, (1) allocating costs, (1) calculating product/market shares, (1) calculating range of values, (1) calculating subsets of values, (1) clearing data blocks, (1) clearing subsets of values, (1) copying subsets of values, (1) currency conversions and, (1) (2) for calculations, (1) Intelligent Calculation and, (1) (2) (3) optimizing calculations with, (1) (2) usage example, (1) fixed-size overhead, (1) flags (partitions), (1) dimensions, (1) loading, (1) using as Linked Reporting Object, (1) flipping data values, (1) floating point representation, in calculations, (1) examples, (1) foreground startup, (1) alias tables, (1) columns for data load, (1) (2) comments, (1) overview, (1) export, (1) free-form data sources, (1) (2) (3) header information, (1) import specifications and, (1) linked object restrictions, (1) report output, (1) suppressing in reports, (1) (2) tab-delimited, (1) defined, (1) listed, (1) nesting, (1) output, (1) formatting, database outlines, (1) building formulas, (1) building MDX formulas, (1) in header records, (1) in rules files, (1) adding series to calculation scripts, (1) adding to calculation scripts, (1) (2) (3) adding to calculations, (1) aggregate storage, (1) applied to members, (1) (2) (3) (4) (5) (6) applying to data subsets, (1) associating with dimensions or members, (1) basic MDX equations, (1) calculating MDX, (1) calculating twice, (1) (2) (3) with Intelligent Calculation, (1) (2) calculation mode used, (1) caution for sparse dimensions, (1) checking MDX syntax of, (1) composing MDX, (1) syntax for, (1) writing equations, (1) crossdimensional operator and, (1) cross-dimensional references in, (1) (2) defined, (1) developing for aggregate storage databases, (1) developing for aggregate storage outlines, (1) (2) difference between block storage and aggregate storage, (1) displaying MDX, (1) dynamic calculations and, (1) (2) examples, (1) grouping in calc scripts, (1) grouping in calculation scripts, (1) (2) in partitioned applications, (1) (2) in time and accounts dimensions, (1) inserting variables, (1) Intelligent Calculation and, (1) limitations and parallel calculation, (1) MDX conditional, (1) MDX cross dimensional, (1) MDX syntax for, (1) MDX, about, (1) names with special characters, (1) (2) on aggregate storage databases, (1) optimizing, (1) partitions and, (1) performance considerations, (1) (2) run-time, (1) setting conditions for, (1) (2) shared members and, (1) top-down, (1) types described, (1) forward calculation references, (1) FoxPro databases. See SQL databases allowance, (1) defined, (1) security file, (1) data load, (1) data sources, (1) reports, (1) FROM keyword in MDX queries, (1) FTP file transfers, (1) defined, (1) temporary files created, (1) See also the specific @function allocation, (1) applying to subsets, (1) Boolean, (1) calculation mode, (1) custom-defined, (1) date and time, (1) defining multiple members and, (1) financial calculations with, (1) forecasting, (1) generating member lists, (1) (2) inserting in calculation scripts, (1) Intelligent Calculation and, (1) mathematical, (1) MaxL DML functions for querying data, (1) member set, (1) range, (1) relationship, (1) report generation, (1) returning specific values, (1) run-time, (1) statistical, (1) fundamentals, (1) future values, calculating, (1) G@GEN function, (1) account reporting values, (1) free-form, (1) with API function calls, (1) arranging in rules files, (1) in header records, (1) in rules files, (1) null values and, (1) adding to report scripts, (1) (2) assigning, (1) for Dynamic Time Series members, (1) static, (1) associating attributes dynamically, (1) building shared members, (1) defined, (1) Dynamic Time Series members, (1) (2) entering in rules files, (1) generating, (1) generation references build method creating shared members, (1) discussion, (1) guidelines for using, (1) null processing, (1) shared members, (1) valid build types, (1) generation references defined, (1) checking for, (1) duplicate, (1) Dynamic Time Series members and, (1) (2) (3) levels vs, (1) referencing in MDX queries, (1) reversing numerical ordering, (1) at multiple, (1) sorting on, (1) @GENMBRS function, (1) GENREF.RUL file, (1) GENREF.TXT file, (1) GETALLREPLCELLS command, (1) GETATTRINFO command, (1) GETCRDBINFO command, (1) GETDBINFO command, (1) (2) (3) (4) (5) GETDBSTATE command, (1) GETDBSTATS command, (1) (2) (3) (4) (5) GETPARTITIONOTLCHANGES command, (1) GETPERFSTATS command, (1) getting started with Analytic Services, (1) GETUPDATEDREPLCELLS command, (1) GETVERSION command, (1) applications, (1) defining, (1) types listed, (1) global calculation commands, (1) global formatting commands in report scripts, (1) (2) global placeholders, (1) global replacement through data loads, (1) goal seeking calculations, (1) GOTO command, (1) grant (MaxL), (1) granularity, (1) in application and database names, (1) in names in scripts and formulas, (1) assigning filters to, (1) assigning privileges to, (1) copying, (1) creating user, (1) defined, (1) deleting, (1) formulas and dimensions in calc scripts, (1) formulas and dimensions in calculation scripts, (1) (2) getting list of, (1) migrating, (1) modifying access settings, (1) (2) overriding column, (1) renaming, (1) security settings, (1) security types, (1) selecting members for report, (1) @GROWTH function, (1) guest accounts, (1) guidelines for analyzing database design, (1) H.H files, (1) handling missing values, (1) handling zero values, (1) formatting, (1) creating, (1) defined, (1) defining load rules, (1) identifying missing dimensions with, (1) locale, (1) skipping, (1) specifying location of, (1) headers. See header information; header records HEADING report command, (1) See also column headings; field names; row headings adding to complex reports, (1) (2) adding to free-form reports, (1) currency conversion, (1) customizing, (1) forcing immediate display, (1) page, (1) suppressing display, (1) using attributes in, (1) API functions, (1) calculation scripts, (1) files, (1) Server Agent, (1) HELP command (Agent), (1) calculation order and, (1) data, (1) relationships defined, (1) (2) dynamic builds, (1) members, (1) outlines, (1) unbalanced in outlines, (1) history-to-date calculations, (1) hit ratios, caches, (1) .HLP files, (1) hosts, and partitions, (1) HP-UX servers. See UNIX platforms H-T-D time series member, (1) (2) HTML files, (1) aggregate storage databases compared to block storage databases, (1) unsupported Analytic Services functions, (1) Hyperion Consulting Services, (1) Hyperion Download Center, for accessing documents, (1) Hyperion Education Services, (1) Hyperion Essbase Query Designer, (1) Hyperion product information, (1) Hyperion Solutions Web Site, for accessing documents, (1) Hyperion Technical Support, (1) hyperion.com, (1) in dimension and member names, (1) in member names, (1) in names in scripts and formulas, (1) in report scripts, (1) II/O access mode, (1) @IALLANCESTORS function, (1) @IANCESTORS function, (1) IANCESTORS report command, (1) @ICHILDREN function, (1) ICHILDREN report command, (1) identical values, (1) identifying data sources, (1) @IDESCENDANTS function, (1) (2) IDESCENDANTS report command, (1) nested statements, (1) purpose of, (1) nested in, (1) interdependent formulas in, (1) member formulas in, (1) semicolons with, (1) syntax, (1) purpose of, (1) semicolons with, (1) syntax, (1) IFERROR command, (1) #MISSING and zero values, (1) (2) end-of-file markers, (1) fields when mapping, (1) lines in rules files, (1) multiple fields in data load, (1) specific records in data load, (1) example of, (1) @ILSIBLINGS function, (1) immediate restructuring, (1) (2) IMMHEADING report command, (1) implementing security measures calculate permissions, (1) for users and groups, (1) (2) (3) (4) globally, (1) guidelines for, (1) partitioned databases, (1) planning, (1) system server, (1) implied shared relationships, (1) (2) (3) IMPORT command, (1) import data (MaxL), (1) import dimensions (MaxL), (1) import lro (MaxL), (1) alias tables, (1) LROs, (1) improper shutdown, (1) for replicated partitions, (1) resetting databases for, (1) transparent partitions, (1) (2) inaccessible applications, (1) overriding, (1) usage, (1) INCFORMATS report command, (1) INCMASK report command, (1) INCMISSINGROWS report command, overriding, (1) inconsistent values, (1) incorrect data values, (1) number of threads, (1) performance, (1) aggregate storage databases compared to block storage databases, (1) incremental data loads, (1) aggregate storage, (1) MaxL process, (1) order of files, (1) incremental growth,database solution, (1) incremental restructuring, (1) disabled with LROs, (1) files, (1) improving performance, (1) INCRESTRUC parameter, (1) overriding, (1) usage, (1) INDENT report command, (1) INDENTGEN report command, (1) indenting columns in reports, (1) advantage of small, (1) checking structural integrity, (1) determining optimal size, (1) (2) (3) disadvantage of large, (1) dynamic calculations and, (1) restructuring, (1) retrieving linked reporting objects, (1) spanning multiple pages, (1) updating, (1) as storage unit, (1) described, (1) fine-tuning, (1) managing, (1) optimizing read/writes, (1) as pointer to data block, (1) (2) managing, (1) allocating storage for, (1) caution for recovery and, (1) cross-platform compatibility, (1) defined, (1) setting maximum, (1) viewing, (1) kernel component, (1) overview, (1) linked reporting objects and, (1) managing, (1) Index Value Pair compression, (1) information flow, (1) informational messages, (1) (2) Analytic Server logs and, (1) application logs and, (1) initialization process (Analytic Server kernel), (1) initializing rules files, (1) input blocks, (1) reloading exported data, (1) restructuring and, (1) input/output (I/O), (1) installing Personal Essbase, (1) insufficient privileges, (1) @INT function, (1) aggregate storage, (1) block size and efficiency, (1) calculation order, (1) clearing values, (1) controlling with calculation scripts, (1) currency conversions and, (1) (2) (3) default calculations and, (1) large indexes and, (1) partial calculations and, (1) recalculating data and, (1) restructuring and, (1) setting as default, (1) time balance properties and, (1) turning on/turning off, (1) two-pass calculations and, (1) (2) (3) canceling operations, (1) command-line syntax for, (1) defined, (1) entering commands, (1) file-name extensions and, (1) overview, (1) running ESSCMD from, (1) interdependent values, (1) (2) interdimensional irrelevance, (1) @INTEREST function, (1) interest, calculating, (1) interfaces between linked objects and client, (1) international applications. See locales international formats, (1) (2) Interntl database, (1) interpolation, with spline, (1) invalid fields in data sources, (1) (2) calculating first/last values, (1) (2) calculating period-to-date values, (1) getting averages, (1) investments, (1) IPARENT report command, (1) @IRDESCENDANTS function, (1) @IRR function, (1) irrelevant data, (1) @IRSIBLINGS function, (1) @ISACCTYPE function, (1) @ISANCEST function, (1) @ISCHILD function, (1) @ISDESC function, (1) @ISGEN function, (1) @ISIANCEST function, (1) @ISIBLINGS function, (1) @ISICHILD function, (1) @ISIDESC function, (1) @ISIPARENT function, (1) @ISISIBLING function, (1) @ISLEV function, (1) canceling calculations and, (1) caution for data loads, (1) (2) committed and uncommitted access, (1) described, (1) parallel calculation, (1) setting, (1) updating, (1) @ISPARENT function, (1) @ISSAMEGEN function, (1) @ISSAMELEV function, (1) @ISSIBLING function, (1) @ISUDA function, (1) example of, (1) JArchives, creating, (1) creating a Java class for CDF, (1) using for custom-defined functions, (1) join, (1) joining fields, (1) JVM memory considerations, (1) Kkernel, aggregate storage compared to block storage, (1) killing processes, (1) LL, last time balance code in data source, (1) dynamically calculating, (1) defining, (1) described, (1) description, (1) specifying in data source, (1) (2) usage example, (1) replacing missing values with, (1) language support (programming), (1) country-specific dimensions, (1) (2) requirements for partitioning, (1) optimizing performance, (1) (2) described, (1) example, (1) specifying in data source, (1) LATEST report command, (1) latest time period, (1) layers, defined (in MDX queries), (1) .LCK files, (1) leading spaces, (1) defined, (1) restructuring, (1) leaf nodes, (1) learning, data mining algorithms and, (1) in application and database names, (1) (2) in names in scripts and formulas, (1) (2) @LEV function, (1) described, (1) dirty status, (1) exporting, (1) restructuring, (1) described, (1) in two-dimensional reports, (1) required in source data, (1) storing, (1) arranging in rules files, (1) in header records, (1) in rules files, (1) null values in, (1) sharing members, (1) adding to report scripts, (1) (2) advantages, (1) static, (1) determining for shared members, (1) (2) generating, (1) associating attributes dynamically, (1) entering in rules files, (1) described, (1) sample rules file for, (1) creating multiple roll-ups, (1) creating shared members, (1) (2) (3) dimension build, (1) guidelines for, (1) null processing, (1) sample rules file for, (1) LEVEL.RUL, (1) LEVEL.TXT, (1) LEVELMUL.RUL, (1) checking for, (1) defined, (1) period-to-date reporting, (1) referencing in MDX queries, (1) sorting on, (1) @LEVMBRS function, (1) .LIB files, (1) .LIC files, (1) getting information for, (1) licensing ports, (1) size and quantity, (1) unsupported Analytic Services functions in Hybrid Analysis, (1) linear regression, with @TREND function, (1) lines, skipping in rules files, (1) LINK report command, (1) linked databases. See linked partitions LRO object type, (1) restrictions, (1) storing, (1) linked object catalogs, (1) deleting, (1) exporting, (1) importing, (1) limiting size, (1) See also linked reporting objects (LRO) viewing, (1) Linked Objects Browser, editing objects, (1) attaching to cells, (1) creating, (1) defined, (1) defining areas, (1) described, (1) disadvantages, (1) guidelines for selecting, (1) implementing security measures, (1) port usage, (1) selecting, (1) linked reporting objects (LRO) assigning access levels, (1) changing member combinations, (1) checking structural integrity, (1) creating, (1) deleting, (1) estimating disk space for, (1) exporting, (1) format restrictions, (1) importing, (1) limiting size, (1) removing from cells, (1) restructuring and, (1) retrieving, (1) storage management, (1) types supported, (1) viewing, (1) Linked Reporting Objects (LROs) aggregate storage databases compared to block storage databases, (1) linked reporting objects, (1) missing, (1) partitioned databases, (1) related databases, (1) supported types, (1) @LIST function, (1) list of members, generating, (1) LISTALIASES command, (1) LISTFILES command, (1) LISTFILTERS command, (1) LISTLINKEDOBJECTS command, (1) LISTLOCATIONS command, (1) generating member, (1) (2) (3) multiple, with @LIST, (1) LISTUSERS command, (1) (2) (3) LISTUSERS commands, (1) LMARGIN report command, (1) @LN function, (1) LOADALIAS command, (1) locating files, (1) LOADDB command, (1) applications, (1) automatically, (1) with related database, (1) aggregate storage process, (1) dynamic calculations and, (1) for testing purposes, (1) from external sources, (1) (2) (3) (4) from partitioned applications, (1) (2) (3) from rules files, (1) incrementally, (1) methods, (1) supported formats, (1) troubleshooting problems with, (1) unauthorized users and, (1) with rules files, (1) in Data Prep Editor, (1) prerequisites, (1) troubleshooting problems, (1) (2) automatically, (1) when starting, (1) error logs, (1) failed records only, (1) output files, (1) specific fields only, (1) specific records, (1) SQL data sources, (1) troubleshooting problems with, (1) text files, (1) update log files, (1) local access, (1) local currency, (1) adding to files, (1) layout, (1) overview, (1) locale indicators,where required, (1) locales, (1) defined, (1) encoding, (1) list of supported, (1) locale header records, (1) partitioned applications and, (1) end-of-file markers, (1) advantages, (1) creating, (1) editing or deleting, (1) to aggregate storage databases, (1) lock files, (1) kernel component, (1) overview, (1) default behavior for, (1) objects, (1) outlines, (1) locking caches into memory, (1) applying, (1) blocks, during calculation, (1) generating reports and, (1) loading data, (1) managing, (1) on objects, (1) on outlines, (1) time-out settings, (1) types described, (1) uncommitted access and, (1) wait intervals, (1) @LOG function, (1) Log Analyzer, (1) @LOG10 function, (1) calculating, (1) calculating exponents, (1) LOGIN command, (1) login scripts (ESSCMD), (1) entering user name and password, (1) limiting attempts, (1) partitioned applications, (1) process overview, (1) LOGMESSAGELEVEL setting, (1) logouts from Server Agent, (1) LOGOUTUSER command (Agent), (1) Analytic Server, (1) analyzing with Log Analyzer, (1) application, (1) calculation scripts and, (1) clearing contents, (1) creating multiple exception logs, (1) deleting, (1) dimension builds, (1) dynamically calculated members, (1) overview, (1) restructuring and, (1) spreadsheet changes, (1) displayed in exception logs, (1) Unicode affects, (1) viewing, (1) viewing retrieval factor, (1) long file names, (1) loops, (1) losing connections in partiitons, (1) LRO catalog, (1) kernel component, (1) overview, (1) LRO. See linked reporting objects (LRO) @LSIBLINGS function, (1) .LST files, (1) MM, time balance codes in data source, (1) macros, custom-defined, (1) copying, (1) creating, (1) deleting, (1) naming, (1) refreshing catalog, (1) removing, (1) scope, (1) updating, (1) using in calculations, (1) viewing, (1) main database in currency application contents described, (1) defined, (1) preparing for conversion, (1) sample main database, (1) maintaining applications, (1) managing applications and databases, (1) porting applications across platforms, (1) running Analytic Server, (1) managing, (1) area-specific partitions, (1) attributes, (1) cells, (1) columns with no members, (1) data source/data target members, (1) databases with location aliases, (1) fields to dimensions, (1) files (.TXT), (1) importing, (1) members in partitions, (1) members to member fields, (1) (2) (3) (4) members with different names, (1) partitioned members, (1) replicated partitions, (1) specific fields only, (1) transparent partitions, (1) margins, setting in reports, (1) market share (calculation example), (1) marking blocks as clean and dirty, (1) (2) markup, (1) entering in report scripts, (1) (2) overriding, (1) usage, (1) @MATCH function, (1) matching case, (1) calculations, (1) currency conversions, (1) formulas and, (1) missing values and, (1) performing on fields, (1) performing on members, (1) prerequisite for, (1) specifying in data source, (1) (2) matrix-style access, (1) @MAX function, (1) Attribute Calculations dimension, (1) changing name, (1) maximum number of threads spawned by Agent, (1) aggregate storage data load example, (1) alter database command, (1) alter system command, (1) changing custom-defined macro, (1) compacting the security file, (1) copying custom-defined macro, (1) (2) create partition, (1) creating custom-defined macro, (1) deleting logs, (1) displaying security file defragmentation percent, (1) drop function records, (1) (2) refresh outline command, (1) registering custom-defined functions, (1) removing custom-defined macro, (1) running calculations, (1) specifying isolation level settings, (1) starting a database, (1) starting a database automatically, (1) starting and stopping applications, (1) starting/stopping databases, (1) (2) updating replicated partitions, (1) MaxL vs. ESSCMD, (1) MAXLOGIN, limit number of user sessions, (1) @MAXRANGE function, (1) @MAXS function, (1) @MAXSRANGE function, (1) @MDALLOCATE function, (1) @MDANCESTVAL function, (1) .MDB files, (1) @MDPARENTVAL function, (1) @MDSHIFT function, (1) .MDX files, (1) about, (1) basic equations, (1) calculating, (1) checking syntax of, (1) composing, (1) conditional, (1) creating with Formula editor, (1) cross dimensional, (1) developing for aggregate storage databases, (1) displaying, (1) syntax for, (1) UDAs and, (1) Filter, example of, (1) IIF, example of, (1) IsUDA, example of, (1) MDX queries on aggregate storage databases, (1) Measures dimension (example), calculating period-to-date values, (1) media failure, (1) @MEDIAN function, (1) median, calculating, (1) @MEMBER function, (1) property tags, (1) member comments, maximum length, (1) member consolidation properties described, (1) defined in data source, (1) duplicate members and, (1) in data source, (1) mapping requirements, (1) (2) (3) (4) valid, (1) calculating subset of, (1) maximum length, (1) rules for naming, (1) setting, (1) commands, (1) sorting members and, (1) in spreadsheets, (1) applying to subsets of members, (1) described, (1) generating lists, (1) in filter definitions, (1) within FIX command, (1) member storage types, for aggregate storage databases, (1) as children of specified parent, (1) guidelines for, (1) through header information in the data source, (1) to dimensions, (1) (2) (3) (4) to member fields, (1) (2) (3) (4) to outlines, (1) adding comments about, (1) adding to outlines, (1) adding to report scripts, (1) in precise combinations, (1) with common attributes, (1) applying skip properties, (1) values to combinations, (1) associating formulas with, (1) associating with report scripts, (1) attribute dimensions, (1) naming, (1) prefixes and suffixes, (1) preventing creation, (1) resulting from formulas, (1) avoiding naming conflicts, (1) calculated members (MDX), (1) across multiple parents, (1) relationships between, (1) caution for sorting with shared, (1) changing combinations for linked objects, (1) changing properties, (1) clearing, (1) containing no data, (1) creating dynamic for time series, (1) (2) data distribution among, (1) (2) default operator, (1) defined, (1) calculation order for, (1) defining calculation order for, (1) dependent on others, (1) in outlines, (1) in reports, (1) duplicate, (1) dynamically building, (1) (2) (3) (4) (5) (6) dynamically calculating, (1) (2) restrictions, (1) excluding from consolidation, (1) (2) getting values for specific combinations, (1) in data hierarchies, (1) inserting in calculation scripts, (1) irrelevant across dimensions, (1) leaving unsorted, (1) mapping names to dimensions, (1) missing in data sources, (1) moving in outlines, (1) moving to new parents, (1) names as range of values, (1) (2) (3) (4) nesting in reports, (1) numbering in data sources, (1) of attribute dimensions, sorting, (1) ordering in dense dimensions, (1) (2) partitioning, (1) positioning in outlines, (1) relationships described, (1) (2) removing from data sources, (1) searching in the Calculation Script Editor, (1) selecting for dynamic calculations, guidelines for, (1) (2) sharing identical values, (1) sorting in reports, (1) storing, (1) testing for, (1) unique combinations for, (1) (2) with no data values, (1) with non-changing names, (1) member-specific formatting commands, (1) availability on different systems, (1) dynamically calculated values and, (1) (2) estimating requirements, (1) index cache size and, (1) locking caches into memory, (1) reducing usage for aggregate storage databases, (1) retrieval buffers, (1) aggregate storage, (1) first-time calculations, (1) setting cache sizes, (1) shortage, (1) storing data, (1) swapping, (1) UNIX platforms, availability of, (1) (2) usage with committed access isolation level, (1) usage with uncommitted access isolation level, (1) Windows platforms, availability of, (1) @MERGE function, (1) merging member lists, (1) displaying for calculations, (1) (2) example for displaying, (1) MetaData privilege, (1) limitations, (1) permission, (1) applications, (1) databases, (1) passwords, (1) users and groups, (1) migration, (1) @MIN function, (1) Attribute Calculations dimension, (1) changing name, (1) minimizing resources, (1) Minimum Database Access options (application properties), (1) @MINRANGE function, (1) @MINS function, (1) @MINSRANGE function, (1) as codes in data source, (1) (2) in data fields, (1) in dimension and member names, (1) in member names, (1) in names in scripts and formulas, (1) in report scripts, (1) miscellaneous text, (1) mismatches, (1) MISSING displayed in cells, (1) (2) missing links, (1) missing members, (1) adding place holder for, (1) averages and, (1) caution for data loads and, (1) caution for dimension fields, (1) consolidating, (1) effects on calculation order, (1) (2) (3) (4) formatting in reports, (1) identifying in data fields, (1) in calculations, (1) inserting into empty fields, (1) optimal entry for, (1) overriding default for, (1) replacing with labels, (1) sorting data with, (1) testing for, (1) viewing with Personal Essbase, (1) MISSINGTEXT report command, (1) mission-critical databases, (1) @MOD function, (1) @MODE function, (1) mode, calculating, (1) modifying, (1) access privileges, (1) (2) (3) alias table names, (1) aliases, (1) calculation scripts, (1) consolidations, (1) data values, (1) scope and precedence, (1) default storage properties, (1) dense and sparse storage, (1) headings in reports, (1) member combinations for linked objects, (1) outlines, (1) caution for, (1) dynamically, (1) with rules files, (1) report layouts, (1) security settings, (1) system password, (1) modulus, calculating, (1) calculations, (1) data, (1) data changes, (1) databases, (1) parallel calculations, (1) user sessions and requests, (1) @MOVAVG function, (1) fields, (1) members and dimensions, (1) members to new parents, (1) moving average, calculating, (1) moving between databases, (1) (2) moving maximum, calculating, (1) moving median, calculating, (1) moving minimum, calculating, (1) moving sum, calculating, (1) @MOVMAX function, (1) @MOVMED function, (1) @MOVMIN function, (1) @MOVSUM function, (1) @MOVSUMX function, (1) MS Access databases. See SQL databases M-T-D time series member, (1) (2) multidimensional arrays, (1) (2) conceptual overview, (1) storage requirements, (1) multi-line column headings, (1) multiple export files for databases, (1) multiple partitions, (1) multiple transactions, (1) multiple-pass calculations, (1) usage overview, (1) operators, (1) setting data consolidation properties, (1) multithreading, (1) setting number of threads, (1) running ESSCMD in, (1) .MXL files, (1) NN, never allow data sharing code in data source, (1) Naive Bayes algorithms, (1) @NAME function, (1) Named Pipes connections, (1) named sets in MDX queries, (1) See also column headings; field names; aliases name length limits, (1) user names, (1) NAMESCOL report command, (1) NAMESON report command, (1) loading into memory, (1) NAMEWIDTH report command, (1) arrays and variables, (1) batch files, (1) ESSCMD script files, (1) fields, (1) members of attribute dimensions, (1) shared members, (1) alias tables, (1) applications, (1) case sensitivity, (1) databases, (1) dimensions, (1) generations and levels, (1) UNIX files, (1) calculating, (1) calculating exponents, (1) navigating between databases, (1) (2) negative numbers, formatting in reports, (1) (2) flipping, (1) in data fields, (1) variance as, (1) column headings, (1) dimensions, (1) formatting commands, (1) members in reports, (1) quotation marks in ESSCMD commands, (1) net present values, (1) network administrators. See administrators network aliases, with partitions, (1) reducing traffic during data load, (1) securing, (1) transferring data via, (1) (2) neural network algorithms, (1) description, (1) effect on members, (1) setting in data source, (1) when to use, (1) as command separator, (1) as file delimiter, (1) new users, (1) NEWPAGE report command, (1) @NEXT function, (1) @NEXTS function, (1) no access permission, (1) No Conversion tag, (1) #NOACCESS value, (1) NOINDENTGEN report command, (1) non-attribute dimensions. See standard dimensions non-constant values, in calculations, (1) None access level, (1) (2) (3) none time balance property, (1) non-typical data sets, (1) non-Unicode, server mode, (1) non-Unicode-mode applications, defined, (1) NOROWREPEAT report command, (1) NOSKIPONDIMENSION report command, (1) NOT operator in report scripts, (1) adding to databases, (1) adding to partitions, (1) annotating to data cells, (1) storing, (1) NOToperator in report scripts, (1) no-wait I/O, (1) .NP files, (1) @NPV function, (1) null values, (1) null processing, (1) columns in reports, (1) members in data sources, (1) report pages, (1) calculated columns, (1) calculation scripts and, (1) formulas and, (1) in array and variable names, (1) in names, (1) truncating, (1) attribute dimensions, sorting members in outline, (1) defined, (1) defining member names in ranges, (1) duplicate values, (1) in data source, (1) with commas, (1) fields in data source, (1) entering in ESSCMD scripts, (1) ranges, setting up, (1) numeric precision representation, in calculations, (1) using in formulas, (1) numerical ordering (generations), (1) NUMERICPRECISION setting, (1) OO, label only code in data source, (1) (2) objects, (1) See also linked reporting objects (LRO) copying, (1) deleting, (1) linking to cells, (1) locking, (1) overview, (1) renaming, (1) unlocking, (1) clearing, (1) file type, (1) .OCN files, (1) .OCO files, (1) ODBC drivers, (1) ODBC files, (1) OFFCOLCALCS report command, (1) OFFROWCALCS report command, (1) OFSAMEGEN report command, (1) OLAP (Online Analytic Processing) fundamentals, (1) OLAP (Online Analytical Processing), (1) getting started tips, (1) history, (1) OLTP vs OLAP, (1) keywords in MDX queries, (1) keywords in MDX queries, (1) keywords in MDX queries, (1) keywords in MDX queries, (1) keywords in MDX queries, (1) ONCOLCALCS report command, (1) Online Analytical Processing. See OLAP Online Transaction Processing. See OLTP ONLY parameter for SET MSG, (1) ONROWCALCS report command, (1) ONSAMELEVELAS report command, (1) open tasks, (1) Calculation Script Editor, (1) Data Prep Editor, (1) data sources, (1) outlines, (1) rules files, (1) SQL data sources, (1) text files, (1) information, (1) multithreaded, (1) recovery, (1) operations, (1) automating routine, (1) archiving, (1) calculations, (1) ESSCMD, (1) canceling ESSCMD, (1) displaying field, (1) displaying replace, (1) failed, (1) missing values and mathematical, (1) restructure types defined, (1) undoing, (1) See also the specific operator calculation scripts and, (1) consolidation listed, (1) creating Boolean expressions with, (1) cross-dimensional, (1) (2) (3) (4) inserting in formulas, (1) overview, (1) default for members, (1) order of precedence, (1) resetting in report scripts, (1) OPGCACHESIZE setting, (1) basic tasks, (1) resetting databases for, (1) caches, (1) calculator cache, (1) with calculation scripts, (1) with dynamic calculations, (1) (2) with Intelligent Calculation, (1) with interdependent values, (1) with two-pass calculations, (1) data analysis, (1) disk space, (1) loading of sparse dimensions, (1) pageable outlines, (1) calculation, (1) calculations, (1) partitioning, (1) using crossdimensional operator, (1) using database settings, (1) readability, (1) replication, (1) sparse dimensions, (1) storage, (1) transparent partitions, (1) optional parameters, (1) Analytic Server kernel, (1) application security settings, (1) calculations, (1) database, (1) databases, (1) dynamic builds, (1) global access, (1) isolation levels, (1) level and generation numbering, (1) in report scripts, (1) in rules files, (1) Oracle databases. See SQL databases entering in report scripts, (1) order of operation, (1) precedence, (1) usage guidelines, (1) data blocks, (1) data sources in data loads, (1) dimensions in outline, (1) dimensions in outlines, (1) members in dense dimensions, (1) (2) members in outlines, (1) (2) (3) output values, (1) ordinary user permission, (1) organizational databases, (1) .OTM files, (1) .OTO files, (1) OUTALT report command, (1) example, (1) usage, (1) example, (1) usage, (1) OUTALTSELECT report command, (1) outline change logs, (1) example, (1) overview, (1) partitions and, (1) restructuring and, (1) setting size, (1) viewing, (1) attribute dimensions, (1) performance considerations, (1) (2) adding comments, (1) adding dimensions and members, (1) Attribute Calculations dimension, (1) changes and restructuring impact, (1) Attribute Calculations member names, (1) Boolean names, (1) date formats in attribute dimensions, (1) clearing alias tables, (1) alias tables, (1) alias tables, (1) aliases, (1) aliases for member combinations, (1) dynamically calculated members, (1) outlines, (1) shared members, (1) accounts dimension type, (1) attribute dimension names, (1) attribute dimension type, (1) (2) consolidation properties, (1) country dimension type, (1) (2) currency conversion properties, (1) formulas, (1) member storage properties, (1) time dimension type, (1) Two-Pass member property, (1) UDAs, (1) variance reporting, (1) moving members, (1) naming generations and levels, (1) opening, (1) positioning dimensions and members, (1) ranges, (1) alias tables, (1) saving outlines, (1) setting dense/sparse storage, (1) setting, current alias table, (1) sorting members, (1) tagging members as label only, (1) verifying outlines, (1) aggregate storage and, (1) creating, (1) cross-platform compatibility, (1) pageable, (1) saving, (1) viewing contents of, (1) described, (1) optimizing, (1) optimizing, (1) size of, (1) described, (1) problems with Dynamic Calc members, (1) shared members, (1) Unicode-mode applications, (1) Outline Viewer, opening, (1) OUTLINECHANGELOG parameter, (1) OUTLINECHANGELOG setting, (1) OUTLINECHANGELOGFILESIZE setting, (1) outline-only restructure, (1) aggregate storage databases, (1) accessing, (1) adding dimensions, (1) performance considerations, (1) (2) restructuring and, (1) adding members, (1) aggregate storage calculations, (1) aggregate storage, maximum size of using dimension build, (1) using loaded outline, (1) associating,calculation scripts with, (1) attribute prefixes and suffixes, (1) bottom-up ordering, (1) calculating, (1) changes impacting restructuring, (1) changing, (1) caution for, (1) dynamically, (1) with rules files, (1) controlling location of, (1) copying in file system, (1) for currency conversions, (1) (2) guidelines for, (1) creating aggregate storage outlines, (1) (2) currency conversions and, (1) drafting for single-server databases, (1) editing, (1) formatting, (1) hierarchical arrangement, (1) improving readability, (1) member relationships described, (1) (2) memory concerns, (1) dimensions and members, (1) generations and levels, (1) opening existing, (1) optimum order of dimensions, (1) ordering dimensions, (1) pageable, (1) purpose, (1) rearranging members and dimensions, (1) removing, (1) removing items, (1) renaming, (1) repeating elements, (1) outline save, (1) prerequisites for, (1) rules, (1) caution for placing, (1) sparse/dense recommendations, (1) (2) process summarized, (1) tracking changes, (1) warning for not applying changes, (1) with report scripts, (1) top-down ordering, (1) tracking changes, (1) updating, (1) validating aggregate storage outlines, (1) (2) (3) verifying, (1) changes to, (1) dynamically calculated members, (1) with unbalanced hierarchies, (1) OUTMBRALT report command, (1) OUTMBRNAMES report command, (1) formatting, (1) options, (1) ordering, (1) security information, (1) selecting specific values for, (1) sorting, (1) output files, (1) loading, (1) saving, (1) OUTPUT report command, (1) overhead, (1) bitmap compression, (1) checking compression ratio, (1) work areas, (1) overlapping partitions, (1) column groupings in reports, (1) data filters, (1) default calculation order, (1) default calculations, (1) filters in partitions, (1) incremental restructuring, (1) security and permissions, (1) overwriting error logs, (1) overwriting existing values, (1) for currency conversions, (1) with values in data source, (1) (2) ownership, (1) Pin report scripts, (1) adding to complex reports, (1) adding to free-form reports, (1) customizing, (1) defined, (1) display options, (1) forcing immediate display, (1) suppressing, (1) using attributes in, (1) adding titles, (1) changing, (1) problems with, (1) inserting page breaks, (1) (2) numbering pages, (1) entering in report scripts, (1) in page layout, (1) pageable outline files, (1) PAGEHEADING report command, (1) overriding, (1) usage, (1) PAGEONDIMENSION report command, (1) database outlines, (1) and calculator cache, (1) and other Analytic Services features, (1) checking current settings, (1) checking status, (1) commit threshold adjustments, (1) definition, (1) effect on bitmap cache, (1) enabling, (1) enabling in calculation scripts, (1) feasibility analysis, (1) formula limitations, (1) identifying additional tasks, (1) identifying tasks, (1) increased speed, (1) introduction, (1) isolation level, (1) monitoring, (1) monitoring performance, (1) overview, (1) partition limitations, (1) procedure for enabling, (1) requirements, (1) requirements for use, (1) restructuring limitations, (1) retrieval performance, (1) serial vs. parallel, (1) setting levels, (1) parallel calculation setting, (1) transparent partition limitations, (1) uncommitted access and, (1) uncommitted mode, (1) aggregate storage cache, (1) data load, (1) enclosure in quotation marks (ESSCMD), (1) entering in ESSCMD scripts, (1) referencing files, (1) PARCHIL.RUL file, (1) PARCHIL.TXT file, (1) @PARENT function, (1) in header records, (1) in rules files, (1) PARENT report command, (1) parent,defined, (1) parent/child relationships and dynamic calculations, (1) (2) (3) parent-child references build method creating multiple roll-ups, (1) creating shared members, (1) (2) (3) creating shared roll-ups from multiple data sources, (1) described, (1) example rules file, (1) parent-child relationships, (1) data sources, (1) defining, (1) in calculation scripts, (1) in dimension and member names, (1) in formulas, (1) in names in scripts and formulas, (1) (2) in report scripts, (1) indicating negative numeric values in fields, (1) as shared members, (1) assigning children to, (1) (2) (3) associating members with, (1) calculation order for outlines, (1) calculations with multiple, (1) checking for, (1) in time dimensions, (1) loading data into, (1) setting values as average, (1) sharing members, (1) specifying for existing members, (1) with only one child, (1) value out of range, (1) changing shared, (1) defined, (1) defining, (1) Dynamic Time Series members in, (1) mapping to specific, (1) partition definition files, (1) defining partitioned areas, (1) Partition Wizard,defining partitioned areas, (1) accessing data, (1) adding members, (1) calculating, (1) transparent, (1) creating, (1) creating, process summarized, (1) described, (1) designing,scenarios for, (1) disadvantages of, (1) language requirements, (1) maintaining, (1) performing calculations on, (1) replicated partitions and, (1) transparent partitions and, (1) (2) retrieving data, (1) running calculation scripts, (1) single-server vs., (1) troubleshooting access to, (1) guidelines, (1) remote data and, (1) viewing current state, (1) when to use, (1) adding partitions for currency conversions, (1) calculating, (1) transparent, (1) creating, (1) creating accounts for, (1) (2) (3) described, (1) dynamically calculating values, (1) filtering, (1) implementing security measures, (1) linking data values, (1) maintaining, (1) sample applications showing, (1) sharing data, (1) sparse member combinations and, (1) with replicated partitions, (1) with transparent partitions, (1) synchronizing data across partitions, (1) synchronizing outlines, (1) (2) testing, (1) time series reporting, (1) troubleshooting connections, (1) workflow, (1) creating a write-back partition for aggregate storage databases, (1) mapping attributes, (1) on aggregate storage databases, (1) See also partitioned applications; partitioned databases, areas advantages, (1) and Unicode-mode applications, (1) annotating, (1) calculating, (1) transparent, (1) circular dependency, (1) controlling updates to, (1) creating, (1) for currency conversions, (1) process summarized, (1) defined, (1) linked, (1) multiple, (1) deleting, (1) dynamic calculations and, (1) (2) getting type, (1) limitiations with parallel calculation, (1) mapping members, (1) overlapping, (1) parts described, (1) performance,improving, (1) primary/secondary sites defined, (1) restructuring performance and, (1) saving definitions, (1) selecting type, (1) (2) (3) (4) (5) troubleshooting, (1) usage examples, (1) using attributes in, (1) PASSWORD command (Agent), (1) changing and propagating, (1) changing system, (1) connections, (1) encoding, (1) entering in logins, (1) in partitions, (1) propagating to other Analytic Servers, (1) setting, (1) partitioned databases, (1) pattern matching, (1) payroll, formula example, (1) as codes in data source, (1) (2) in names in scripts and formulas, (1) allocating, (1) displaying in reports, (1) returning variance, (1) (2) (3) setting consolidation properties, (1) specifying in data source, (1) (2) #MI values and, (1) cache statistics, (1) calculation, (1) checking, (1) CLEARDATA and, (1) improvement techniques, (1) increase with periodic tasks, (1) linked partitions and, (1) (2) monitoring parallel calculation, (1) multi-user considerations, (1) calculation, (1) calculations, (1) disk space, (1) partitioning, (1) restructures, (1) using crossdimensional operator, (1) using database settings, (1) recommended settings, (1) replicated partitions and, (1) permanence, (1) transparent partitions and, (1) using Windows 4GT, (1) performance-related storage settings, (1) (2) in application and database names, (1) (2) in names in scripts and formulas, (1) period-to-date calculations, (1) period-to-date values, (1) retrieving, (1) assigning/reassigning user, (1) setting database, (1) permissions, (1) Application Designer, (1) Application or Database Designer, (1) application-level settings, (1) assigning/reassigning user, (1) Calculate (or execute), (1) Create/Delete Applications, (1) Create/Delete Users/Groups, (1) Database Designer, (1) designer, (1) filters and, (1) linked reporting objects, (1) MetaRead, (1) ordinary user (no access), (1) Read, (1) routine operations and, (1) scope of, (1) Supervisor, (1) transactions and, (1) user types, (1) user/group, (1) Write, (1) Personal Essbase, (1) creating applications and databases, (1) installing, (1) loading data, (1) loading output files, (1) viewing data, (1) PIDs, finding for Analytic Services applications, (1) pivoting, (1) .PL files, (1) porting applications across, (1) (2) creating backups for, (1) redefining information for, (1) porting applications to UNIX servers, (1) as codes in data source, (1) (2) in application and database names, (1) (2) in member names, (1) in names in scripts and formulas, (1) (2) .PM files, (1) member combinations, (1) creating backups for, (1) redefining server information, (1) to UNIX platforms, (1) and linked partitions, (1) and replicated partitions, (1) and transparent partitions, (1) changing default values used by Agent, (1) displaying installed, (1) Essbase Administration Services and, (1) freeing, (1) licensed and multithreading, (1) protocol-specific assignments, (1) remote start and, (1) Remote Start Server, (1) reserved, (1) running out of, (1) viewing statistics, (1) PORTS command (Agent), (1) (2) positive values, (1) variance as, (1) pound sign (#) in array and variable names, (1) @POWER function, (1) power down (caution), (1) power failures. See failures; recovery power loss, (1) precedence, in calculations, (1) precision, (1) predefined Dynamic Time Series members, (1) enabling/disabling, (1) generation names for, (1) in shared areas, (1) listed, (1) specifying aliases for, (1) predictor accessors, data mining, (1) (2) adding to fields, (1) assignment sequence in data build, (1) attribute member names, (1) (2) (3) member and alias names, (1) Pre-image Access option, (1) PRELOADALIASNAMESPACE setting, (1) PRELOADMEMBERNAMESPACE setting, (1) prerequisites for using this guide, (1) preventing calculation delays, (1) preventing system failures, (1) (2) calculation scripts, (1) reports, (1) rules files, (1) PRINTPARTITIONDEFFILE command, (1) PRINTROW report command, (1) @PRIORS function, (1) privileges, (1) applying to groups, (1) global, (1) to users and groups, (1) inheritance from group, (1) insufficient, (1) layers defined, (1) linked reporting objects, (1) planning for user access, (1) replicating, (1) transactions and, (1) types listed, (1) procedural commands, (1) process IDs, finding for Analytic Services applications, (1) processes, (1) killing, (1) monitoring, (1) processors,calculations across multiple, (1) product and market shares, (1) Product dimension example, (1) (2) product version, (1) production servers, migrating to, (1) production versions of Analytic Server, (1) profit and loss, (1) calculation script example, (1) example for tracking, (1) profit margins,dynamically calculating, (1) programming interface. See API (Application Programming Interface) programming-specific files, (1) propagating outline changes. See synchronizing propagating passwords, (1) currency conversion, (1) caution for two-pass tags, (1) as label only, (1) design checklist for, (1) dimension building, field types, (1) dimension, setting, (1) dynamic calculations, (1) in outlines, (1) member, set in rules file, (1) member, setting, (1) querying in MDX, (1) setting application, (1) setting dynamically, (1) time balance, (1) two-pass calculations, (1) properties windows,refreshing pages in, (1) in header records, (1) in rules files, (1) specifying in data source, (1) protecting data, (1) P-T-D time series member, (1) (2) PURGELINKEDOBJECTS command, (1) PURGEOTLCHANGEFILE command, (1) PUTALLREPLCELLS command, (1) PUTUPDATEDREPLCELLS command, (1) PYRAMIDHEADERS report command, (1) (2) QQ-T-D time series member, (1) (2) Dynamic Time Series, (1) example, (1) optimizing performance, (1) saving, (1) query application (MaxL), (1) query governors, (1) query limits, (1) in application and database names, (1) used as wildcard, (1) See also closing; exiting; stopping and ESSCMD commands, (1) enclosing member names, (1) (2) in application and database names, (1) in calculation scripts, (1) in dimension and member names, (1) in formulas, (1) in report scripts, (1) in scripts and formulas, (1) (2) in application and database names, (1) (2) in dimension and member names, (1) QUOTEMBRNAMES command, (1) Rragged hierarchies,on aggregate storage databases, (1) @RANGE function, (1) range functions, (1) (2) (3) (4) formulas and, (1) calculating, (1) copying, (1) data exceeding, (1) duplicate members in, (1) member names as, (1) (2) (3) (4) optimizing data loads with, (1) reading multiple, (1) report member selection, (1) (2) setting automatically, (1) building multilevel (example), (1) different sizes, (1) numeric,caution regarding inserting new values, (1) setting up, (1) @RANK function, (1) ranking values, (1) ratio, viewing average clustering, (1) @RDESCENDANTS function, (1) Read locks, (1) described, (1) with committed access, (1) with uncommitted access, (1) Read Only privilege, (1) Read permission, (1) Read/Write privilege, (1) read-only mode, backups and, (1) reads, optimizing, (1) read-write mode, backups and, (1) reboot (caution), (1) rebuilding databases, (1) after exporting, (1) Dynamic Calc and Store members, (1) examples, (1) for Personal Essbase servers, (1) Intelligent Calculation and, (1) (2) two-pass calculations and, (1) adding to data sources, (1) (2) (3) as headers in rules files, (1) (2) bottom-up ordering and, (1) defined, (1) defining operations for rules files, (1) defining roll-ups for, (1) (2) (3) in data source, (1) loading specific range, (1) maximum logged, setting, (1) missing from error logs, (1) (2) rejecting for loads, (1) reloading failed, (1) selecting, (1) setting parent-child relationships, (1) sorting to optimize data loading, (1) top-down ordering and, (1) viewing, (1) with extra fields, (1) recovery, (1) caution for loading data and, (1) failed operations, (1) improper shutdowns, (1) managing, (1) procedures, (1) redundant data and, (1) restructuring databases, (1) redefining server information, (1) database size, (1) network traffic, (1) dynamically calculated members, (1) filters and updating, (1) forward calculation, (1) generation, (1) null processing, (1) shared members, (1) level, (1) null processing, (1) parent-child, (1) example rules file, (1) specific values, (1) referencing files with ESSCMD, (1) refresh outline command, (1) refresh replicated partition (MaxL), (1) data in replicated partitions, (1) properties windows, (1) Region dimension example, (1) (2) registration,of custom-defined functions, (1) about, (1) defining on multiple fields, (1) example, (1) locating end-of-file markers with, (1) specifying in rules file, (1) (2) relational databases. See databases relationship among members, (1) (2) (3) (4) relationship functions, (1) in MDX queries, (1) Intelligent Calculation and, (1) @RELATIVE function, (1) database files, (1) @REMAINDER function, (1) remainders, (1) accessing, (1) manipulating data, (1) remote partitions. See transparent partitions about, (1) configuring, (1) starting/stopping, (1) Windows service, (1) remote start, Analytic Server, (1) @REMOVE function, (1) entering in report scripts, (1) usage, (1) alias tables, (1) applications, (1) calculation scripts, (1) data blocks, (1) databases, (1) dimensions,and restructuring, (1) items from outlines, (1) linked objects, (1) locks, (1) logs, (1) members from data sources, (1) members from member lists, (1) objects, (1) partitions, (1) spaces in fields, (1) substitution variables, (1) temporary files, (1) RENAMEAPP command, (1) RENAMEDB command, (1) RENAMEFILTER command, (1) applications, (1) databases, (1) error logs, (1) files with FTP, (1) filters, (1) groups, (1) objects, (1) users, (1) renaming, alias tables, (1) renumbering data blocks, (1) replace operations, (1) empty fields with values, (1) files from backups, (1) missing values with text, (1) text strings, (1) defined, (1) defining areas, (1) dynamically calculated values in, (1) example of, (1) guidelines for selecting, (1) implementing security measures, (1) improving performance, (1) port usage, (1) troubleshooting, (1) type, selecting, (1) disadvantage, (1) guidelines, (1) usage restrictions, (1) data, (1) partial data sets, (1) associating members with dimensions, (1) described, (1) errors, (1) extracting data, (1) extraction order, (1) generating free-form reports, (1) ignored characters, (1) internal numerical comparisons, (1) report formatting commands, (1) (2) defined, (1) listed, (1) nesting, (1) output, (1) types described, (1) report generation functions, (1) report output commands, (1) color-coding in, (1) creating scripts, (1) described, (1) syntax auto-completion, (1) report script files,adding scripts, (1) adding comments, (1) adding members, (1) adding variables, (1) (2) (3) (4) associating members with, (1) batch files and, (1) caution for aliases in, (1) caution for non-changing names in, (1) color-coding in, (1) control characters in, (1) in file system, (1) parts described, (1) currency conversions and, (1) defined, (1) defining page layouts, (1) (2) editing, (1) executing, (1) executing in background, (1) exporting data with, (1) reports, (1) formatting calculated values, (1) inserting UDAs, (1) inserting, equations in, (1) migrating with applications, (1) names with special characters, (1) (2) naming restrictions, (1) resetting operators, (1) running,examples, (1) selecting members for column groups, (1) selecting members, with common attributes, (1) selecting precise member combinations, (1) sorting members, (1) suppressing shared member selection, (1) synchronizing outlines with, (1) using attribute members, (1) wildcards in, (1) Report Viewer, (1) aggregate storage databases compared to block storage databases, (1) commands described, (1) creating text files, (1) main components, (1) assigning access levels, (1) changing member combinations, (1) checking structural integrity, (1) creating, (1) estimating disk space for, (1) format restrictions, (1) limiting size, (1) removing from cells, (1) restructuring and, (1) retrieving, (1) storage management, (1) types supported, (1) viewing, (1) creating simple reports, (1) (2) design process, (1) developing free-form reports, (1) editing report scripts, (1) implementing security, (1) saving report scripts, (1) See also time series reporting ad hoc currency, (1) adding blank spaces, (1) adding calculated columns, (1) (2) adding titles, (1) adjusting column length, (1) basic techniques, (1) process, (1) symmetric and asymmetric grouping, (1) (2) with API function calls, (1) calculating currency conversions, (1) headings in columns, (1) layouts, (1) clearing values in calculated columns, (1) (2) creating two-dimensional, (1) (2) customizing page layouts, (1) (2) designing headings, (1) developing free-form, (1) displaying member names, (1) dynamically calculated values and, (1) eliminating data duplication, (1) improving readability, (1) numbering columns, (1) ordering output values, (1) output destinations, (1) problems with formatting, (1) repeating column/row headings, (1) (2) replacing missing values, (1) restricting data retrieval, (1) (2) process, (1) setting maximum rows allowed, (1) saving, (1) suppressing formatting in, (1) (2) terminating, (1) updating, (1) variance reporting examples, (1) repositories, (1) Dynamic Calculations and, (1) managing, (1) partitioned applications, (1) resulting events, (1) parallel calculation use, (1) reserved names, (1) RESETDB, (1) RESETOTLCHANGETIME command, (1) RESETSTATUS command, (1) resetting databases, (1) minimizing, (1) partitioning databases and, (1) (2) restarting system, (1) databases from backups, (1) security settings, (1) NUMERICPRECISION parameter, (1) order of operation, (1) improving performance, (1) Restructure Database dialog box, (1) explicit, (1) incremental, (1) outline changes impacting, (1) types, (1) aggregate storage databases, (1) attribute dimensions, (1) conflicts, (1) changing outlines and, (1) dynamic calculations and, (1) Intelligent Calculation and, (1) (2) overview, (1) process described, (1) databasesactions causing, (1) indexes, (1) limitations with parallel calculation, (1) linked reporting objects and, (1) prerequisites for, (1) when saved, (1) partitioned databases, (1) (2) setting size, (1) sizing, (1) sizing dyamicallly, (1) retrieval factor,displaying, (1) retrieval performance and parallel calculation, (1) retrieval sort buffer, sizing, (1) affect by dynamic calculations, (1) retrieval time,reducing, (1) aggregate storage data, (1) cross-database values, (1) data in Administration Services Console, (1) placing restrictions on, (1) (2) Report Extractor process, (1) setting maximum rows allowed, (1) data values from remote databases, (1) (2) (3) Dynamic Time Series members, (1) dynamically calculated values, (1) (2) (3) (4) linked reporting objects, (1) partition type, (1) period-to-date values, (1) values for sparse dimensions, (1) (2) reversing data values, (1) described, (1) sizing fragmentation, (1) specifying, (1) after Analytic Server shutdown, (1) after application shutdown, (1) after database shutdown, (1) effects by committed or uncommitted access, (1) outlines, (1) rolling average values, (1) rolling back transactions. See recovery building multiple, (1) defining shared members in dimension build, (1) implementing, (1) maximum number in records, (1) member consolidation property and, (1) multiple data sources, (1) optimizing, (1) ordering in rules files, (1) setting for time balance properties, (1) (2) root member, defined, (1) @ROUND function, (1) rounding errors in aggregate storage, (1) round-trip problem,Unicode as solution, (1) routine operations, (1) row calculation commands, (1) adding to reports, (1) attribute calculation dimension, (1) defined, (1) free-form reports, (1) names truncated, (1) repeating, (1) suppressing, (1) ROW report command, entering in report scripts, (1) entering in report scripts, (1) usage, (1) attributes in report scripts, (1) calculating totals, (1) empty values in, (1) missing values in, (1) in data sources, (1) restrictions on retrieval, (1) setting qualifications for retrieval, (1) (2) (3) setting transactions levels, (1) @RSIBLINGS function, (1) .RUL files, (1) creating shared members, (1) defined, (1) when to use, (1) defining attributes, (1) defining dimension type, (1) (2) dimension build, (1) formatting data sources, (1) (2) (3) formatting free-form data sources, (1) (2) replicated partitions, (1) replicating data, (1) transparent partitions, (1) (2) UDAs, (1) adding members with, (1) associating aliases with attributes, (1) attribute associations, (1) building dimensions, (1) described, (1) different generation, (1) same generation, (1) (2) (3) (4) changing field names, (1) converting block to aggregate, (1) copying in file system, (1) new fields, (1) process overview, (1) process review, (1) creating new fields, (1) cross-platform compatibility, (1) for dimension builds, (1) generation references and, (1) (2) (3) initializing, (1) invalid, (1) level references and, (1) (2) (3) (4) loading, prerequisites, (1) manipulating fields in, (1) migrating with applications, (1) opening, (1) optimizing usage, (1) parent-child builds, (1) (2) (3) (4) (5) printing, (1) replacing text strings, (1) restrictions for entering field types, (1) saving, (1) specifying field types, (1) top-down ordering, (1) validating, (1) validating,troubleshooting problems with, (1) with blank fields, (1) RUNCALC command, (1) Run-Length Encoding. See RLE data compression batch files, (1) calculation scripts, (1) file extension, (1) logging calculation order, (1) on partitioned applications, (1) accessing multiple databases, (1) caution for pausing systems while, (1) in interactive mode, (1) on different OS platforms, (1) report scripts,examples, (1) SS, Stored member (non-Dynamic Calc) code in data source, (1) salary databases, (1) salary databases, formula example, (1) allocating percentages for, (1) calculating commission example, (1) estimating profits, (1) period-to-date values, (1) year-to-date and rolling averages, (1) partitioning examples, (1) replicated partitions in, (1) ESSCMD script files, (1) questions, (1) script files, (1) creating simple reports, (1) currency conversion databases, (1) sample applications,viewing, (1) batch mode processes, (1) consolidation example, (1) creating outlines for, (1) defining calculation member properties, (1) (2) actual values, (1) allocating values across one dimension, (1) data subsets, (1) forecasting future values, (1) forward references and, (1) percentage of variance, (1) product and market share, (1) sales and profit, (1) shared members in, (1) specific cells, (1) (2) (3) (4) dense dimensions in, (1) (2) (3) (4) (5) dynamically calculating data, (1) generating reports, (1) header and mapping information in, (1) (2) Intelligent Calculations on, (1) (2) (3) loading new budget values, (1) optimal dimension configurations, (1) (2) optimizing calculations in, (1) (2) (3) partitioning examples, (1) (2) (3) report calculations in, (1) report formatting examples, (1) (2) (3) selecting members for reports, (1) (2) sorting example, (1) sparse dimensions in, (1) (2) (3) (4) (5) two-pass calculations in, (1) Sample_U Basic database, (1) partitioning examples, (1) replicated partitions in, (1) @SANCESTVAL function, (1) SAVEANDOUTPUT report command, (1) restrictions, (1) usage, (1) attachments, (1) calculation scripts, (1) filters, (1) outline files, (1) output files, (1) partition definitions, (1) report scripts, (1) rules files, (1) scaling data values, (1) Scenario dimension, currency applications, (1) checklist for analyzing, (1) custom-defined macros, (1) database settings, (1) determining, (1) script files. See ESSCMD script files scripts. See calculation scripts; report scripts large indexes and, (1) members in Calculation Script Editor, (1) returning specific values, (1) (2) (3) season-to-date calculations, (1) secondary roll-ups, (1) (2) (3) See also access; filters; privileges aggregate storage, (1) application-level settings, (1) backup files, (1) changing for users and groups, (1) checking information about, (1) custom-defined functions, (1) definitions, (1) for applications and databases, (1) calculation permissions, (1) for users and groups, (1) (2) (3) (4) globally, (1) guidelines for, (1) process, (1) system server, (1) information file, (1) layers defined, (1) linked reporting objects, (1) managing data locks, (1) modifying user access settings, (1) (2) overview, (1) passwords, (1) planning for, (1) creating, (1) editing, (1) report scripts and, (1) saving information to text files, (1) setting up for partitioned databases, (1) backup of, (1) contents of, (1) cross-platform compatibility, (1) defragment, (1) defragmentation, (1) defragmentation status, displaying, (1) filter storage, (1) restoring, (1) updating, (1) security system, (1) security types, defined, (1) SECURITYFILECOMPACTIONPERCENT setting, (1) in MDX queries, (1) starting an application, (1) select criteria. See selection criteria select statements. See SQL databases aggregate views, (1) applications for loading,using ESSCMD, (1) data to partition, (1) (2) (3) databases for loading,using ESSCMD, (1) dimension storage type, (1) (2) (3) (4) dimension type,guidelines for, (1) members for dynamic calculations,guidelines for, (1) (2) from Dynamic Time Series, (1) using static member names, (1) with ATTRIBUTE command, (1) with Boolean operators, (1) with substitution variables, (1) with TODATE command, (1) with UDAs, (1) with wildcards, (1) with WITHATTR command, (1) members, for column groupings, (1) partition type, (1) (2) (3) (4) records, (1) saved aggregation scripts, (1) values for dynamic calculations, (1) (2) (3) guidelines for, (1) defining on multiple fields, (1) specifying in rules file, (1) (2) (3) in application and database names, (1) (2) in calculation scripts, (1) (2) (3) in ESSCMD syntax, (1) in names in scripts and formulas, (1) (2) commas in numbers, (1) member lists, (1) report script commands, (1) (2) serial calculations, overview, (1) Analytic Services components, (1) caution for rebooting, (1) client/server model described, (1) connecting to. See connections crashes, recovering from, (1) cross-platform compatibility, (1) locale support, (1) maximum name length, (1) non-Unicode mode, (1) partitioning databases across multiple, (1) redefining information, (1) setting to Unicode mode, (1) Unicode enabled, (1) Unicode-mode, defined, (1) accessing, (1) described, (1) displaying available commands, (1) installing multiples on one computer (UNIX), (1) installing multiples on one computer (Windows), (1) monitoring applications, (1) overview client-server communications, (1) running as background process, (1) setting number of threads, (1) server applications. See client-server applications shutting down Analytic Server, (1) starting Analytic Server, (1) starting databases, (1) stopping applications, (1) (2) (3) stopping databases, (1) server event logs. See Analytic Server logs server logs. See Analytic Server logs server requirements, multithreaded operating system, (1) SERVERPORTBEGIN setting, (1) (2) SERVERPORTEND setting, (1) (2) SERVERTHREADS setting, (1) sessions, managing, (1) and allocating costs, (1) and member combinations, (1) SET CACHE command, (1) SET CALCPARALLEL command, (1) SET CALCTASKDIMS command, (1) calculating subsets with, (1) concurrent calculations and, (1) defined, (1) Intelligent Calculation and, (1) (2) (3) (4) (5) multi-pass calculations, (1) (2) parameters listed, (1) two-pass calculations, (1) SET CREATEBLOCKEQ command, (1) SET CREATENONMISSINGBLK command, (1) SET FRMLBOTTOMUP command, (1) (2) SET LOCKBLOCK command, (1) (2) SET MSG calculation script command, (1) SET MSG DETAIL command, (1) SET MSG ONLY, (1) SET MSG ONLY command, (1) usage example, (1) SET NOTICE command, (1) (2) (3) SET UPDATECALC command, (1) (2) SET UPDATECALC OFF command, (1) SET UPTOLOCAL command, (1) SETALIAS command, (1) SETAPPSTATE command, (1) SETCENTER report command, (1) changing data compression, (1) precedence, (1) running in batch mode, (1) setting, index page size, (1) (2) SETDBSTATEITEM command, (1) changing database settings, (1) changing database storage settings, (1) consolidating missing values, (1) (2) (3) (4) increasing retrieval buffer, (1) precedence, (1) running in batch mode, (1) scope of storage settings, (1) I/O access mode, (1) retrieval buffer size, (1) (2) transaction isolation levels, (1) (2) data compression, (1) SETDEFAULTCALCFILE command, (1) SETPASSWORD command, (1) entering in report scripts, (1) usage, (1) in MDX queries, (1) named (in MDX queries), (1) See also assigning; defining; applying cache size, (1) first-time calculations, (1) overview, (1) conditions in formulas, (1) (2) configurable variables, (1) consolidation properties, (1) data cache size, (1) data file cache size, (1) default calculations, (1) delimiters, (1) dimension and member properties, (1) global options, (1) index cache size, (1) Intelligent Calculation default, (1) maximum records logged, (1) member consolidation properties, (1) messages in Analytic Server logs, (1) messages in application logs, (1) outline change log size, (1) overview, (1) partitioned databases, (1) properties dynamically, (1) report output destinations, (1) retrieval buffer size, (1) transaction isolation levels, (1) setting the number of threads for Analytic Server, (1) @SHARE function, (1) shared areas. See partition areas shared library files, (1) shared member property, (1) (2) caution for placing, (1) affect on consolidation paths, (1) building dynamically, (1) (2) (3) (4) building dynamically, (1) (2) (3) (4) caution for sorting, (1) for different generations, (1) (2) overview, (1) with Outline Editor, (1) described, (1) design approach for attributes, (1) different generations, (1) getting, (1) linked reporting objects and, (1) parent-child, most versatile build method, (1) partitioned applications and, (1) properties, (1) relationship implied, (1) reorganizing, (1) rolling up, (1) same generation, (1) generation references, (1) parent-child references, (1) (2) (3) (4) suppressing for report generation, (1) with branches, building dynamically, (1) (2) with outline synchcronization, (1) shared partition areas, (1) shared roll-ups, (1) across multiple sites, (1) (2) in partitioned databases, (1) (2) (3) never allow property, (1) (2) (3) not allowing, (1) dimension build technique, (1) multiple generations, (1) sharing members. See shared members sheets. See Spreadsheet Add-in; spreadsheets shell scripts (UNIX), (1) SHGENREF.RUL file, (1) SHGENREF.TXT file, (1) @SHIFT function, (1) @SHIFTMINUS function, (1) @SHIFTPLUS function, (1) SHLEV.RUL file, (1) SHLEV.TXT file, (1) shutdown (caution for improper), (1) SHUTDOWNSERVER command, (1) (2) shutting down Analytic Server, (1) @SIBLINGS function, (1) calculation order in outlines, (1) checking for, (1) consolidation properties and, (1) defined, (1) getting, (1) rolling up, (1) SIBLOW.RUL file, (1) SIBLOW.TXT file, (1) SIBPAR.TXT file, (1) SIBSTR.TXT file, (1) simple interest, (1) simulating calculations, (1) in application and database names, (1) (2) in dimension and member names, (1) analyzing database scope, (1) (2) creating outlines, (1) defining calculations, (1) (2) (3) identifying data sources, (1) implementing security, (1) partitioned vs., (1) array variables, (1) controlling, (1) optimum, (1) data files, setting maximum size, (1) determining cache, (1) estimating database, (1) field and optimal loads, (1) index files, setting maximum size, (1) minimizing for linked objects, (1) outline change logs, (1) planning for optimal, (1) reducing database, (1) retrieval buffer, (1) setting cache, (1) calculator cache, (1) coordinating, (1) first-time calculations, (1) setting data cache, (1) setting data file cache, (1) setting index cache, (1) setting limits for linked objects, (1) setting retrieval buffer, (1) skip properties, (1) SKIP report command, (1) SKIPONDIMENSION report command, (1) and time series data, (1) in MDX queries, (1) overview, (1) #MISSING and/or zero values in a range, (1) fields when mapping, (1) lines in rules files, (1) multiple fields in data load, (1) next #MISSING and/or zero values, (1) records in data load, (1) .SL files, (1) as codes in data source, (1) (2) in application and database names, (1) in names in scripts and formulas, (1) (2) defined, (1) for different perspectives, (1) in MDX queries, (1) @SLN function, (1) smoothing data, (1) SMP (symmetric multiprocessing), (1) .SO files, (1) software version, (1) Solaris servers. See UNIX platforms solve order in MDX queries, (1) defining, (1) members in outline, (1) output, (1) SORTALTNAMES report command, (1) SORTASC report command, (1) SORTDESC report command, (1) SORTGEN report command, (1) data with missing values, (1) dimensions and members, (1) (2) members in reports, (1) records to optimize data loading, (1) SORTLEVEL report command, (1) precedence in sorts, (1) usage, (1) SORTNONE report command, (1) source data, changing case, (1) source outline (defined), (1) as file delimiter, (1) converting to underscores, (1) (2) data, (1) in application and database names, (1) in dimension and member names, (1) in names, (1) to underscores in data load, (1) @SPARENTVAL function, (1) SPARSE command, (1) See also dense dimensions; dimensions calculating values in, (1) (2) (3) (4) defining member combinations for, (1) (2) dynamically calculating, (1) (2) (3) (4) (5) formulas and, (1) grouping member combinations, (1) implications for restructuring and, (1) (2) Intelligent Calculation and, (1) marked as clean, (1) optimizing loading, (1) partitioning, (1) recalculating values in, (1) (2) reporting on, (1) selecting, (1) selection scenarios, (1) (2) (3) storing member combinations, (1) unique member combinations, (1) (2) SPARSE report command, (1) sparse restructure, (1) specifying port values, AGENTPORT, (1) @SPLINE function, (1) spline, calculating, (1) split dimensions, (1) fields, (1) ad hoc currency reporting, (1) aggregate storage databases compared to block storage databases, (1) getting Dynamic Time Series members, (1) linked partitions and, (1) (2) linked reporting objects and, (1) (2) running calculation scripts, (1) specifying latest time period, (1) viewing database information, (1) spreadsheet files, (1) data source, (1) logging updates, (1) supported for data loading, (1) Unicode support, (1) batch mode example, (1) data source, (1) field names in, (1) supported data source, (1) troubleshooting problems with, (1) opening, (1) troubleshooting connections, (1) SSAUDIT parameter, (1) SSAUDITR parameter, (1) SSLUNKNOWN setting, (1) stages of data loading, (1) standard deviation, calculating, (1) attribute formulas on, (1) comparison with attribute dimensions, (1) defining in dimension build, (1) described, (1) START command (Agent), (1) (2) entering in report scripts, (1) usage, (1) Analytic Server, (1) from Administration Services, (1) Analytic Server kernel, (1) application server, (1) databases, (1) prerequisites, (1) process, (1) startup commands, (1) startup information, (1) startup settings, restoring, (1) ESSCMD commands, (1) in block storage formulas, (1) (2) in report scripts, (1) inserting in calculation scripts, (1) (2) calculation scripts and, (1) (2) (3) static member names, (1) statistical calculations, generating with calc scripts, (1) statistical functions, (1) statistical variance, calculating, (1) statistics, checking cache, (1) status, partitioned applications, (1) S-T-D time series member, (1) (2) @STDEV function, (1) @STDEVP function, (1) @STDEVRANGE function, (1) STOP command (Agent), (1) (2) (3) See also closing; exiting; quitting Analytic Server, (1) before backup, (1) calculations, (1) allocating block storage disk space, (1) allocating disk space, (1) example, (1) allocatoing aggregate storage disk space, (1) bitmap compression option, (1) checking disk space, (1) data blocks and, (1) (2) (3) (4) data compression, (1) data files, (1) deallocation and, (1) default properties, (1) dynamically calculated values, (1) overview, (1) with attributes, (1) fine-tuning, (1) index files, (1) inefficient data blocks, (1) (2) internal structures optimizing, (1) (2) linked reporting objects, (1) (2) (3) local, (1) multiple applications, (1) optimizing, (1) overview, (1) partitioned databases, (1) sparse member combinations and, (1) with replicated partitions, (1) with transparent partitions, (1) planning for, (1) restructuring and, (1) RLE compression method, (1) server configurations, (1) temporary variables, (1) scope, (1) stored members, defining in data source, (1) adding fields by matching, (1) adding members by matching, (1) as tokens, (1) calculation scripts as, (1) in calculation formulas, (1) preceded by &, (1) replacing for data loads, (1) strings, in calculation formulas, (1) commands to use, (1) example, (1) process, (1) with Intelligent Calculation, (1) clearing, (1) copying, (1) copying to Personal Essbase, (1) prerequisites, (1) process, (1) substitution variables, (1) adding to report scripts, (1) (2) (3) copying, (1) creating, (1) deleting, (1) formulas and, (1) free-form reports and, (1) inserting in calculation scripts, (1) (2) updating, (1) usage overview, (1) @SUBSTRING function, (1) consolidation codes in data source, (1) (2) prerequisite for, (1) setting member consolidation properties, (1) adding to fields, (1) assignment sequence in data build, (1) attribute member names, (1) (2) (3) member names, (1) @SUM function, (1) Sum member, Attribute Calculations dimension aggregate storage, (1) changing name, (1) described, (1) summaries, (1) summary information, (1) @SUMRANGE function, (1) SUPALL report command, (1) overriding, (1) usage, (1) SUPCOLHEADING report command, (1) SUPCOMMAS report command, (1) SUPCURHEADING report command, (1) affect by other commands, (1) usage, (1) supervised learning, data mining algorithms and, (1) Supervisor permission, (1) SUPEUROPEAN report command, (1) SUPFEED report command, (1) SUPFORMATS report command, (1) SUPHEADING report command, (1) SUPMASK report command, (1) SUPMISSINGROWS report command, (1) SUPNAMES report command, (1) SUPOUTPUT report command, (1) SUPPAGEHEADING report command, (1) SUPPMISSING report command, (1) suppressing report formatting, (1) (2) SUPSHARE report command, (1) SUPSHAREOFF report command, (1) SUPZEROROWS report command, (1) SUPZEROS report command, (1) Sybase SQL Server. See SQL databases @SYD function, (1) entering in report scripts, (1) usage, (1) symmetric columns, (1) symmetric multiprocessing (SMP), (1) asymmetric reports vs., (1) calculated columns in, (1) changing column headings, (1) defined, (1) formatting, (1) overriding column groupings, (1) process summarized, (1) tracking changes, (1) Unicode-mode applications, (1) warning for not applying changes, (1) with report scripts, (1) auto-completion in scripts, (1) (2) calculation commands, (1) checking in Calculation Script Editor, (1) checking in Formula Editor, (1) (2) comments, (1) finding in MDX formulas, (1) ESSCMD, (1) formulas, guidelines for, (1) report scripts, (1) member selection, (1) substitution variables, (1) user-defined attributes, (1) with wildcards, (1) finding in calculation scripts, (1) finding in formulas, (1) formulas and dynamically calculated members, (1) system administrators. See administrators system errors, (1) categories, (1) logs locations and names, (1) overview, (1) system failures. See failures; recovery system information, (1) system password, changing, (1) TT, two-pass calc code in data source, (1) as column separator, (1) as command separator, (1) as file delimiter, (1) in names, (1) usage, (1) TABDELIMIT report command, entering in report scripts, (1) tab-delimited formats, (1) tables. See alias tables; databases default, described, (1) temp, described, (1) defined, (1) defining, (1) maximize size, (1) tabs, in application and database names, (1) assigning to members, (1) usage examples, (1) target accessors, data mining, (1) (2) target outline, (1) changing data in, (1) changing outlines, (1) copying from, (1) defined, (1) for multiple partitions, (1) for partitions, (1) logging into, (1) losing connections to, (1) mapping information, (1) mapping members, (1) specifying specific areas, (1) member names differing from source, (1) missing data, partitions, (1) partitioning information for, (1) specifying shared areas, (1) updating changes to, (1) viewing data in linked partitions, (1) .TCP files, (1) TCP/IP connections, (1) temp tablespace, described, (1) deleting, (1) used during restructuring, (1) terminating OLAP Server connections, for specific user, (1) terminating processes, (1) about, (1) specifying, (1) test versions of Analytic Server, (1) calculations, (1) database design, (1) for missing values, (1) partitions, (1) adding to empty fields, (1) attribute type, (1) fields, (1) in data sources, (1) linked reporting object, (1) replacing missing values with, (1) storing, (1) strings, replacing in rules file, (1) calculation scripts and, (1) ESSCMD commands and, (1) report scripts and, (1) text files, (1) calculation scripts in, (1) converting to UTF-8, (1) creating, (1) cross-platform compatibility, (1) dumping security information to, (1) locale header record, (1) locale indicators, (1) opening, (1) trigger definition file, (1) usage, (1) using to add titles, (1) The Beverage Company (TBC), (1) third-party backup utility, (1) setting number for Analytic Server, (1) threshold (transactions), (1) as codes in data source, (1) (2) in headings, (1) in names in scripts and formulas, (1) time balance first/last properties in combination with skip property, (1) setting, (1) aggregate storage, (1) described, (1) aggregate storage databases compared to block storage databases, (1) time balance tags, (1) calculating accounts data, (1) calculating averages, (1) missing and zero values, (1) specifying in data sources, (1) currency applications, (1) defining formulas for, (1) description, (1) setting, (1) time balance members and, (1) time series members and, (1) (2) two-pass calculations and, (1) usage example, (1) (2) (3) (4) time-out errors, (1) data locks, (1) transactions, (1) budgeting expenses for, (1) determining first value for, (1) (2) determining last value for, (1) (2) time dimension, (1) time-sensitive data, (1) calculating averages, (1) calculating period-to-date values, (1) creating dynamic members for, (1) (2) getting first/last values, (1) (2) (3) overview, (1) partitioned databases, (1) retrieving period-to-date values, (1) selecting time series members, (1) skipping missing or zero values, (1) Time Series tags, Intelligent Calculation and, (1) time series, aggregate storage, (1) time zones, (1) time, estimated for calculation, (1) timestamps, comparing, (1) TIMINGMESSAGES setting, (1) TODATE report command, (1) (2) tokens, (1) caution for usage, (1) entering in report scripts, (1) (2) order of operation, (1) precedence, (1) restrictions, (1) upper limits, (1) usage, (1) calculations, (1) top-down partitioning, defined, (1) tracing calculations, (1) tracking, data changes, (1) traffic lighting, (1) trailing spaces, (1) training data mining algorithms, (1) transaction control files, (1) transaction control table (.tct), (1) (2) kernel component, (1) overview, (1) actions triggering, (1) canceling calculations and, (1) caution for committed access, (1) caution for data loads, (1) (2) defined, (1) forcing at load completion, (1) managing, (1) multiple, (1) predictability, (1) processing, (1) required permissions, (1) required privileges, (1) rolling back, (1) rolling back after shutdown, (1) (2) (3) server crashes and active, (1) setting isolation levels, (1) tracking, (1) updating isolation levels, (1) wait intervals, (1) transparent members, (1) advantages, (1) calculating, (1) clearing values in, (1) currency conversions and, (1) (2) data loading and, (1) defined, (1) defining areas, (1) described, (1) disadvantages, (1) dynamically calculated values in, (1) example of, (1) implementing security measures, (1) improving performance, (1) (2) (3) limitations with parallel calculation, (1) port usage, (1) type, selecting, (1) usage restrictions, (1) using attributes in, (1) moving members in, (1) @TREND function, (1) trends, calculating, (1) creating, (1) design and security, (1) examples, (1) managing, (1) maximum name length, (1) performance and memory usage, (1) calculation scripts, (1) currency conversion, (1) data loading, (1) formulas, (1) partitions, (1) using logs for, (1) True Boolean attribute, changing name, (1) @TRUNCATE function, (1) truncated names, (1) truncating values, (1) in MDX queries, (1) member types supported, (1) usage example, (1) aggregate storage, (1) and attributes, (1) enabling, (1) calc scripts and, (1) (2) (3) (4) calculation scripts and, (1) dynamic calculations and, (1) (2) enabling, (1) Intelligent Calculation and, (1) (2) overview, (1) requiring additional pass, (1) usage examples, (1) selecting, partition, (1) tagging dimensions, (1) UUCHARACTERS report command, (1) UCOLUMNS report command, (1) @UDA function, (1) in header records, (1) in rules files, (1) selecting members with, (1) usage example, (1) adding to report scripts, (1) allowing changes, (1) calculation script example, (1) checking for, (1) compared with attributes, (1) creating, (1) described, (1) design approach for attributes, (1) flipping values in data load, (1) MDX formula for, (1) querying in MDX, (1) rules for creating, (1) shared members and, (1) UDATA report command, (1) UNAME report command, (1) UNAMEONDIMENSION report command, (1) unauthorized users, (1) unavailable server or data sources, (1) (2) about, (1) commits and, (1) handling transactions with, (1) memory usage, (1) parallel calculation and, (1) rollbacks and, (1) parallel calculation, (1) UNDERLINECHAR report command, usage, (1) underlining, (1) in array and variable names, (1) in dimension and member names, (1) in report scripts, (1) undoing, database operations, (1) unexpected values, (1) Analytic Server property viewing, (1) application property, viewing, (1) client-server interoperability, (1) client-server interoperability table, (1) computer setup, (1) encoding of logs, (1) implementation, (1) overview, (1) sample database, (1) when to use, (1) aggregate storage databases compared to block storage databases, (1) administration tools, (1) defined, (1) Unicode-enabled API, (1) Unicode-mode applications, (1) and partitions, (1) creating, (1) defined, (1) file encoding, (1) migrating to, (1) migration, preparation for, (1) Unicode-mode client programs, (1) Unicode-mode server, defined, (1) Unicode-mode setting, Analytic Server, (1) Uniform Resource Locators. See URLs assigning #MISSING values to, (1) Intelligent Calculation and, (1) basic memory requirements, (1) file naming conventions, (1) monitoring applications, (1) running Analytic Server in background, (1) running batch files, (1) specifying disk volumes, (1) starting Analytic Server, (1) remotely, (1) unknown member errors, (1) unknown values, (1) UNLOADALIAS command, (1) UNLOADDB command, (1) data, (1) databases, with Application Designer privilege, (1) objects, (1) outlines, (1) unsupervised learning, data mining algorithms and, (1) update log files, (1) system failures and, (1) turning on Intelligent Calculation, (1) committed access and, (1) troubleshooting, (1) UPDATEVARIABLE command, (1) alias tables, (1) cache sizes, (1) changed blocks only, (1) data compression, (1) data sources, (1) data targets, (1) databases, (1) indexes, (1) outlines, (1) partitioned applications, (1) guidelines, (1) replicated partitions, (1) status, (1) with remote data, (1) references, (1) reports, (1) spreadsheets, (1) substitution variables, (1) transaction isolation settings, (1) volume settings, (1) upgrades, (1) consolidation behavior, (1) defined, (1) dynamically calculating, (1) (2) (3) recalculating values in, (1) restructuring and, (1) linking to cells, (1) maximum character length, (1) storing, (1) assigning filters to, (1) assigning privileges, (1) creating, (1) defined, (1) defining security settings, (1) (2) modifying access settings, (1) (2) accessing linked objects and clients, (1) user-management tasks, (1) (2) (3) activating disabled, (1) disabling, (1) entering, (1) user sessions, managing, (1) defined, (1) ordinary, (1) Supervisor, (1) user-defined macros, validating, (1) accessing locked blocks, (1) activating disabled, (1) application permission, (1) filters, (1) privileges, (1) changing access privileges, (1) (2) copying, (1) creating, (1) creating accounts for, (1) deleting, (1) disabling, (1) disconnecting from OLAP Servers, (1) displaying, defined users, (1) editing security settings, (1) Essbase Administration Services and, (1) limiting login attempts, (1) limiting maximum number of sessions, (1) logging out, (1) login procedure, (1) maintaining information for, (1) migrating, (1) renaming, (1) replicating privileges, (1) rules for naming, (1) security settings, (1) security types, (1) setting global access levels, (1) unauthorized, (1) USERS command (Agent), (1) (2) and Unicode-mode applications, (1) computer setup, (1) converting files to, (1) UTF-8 recommendation, (1) adding to files, (1) described, (1) VV, Dynamic Calc and Store code in data source, (1) described, (1) incremental restructuring usage, (1) partitioned applications and, (1) VALIDATEPARTITIONDEFFILE command, (1) aggregate storage outlines, (1) (2) data integrity, (1) field names, (1) outlines, (1) rules files, (1) troubleshooting problems, (1) validity checking, (1) See also missing values; range of values accumulation, (1) assigning to member combinations, (1) assigning to variables, (1) averaging, (1) non-zero values and, (1) calculation types, (1) changing, (1) changing in replicated partitions, (1) compression and repetitive, (1) (2) defined, (1) distribution among dimensions, (1) (2) duplicating, (1) dynamically calculating, (1) (2) (3) entering in empty fields, (1) example of comparing, (1) filtering, (1) flipping, (1) formatting in reports, (1) (2) identical, (1) inconsistent, (1) incorrect, (1) interdependent, (1) looking up, (1) measuring, (1) member with no, (1) flipping, (1) in data sources, (1) variance as, (1) optimizing in sparse dimensions, (1) out of range, (1) overview, (1) for currency conversions, (1) in time or accounts dimensions, (1) placing retrieval restrictions, (1) (2) reading multiple ranges, (1) retrieving dynamically calculated, (1) (2) (3) (4) process, (1) setting maximum rows allowed, (1) retrieving from remote databases, (1) (2) (3) rolling up, (1) scaling, (1) truncating, (1) unexpected, (1) assigning #MISSING values to, (1) Intelligent Calculation and, (1) unknown, (1) variables as, (1) when stored in aggregate cells, (1) VAR command, (1) adding to report scripts, (1) (2) (3) (4) assigning values, (1) copying substitution, (1) creating substitution, (1) deleting substitution, (1) free-form reports and, (1) inserting in calculation scripts, (1) (2) naming, (1) setting configurable variables, (1) substitution, (1) updating substitution, (1) @VARIANCE function, (1) See also statistical variance, calculating dynamically calculating, (1) calculating, (1) aggregate storage databases compared to block storage databases, (1) variance reporting properties, (1) (2) setting, (1) @VARIANCEP function, (1) @VARPER function, (1) (2) (3) (4) outlines, (1) values retrieved in loads, (1) VERSION command (Agent), (1) version numbers, (1) vertical bars ( | ), in application and database names, (1) (2) Analytic Server logs, (1) Analytic Server properties, (1) application information, (1) application logs, (1) application properties, (1) applications and databases, (1) changes to outlines, (1) different perspectives, (1) in multidimensional databases, (1) in targets, (1) through dimension coordinates, (1) data load error logs, (1) database properties, (1) dimension build error logs, (1) dynamically calculated members, (1) (2) exception logs, (1) field operations, (1) filters, (1) formulas, (1) informational messages, (1) (2) linked objects, (1) locked data, (1) member combinations, (1) (2) (3) (4) member names in reports, (1) members in outlines, (1) outline change logs, (1) records, (1) replace operations, (1) selection/rejection criteria, (1) Server Agent commands, (1) software version, (1) VLBREPORT setting, (1) volume names, (1) allocation and, (1) data storage and multiple, (1) deallocating, (1) index files and, (1) specifying, with ESSCMD, (1) updating storage settings, (1) Wlocks, (1) transactions, (1) Analytic Server logs and, (1) application logs and, (1) week-to-date calculations, (1) WHERE section in MDX queries, (1) cross-dimensional operator and, (1) formulas, (1) in dimension and member names, (1) in report layouts, (1) report scripts, (1) WIDTH report command, (1) wildcard matches, (1) wildcards in report scripts, (1) Windows performance feature, (1) and Personal Essbase, (1) memory for, (1) monitoring applications, (1) WITHATTR report command, (1) and partitions, (1) overview, (1) usage, (1) Write access, (1) write access, (1) with committed access, (1) with uncommitted access, (1) (2) Write permission, (1) creating for aggregate storage databases, (1) example, (1) write-back, to aggregate storage databases, (1) error logs, (1) optimizing, (1) writing back, to aggregate storage databases, (1) W-T-D time series member, (1) (2) www.hyperion.com, (1) XX member code, (1) X, Dynamic Calc code in data source, (1) Xchgrate database, (1) .XLL files, (1) .XLS files, (1) @XRANGE function, (1) @XREF function, (1) Yyear-to-date calculations, (1) (2) yen currency symbol, (1) Y-T-D time series member, (1) (2) ZZ, time balance codes in data source, (1) consolidating, (1) excluding in time balances, (1) formatting in reports, (1) (2) including in time balances, (1) replacing with labels, (1) ZEROTEXT report command, (1) described, (1) specifying, (1) |