Thanks

This is the first thing I tested. Didn't work for me.

Once you find that @@Error is not 0, is there a way to retrieve actual SQL error message? Is there a variable like that?

Thanks

I was wondering about the same thing. What's a filegroup? And why is there more than one?

Thanks

Wow! I looked through the article and found one more surprise - derived table can even be used in a join.

Thanks for your help!

Antares686, Thank you.

Your solution works for me. I didn't know you can substitute the "select" statement for the table name. I tried...

Yes, nobody replied so far...

Thanks for your reply. I'm thinking of escalating the issue to minimize a number of DBAs. We have at least 6.

that makes sense...usually I see this status when remote calls are made through the linked server....

thanks for your reply....

select @mdxstr = 'select * from openquery(linked_server_OLAP, "' + @your_mdx + '")'

execute (@mdxstr)

Thanks guys,

Both solutions seem to work.

Steve,

I tried to set the formatting within the cube - Cube -> Edit. That works only within the cube. I can get this data to show the way I want...

This seems to work.

Thanks Guarddata!!!

Thanks for your reply.

I tried to find an MDX function that would do that, but was unsuccessful. Here are some more details about this problem.

What happens is the data comes...

Thanks for your replies, guys.

What happens is the data comes back from the cube in the nvarchar format which I cannot immediately convert to decimal or numeric. I'm forced to...