Indicates whether sparse data exists for the specified cell. A dimension that may not contain data for every combination of dimension members is considered sparse.
DoesSparseDataExist returns FALSE if the specified parent entity’s cells do not contain sparse data, regardless of whether the child entity’s cells contain sparse data.
Syntax
<HsvData>.DoesSparseDataExist lScenario, lYear, lPeriod, lEntity, lParent, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, pvbDataExists
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 Parent dimension member. |
lEntity | Long (ByVal). The member ID of the cell's Entity dimension member. |
lParent | Long (ByVal). The member ID of the cell's Period dimension member. |
lValue | Long (By Val). The member ID of the cell's Value dimension member. |
lAccount | Long (By Val). The member ID of the cell's Account dimension member. |
lICP | Long (By Val). The member ID of the cell's Intercompany Partner dimension member. |
lCustom1 | Long (By Val). The member ID of the cell's Custom 1 dimension member. |
lCustom2 | Long (By Val). The member ID of the cell's Custom 2 dimension member. |
lCustom3 | Long (By Val). The member ID of the cell's Custom 3 dimension member. |
lCustom4 | Long (By Val). The member ID of the cell's Custom 4 dimension member. |
pvbDataExists | Boolean (By Val). Boolean. Returns TRUE if the cell contains sparse data, otherwise FALSE. |