HypGetRowCount

Data source types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)

Description

HypGetRowCount() returns the number of row dimensions.

Note:

This function is used specifically with dynamic link views, as described in VBA Functions and Dynamic Link Views.

Syntax

HypGetRowCount()

Return Value

Returns number of row dimensions if successful; otherwise, returns the negative error code.

Example

Declare Function HypGetRowCount Lib "HsAddin" () As Long

Sub Macro()
   Dim vtGrid as Variant
   Sts = HypConnect(Empty, "system", "password", "MyDemoBasic")
   Sts = HypRetrieve(Empty)
   Range (“B2”).Select
   Sts = HypGetSourceGrid (Empty, vtGrid)
   Sts = HypGetRowCount ()
End sub