Developer's Guide Oracle Smart View For Office
Oracle Smart View for OfficeDeveloper's GuideRelease 11.1.2.5.710E91405-01December 2017
Oracle Smart View for Office Developer's Guide, Release 11.1.2.5.710E91405-01Copyright 2004, 2017, Oracle and/or its affiliates. All rights reserved.Primary Author: EPM 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.
ContentsDocumentation AccessibilityDocumentation Feedback1About the Smart View Developer's Guide2About VBA Functions3Assumed Knowledge2-1VBA Functions Location2-1Using VBA Function Code Samples2-1VBA Functions in 64-Bit Versions2-2VBA Parameters2-2VBA Return Values (Error Codes)2-3Using Spreadsheet Toolkit VBA Applications in Smart View2-6VBA Function Types2-6VBA Functions—Alphabetical List2-7Menu FunctionsAbout Menu ect3-6HypMenuVCopyDataPoints3-6iii
23HypHideRibbonMenuReset3-24General FunctionsAbout General Applications4-3HypListDatabases4-5iv
Connection FunctionsAbout Connection 5-16HypSetAsDefault5-17v
HypSetConnAliasTable6785-17Ad Hoc FunctionsAbout Ad Hoc 15HypRemoveOnly6-16HypZoomIn6-17HypZoomOut6-18Form FunctionsAbout Forms7-1HypOpenForm7-1Cell FunctionsAbout Cell lsDirty8-8HypDeleteAllLROs8-9HypDeleteLROs8-9vi
ypGetDrillThroughReports8-15POV FunctionsAbout POV pSetDimensions9-10Calculation Script and Business Rule FunctionsAbout Calculation Script and Business Rule tring10-10HypDeleteCalc10-11Calculation, Consolidation, and Translation FunctionsAbout Calculation, Consolidation, and Translation onsolidateAllWithData11-4HypForceCalculate11-4vii
nslate11-6HypTranslate11-6Member Query FunctionsAbout Member Query nformationEx12-18Options FunctionsAbout Options ms13-17Dynamic Link FunctionsAbout Dynamic Link Views14-1Setting Up Dynamic Link Views14-2Automating Macro 3viii
ypGetPOVItems14-16HypSetPOVItems14-17MDX Query FunctionsAbout MDX15-1HypExecuteMDXEx15-1Oracle Journals for Financial Management FunctionsAbout Oracle Journals for Financial Management Functions16-1Registering the Oracle Journals VBA Functions Using RegAsm16-1Preparing to Work with Oracle Journals for Financial Management Functions16-2Instantiating an Oracle Journals for Financial Management Extension Object16-3Oracle Journals for Financial Management Extension -11Oracle Analytics Cloud FunctionsAbout Oracle Analytics Cloud Functions17-1Preparing to Work with Oracle Analytics Cloud Functions17-1Instantiating an Oracle Smart View BI Extension Object17-1Oracle Smart View BI Extension Functions17-2ix
2PasteView17-12Oracle BI EE FunctionsAbout Oracle BI EE Functions18-1Preparing to Work with Oracle BI EE Functions18-1Instantiating an Oracle Smart View BI Extension Object18-1Oracle Smart View BI Extension opyView18-12PasteView18-12x
Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the OracleAccessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic supportthrough My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id info or visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trsif you are hearing impaired.xi
Documentation FeedbackDocumentation FeedbackTo provide feedback on this documentation, send email to epmdoc ww@oracle.com,or, in an Oracle Help Center topic, click the Feedback button located beneath theTable of Contents (you may need to scroll down to see the button).Follow EPM Information Development on these social media sites:LinkedIn - http://www.linkedin.com/groups?gid 3127051&goback .gmp 3127051Twitter - http://twitter.com/hyperionepminfoFacebook - 2682103112642Google - 915048672979407731/postsYouTube - https://www.youtube.com/user/EvolvingBIxii
1About the Smart View Developer's GuideThe Oracle Smart View for Office Developer's Guide describes the Microsoft VisualBasic for Applications (VBA) functions that you can use to develop applications forOracle Smart View for Office. This reference is intended for advanced users who needdetailed information and examples for supported VBA functions.1-1
2About VBA FunctionsRelated Topics: Assumed Knowledge VBA Functions Location Using VBA Function Code Samples VBA Functions in 64-Bit Versions VBA Parameters VBA Return Values (Error Codes) Using Spreadsheet Toolkit VBA Applications in Smart View VBA Function Types VBA Functions—Alphabetical ListAssumed KnowledgeYou can customize and automate common tasks using Microsoft Visual Basic forApplications (VBA) functions in Oracle Smart View for Office using Microsoft Excel'sVisual Basic Editor.To use the information in this chapter to develop VBA applications for Smart View, youmust have working knowledge of the following: Smart View and how it is used in your organization Visual Basic or VBA programming language Excel Visual Basic Editor as an environment for VBA developmentVBA Functions LocationAll Oracle Smart View for Office VBA functions are contained in the file smartview.bas,located by default in EPM ORACLE HOME/smartview/bin. To access these functions, importsmartview.bas into a Visual Basic Editor module and use this module as a source ofVBA functions for your program.Using VBA Function Code SamplesThis guide provides examples for each VBA function. You can copy these codesamples into a Visual Basic Editor Module; however Oracle recommends that you usesmartview.bas imported into a module as the source of the function declarations. Thisis particularly important for declarations that contain arrays. See VBA FunctionsLocation.If you do copy and paste code samples, always use the HTML version of this guide.Copying from a PDF file may cause characters in the code to be lost.2-1
Chapter 2VBA Functions in 64-Bit VersionsVBA Functions in 64-Bit VersionsIf you are using the 64-bit version of Microsoft Office, VBA function declarations areslightly different from those in the 32-bit version. In 64-bit versions, the declarationsinclude PtrSafe after the Declare keyword. For example: 32-bit version: Public Declare Function HypMenuVAbout Lib "HsAddin" () As Long 64-bit version: Public Declare PtrSafe Function HypMenuVAbout Lib "HsAddin" ()As Long.The smartview.bas file provided with your Oracle Smart View for Office installationautomatically contains the appropriate declaration statements.Note:The code samples in this guide contain declarations for the 32-bit version ofOffice; if you have the 64-bit version, you must ensure that PtrSafe is includedin the declarations.VBA ParametersMost VBA functions require you to supply values for one or more parameters. Table 1lists the parameter types and the valid values for each type:Table 2-1VBA ParametersParameterValueTextA word or phrase or name in quotation marks.For example: "Smart View" "[Book2.xls]Sheet1"Boolean Range objectA cell, row or column, one or more selectionsof cells, or a three-dimensional range address,surrounded by quotation marks. For example: RANGE("A1") RANGE("A1:B2") RANGE("G:G,I:I,K:K") RANGE("A1:B5,C1:C10,D5:L8") RANGE("Sheet1!C3:R20,Sheet2!C3:R20")NumberA number without quotation marks and withoutcommas. For example: 1 2.5 50000List of stringsA list of text values separated by commas. Forexample: "Qtr1", "Actual", "Oregon"TrueFalse2-2
Chapter 2VBA Return Values (Error Codes)Table 2-1(Cont.) VBA ParametersParameterValueConstantA predefined constant from smartview.basDefault value NullEmptyNote:Many parameters have default values orbehavior that the function uses if you specifyNull or Empty. If you do not specify a value forsuch parameters, use Null or Empty. See thedescription of each function for default valuesof such parameters.VBA Return Values (Error Codes)Oracle Smart View for Office VBA functions may return any of the values in Table 1 toindicate success or failure of the function. A return value of zero (0) indicates that the function ran successfully. A return value of 1 or 2 indicates that the function ran successfully, but with acondition. Negative return values indicate client issues. A return value of 4 indicates a server issue.Note:Return values are often referred to as error codes.Table 2-2Return Values (Error Codes) and Their DescriptionsReturn ValueNameDescription4SS ERR ERRORAn error specific to the data provideror a generic error that cannot bemapped to a value.2SS NO GRID ON SHEET BUT F The function ran successfully;UNCTIONS SUBMITTEDhowever, the function sheet that wassubmitted contained no grid.1SS SHEET NOT CONNECTED BUT FUNCTIONS SUBMITTEDThe function ran successfully;however, the function sheet that wassubmitted was not connected.0SS OKThe function ran successfully.2-3
Chapter 2VBA Return Values (Error Codes)Table 2-2(Cont.) Return Values (Error Codes) and Their DescriptionsReturn ValueNameDescription-1SS INIT ERRInitialization error.-2SS TERM ERRTermination error.-3SS NOT INITInitialization error.-4SS NOT CONNECTEDThe spreadsheet is not yetconnected to the server.-5SS NOT LOCKEDThe spreadsheet is not locked.-6SS INVALID SSTABLEThe spreadsheet has becomeunstable.-7SS INVALID SSDATAThe spreadsheet contains invaliddata.-8SS NOUNDO INFONo Undo information exists.-9SS CANCELEDOperation has been canceled.-10SS GLOBALOPTSNot used.-11SS SHEETOPTSNot used.-12SS NOTENABLEDUndo is not enabled.-13SS NO MEMORYNot enough memory resources areavailable.-14SS DIALOG ERRORAppropriate dialog box could not bedisplayed.-15SS INVALID PARAMFunction contains an invalidparameter.-16SS CALCULATINGCalculation is in progress.-17SS SQL IN PROGRESSObsolete setting.-18SS FORMULAPRESERVEOperation is not allowed because thespreadsheet is in formulapreservation mode.-19SS INTERNALSSERROROperation cannot take place on thespecified sheet.-20SS INVALID SHEETCurrent sheet cannot be determined.-21SS NOACTIVESHEETSpreadsheet name was not specifiedand no active sheet is selected.-22SS NOTCALCULATINGCalculation cannot be canceledbecause no calculation is running.-23SS INVALIDSELECTIONSelection parameter is invalid.-24SS INVALIDTOKENNot used.-25SS CASCADENOTALLOWEDCascade list file cannot be created,or you are attempting to cascadewhile the spreadsheet is embeddedin another document.-26SS NOMACROSSpreadsheet macros cannot be rundue to a licensing agreement.-27SS NOREADONLYMACROSSpreadsheet macros which updatethe database cannot be run due to alicensing constraint.-28SS READONLYSSYou have a read-only license andcannot update the database.-29SS NOSQLACCESSObsolete setting.2-4
Chapter 2VBA Return Values (Error Codes)Table 2-2(Cont.) Return Values (Error Codes) and Their DescriptionsReturn ValueNameDescription-30SS MENUALREADYREMOVEDThe menu is removed already.-31SS MENUALREADYADDEDThe menu is added already.-32SS NOSPREADSHEETACCESSNot used.-33SS NOHANDLESNot used.-34SS NOPREVCONNECTIONNot used.-35SS LROERRORNot used.-36SS LROWINAPPACCESSERRNot used.-37SS DATANAVINITERRNot used.-38SS PARAMSETNOTALLOWEDNot used.-39SS SHEET PROTECTEDThe specified worksheet is protected.Unprotect the worksheet and try theoperation again.-40SS CALCSCRIPT NOTFOUNDCalc script not found.-41SS NOSUPPORT PROVIDERProvider not supported.-42SS INVALID ALIASInvalid alias.-43SS CONN NOT FOUNDConnection not found.-44SS APS CONN NOT FOUNDProvider Services connection notfound.-45SS APS NOT CONNECTEDProvider Services not connected.-46SS APS CANT CONNECTProvider Services cannot connect.-47SS CONN ALREADY EXISTSConnection already exists.-48SS APS URL NOT SAVEDProvider Services URL not saved.-49SS MIGRATION OF CONN NOT Migration of connection not allowed.ALLOWED-50SS CONN MGR NOT INITIALIZEDConnection manager not initialized.-51SS FAILED TO GET APS OVERRIDE PROPERTYFailed to get Provider Servicesoverride property.-52SS FAILED TO SET APS OVERR Failed to set Provider ServicesIDE PROPERTYoverride property.-53SS FAILED TO GET APS URL-54SS APS DISCONNECT FAILEDProvider Services disconnect failed.-55SS OPERATION FAILEDOperation failed.-56SS CANNOT ASSOCIATE SHEET Cannot associate sheet withWITH CONNECTIONconnection.-57SS REFRESH SHEET NEEDED-58SS NO GRID OBJECT ON SHEE No grid object on sheet.T-59SS NO CONNECTION ASSOCIAT No connection associated.ED-60SS NON DATA CELL PASSED-61SS DATA CELL IS NOT WRITAB Data cell is not writable.LE-62SS NO SVC CONTENT ON SHEETFailed to get Provider Services URL.Worksheet refresh needed.Non-data cell passed.No Smart View content on sheet.2-5
Chapter 2Using Spreadsheet Toolkit VBA Applications in Smart ViewTable 2-2(Cont.) Return Values (Error Codes) and Their DescriptionsReturn ValueNameDescription-63SS FAILED TO GET OFFICE OB Failed to get Office object.JECT-64SS OP FAILED AS CHART IS SELECTEDOperation failed because chart isselected.-65SS EXCEL IN EDIT MODEExcel in edit mode.-66SS SHEET NON SMARTVIEW COMPATIBLESheet not compatible with SmartView.-67SS APP NOT STANDALONEApplication not stand alone.-68SS SMART VIEW DISABLEDSmart View is disabled.-69SS VBA DEPRECATEDThe function has been deprecated.-70SS OPERATION NOT SUPPORTE The operation is not supported inD IN MULTIGRID MODEworksheets that are in multiple-gridmode.-71SS INVALID MEMBERThe member name is invalid. Usedwith HypGetMemberInformation.-72SS NO SV NAME RANGENo named ranges are available.Used with HypGetNameRangeList.-73SS AMBIGUOUS MENUThe menu item is ambiguous andcould not be resolved. Used withHypExecuteMenu,HypHideRibbonMenu, andHypHideRibbonMenuReset.Using Spreadsheet Toolkit VBA Applications in Smart ViewVBA applications created in Oracle Hyperion Essbase Spreadsheet Toolkit can beconverted to Oracle Smart View for Office by making the following modifications: Replace the EssV prefix of Spreadsheet Toolkit functions with Hyp; for example,change EssVRemoveOnly to HypRemoveOnly. Replace the EssMenuV prefix of Spreadsheet Toolkit menu functions with HypMenuV;for example, change EssMenuVZoomIn to HypMenuVZoomIn. Replace the declarations in essxlvba.txt with the declarations in smartview.bas.VBA Function Types Menu functions are identical to the equivalent commands on the Oracle SmartView for Office menu and ribbon. See Menu Functions. General functions perform actions, set options, or retrieve information typicallyperformed from the Smart View ribbon or Options dialog box. See GeneralFunctions. Connection functions perform actions related to connections to data providers.See Connection Functions. Ad hoc functions perform ad hoc operations such as zooming, retrieving andsubmitting data, and pivoting. See Ad Hoc Functions.2-6
Chapter 2VBA Functions—Alphabetical List The Form function opens a data form. See Form Functions. Cell functions perform operations and retrieve information for data cells and theircontents. See Cell Functions. POV functions specify or retrieve settings for the POV. See POV Functions. Calculation script and business rule functions retrieve lists of or executecalculation scripts and business rules. See Calculation Script and Business RuleFunctions. Calculation, consolidation, and translation functions executes these operationson data for Oracle Hyperion Financial Management applications. See Calculation,Consolidation, and Translation Functions. Member query functions retrieve generation, level, attribute, and other informationabout members. See Member Query Functions. Options functions set and retrieve information for global and/or sheet options, andenable deletion of MRU items. See Options Functions. Dynamic link functions set or retrieve data point details that are displayed inseparate windows via dynamic links. See Dynamic Link Functions. The MDX query function executes an MDX query whose results are not displayedin a worksheet. See MDX Query Functions. Oracle Journals functions support Financial Management Journals functionality inSmart View. See Oracle Journals for Financial Management Functions. Oracle Analytics Cloud functions support Smart View operations when connectedto an Oracle Analytics Cloud data source. See Oracle Analytics Cloud Functions Oracle BI EE functions support Smart View operations when connected to anOracle Business Intelligence Enterprise Edition data source. See Oracle BI EEFunctions.Note:See also VBA Functions—Alphabetical List.VBA Functions—Alphabetical ListTable 2-3VBA Functions—Alphabetical ListVBA FunctionsApplicable Data SourcesAnalysisPropertiesOracle Analytics CloudAnalysisPropertiesOracle Business Intelligence EnterpriseEditionCopyViewOracle Analytics CloudCopyViewOracle BI EECreateJournalOracle Hyperion Financial Management andOracle Journals Extension for FinancialManagementDeleteViewOracle Analytics Cloud2-7
Chapter 2VBA Functions—Alphabetical ListTable 2-3(Cont.) VBA Functions—Alphabetical ListVBA FunctionsApplicable Data SourcesDeleteViewOracle BI EEDirPropertiesOracle Analytics CloudDirPropertiesOracle BI EEEditPagePromptsOracle Analytics CloudEditPagePromptsOracle BI EEEditPromptsOracle Analytics CloudEditPromptsOracle BI EEGetPagePromptsOracle Analytics CloudGetPagePromptsOracle BI EEHypAddLROOracle Analytics Cloud - Essbase, OracleEssbaseHypCalculateFinancial ManagementHypCalculateContributionFinancial Management (ad hoc only)HypCellOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Oracle Hyperion Planning, FinancialManagementHypConnectEssbase, Planning, Financial ManagementHypConnectedOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypConnectionExistsOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypConsolidateFinancial Management (ad hoc only)HypConsolidateAllFinancial Management (ad hoc only)HypConsolidateAllWithDataFinancial Management (ad hoc only)HypCreateConnectionOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial Management, OracleHyperion Reporting and AnalysisHypCreateConnectionExOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial Management, Reportingand AnalysisHypCopyMetaDataOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypDeleteAllLROsOracle Analytics Cloud - Essbase, Essbase,HypDeleteAllMRUItemsAllHypDeleteCalcOracle Analytics Cloud - Essbase, EssbaseHypDeleteLROsOracle Analytics Cloud - Essbase, EssbaseHypDeleteMetaDataOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial Management, Reportingand Analysis2-8
Chapter 2VBA Functions—Alphabetical ListTable 2-3(Cont.) VBA Functions—Alphabetical ListVBA FunctionsApplicable Data SourcesHypDisconnectOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypDisconnectAllOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypDisconnectExOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypDisplayToLinkViewOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypExecuteCalcScriptOracle Analytics Cloud - Essbase, EssbaseHypExecuteCalcScriptExOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, eHypExecuteMDXExOracle Analytics Cloud - Essbase, EssbaseHypExecuteQueryOracle Analytics Cloud - Essbase, EssbaseHypFindMemberOracle Analytics Cloud - Essbase, EssbaseHypFindMemberExOracle Analytics Cloud - Essbase, EssbaseHypForceCalculateFinancial ManagementHypForceCalculateContributionFinancial Management (ad hoc only)HypForceTranslateFinancial Management (ad hoc only)HypFreeDataPointOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetActiveMemberOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetAncestorOracle Analytics Cloud - Essbase, EssbaseHypGetBackgroundPOVOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial rMbrCombinationOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetChildrenOracle Analytics Cloud - Essbase, EssbaseHypGetColCountOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud (ad hoc only),Essbase, Planning (ad hoc only), FinancialManagement (ad hoc only)HypGetColItemsOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud (ad hoc only),Essbase, Planning (ad hoc only), FinancialManagement (ad hoc only)2-9
Chapter 2VBA Functions—Alphabetical ListTable 2-3(Cont.) VBA Functions—Alphabetical ListVBA FunctionsApplicable Data SourcesHypGetConnectionInfoOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud (ad hoc only),Essbase, Planning (ad hoc only), FinancialManagement (ad hoc only)HypGetDatabaseNoteOracle Analytics Cloud - Essbase, EssbaseHypGetDataPointOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetDimensionsOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetDimMbrsForDataCellOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial obalOptionOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetLastErrorAllHypGetLinkMacroOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud (ad hoc only),Essbase, Planning (ad hoc only), FinancialManagement (ad hoc only)HypGetMemberInformationOracle Analytics Cloud - Essbase, EssbaseHypGetMemberInformationExOracle Analytics Cloud - Essbase, EssbaseHypGetMembersOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetNameRangeListOracle Analytics Cloud - Essbase, EssbaseHypGetOptionOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetPagePOVChoicesOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud, Essbase,Planning, Financial ManagementHypGetParentOracle Analytics Cloud - Essbase, EssbaseHypGetPOVCountOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud (ad hoc only),Essbase, Planning (ad hoc only), FinancialManagement (ad hoc only)HypGetPOVItemsOracle Analytics Cloud - Essbase, OraclePlanning and Budgeting Cloud (ad hoc only),Essbase, Pla
Using Spreadsheet Toolkit VBA Applications in Smart View 2-6 VBA Function Types 2-6 VBA Functions—Alphabetical List 2-7 3 Menu Functions About Menu Functions 3-2 HypMenuVAbout 3-2 HypMenuVAdjust 3-3 HypMenuVBusinessRules 3-3 HypMenuVCalculation 3-3 HypMenuVCascadeNewWorkbook 3-4 HypMenuVCascadeSameWorkbook 3-4 HypMenuVCellText 3
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
xii Oracle Workflow Developer's Guide Audience for This Guide Welcome to the Oracle Workflow Developer's Guide. This guide assumes you have a working knowledge of the following: The principles and customary practices of your business area. Oracle Workflow Oracle Workflow Developer's Guide. Workflow.
Changes in Oracle SQL Developer Release 18.1 xlviii 1 SQL Developer Concepts and Usage 1.1 About SQL Developer 1-2 1.2 Installing and Getting Started with SQL Developer 1-2 1.3 SQL Developer User Interface 1-3 1.3.1 Menus for SQL Developer
7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
Specific tasks you can accomplish using Oracle Sales Compensation Oracle Oracle Sales Compensation setup Oracle Oracle Sales Compensation functions and features Oracle Oracle Sales Compensation windows Oracle Oracle Sales Compensation reports and processes This preface explains how this user's guide is organized and introduces
PeopleSoft Oracle JD Edwards Oracle Siebel Oracle Xtra Large Model Payroll E-Business Suite Oracle Middleware Performance Oracle Database JDE Enterprise One 9.1 Oracle VM 2.2 2,000 Users TPC-C Oracle 11g C240 M3 TPC-C Oracle DB 11g & OEL 1,244,550 OPTS/Sec C250 M2 Oracle E-Business Suite M
