sql server reporting services: MDX Query Tool Problem -- sql server reporting services

MDX Query Tool Problem

simon p
8/28/2006 11:26:01 AM

sql server reporting services: I am trying to get to grips with cube reporting and am running the MDX Query
Tool against AdventureWorksDW on SQL 2005 sp1, Standard Edition (I am not
fluent in MDX). No matter what dimensions I drag on, the only output I can
get is a single cell / report services field.

For example, if I drag on the geography.country dimension and Sales
Order.Order Count measure, I just get a count of all orders.
--

RE: MDX Query Tool Problem

simon p
8/29/2006 3:39:01 AM

I have found some sample MDX code for AdventureWorks that does work with the
Report Builder. Clearly I need to get more proficient with writing good
queries.

--
simon

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.