VBA Function Types
Describes the VBA function types.
-
Menu functions are identical to the equivalent commands on the Oracle Smart View for Office menu and ribbon. See Menu Functions.
-
General functions perform actions, set options, or retrieve information typically performed from the Smart View ribbon or Options dialog box. See General Functions.
-
Connection functions perform actions related to connections to data providers. See Connection Functions.
-
Ad hoc functions perform ad hoc operations such as zooming, retrieving and submitting data, and pivoting. See Ad Hoc Functions.
-
The Form function opens a data form. See Form Functions.
-
Cell functions perform operations and retrieve information for data cells and their contents. 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 execute calculation scripts and business rules. See Calculation Script and Business Rule Functions.
-
Calculation, consolidation, and translation functions executes these operations on data for Oracle Hyperion Financial Management applications. See Calculation, Consolidation, and Translation Functions.
-
Member query functions retrieve generation, level, attribute, and other information about members. See Member Query Functions.
-
Options functions set and retrieve information for global and/or sheet options, and enable deletion of MRU items. See Options Functions.
-
Dynamic link functions set or retrieve data point details that are displayed in separate windows via dynamic links. See Dynamic Link Functions.
-
The MDX query function executes an MDX query whose results are not displayed in a worksheet. See MDX Query Functions.
-
Oracle Journals functions support Financial Management Journals functionality in Smart View. See Oracle Journals for Financial Management Functions.
-
Oracle Analytics Cloud functions support Smart View operations when connected to an Oracle Analytics Cloud data source. See Oracle Analytics Cloud Functions
-
Oracle BI EE functions support Smart View operations when connected to an Oracle Business Intelligence Enterprise Edition data source. See Oracle BI EE Functions.
Note:
See also VBA Functions—Alphabetical List.