Search google for "ssrs dynamic connection string".

You can build the connection string from parameter information. There are some pretty clear examples if you look around a bit.

You don't actually do that. Do the formatting as you have (not that I like the format), but leave it alone.

In your dimension definition, you can configure a "Name"...

There is actually a ValueFilter() MDX function just for this.

It is a relatively slow function, so avoiding it is typically a good idea.

So now let's discuss those people that post without reading the entire thread...

Being that I am weighing in on this later this may already be covered and I missed it...

Don't use notification services - the feature has been removed from SQL Server.

There are a lot of ways to deal with this. It will depend on your network structure,...

There are plenty of broken-english or "google translated" postings that have no hint of this type of entitlement.

It's the individual, not the language barrier.

Or at least share whatever it is the're smoking.

The transaction will remain open as long as the connection is open. If you close the connection without issuing a commit, the transaction will be rolled back.

That is a bit open-ended.

Can you be more specific on your replication configuration?

The rendering in BIDS is sometimes a little different. Gaps like you are describing are often just mis-aligned controls. Make sure you don't have something a little bit...

Ok, here we go again.

This is one of the best ones I have seen in awhile.

http://www.sqlservercentral.com/Forums/Topic607321-146-1.aspx

Jeff, I don't know if there is a way you could have responded with more...

Ok, you all have way too much time on your hands.

Look up TABLESAMPLE in BOL.

The side-by-side upgrade is the way to go. Are you going to use diffeent hardware, or just a second instance?

Obviously, new hardware is best, but either plan will work....

Sure, I agree with much of that argument, and I tend to not use GUID's unles necessary, but in your case, that is not really the point.

You have a system...