Pushing Smart View Private Connections to Users

I worked with the other Schwartberg (Ross, not Glenn.  Which, by the way, are both equally smart) on another issue a few weeks ago.  A client asked him to create a script to push Private Smart View Connections to each user.  You see,  if you share workbooks and don’t have the EXACT Smart View connection, the workbooks  will  break and armageddon will ensue.

First step, onnected to Shared Connections, find the database that needs the private  connection.

Right click on the database, select Private Connection


Create a name for the connection. I suggest using a name that best reflects the database:  Finance_Prod, etc.


Verify your Private Connection.


Now for the fun part!  Let’s mess with our Registry again!  Kids, don’t try this at home.

Navigate to the following folder:

HKEY_CURRENT-USER\Software\Hyperion Solutions\HyperionSmartView\Connections listed by connection name.


Right Click on Connections and export everything in the folder as SVConnections.reg.



Edit the file to include only the connections that need to be publisehd. For example:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Hyperion Solutions\HyperionSmartView\Connections]

“EssbaseCluster1_Finance_Prod”=hex:ff,ff,07,00,0e,00,49,48,79,70,43,6f,6e,6e,65,\ 63,74,69,6f,6e,ff,fe,ff,04,74,00,65,00,73,00,74,00,ff,fe,ff,05,61,00,64,00,\6d,00,69,00,6e,00,ff,fe,ff,24,68,00,74,00,74,00,70,00,3a,00,2f,00,2f,00,73,\00,61,00,6e,00,64,00,62,00,6f,00,78,00,63,00,76,00,3a,00,31,00,39,00,30,00,\30,00,30,00,2f,00,61,00,70,00,73,00,2f,00,53,00,6d,00,61,00,72,00,74,00,56,\ 00,69,00,65,00,77,00,ff,fe,ff,10,45,00,73,00,73,00,62,00,61,00,73,00,65,00,\43,00,6c,00,75,00,73,00,74,00,65,00,72,00,2d,00,31,00,ff,fe,ff,04,44,00,65,\00,6d,00,6f,00,ff,fe,ff,05,42,00,61,00,73,00,69,00,63,00,ff,fe,ff,25,41,00,\ 6e,00,61,00,6c,00,79,00,74,00,69,00,63,00,20,00,53,00,65,00,72,00,76,00,69,\ 00,63,00,65,00,73,00,20,00,53,00,6d,00,61,00,72,00,74,00,20,00,56,00,69,00,\65,00,77,00,20,00,50,00,72,00,6f,00,76,00,69,00,64,00,65,00,72,00,ff,fe,ff,\ 00,ff,fe,ff,00,01,00,00,00,00,00,00,00,ff,fe,ff,1a,41,00,6e,00,61,00,6c,00,\79,00,74,00,69,00,63,00,20,00,50,00,72,00,6f,00,76,00,69,00,64,00,65,00,72,\ 00,20,00,53,00,65,00,72,00,76,00,69,00,63,00,65,00,73,00,ff,fe,ff,04,6e,00,\ 6f,00,6e,00,65,00,ff,fe,ff,00,ff,fe,ff,00,ff,fe,ff,26,7b,00,35,00,36,00,43,\ 00,34,00,33,00,43,00,32,00,45,00,2d,00,38,00,38,00,45,00,35,00,2d,00,34,00,\32,00,37,00,42,00,2d,00,39,00,43,00,42,00,38,00,2d,00,43,00,33,00,32,00,33,\00,44,00,36,00,42,00,45,00,45,00,45,00,30,00,30,00,7d,00,ff,fe,ff,00

Save your changes.

The changes can manually be applied for the users by simply giving them the .reg file.  They double-click on it to insert the connections into their registry.

Administrators can also use Group Policy Management to deploy these registry entries to a group of users.





Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s