Data sources:
Supports both shared and private connections:
Essbase
Financial Management
Planning
Supports private connections only:
Hyperion Enterprise
If you are familiar with the contents of your database, you can use the Smart View functions described below to perform operations on specific data in Excel cells.
HsGetValue: Retrieves data from a data source.
HsSetValue: Sends values to the data source.
HsCurrency: Retrieves the entity currency for the selected members.
HsDescription: Displays the description for the default member.
HsLabel: Displays the label for the default member.
HsGetText: Retrieves cell text from the data source.
HsSetText: Sends cell text to the data source.
HsGetVariable: Retrieves the associated value for a substitution variable.
HsGetSheetInfo: Retrieves detailed information about the current worksheet.
Note: | When using the above Smart View functions, 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. |