Is there a way (using MDX) to query member names from a dimension by providing some criteria? I Think I've seen (in passing) someone using custom VB functions in Dlls to accomplish something like this... Here is a sample Scenario given a dimension (and level), return a list of member names that meet some criteria. something like: give me all members of dimension "A", Level "Manager" containing "joe" (as a substring)...
This may need tweaking but for example: select {} on 0, filter( [A].[Manager].members, instr( [A].currentmember.name, "joe" ) > 0 ) on 1 from cube You would need to use VBA functions to do the substring type operations... HTH, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Eric S" wrote in message news:1141239701.091418.90770@t39g2000cwt.googlegroups.com... > Is there a way (using MDX) to query member names from a dimension by > providing some criteria? > > I Think I've seen (in passing) someone using custom VB functions in > Dlls to accomplish something like this... > > Here is a sample Scenario > given a dimension (and level), return a list of member names that meet > some criteria. > > something like: give me all members of dimension "A", Level "Manager" > containing "joe" (as a substring)... >
so nothing goes in the braces {}? on the 0 axis?
Yes. If you leave it an empty set, then no cell values will need to be calculated (because the cellset is empty) and performance can improve in cases when you have lots of cells/calculations. Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Eric S" wrote in message news:1141322545.099362.322950@t39g2000cwt.googlegroups.com... > so nothing goes in the braces {}? on the 0 axis? >
