Share via

Requiring Report Builder users to choose a perspective

  • Article

Some customers have report models that are large enough they do not expect any user to ever request the entire model, and would actually prefer to disallow that option, and require them to choose a perspective instead. There is an undocumented and unsupported feature that provides this behavior in the current release. It is used by Analysis Services when generating a report model over a cube.

The simplest approach is to use the SOAP API's to add a custom property to the report model with name = "MustUsePerspective" and value = "true".

If you wish, you can add a similar custom property to the report model within Model Designer, set the property data type to Boolean, set the namespace to "https://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign", and whenever you publish the model the corresponding server property will be added automatically.

Comments

  • Anonymous
    March 17, 2007
    Hi Bob,How can I use stored procedures to create a report model. I saw some posts on MSDN forums but it is not clear. Please enlighten us with an article, Scores of users like me are interested to know how to accomplish this.
  • Anonymous
    March 29, 2007
    The comment has been removed
  • Anonymous
    April 07, 2007
    The comment has been removed
  • Anonymous
    September 11, 2007
    I want get the modelitems in a report server model and also included in a perspective. I am trying to do this desperately. Plz can you help me anyway to achive this?  
  • Anonymous
    January 06, 2009
    Hi,We are currently looking for a report writer where non technical users can write their own reports.  I've heard that reporting services is capable of handling this task.  Please enlighten about this.Thanks...http://www.lugaluda.com
  • Anonymous
    April 27, 2009
    Customer report models that vary in size from a few to a few hundred entities. Little Northwind with