I had the same Problem today.

For me the Setup was:

* I am not sysadmin on the Server

* I was not the owner of the job (the Job was owned by...

Hi Rick,

sorry, I hadn't thought of that problem.

I have one idea which might work. You could build your 3rd mdx in such a way that it always returns at least...

Rick,

Maybe I get your question wrong, but wouldn't it help to do a left join to the last query, so it would return the results of the first two queries...

Hi dave-dj,

the SSAS article has been published under http://www.sqlservercentral.com/articles/Linked+Server/63867/[/url]

Take care

Martin

Hi Ron,

you can use the approach shown in this article to create a report which gets its content from more than one cubes:

For example you have one mdx which...

Hi Sergio,

I published the SSAS-article on SQLServerCentral a while ago. You should find it here: http://www.sqlservercentral.com/articles/Linked+Server/63867/

[/url]

Concerning SQL Server 2008:

The Reporting Services 2008 has a new control called "tablix" ("table" and...

Hi Ben,

how did you configure the Security tab of the Linked Server Properties?

I attached a screen shot where I erased the login names.

In the red area you can assign a...

Matteo (7/24/2008)

---

Another way to do this using more of the native function of the Matrix would be to create a grouping column, where one group value is tied to the...

Hello bteague,

I hope to have that article written within the next week.

But I do not know how long it takes for the article to be published.

Martin