Another link...MDX support in Report Builder: http://msdn.microsoft.com/en-us/library/dd220489.aspx

AFAIK Report Builder can be used to build ad hoc reports using a cube as an initial data source.

1. Create and publish a Report Model from an SSAS Cube: http://msdn.microsoft.com/en-us/library/ms345292(v=SQL.105).aspx

2....

What does the error message say?

Sounds like it could be a network route issue. From your machine, what IP does the server name resolve to? Is it the same as the IP address you were...

Sorry this took so long...

I have a testbed setup and can see the XML value from your DB query within a script task...it looks OK and as you mentioned now...

I thought of an option...I haven't done a proof-of-concept on it because I don't have a copy of Visual Studio here that supports SQL Server Database Projects but I did...

DECLARE @x XML = N'<parent><child>Hello World!</child></parent>' ;

SELECT @x.query('/parent/child') ;

Is this for a local instance of SQL Server?

pwalter83 (3/9/2011)

---

Now this is really frustrating. Without even reading the question, you have given a template answer. This way...

First issue: I think the reason why you cannot access the DB from Excel using Windows Auth while your machine is unplugged from the network is because SQL Server cannot...

TK-487581 (3/8/2011)

---

Yes, i've even tried the top 100 percent, but still no good.

So, just confirming - Index is only for performance. It has no hand in sorting the data, right?...

TK-487581 (3/8/2011)

---

Yes, i've even tried the top 100 percent, but still no good.

So, just confirming - Index is only for performance. It has no hand in sorting the data, right?...

The only way to guarantee sort order is to issue an ORDER BY in your query...this is a fundamental concept of set theory.

This may look familiar: The ORDER BY...

This may clear things up:

SELECT CONVERT(DECIMAL(6), 10.95) AS a,

CONVERT(DECIMAL(6, 2), 10.95) AS b

SELECT *

FROM sys.databases

WHERE state_desc != 'ONLINE'