Update Smart View options for all Users


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.

properties

Open properties.xml

properties-file

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.

regkey

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

Tada, that’s it. I’ve even added the timeout setting with that script.
Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase.

Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I’m an Independent Consultant with “Intekgrate Corporation” based out of Aurora office.

I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader.

I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “Update Smart View options for all Users