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 and Oracle Hyperion Enterprise® 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 BI EE functions support Smart View operations when connected to an Oracle Business Intelligence Enterprise Edition data source. See Oracle BI EE Functions.