Data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Oracle Hyperion Financial Management (ad hoc only)
Description
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.
Syntax
HypGetColCount()
Return Value
Returns the number of column dimensions if successful; otherwise, returns the appropriate error code.
Example
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