Data provider types: Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypGetColCount() returns the number of column dimensions.
Note: | It is assumed that a call has already been made to HypGetSourceGrid to initialize the dynamic link query, which contains the information about the active data provider and the grid on the worksheet. |
HypGetColCount()
Returns the number of column dimensions if successful; otherwise, returns the appropriate error code.
Declare Function HypGetColCount Lib "HsAddin" () As Long Sub Example_HypGetColCount() Dim vtGrid As Variant Sts = HypConnect(Empty, "UserName", "Password", "MyDemoBasic") Sts = HypRetrieve(Empty) Range ("B2").Select Sts = HypGetColCount () End sub