Hi all,
I have a cube that has some hidden measure and I would like to get a list of them with ADOMD. However I can only get the visible ones. Any ideas? Do you know an API that would do that?
Here is my code:
Set iCubeD = mCatalog.CubeDefs.Item(mCubeName)
For i = 0 To iCubeD.Dimensions.Count - 1
Set iDim = iCubeD.Dimensions.Item(i)
if StrComp(iDim.Name, "Measures", vbTextCompare) = 0 Then
For Each iHier In iDim.Hierarchies
For Each iLev In iHier.Levels
For Each iMember In iLev.Members
' And this will only iterate through visible members.
Thanks,
Shab
I have a cube that has some hidden measure and I would like to get a list of them with ADOMD. However I can only get the visible ones. Any ideas? Do you know an API that would do that?
Here is my code:
Set iCubeD = mCatalog.CubeDefs.Item(mCubeName)
For i = 0 To iCubeD.Dimensions.Count - 1
Set iDim = iCubeD.Dimensions.Item(i)
if StrComp(iDim.Name, "Measures", vbTextCompare) = 0 Then
For Each iHier In iDim.Hierarchies
For Each iLev In iHier.Levels
For Each iMember In iLev.Members
' And this will only iterate through visible members.
Thanks,
Shab