Can i do Wild card search in dimension? or is there any way to search members starting from any specific Character ? For Example : querying for : a% or a* It will give me all the members in the specified dimension starting with character 'a'. or any string provided. Thanks in advance Faraz
You can do something like: SELECT Filter( level.members, instr(hierarchy.currentmember.caption, expression) >= 0 ) ... The VBA functions can give you the wild card type functionality that you are looking for. Note that this may not be very efficient for large amounts of data... 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. "Faraz" wrote in message news:1124205165.240273.185400@z14g2000cwz.googlegroups.com... > Can i do Wild card search in dimension? or is there any way to search > members starting from any specific Character ? > > > For Example : > > > querying for : a% or a* > > > It will give me all the members in the specified dimension starting > with character 'a'. or any string provided. > > > Thanks in advance > > > Faraz >
I think the result the this MDX will return me all the members containing the Expression . I want to get all the members starting with the expression Akshai Mirchandani [MS] wrote: > You can do something like: > SELECT Filter( level.members, instr(hierarchy.currentmember.caption, > expression) >= 0 ) ... > The VBA functions can give you the wild card type functionality that you are > looking for. Note that this may not be very efficient for large amounts of > data... > > 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. > > "Faraz" wrote in message > news:1124205165.240273.185400@z14g2000cwz.googlegroups.com... > > Can i do Wild card search in dimension? or is there any way to search > > members starting from any specific Character ? > > > > > > For Example : > > > > > > querying for : a% or a* > > > > > > It will give me all the members in the specified dimension starting > > with character 'a'. or any string provided. > > > > > > Thanks in advance > > > > > > Faraz > >
Use Instr = 0 then (or Left)... 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. "Faraz" wrote in message news:1124437481.156283.295480@z14g2000cwz.googlegroups.com... > > I think the result the this MDX will return me all the members > containing the Expression . I want to get all the members starting with > the expression > > Akshai Mirchandani [MS] wrote: > > You can do something like: > > SELECT Filter( level.members, instr(hierarchy.currentmember.caption, > > expression) >= 0 ) ... > > The VBA functions can give you the wild card type functionality that you are > > looking for. Note that this may not be very efficient for large amounts of > > data... > > > > 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. > > > > "Faraz" wrote in message > > news:1124205165.240273.185400@z14g2000cwz.googlegroups.com... > > > Can i do Wild card search in dimension? or is there any way to search > > > members starting from any specific Character ? > > > > > > > > > For Example : > > > > > > > > > querying for : a% or a* > > > > > > > > > It will give me all the members in the specified dimension starting > > > with character 'a'. or any string provided. > > > > > > > > > Thanks in advance > > > > > > > > > Faraz > > > >
