Displaying member name instead of key in query

In the tools that I have used for getting generated MDX queries (Query Analyzer, Proclarity, Excel) the query always seems to show the key value instead of the member name.

Is it possible or is there a query tool that will generate queries with the member name instead?

See example:

[Organization].&[152551]

Should read

[Organization].[By Division]

thanks,

Andrew

Set "MemberNamesUnique" to True for a particular attribute. That should do it|||

Thanks! Didn't even have to reprocess!

cheers,

Andrew

Display estimated execution plan problem

Hi all,
I have a complex query inside a stored procedure. When I try to see the
estimated query plan from Query Analyzer it hangs (I wait for at least one
minute).
When I stoped the QA with the red button it answers with a syntax error...
But there aren't syntax errors... I tried to do the same in another
environment and all things work.
Any idea?
Thank you very much!!
Alexandre Calderaro
Avanade Italy
Hi Alex my colleage :-)
Same Compatibility level ? If you use another compat. level some
statements might not be able to compile.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de

Display estimated execution plan bug

Hello. I'm using SQL2000, and I have a problem.
Each time I try to display estimated execution plan in Query Analyzer, the
graphical plan shows optimization costs 0%, 100%, or 600%, and the cost is
shown only for the first step. I installed sp4, but that didn't change
anything. I know I can use showplan_all, but it's better to have a graphical
display. I saw on Microsoft's web pages that this is a bug
(http://support.microsoft.com/defaul...Ben-us%3B274643), but
they are saying that it comes in some cases and I get it all the time.
Please help.
Draen Grabovac.Did you try to change the windows regional settings so that the decimal sepa
rator is . and not , ?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Grabi" <drazen@.git.hr> wrote in message news:dvjiib$kjf$1@.ss405.t-com.hr...
> Hello. I'm using SQL2000, and I have a problem.
> Each time I try to display estimated execution plan in Query Analyzer, the
> graphical plan shows optimization costs 0%, 100%, or 600%, and the cost is
> shown only for the first step. I installed sp4, but that didn't change
> anything. I know I can use showplan_all, but it's better to have a graphic
al
> display. I saw on Microsoft's web pages that this is a bug
> (http://support.microsoft.com/defaul...Ben-us%3B274643), but
> they are saying that it comes in some cases and I get it all the time.
> Please help.
> Draen Grabovac.
>