Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management


HypResetFriendlyName modifies the friendly name to a new one. To modify the friendly name of a connection in the Smart View Panel, Oracle Smart View for Office must be connected to Oracle Hyperion Provider Services.


HypResetFriendlyName (vtOldFriendlyName, vtNewFriendlyName)

By Val vtOldFriendlyName As Variant

By Val vtNewFriendlyName As Variant


vtOldFriendlyName: The old friendly connection name

vtNewFriendlyName: The new friendly connection name

Return Value

Returns 0 if successful; otherwise, returns the appropriate error code.


Declare Function HypResetFriendlyName Lib "HsAddin" (ByVal vtOldFriendlyName As Variant, ByVal vtNewFriendlyName As Variant) As Long

Sub Example_HypResetFriendlyName()
                Dim lRet As Long
                lRet = HypResetFriendlyName("server2_Sample_Basic", "My Sample Basic")
End Sub