ClearAllDescriptionsInSubCube

Removes the cell text from all the cells in a subcube. The subcube is identified by ClearAllDescriptionsInSubCube’s arguments. (For information on subcubes, see About Subcubes.)

Syntax

<HsvData>.ClearAllDescriptionsInSubCube lScenario, lYear, lPeriod, lEntity, lParent, lValue

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.
lEntity	Long (ByVal). The member ID of the cell's Entity dimension member.
lParent	Long (ByVal). The member ID of the parent of the lEntity argument's entity.
lValue	Long (ByVal). The member ID of the cell's Value dimension member.

Example

The following example clears the cell text in all cells contained by a subcube. The subcube is identified by the member IDs passed in the calls to the user-defined GetMemberID function; for details on GetMemberID, see the Examples for GetItemID.

Dim lScen As Long, lYear As Long, lPer As Long
Dim lEnt As Long, lPar As Long, lVal As Long
lScen = GetMemberID(DIMENSIONSCENARIO, "Actual")
lYear = GetMemberID(DIMENSIONYEAR, "2000")
lPer = GetMemberID(DIMENSIONPERIOD, "July")
lEnt = GetMemberID(DIMENSIONENTITY, "Connecticut")
lPar = GetMemberID(DIMENSIONENTITY, "UnitedStates")
lVal = GetMemberID(DIMENSIONVALUE, "USD")
m_cData.ClearAllDescriptionsInSubCube lScen, lYear, lPer, _ 
lEnt, lPar, lVal