Show TOC

Function documentationList of Menu Commands Locate this document in the navigation structure

 

You can use each function in the following list within an =EvMNU(command,parameter1,…) function or within a VBA macro.

In the table, X means Available.

Menu Command

Description

NetWeaver

Microsoft

EVGOTOHOMESHEET

Returns you to the first sheet in the workbook. The first sheet must be named Home.

X

MNU_eANALYZE_OPENMY

Opens the MyReports report folder.

X

X

MNU_eANALYZE_OPENSTANDARD

Opens the report library at the eExcel/Reports directory.

X

X

MNU_eANALYZE_REFRESH

Recalculates reports.

X

X

MNU_eANALYZE_REPORTWIZARD

Launches the dynamic template report dialog box.

X

X

MNU_eANALYZE_SAVEMY

Saves the report to the MyReports folder.

X

X

MNU_eDATA_CLEARPROMPTVALUE

Clears saved Data Manager prompt values.

X

X

MNU_eDATA_DATADOWNLOAD

Opens the Data Manager Data Download dialog box. Allows users who have access to download data files from the server.

X

X

MNU_eDATA_DATAPREVIEW

Opens the Data Manager Data Preview dialog box.

X

X

MNU_eDATA_DATAUPLOAD

Opens the Data Manager Data Upload dialog box. Allows users who have access to upload data files to the server perform data transformations.

X

X

MNU_eDATA_MANAGESITEPACKAGE

Opens the Data Manager Manage Team User Package Access dialog box.

X

X

MNU_eDATA_NEWCONVERSIONFILE

Creates a new Data Manager conversion file.

X

X

MNU_eDATA_NEWCONVERSIONSHEET

Creates a new conversion sheet in the active conversion workbook

X

MNU_eDATA_NEWTRANSFORMATION

Creates a new Data Manager Transformation sheet.

X

X

MNU_eDATA_OPENCONVERSIONFILE

Opens the Data Manager Open Conversion File dialog box.

X

X

MNU_eDATA_OPENTRANSFORMATION

Opens the Data Manager Open Transformation dialog box.

X

X

MNU_eDATA_ORGANIZEPACKAGE

Opens the Data Manager Organize Package dialog box.

X

X

MNU_eDATA_RUNPACKAGE

Opens the Data Manager Run Package dialog box. Allows users who have access to run database packages.

X

X

MNU_eDATA_SAVECONVERSIONFILE

Saves the active conversion file.

X

X

MNU_eDATA_SAVEASCONVERSIONFILE

Shows the Data Manager Save as Conversion File dialog box.

X

X

MNU_eDATA_SAVESTRANSFORMATION

Opens the Data Manager Save As Transformation Sheet dialog box.

X

X

MNU_eDATA_SAVETRANSFORMATION

Saves the active Transformation sheet.

X

MNU_eDATA_SELECTPACKAGE

