Hi, I have this problem, too.

Changing the content in Reportserver Database does not seem to be a feasible solution to me. I do not want to think of what...

thx for the tip, see my comment thereover if interested...

Hi,

the disadvantage of dropping the fk_relationship is that it could last a while until it is recreated. In SQL 2005 there is another way, you could disable the fk,...

Hi,

I had problems with building a linked server using the installed drivers of Client Access for iseries on a x64 machine. I could solve the problem using the OLEDB...

This a book about the theme:

http://www.amazon.com/gp/product/0471462616

Hi,

there are a lot of books on the market. For a general overview about the concepts I would suggest to read the books from Kimball. There is also a...

Hi,

there are several possibilities which could help:

x Maybe you could "tune" the processing of the cube by using other processing options as full process. You could use incremental...

Hi,

this sounds like an authentification problem. SSAS does use Integrated Windows Authentification only. This means that the current user's credentials (on your client) (user + password) are used to...

Hi,

what was not mentioned in this thread was that Performance Point is the tool from MS with which you could do Planing. (e.g. budget planing) This completes the BI...

Hi,

if you process the cube database (full process) in Management studio, using the GUI some more details about the key log errors were provided. So you should see which...

Hi,

the problem that you could not schedule the package sounds like a security problem. If you want to access the odbc connection using a user and a password you...

Hi,

heres a pretty good website about available ODBC connections for SQL Server http://ssis.wik.is

If you do not get it to work using OLEDB/ODBC drivers and so on a possible...

Hi,

try to check the error logs of reporting services on your machine. These files is under your SQL Server installation path MSSQL.3\Reporting Services\LogFiles . Normally 4 files log different...

Hi,

I would begin with 1 dimension for the customer. The ship to and bill to adresses are attributes of the customers and it is possible to build more than...

Hi,

it is no problem to change the data source view. You have several posibilities:

Open Bi Development Studio - Open - Analysis Services database - choose your server and...