Fixing Links in Functions
You may need to fix broken links in functions.
Broken links can occur in Oracle Smart View for Office (Mac and Browser), when you
open a workbook containing functions that were created in Oracle Smart View for Office. Smart View functions
(such as HsGetValue and HsSetValue) created in Smart View (Windows) make use of the HsTbar.xla file, located in the
<SmartViewInstallLocation>/bin/ folder, and caches the path
to this file. The Fix Links command cleans up such paths present in front of
function names in the sheet. For example, a sheet created in Smart View (Windows) may contain a path like 'C:/Oracle/SmartView/bin/HsTbar.xla'
before the function name when opened on a Mac. This path gets cleaned when you click
Fix Links, so that the function can run
properly.
Note:
Currently, the Fix Links command is supported only when using Smart View (Mac and Browser) on a Mac.
To fix broken links in functions:
-
In the Smart View ribbon, click Functions and then click the Fix
Links button,
.
-
If you see a
#NoConnectionmessage in the sheet, select the cube, select Set as Connection for Functions, and then enter a name for the connection.You can provide a meaningful name for the connection. The connection will automatically include information on the environment you're using, the application, and cube, and will be valid for all sheets in the workbook.
