DoesDataExist

Indicates whether any data exists in the cells intersected by the Scenario, Year, and parent and child Entity dimension members specified in the arguments.

DoesDataExist returns FALSE if the specified parent entity’s cells do not contain data, regardless of whether the child entity’s cells contain data.

Syntax

<HsvData>.DoesDataExist lScenario, lYear, lEntity, lParent, pvbExist

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.
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.
pvbExist	Boolean. Returns TRUE if any of the cells contain data, otherwise FALSE.

Example

This example shows how to call DoesDataExist and then test the pvbExist argument. If DoesDataExist returns FALSE, any code placed in the If structure would be executed. The example assumes that the variables for the member ID arguments have been previously set in another procedure.

m_cHsvData.DoesDataExist lScen, lYr, lEnt, lPar, bExists
If bExists = False Then
  …
End If