Returns a cell’s data, given the member IDs that identify the cell. GetData also indicates whether the cell is null.
Tip: | To get a cell’s data by passing an index, use GetDataAtIndex. For details, see GetDataAtIndex. |
Syntax
<HsvMDDataBufferLite>.GetData lScenario, lYear, lPeriod, lView, lEntity, lParent, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, pdData, pvbIsNoData
Argument | Description |
|---|
lScenario | Long (ByVal). The member ID of the cell’s Scenario dimension member. |
lYear | Long (ByVal). The member ID of the cell’s Year dimension member. |
lPeriod | Long (ByVal). The member ID of the cell’s Period dimension member. |
lView | Long (ByVal). The member ID of the cell’s View dimension member. You must pass a member ID for a user-defined member. Do not pass the member ID for the system-defined member <Scenario View>. |
lEntity | Long (ByVal). The member ID of the cell’s Entity dimension member. |
lParent | Long (ByVal). Pass the HFMConstants type library constant MEMBERNOTUSED. |
lValue | Long (ByVal). The member ID of the cell’s Value dimension member. You must pass a member ID for a user-defined member. Do not pass a member ID for system-defined members such as <Entity Currency>. |
lAccount | Long (ByVal). The member ID of the cell’s Account dimension member. |
lICP | Long (ByVal). The member ID of the cell’s Intercompany Partner dimension member. |
lCustom1 | Long (ByVal). The member ID of the cell’s Custom 1 dimension member. |
lCustom2 | Long (ByVal). The member ID of the cell’s Custom 2 dimension member. |
lCustom3 | Long (ByVal). The member ID of the cell’s Custom 3 dimension member. |
lCustom4 | Long (ByVal). The member ID of the cell’s Custom 4 dimension member. |
pdData | Double. Returns the cell’s data. |
pvbIsNoData | Boolean. Indicates whether the cell is null. Returns TRUE if null, FALSE otherwise. |
Example
The following example returns a cell’s data in the dDataCell variable. The example assumes the cell’s dimension member IDs have previously been defined.