Function Descriptions

Oracle Smart View for Office provides these functions. Click a function name to access description, syntax, and examples.

HsGetValue: Retrieves data from the data source for selected dimension members of a Point of View.

HsSetValue: Sends a value to the data source for selected dimension members of a Point of View.

HsGetSheetInfo: Retrieves detailed information about the current worksheet.

HsCurrency: Retrieves the entity currency for the selected members.

HsDescription: Displays the description for the default Point of View member.

HsAlias: Displays the alias of the specified dimension member.

HsLabel: Displays the label for the default Point of View member.

HsGetText: Retrieves cell text from the data source.

HsSetText: Sends cell text to the data source.

HsGetVariable: Retrieves the value for a substitution variable.

HsGetSharedConnectionURL: Identifies the shared connection data source that is being used.