SSRS connectivity in a Consortium

This can be a complex issue depending on the agreement within your consortium (consult your consortium SLA if you have one), but at the very least this involves these issues:

- Secure access to Tessitura databases for read-only access to relevant tables and secured (control group) views, and Stored Procedures

- Access to tools for report development such as Business Intelligence Development Studio and Management Studio.

- Access to hosted network with appropriate permissions to access databases, tools and SSRS.

There is no standard DB role provided with Tessitura for read-only reporting access, and not providing control group access solely.  This can be accomplished by creating your own role in the Tessitura db with read-only rights to the database objects required.  You would need, beyond the db connection, a way to ensure control group security is applied to your database connection.  This can be accomplished in several ways, but it may be useful to look into the External Control Group Security option provided by the Tessitura Network.  This add-on is available on TASK in the Version Releases and Patches project.

As for analysis services, there is no inherent control group security in any hand-rolled cube.  The TStats cubes are “control grouped” by dividing the cubes into logical security chunks called “divisions”.  You either have full rights to a cube or you don’t.

I hope that is at least a good “start”, and if you need further assistance, I would check with other licensees who have gone down this route, or maybe have a conversation with Network consulting who may be able to assist with your needs further.

Best,

-Ryan

We are presently sublicensees in a consortium.  I would like to connect to the SQL Server 2005 database and Analysis Services of our host (main Licensee) to use SSRS to build and deploy reports.  Everything is control grouped at our Center for Perf Arts and we are not on the same network.    What would the best method be to obtain this and maintain security between the sharing entities on the system.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!