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: For this menu command, the parameters are part of the MacroName, so you must leave the Parameter section blank. For example, if you have |
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 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 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 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 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:
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
There is no MNU command to open the comment function in the action pane. You can enter comments only through the EvCOM function.