Good one, thanks!

Choose 0 and get it wrong, what a winner!! 😛

I'm a fan of Pivot Grid Designer.

http://www.kropka-olap.com/PGD.htm

+1 to Daniel's comment.

Do you happen to have Visual Studio installed? If so, this may help.

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/b6eb12c0-9db5-403a-89b0-db71a153c9a0

Just a thought. Try pulling over the old data, as it is, into the new db. From there, use the old data in the new location as the...

Take a look at this and see if it helps.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82508

I have not personally done this, as I lean toward importing the data into a SQL table, but I...

something like this may work for your purpose, but I think that may depend on

SELECT REPLACE(REPLACE(yourfield, CHAR(13), ''), CHAR(10), '')

This basically replaces the char with nothing.

The only thing you can do is filter out values of a parameter based on a previously selected parameter value (e.g. Choose Illinois as your State and the City parameter...

No, you would not want to attempt to join to fact tables.

You can have two fact tables in a cube that could relate to the same dimensions, but...

That is just plain mean. No call for that in any exchange, whether it be in person or through the perceived anonymity of cyberspace. :ermm:

I would start with the providers first.

http://support.sas.com/demosdownloads/setupcat.jsp;jsessionid=CA0AA101356ACBAF269E323F13B26A8B.tc5j5_external_w1?cat=SAS+Providers+for+OLE+DB

Are you running as Administrator?

Been there myself, and on occasion still forget to change the encryption.

Change the destination db field if you can, or "T"ransform the source to limit the length to 5.

I have seen this "error" many, many times and for me...