In AS2005 you can use more than one fact table in the same cube.

Also, you can denormilize the tables, making only one; something like this:

select *

from project left join work...

Are you using AS2005? If so, you can create a measure group for each distinct count you want and a measure group for sum.

The measures must be different for the...

You have to give browser access to the users.

Go to the home page, then Properties and click New Role Assignment. Add the group of users or the user and assign...

Yes, it is the way you have to do it in SQL2000.

In the Data Source View you can add tables from distinct data sources. Just create a new DS pointing to the other DB, then edit your DSV to add the...

This query will return the list of tables that belong to FG1 file group:

select o.name

from sysindexes i, sysobjects o, sysfilegroups fg

where i.id = o.id

and i.groupid = fg.groupid

and indid in (1,0)

and...

That's a common problem with AS2000 and distinct count. You have to do a Basket Analysis. I don't know if it's supported in OWC.

More info here:

http://msdn2.microsoft.com/en-us/library/aa902637(sql.80).aspx

It's resolved in AS2005: http://blogs.conchango.com/christianwade/archive/2005/04/03/Distinct-Count-in-Analysis-Services-2005.aspx

9.00.2047 is SP1.

Take a look at here: http://support.microsoft.com/?kbid=321185

You could put the database in emergency mode to copy readable data.

In SQL2000 you do this ( http://www.devx.com/vb2themax/Tip/18624 ) :

update sysdatabases

set status = status | -32768

where name = 'MioSuspectDatabase'

In SQL2005:

ALTER...

This query will show you the information for each databases where there is a table with column name ColName.

sp_msforeachdb 'select table_catalog, table_schema, table_name, column_name, data_type, character_maximum_length

from ?.INFORMATION_SCHEMA.COLUMNS

where column_name = ''ColName''...

with this query you could check which schema the user owns:

select * from information_schema.schemata

where schema_owner = 'user'

You can use the store procedure: sp_msforeachdb to run the query against every database on the system.

http://www.mssqlcity.com/FAQ/Devel/sp_msforeachdb.htm

Try to look in the log files of RS, they are in the LogFiles folder in RS installation folder.

What is the error when you try to connect?

Have you tried to connect from the server?

Right click on the DTS and select Disconnected Edit. Expand Steps and look for the name, in the Description Property you can see the name that is displayed by the...