Update Smart View options for all Users 2

Second post of the day. I’m working too hard 😉 You all might have done this already at your client, however if you have not then read on.

All of us might have done this one way or the other. Maybe you gave a deck to all Smart View users and made them set the options for Suppression, Update the Shared Services URL and so on.

You don’t need to do all these steps now. It can all be done by a bat file and SmartView.exe

Some things that might interest you are.

Shared Connections URL is coming from a file!!!

Yup if you look under %APPDATA%OracleSmartView you’ll see these files.

Open properties.xml

The default url is under the overrideWorkspaceUrl and all previous ones are under previousURLList

Now if you look at the Options, there are fed from a registry key.

Look for a key called CAOptionsXML under HKCUSoftwareHyperion SolutionsHyperionSmartViewOptions, yup it is a XML (no surprises there)

Now all you’ve to do is to set the Global options from an Admin laptop, copy the value of CAOptionsXML.

Find and replace all ” with “””

Create a Install.cmd file as given below

ziExpand is nothing but your Zoom in Level (rest of them I guess is self explanatory)

taskkill /IM excel.exe /F
taskkill /IM outlook.exe /F
taskkill /IM winword.exe /F
taskkill /IM powerpnt.exe /F
SmartView.exe /s /v"/qn URL=https://<server>:<port>/workspace/SmartViewProviders"
REG.exe ADD "HKCUSoftwareMicrosoftWindowsCurrentVersionInternet Settings" /v "ReceiveTimeOut" /t REG_DWORD /d "4718592" /f
REG.exe ADD "HKCUSoftwareMicrosoftWindowsCurrentVersionInternet Settings" /v "KeepAliveTimeOut" /t REG_DWORD /d "2400000" /f
REG.exe ADD "HKCUSoftwareMicrosoftWindowsCurrentVersionInternet Settings" /v "ServerInfoTimeOut" /t REG_DWORD /d "2400000" /f
reg ADD "HKCUSoftwareHyperion SolutionsHyperionSmartViewOptions" /v CAOptionsXML /d "<root version="""0"""><option key="""ziExpand""" value="""1"""/><option key="""ziAncestor""" value="""0"""/><option key="""indentLevel""" value="""1"""/><option key="""supRowsNoDataMissing""" value="""1"""/><option key="""supRowsZeros""" value="""1"""/><option key="""supRowsNoAccess""" value="""1"""/><option key="""supRowsInvalid""" value="""0"""/><option key="""supRepeatedMembers""" value="""0"""/><option key="""supUnderScores""" value="""0"""/><option key="""mbrRetIncludeSelection""" value="""1"""/><option key="""mbrRetWithinSelectedGroup""" value="""0"""/><option key="""mbrRetRemoveUnselectedGroups""" value="""0"""/><option key="""modeDataLessNav""" value="""0"""/><option key="""useDoubleClickForAdhoc""" value="""1"""/><option key="""bUndoEnable""" value="""1"""/><option key="""iUndoBufSize""" value="""10"""/><option key="""strRepMissinglabel""" value=""""""/><option key="""strRepNoAccesslabel""" value="""#No Access"""/><option key="""strRepInvalidlabel""" value="""#Invalid"""/><option key="""cellStatus""" value="""0"""/><option key="""messageDisplay""" value="""2"""/><option key="""strScale""" value="""Default"""/><option key="""strDecPlaces""" value="""Default"""/><option key="""bAdhocUseStyles""" value="""0"""/><option key="""bRetainNumericFormatting""" value="""0"""/><option key="""m_bUseExcelColorPalette""" value="""0"""/><option key="""m_bPreserveFormulasOnPOVChange""" value="""0"""/><option key="""bManualCalc""" value="""0"""/><option key="""bUseThousandsSep""" value="""0"""/><option key="""bUseListStripes""" value="""0"""/><option key="""bClearLogMessage""" value="""0"""/><option key="""bRouteLogMessages""" value="""0"""/><option key="""bRefreshFunctionsOnly""" value="""0"""/><option key="""strMessageLogFile""" value=""""""/><option key="""clrLightStripe""" value="""15723237"""/><option key="""clrDarkStripe""" value="""15328221"""/><option key="""memberDisplay""" value="""0"""/><option key="""memberDisplayEssbase""" value="""0"""/><option key="""bShowAliasForPlanningMbrSel""" value="""0"""/><option key="""bEnableFormatStr""" value="""1"""/><option key="""iSVPanelActiveDialog""" value="""9"""/><option key="""iReportDesignerSplitState}""" value="""11"""/><option key="""iSVPanelFlyoutWidth}""" value="""300"""/><option key="""bSVPanelMinimized}""" value="""1"""/><option key="""szPluginUIProgID""" value=""""""/><option key="""bDisplayHomePanelOnStartup""" value="""1"""/><option key="""bExpandLoginDialog""" value="""1"""/><option key="""iSVPanelDockPosition""" value="""2"""/><option key="""strBIPlusRepositoryURL""" value=""""""/><option key="""strBIPlusRepositoryFolder""" value="""Crystal Ball"""/><option key="""bCommentDlgEnable""" value="""0"""/><option key="""bsubmitZero""" value="""0"""/><option key="""bMRUEnable""" value="""1"""/><option key="""iMRUBufSize""" value="""9"""/><option key="""bHandleCellDependency""" value="""0"""/><option key="""bIgnoreFormulaAndComment""" value="""0"""/><option key="""bPreserveEssbaseComment""" value="""1"""/><option key="""bEnableProfiling""" value="""0"""/><option key="""bEnableProfileTab""" value="""0"""/><option key="""bDefaultLanguage""" value="""0"""/><option key="""strLanguageCode""" value="""1033"""/><option key="""strMissinglabelList""" value=""""""/><option key="""strNoAccesslabelList""" value=""""""/><option key="""strInvalidlabelList""" value=""""""/><option key="""bContextSensitive""" value="""1"""/><option key="""strDisableContextSenseFor""" value=""""""/><option key="""bDisplaySVMenuOnly""" value="""0"""/><option key="""bRetainRibbonContext""" value="""1"""/><option key="""bDisplayDrillThroughTooltip""" value="""0"""/><option key="""bDisplayInvalidData""" value="""0"""/><option key="""supColsNoDataMissing""" value="""0"""/><option key="""supColsZeros""" value="""0"""/><option key="""supColsNoAccess""" value="""0"""/><option key="""supColsInvalid""" value="""0"""/><option key="""supBlocksMissing""" value="""1"""/><option key="""bAdjustColumns""" value="""1"""/><option key="""bWarnAdjustColumn""" value="""0"""/><option key="""bFormulaFill""" value="""1"""/><option key="""bShowPovInNotesDlg""" value="""1"""/><option key="""bShowPovInAttachmentsDlg""" value="""1"""/><option key="""bShowPovInHistoryDlg""" value="""1"""/><option key="""bMoveFormats""" value="""0"""/><option key="""bShowProgressDlg""" value="""0"""/><option key="""iProgressDelayTime""" value="""5"""/><option key="""iApplyFormattingChoice""" value="""1073741826"""/><option key="""bRepeatMembersInForm""" value="""1"""/><option key="""bRefreshLinkedWorkbook""" value="""0"""/></root>" /f