Transcription
Oracle CloudTechnical Reference for Oracle AnalyticsCloud - EssbaseE70189-10January 2019
Oracle Cloud Technical Reference for Oracle Analytics Cloud - Essbase,E70189-10Copyright 1996, 2019, Oracle and/or its affiliates. All rights reserved.Primary Author: Essbase Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify,license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means.Reverse engineering, disassembly, or decompilation of this software, unless required by law forinteroperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agencyspecific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of theprograms, including any operating system, integrated software, any programs installed on the hardware,and/or documentation, shall be subject to license terms and license restrictions applicable to the programs.No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not beresponsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPreface1AudiencexxiiiDocumentation AccessibilityxxiiiRelated ResourcesxxiiiConventionsxxivTechnical Reference OverviewAbout the Technical ReferenceWhat You Should Know Before You Start1-1Sample Applications1-1Syntax Conventions1-1About Aggregate Storage Databases21-11-3Calculation FunctionsCalculation Functions Overview2-1Generations and Levels2-1Abbreviations2-2Function Syntax2-2Function Parameters2-2Calculation Operators2-5Mathematical Operators2-6Conditional and Logical Operators2-6Cross-Dimensional Operators2-6Operation Results on #MISSING Values and Zero (0) Values2-7Calculation Function Categories2-8Boolean Functions2-8Relationship Functions2-9Mathematical Functions2-10Member Set Functions2-11Range and Financial Functions2-14Allocation Functions2-19iii
Forecasting Functions2-19Statistical Functions2-20Date & Time Function2-21Miscellaneous Functions2-21Calculation Function 74@ENUMVALUE2-76@EQUAL2-76@EXP2-77iv
SSAMELEV2-118@ISSIBLING2-119v
175vi
UMRANGE2-229@SYD2-230@TODATE2-232@TODATEEX2-233vii
XWRITE2-265Functions Supported in Hybrid Aggregation Mode32-267Calculation CommandsCalculation Commands Overview3-1Calculation Operators3-1Mathematical Operators3-1Conditional and Logical Operators3-2Cross-Dimensional Operator3-2Calculation Command Groups3-3Conditional Commands3-3Control Flow Commands3-4Data Declaration Commands3-4Functional Commands3-4Member Formulas3-5Calculation Command List3-6& (ampersand)3-7AGG3-8ARRAY3-8CALC ALL3-10CALC AVERAGE3-10CALC DIM3-11CALC FIRST3-12CALC LAST3-12CALC viii
ATAMERGE3-23ELSE3-24ELSEIF3-25ENDIF3-26EXCLUDE ENDEXCLUDE3-27FIX .ENDLOOP3-38POSTFIXPARALLEL3-38SET Commands3-40SET AGGMISSG3-40SET CACHE3-41SET CALCDIAGNOSTICS3-42SET CALCPARALLEL3-46SET CALCTASKDIMS3-46SET CLEARUPDATESTATUS3-47SET COPYMISSINGBLOCK3-50SET CREATENONMISSINGBLK3-51SET CREATEBLOCKONEQ3-53SET DATAEXPORTOPTIONS3-55SET DATAIMPORTIGNORETIMESTAMP3-64SET EMPTYMEMBERSETS3-65SET FRMLBOTTOMUP3-66SET FRMLRTDYNAMIC3-66SET MSG3-67SET NOTICE3-70SET REMOTECALC3-71SET RUNTIMESUBVARS3-72SET SCAPERSPECTIVE3-74SET TRACE3-75SET UPDATECALC3-77THREADVAR3-77USE MDX INSERT3-78VAR3-79ix
4Configuration SettingsConfiguration Settings Categorical List4-1Calculation Configuration Settings4-1Data Import and Export Configuration Settings4-2Memory Management Configuration Settings4-2Logging and Error Handling Configuration Settings4-2Miscellaneous Configuration Settings4-2Partitioning Configuration Settings4-2Ports and Connections Configuration Settings4-2Query Management Configuration Settings4-3Aggregate Storage and Block Storage Settings Comparison4-3Block Storage and Aggregate Storage Configuration Settings4-3Aggregate Storage Configuration Settings4-4Block Storage Configuration Settings4-4Config Settings SIONMESSAGES4-28GRIDSUPPRESSINVALID4-29x
AXNUMBEROFACTIVEDB4-34MAX REQUEST GRID SIZE4-35MAX RESPONSE GRID ARGETTIMESERIESOPT4-54MaxLOverview of MaxL and MDX5-1How to Read MaxL Railroad Diagrams5-1Anatomy of MaxL Statements5-2Railroad Diagram Symbols5-2Sample Railroad Diagram5-3MaxL Data Definition Language (DDL)5-4MaxL Statements5-4Performance Statistics in MaxLThe Essbase Performance Statistics Tables5-55-5xi
MaxL Script ExampleListed By Refresh5-14Listed by Objects5-14Aggregate Build5-15Aggregate Process5-15Aggregate Selection5-15Allocation5-15Application5-15Archive ons5-16Drillthrough5-16Filter5-16Group5-16Location ce5-17Trigger5-18Trigger Spool5-18User5-18Variable5-18MaxL Statement Reference5-18xii
Alter Application5-18Alter Database5-22Alter Database enable disable5-23Alter Database Set5-25Alter Database (Misc)5-29Alter Drillthrough5-33Alter Filter5-34Alter Object5-35Alter Partition5-37Alter Session5-40Alter System5-42Alter Tablespace (Aggregate Storage)5-48Alter Trigger5-50Create Application5-51Create Calculation5-52Create Database5-53Create Drillthrough5-55Create Filter5-56Create Location Alias5-58Create Partition5-59Create Replicated Partition5-59Create Transparent Partition5-63Create Trigger5-65Create After-Update Trigger5-66Create On-Update Trigger5-67Display Application5-69Display Calculation5-71Display Database5-72Display Drillthrough5-77Display Filter5-78Display Filter Row5-79Display Group5-79Display Location Alias5-80Display Lock5-81Display Object5-82Display Partition5-83Display Privilege5-84Display Session5-85Display System5-87Display Trigger5-90Display Trigger Spool5-91xiii
Display User5-91Display Variable5-94Drop Application5-95Drop Calculation5-95Drop Database5-96Drop Drillthrough5-96Drop Filter5-97Drop Location Alias5-97Drop Lock5-98Drop Object5-99Drop Partition5-99Drop Trigger5-101Drop Trigger Spool5-101Execute Calculation5-101Execute Aggregate Process (Aggregate Storage)5-104Execute Aggregate Build5-106Execute Aggregate Selection5-107Export Data5-111Export LRO5-113Export Outline5-115Grant5-118Import Data5-120Import Dimensions5-122Import LRO5-123Query Application5-124Query Archive File5-125Query Database5-126Refresh Outline5-131Refresh Replicated Partition5-134MaxL Definitions5-135MaxL Syntax Notes5-135Numbers in MaxL iv
CUBE-AREA or TLINE-ID5-158PASSWORD5-158PATHNAME ABLSP-NAME5-163xv
ZE5-168Privileges and Roles5-168Application-Level System Roles5-168Database-Level System Roles5-169Quoting and Special Characters Rules for MaxL Language5-169Tokens enclosed in Single Quotation Marks5-170Tokens Enclosed in Double Quotation Marks5-170Use of Backslashes in MaxL5-170Use of Apostrophes (Single Quotation Marks)5-171Use of Dollar Signs5-171MaxL Shell Commands5-171Overview of MaxL Shell5-172MaxL Shell Invocation5-172Prerequisites for Using MaxL5-172MaxL Invocation Summary5-173Interactive Input5-175File Input5-178Standard ry Cancellation5-181MaxL Shell Syntax Rules and Variables5-181Semicolons5-182Variables5-182Quoting and Special Characters Rules for MaxL Shell5-186MaxL Shell and Unicode5-187MaxL Shell Command Reference5-187Spool on/off5-188Set Display Column Width5-189Set Message
Oracle Cloud Technical Reference for Oracle Analytics Cloud - Essbase E70189-10 January 2019
