You should be able to generate a report model for a cube from Management
Studio:

http://msdn2.microsoft.com/en-us/lib...4(SQL.90).aspx

You can generate models from an Analysis Services cube or a SQL Server
database using Management Studio. Report models are generated from
shared data sources that are published on the report server. If you do
not already have a shared data source, you must create one.

The report model that you generate is based entirely on the schema of
the shared data source. You cannot choose which parts of the data source
are included in the model, nor can you edit the rules or metadata of a
generated model.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***