Show TOC

Syntax documentationEvHOT Locate this document in the navigation structure

The EvHOT (hot link) function sets up a hot link to another report or cell within another report. Hot links can be used to guide a user through ad-hoc analysis.

Syntax Syntax

EvHOT(AppName,ReportName,DisplayName,Member1–N)

AppName — The name of the application. You can connect to another application by specifying a different application ID.

ReportName — The name of the report. The root directory for Planning and Consolidation reports is the Wizard directory for the given application. Use the   eTools   Save Template Library   option when creating the report. You must be authorized and advance the version for the user to have the appropriate reports.

DisplayName — The text the user clicks to go to the specified report location.

Member1–n — (Optional) The current view member. You can list as many members as you want, and you can link this as a member of the report or hard code it into the formula. For example, you may have an expansion of entities in the rows. The linked report may have accounts in the row, so you want to pass the specific row entity into the account template.

End of the code.

Example Example

The following example creates a hot spot labeled 2008 Quarter 1 that the user can click to drill-down.

EvHot(Finance,Report1.xlt,2008 Quarter 1,2008.Q1)

End of the example.