There is a role named Report Builder, just assign it to your users.

For the Report Builder to be used, first you have to create and deploy a report model.

Here...

Try this:

http://www.mssqltips.com/tip.asp?tip=1046

When you start the server with sqlservr -c -m, the server is in single-user mode, so all system databases are already in single-user mode.

From EM, just right-click the master database,...

To restore master: http://msdn2.microsoft.com/en-us/library/aa173515(SQL.80).aspx

To restore msdb, model: you restore these databases as any other db and after you restore the master db.

Stop SQLServer Agent when restore msdb.

It's not...

For SQL 2000, there is a separate CD for reporting services. Ask your vendor for it or if you have access download it from technet.

Yes, Olap Admins can do whatever they want on the server (create, edit, delete cubes, change server settings, etc.) and cannot be limited.

The users need read-only access to the cubes...

The objects (cubes, dimensions, etc) are created and published from BIDS. After you create the project, deploy it to the server. In BIDS, go to project properties, then deployment, set...

May be this help:

http://support.microsoft.com/kb/280106

http://msdn2.microsoft.com/en-us/library/ms152516.aspx

Try to add the schema to the query:

update linkedoracleserver..SCHEMA.ORACLETABLE

set fieldname = 'TT'

You can have one cube with all measures and then create virtual cubes with just the measures you need.

For example, create a virtual cube named margin and just add measures...

They are stored in the ReportServer database.

May be both, that depends on what you want to analyze.

If you just want to categorize the work by project, then project is a dimension. But if you also...

Try to add the user: NT AUTHORITY\ANONYMOUS LOGON.

Also, you could try to create a local user with the same credentials as the user logged on the client pc.

AS2000 does not have measure groups, so basically you cannot classify them.

It uses Analysis Services 9.0 OLE DB Provider, you have to install it in every workstation.