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
“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.