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

SVPC

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

SVURL

Verify your Private Connection.

SVVerify

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.

SVRegisty

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

SVRegistryExp

SVRegSave

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.

Enjoy!

~Sum

 

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s