Using Functions
If you are familiar with the contents of your database, you can use Oracle Smart View for Office functions to perform operations on specific data in Excel cells.
Note:
When using the Smart View functions in Table 18-1, as a best practice, 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 18-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. |
Essbase |
|
Use this to quickly identify the shared connection data source that is being used. |
|