in

jetlounge

the minty fresh blog that whitens your teeth!


Syndication


Enforce Perspective Use in SQL Report Builder Models

by David Leibowitz | December 15, 2007 | Comments: 0

Typically you'll lock down access to a SQL Reporting Services Model by creating a Perspective, either for security or to limit the amount of attributes available for a report. By default, the main model will be available in Report Builder with children listed for your available Perspectives.
But Report Builder is meant for ad-hoc generation by non-technical users. They might click the parent model instead of a perspective since it's the first entity they see on the screen or since they just don't know any better.
To help guide those users and to enforce the use of a Perspective you can disable the ability to build reports from the main model.

  • From the Report Model builder in MS BIDS (Visual Studio), create your perspectives. 
  • Click the main model and look for Properties 
  • Select the elipsis (...) in the Custom Properties item
  • When the Popup appears, click Add and create a new property with the following values:
     DataType: Boolean
     LocalName: MustUsePerspective
     Namespace: http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign
     Value: True
  • Save and deploy your model
del.ico.us digg this technorati BlinkList Furl reddit DotNetKicks google! live Facebook Stumble Upon Yahoo!



Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
Powered by Community Server (Non-Commercial Edition), by Telligent Systems