jetlounge

In SQL Server 2005 Reporting Services you can Increase your Model reusability and development productivity by creating Perspectives. You then limit the usage of a Model only to those Perspectives, rather than the huge monster views.

In Report Model designer, (BIDS), select the top node of the model called, "Model".

In Properties, click the elipsis next to CustomProperties.
Add a New Member with the following details:
DataType : Boolean
Name \ LocalName: MustUsePerspective
Namespace : http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign
Value  : True

Redeploy the Model.

Now when you launch Report Builder the main Model will be grey, but users may select the Perspectives below.