Show TOC

EPMPathLinkLocate this document in the navigation structure

This function retrieves a specified text on which you double-click to open a Microsoft Excel workbook.

When you double-click the link, the specified file opens and the context is retrieved. If you want to override certain context members, you can optionally specify other members.
Note
  • Make sure that double-click actions are enabled (the Enable Double-Click option must be selected in Start of the navigation path EPM Next navigation step Options Next navigation step User Options End of the navigation path).
  • If the cell on which you double-click is merged with other cells, the double-click will not function.
Parameter Description
connection name Name of the connection.

For details about the syntax you must use, see Connection Name Parameter - Syntax.

Note For SAP BW (INA Provider) connections, use the connection name, not the query alias and note that the connection must already be connected.
file
  • If you use a local connection, enter the path you want and the file to open. Also, make sure the Local option is selected in the Others tab of the User Options.
  • If you use a Planning and Consolidation connection, enter a path and a file to the server, keeping in mind that it is automatically searched for at the following location: \WEBEXCEL\TEMPLATELIBRARY\.
    Note This path is different from the path for the EPMLink function. For more information, see EPMLink.

    Also, make sure the Planning and Consolidation option is selected in the Others tab of the User Options. However, if the file is not found in the Planning and Consolidation server, the file is searched for in local folders.

  • If you use a SAP BW (INA Provider) connection, enter a path and a file to the server, keeping in mind that it is automatically searched for at the following location: \Team Public\
displayedText Text in the cell to double-click on. Optional.
member1... to member23 Members that override the context members. Optional.
  • Name of the member.
  • Or name of the context favorite. If you enter a context favorite in Member1, leave the other member parameters blank.
Note
  • If the description of a member exists in several dimensions, once you have entered the function, a message appears, stating that the description is ambiguous and recommending that you use the ID of the member instead.
  • If the ID of a member exists in several dimensions, once you have entered the function, a message appears, stating that the ID is ambiguous and recommending that you use the full unique name of the member instead.