Using Functions
If you are familiar with the contents of your database, you can use the Oracle Smart View for Office functions described in Table 19-1 to perform operations on specific data in Excel cells.
Note:
When using the Smart View functions in Table 19-1, do not use the hash mark (#
) or the semicolon (;
) in member names, dimension names, or variable names. These characters are reserved for delimiters in the functions noted in this chapter.
Table 19-1 Smart View Functions and Supported Providers
Function | Description | Supported Providers |
---|---|---|
Retrieves data from a data source. |
|
|
Sends values to the data source. |
|
|
Retrieves detailed information about the current worksheet. |
Provider-independent |
|
Displays the alias of the specified dimension member. |
|
|
Displays the description for the default member. |
|
|
Retrieves the associated value for a substitution variable. |
Oracle Analytics Cloud - Essbase |