Opens a specific Data Manager package. Syntax: MNU_eDATA_SELECTPACKAGE(<package name>, <package file path>, <teamname>, <package group>

For this menu command, the parameters are part of the MacroName, so you must leave the Parameter section blank. For example, if you have MNU_eData_SelectPackage(""import"",""examples/import.dts"",""HQ"") in cell A1, FX Restatement in cell A2, your EvMNU function would be: EvMNU(A1,A2,).

X

MNU_eDATA_TESTTRANSFORMATIONWDATA

Opens the Data Manager Test Transformation with Data dialog box.

X

X

MNU_eDATA_VIEWSTATUS

Opens the Data Manager View Status dialog box.

X

X

MNU_eJOURNAL_QUERY

Opens the Journal Manager.

Note Note

The forms are only available if Journals are set up on the server.

End of the note.

X

X

MNU_eJOURNAL_REPORT

Opens the Journal Report Wizard.

Note Note

The forms are only available if Journals are set up on the server.

End of the note.

X

X

MNU_ePUBLISH_OPENPUBLICATION

Opens Interface for the Web directory so you can select the location and file.

X

X

MNU_ePUBLISH_PUBLISHBOOK_EDIT

Edits a book.

X

MNU_ePUBLISH_PUBLISHBOOK_NEW

Creates a new book.

X

MNU_ePUBLISH_PUBLISHBOOK_SAVE

Saves the current book.

X

MNU_ePUBLISH_PUBLISHBOOK_SAVEAS

Opens the Save As dialog box.

X

MNU_ePUBLISH_PUBLISHBOOK_VALIDATE

Validates the current book.

X

MNU_ePUBLISH_PUBLISHBOOK_WIZARD

Launches the book publication wizard.

X

MNU_ePUBLISH_PUBLISHSHEET

Publishes a worksheet to Interface for the Web.

X

X

MNU_ePUBLISH_OFFLINE_EDIT

Edits offline options.

X

X

MNU_ePUBLISH_OFFLINE_NEW

Creates a new offline report.

X

X

MNU_ePUBLISH_OFFLINE_SAVE

Saves the offline report.

X

X

MNU_ePUBLISH_OFFLINE_SAVEAS

Opens the Save As dialog box.

X

X

MNU_ePUBLISH_OFFLINE_VALIDATE

Validates an offline report.

X

X

MNU_ePUBLISH_OFFLINE_WIZARD

Opens the Distribution Wizard.

X

X

MNU_ePUBLISH_VIEWeDASH

Opens Interface for the Web.

X

X

MNU_ESUBMIT_COMMENT

Sends comment only, no refresh comment.

X

X

MNU_ESUBMIT_COMMENT_AFTER_SENDDATA

Sends comment first

X

X

MNU_eSUBMIT_CURRENT

Opens the Send and Refresh Schedules dialog box.

X

MNU_ESUBMIT_MANAGE_DYNAMICHIERARCHIES

Open Dynamic Hierarchies dialog box

X

MNU_eSUBMIT_MODIFY

Opens the work status action pane in Interface for the Web.

X

X

MNU_eSUBMIT_ONLINE

Collaborates on input schedules.

MNU_eSUBMIT_OPENMY

Opens the MySchedules folder.

X

X

MNU_eSUBMIT_OPENSTANDARD

Opens the input schedule library at the eExcel/Input Schedule directory.

X

X

MNU_eSUBMIT_REFRESH

Refreshes the schedule without sending data.

X

X

MNU_eSUBMIT_REFSCHEDULE_BOOK_CLEARANDREFRESH

Sends workbook and clears data and refreshes workbook.

X

X

MNU_eSUBMIT_REFSCHEDULE_BOOK_NOACTION

Sends data without clearing or refreshing the worksheet.

X

X

MNU_eSUBMIT_REFSCHEDULE_BOOK_NOACTION_SHOWRESULT

Sends data without clearing or refreshing the worksheet, and shows the result in a window upon successful send.

X

X

MNU_eSUBMIT_REFSCHEDULE_BOOK_NODIALOG_SHOWRESULT

Sends active book without any dialog and show result box.

X

X

MNU_eSUBMIT_REFSCHEDULE_BOOK_REFRESH

Sends workbook and refreshes data.

X

X

MNU_eSUBMIT_REFSCHEDULE_SHEET_CLEARANDREFRESH

Sends data and clears and refreshes the worksheet.

X

X

MNU_eSUBMIT_REFSCHEDULE_SHEET_NOACTION

Sends data without clearing or refreshing.

X

X

MNU_eSUBMIT_REFSCHEDULE_SHEET_REFRESH

Sends data and refreshes the worksheet.

X

X

MNU_eSUBMIT_SAVEMY

Saves the input schedule to the MySchedules folder.

X

X

MNU_eSUBMIT_SCHEDULE

Opens the dynamic schedule template dialog box.

X

X

MNU_ESUBMIT_SENDDATA

Sends data only, no Refresh data.

X

X

MNU_ESUBMIT_SENDDATA_AFTER_COMMENT

Sends data first.

X

X

MNU_eSUBMIT_SUBMIT

Submits supporting documents.

MNU_eSUBMIT_VALIDATE

Validates the data submission.

MNU_eTOOLS_ABOUT

Opens the About BPC dialog box.

X

X

MNU_eTOOLS_CHANGEAPP

Opens the Change Application Set dialog box.

X

X

MNU_eTOOLS_DATAMANAGER

Opens the Data Manager and adds the eData menu.

X

X

MNU_eTOOLS_DRILLDOWN

Performs drill down on current cell.

Note Note

This menu command can be used only in VBA, not a menu.

End of the note.

X

X

MNU_eTOOLS_DRILLDOWN_BACK

Reverses last drill-down.

X

X

MNU_eTOOLS_DRILLDOWN_FORWARD

Performs a drill-down that was undone by the DRILLDOWN_BACK task.

X

X

MNU_eTOOLS_DRILLTHROUGH

Performs drill through on current cell.

X

MNU_eTOOLS_EXPAND

Expands all dynamic expansions and refreshes (unless EvDRE option states no refresh).

X

X

MNU_eTOOLS_EXPANDANDREFRESH

Expands all dynamic expansions and then refreshes (unless EvDRE option states no refresh).

X

MNU_eTOOLS_FUNCTIONWIZARD

Opens the Function Wizard.

X

X

MNU_eTOOLS_JOURNAL

Opens the Journal form.

Note Note

The forms are only available if Journals are set up on the server.

End of the note.

X

X

MNU_eTOOLS_MEMBERSELECTOR_x

Opens the Member Lookup for the specified dimension type. The dimension types are:

  • A — account

  • C — category

  • E — Entity

  • T — Time

  • F — Measures

  • I — Intercompany

  • D — data source

  • S — subtype

  • Ua - Ux — User-defined dimensions

For example, if you enter MNU_eTOOLS_MEMBERSELECTOR_E, the Member Lookup opens to the Entity dimension.

X

X

MNU_eTOOLS_OPENSTANDARD

Opens the template library.

X

X

MNU_eTOOLS_OPTION

Opens the Client Options dialog box.

X

X

MNU_eTOOLS_PARKNGO

Opens the Park N Go dialog box.

X

X

MNU_eTOOLS_REFRESH

Refreshes reports and input schedules from the server.

X

X

MNU_ETOOLS_REFRESHRANGE

You can assign this macro to a button control. Before executing the macro, select one or more cells manually. Otherwise, only the active cell is refreshed. If the worksheet mode is Report, the selected cells (including EVGET/EVGTS) are refreshed. If the worksheet mode is Input schedule, the reference cells of the selection (including EVSND) are refreshed.

x

MNU_eTOOLS_SAVESTANDARD

Saves to template library.

X

X

MNU_ETOOLS_TASKPANE

Shows Action Pane

X

MNU_eTOOLS_UPDATEAPPINFO

Refreshes dimensions from server.

X

MNU_eTOOLS_WBOPTION

Opens the Workbook Options dialog box.

X

X

Note Note

There is no MNU command to open the comment function in the action pane. You can enter comments only through the EvCOM function.

End of the note.

More Information

Custom Menus