Re: Filtering using member key in mdx query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Deepak Puri <deepak_puri@xxxxxxxxxxxxxxx>
Date: Mon, 25 Apr 2005 00:16:33 -0700

Maybe I'm missing something, but if you have the member name, why can't
you use it in the where slicer? If it's available as a string, you can
use StrToMember(), like:

where (StrToMember("MyMemberName"))

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.

Follow-Ups:
- Re: Filtering using member key in mdx query
  - From: karthik kt

References:
- Re: Filtering using member key in mdx query
  - From: ktk

Prev by Date: RE: DSO function failed
Next by Date: Re: Filtering using member key in mdx query
Previous by thread: Re: Filtering using member key in mdx query
Next by thread: Re: Filtering using member key in mdx query
Index(es):
- Date
- Thread

Relevant Pages

Re: What is Good In MDX
... server time to process it. ... on the mdx not on the design mode of the server because i get the query from ... member.DateRange AS ... "Deepak Puri" wrote: ...
(microsoft.public.sqlserver.olap)
Re: Filter,Slicer
... review your code with detail and finally understand what I needed to to. ... I have Created one set for each Dimension and then create a agregated Member ... "Deepak Puri" wrote: ...
(microsoft.public.sqlserver.olap)
Re: mdx formula
... the formula is used in a calcutaded member in the same dimension. ... Total Variable Cost ... Deepak Puri wrote: ...
(microsoft.public.sqlserver.olap)
Re: Slow member loading in excel 2003 pivot table
... really interresting idea! ... I'm going to try it but wouldn't that give me "wrong" measures if i simply exclude these low count values? ... "Deepak Puri" wrote in message ... "unknown" member. ...
(microsoft.public.sqlserver.olap)
Re: mdx formula
... the formula is used in a calcutaded member in the same dimension. ... Eje. ... Deepak Puri wrote: ...
(microsoft.public.sqlserver.olap)