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
Will have to try this out soon Celvin.
This tip helped me resolve one long pending issue. Thanks Celvin.