Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get a list of hidden cube measure with ADOMD

Status
Not open for further replies.

Shab

Programmer
Oct 9, 2001
60
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top