mdx queries

#1

I'm quite new to OLAP, so pls excuse me for silly question. Is there place
in AS where I can type in and issue my mdx queries, sort of QA in SQL
Server? I couldn't find at first glance.

--

Thank you,

Alex

#2

Try the MDX Sample Application that comes with Analysis Services. It is not
as extensive as QA, but it is all you've got without buying a third party
tool. There is supposed to be an MDX query development app built in to SQL
Server 2005.
"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote

Quote:

I'm quite new to OLAP, so pls excuse me for silly question. Is there place
in AS where I can type in and issue my mdx queries, sort of QA in SQL
Server? I couldn't find at first glance.

--

Thank you,

Alex

#3

Thank you Mark for response,
Still have couple of questions.
I can run MDX queries of any type in MDX Sample Application, I mean without
any limitations?
And could you please name some of those third party tools offhand?

"Mark Job" <markDOTjobATimmedientDOTcom> wrote

Quote:

Try the MDX Sample Application that comes with Analysis Services. It is
not
as extensive as QA, but it is all you've got without buying a third party
tool. There is supposed to be an MDX query development app built in to
SQL
Server 2005.
"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote in message
news:10fr27d34u59lf7 (AT) corp (DOT) supernews.com...
I'm quite new to OLAP, so pls excuse me for silly question. Is there
place
in AS where I can type in and issue my mdx queries, sort of QA in SQL
Server? I couldn't find at first glance.

--

Thank you,

Alex

#4

Not sure what you mean by "limitations". If it is valid MDX, you can run it
in the Sample App. What will be returned might be limited, e.g. what
attributes. The XML for Analysis 1.1 application also has a sample app. It
is much more limited in its handling of the text that makes up query files,
but through XML it exposes a lot more of MDX functionality (when you view
Results as XML).

ProClarity is the main tool that comes to mind. If you pick up some of the
major MDX textbooks, they usually have a trial version of one of these tools
included. Spofford's "MDX Solutions" (by far the best book on MDX) has MDX
Builder 2.0, but I don't know if the vendor of this product (BI Sense) still
exists. Fast Track to MDX by Whitehorn et al has a trial of ProClarity.

"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote

Quote:

Thank you Mark for response,
Still have couple of questions.
I can run MDX queries of any type in MDX Sample Application, I mean
without
any limitations?
And could you please name some of those third party tools offhand?

"Mark Job" <markDOTjobATimmedientDOTcom> wrote in message
news:u8WB0qqbEHA.1732 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Try the MDX Sample Application that comes with Analysis Services. It is
not
as extensive as QA, but it is all you've got without buying a third
party
tool. There is supposed to be an MDX query development app built in to
SQL
Server 2005.
"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote in message
news:10fr27d34u59lf7 (AT) corp (DOT) supernews.com...
I'm quite new to OLAP, so pls excuse me for silly question. Is there
place
in AS where I can type in and issue my mdx queries, sort of QA in SQL
Server? I couldn't find at first glance.

--

Thank you,

Alex

#5

Thank you Mark for comprehensive explanation.

Alex

"Mark Job" <markDOTjobATimmedientDOTcom> wrote

Quote:

Not sure what you mean by "limitations". If it is valid MDX, you can run
it
in the Sample App. What will be returned might be limited, e.g. what
attributes. The XML for Analysis 1.1 application also has a sample app.
It
is much more limited in its handling of the text that makes up query
files,
but through XML it exposes a lot more of MDX functionality (when you view
Results as XML).

ProClarity is the main tool that comes to mind. If you pick up some of
the
major MDX textbooks, they usually have a trial version of one of these
tools
included. Spofford's "MDX Solutions" (by far the best book on MDX) has
MDX
Builder 2.0, but I don't know if the vendor of this product (BI Sense)
still
exists. Fast Track to MDX by Whitehorn et al has a trial of ProClarity.

"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote in message
news:10fr8v1qfamuj51 (AT) corp (DOT) supernews.com...
Thank you Mark for response,
Still have couple of questions.
I can run MDX queries of any type in MDX Sample Application, I mean
without
any limitations?
And could you please name some of those third party tools offhand?

"Mark Job" <markDOTjobATimmedientDOTcom> wrote in message
news:u8WB0qqbEHA.1732 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Try the MDX Sample Application that comes with Analysis Services. It
is
not
as extensive as QA, but it is all you've got without buying a third
party
tool. There is supposed to be an MDX query development app built in
to
SQL
Server 2005.
"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote in message
news:10fr27d34u59lf7 (AT) corp (DOT) supernews.com...
I'm quite new to OLAP, so pls excuse me for silly question. Is there
place
in AS where I can type in and issue my mdx queries, sort of QA in
SQL
Server? I couldn't find at first glance.

--

Thank you,

Alex

#6

Panorama Software (http://www.panoramasoftware.com) are well worth a look as well!

Regards
Jamie

"Alex" wrote:

Quote:

Thank you Mark for response,
Still have couple of questions.
I can run MDX queries of any type in MDX Sample Application, I mean without
any limitations?
And could you please name some of those third party tools offhand?

"Mark Job" <markDOTjobATimmedientDOTcom> wrote in message
news:u8WB0qqbEHA.1732 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Try the MDX Sample Application that comes with Analysis Services. It is
not
as extensive as QA, but it is all you've got without buying a third party
tool. There is supposed to be an MDX query development app built in to
SQL
Server 2005.
"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote in message
news:10fr27d34u59lf7 (AT) corp (DOT) supernews.com...
I'm quite new to OLAP, so pls excuse me for silly question. Is there
place
in AS where I can type in and issue my mdx queries, sort of QA in SQL
Server? I couldn't find at first glance.

--

Thank you,

Alex

#7

There is. The querying tool is integrated with the replacement for Query Analyser (SQL Server Workbench) so you can seamlessly move between querying SQL Server and Analysis Services from the same environment.

Regards
Jamie

"Mark Job" wrote:

Quote:

Try the MDX Sample Application that comes with Analysis Services. It is not
as extensive as QA, but it is all you've got without buying a third party
tool. There is supposed to be an MDX query development app built in to SQL
Server 2005.
"Alex" <alex_removethis_ (AT) healthmetrx (DOT) com> wrote in message
news:10fr27d34u59lf7 (AT) corp (DOT) supernews.com...
I'm quite new to OLAP, so pls excuse me for silly question. Is there place
in AS where I can type in and issue my mdx queries, sort of QA in SQL
Server? I couldn't find at first glance.

--

Thank you,

Alex

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

mdx queries

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

mdx queries - 07-20-2004 , 04:04 PM

Re: mdx queries - 07-20-2004 , 05:41 PM

Re: mdx queries - 07-20-2004 , 05:59 PM

Re: mdx queries - 07-20-2004 , 06:48 PM

Re: mdx queries - 07-20-2004 , 06:53 PM

Re: mdx queries - 07-21-2004 , 03:11 AM

Re: mdx queries - 07-21-2004 , 03:15 AM