Currently Being Moderated

BPC Excel has a variety of delivered macros that utilized by the BPC application builder.  These macros can be incorporated into any BPC design and can be executed via the instructions provided in my previous posting [Business Planning and Consolidations (BPC) Tips -1].

 

Please note, although this list is substantial, I do not wish to imply it is in any way 100% complete:

 

Send and Refresh Schedule

MNU_ESUBMIT_REFRESH

Open My Schedule

MNU_ESUBMIT_OPENMY

Save My Schedule

MNU_ESUBMIT_SAVEMY

Open Dynamic Schedule Template

MNU_ESUBMIT_SCHEDULE

Open Schedule Library

MNU_ESUBMIT_OPENSTANDARD

Validate Submission

MNU_ESUBMIT_VALIDATE

Publish to Content Library

MNU_ESUBMIT_SUBMIT

Modify Work Status

MNU_ESUBMIT_MODIFY

Spread

MNU_eSUBMIT_ESPREAD

Trend

MNU_eSUBMIT_ETREND

Weight

MNU_eSUBMIT_EWEIGHT

Manage Dynamic Hierarchies

MNU_ESUBMIT_MANAGE_DYNAMICHIERARCHIES

Using Schedule's Help

MNU_ESUBMIT_HELP

 

 

Open My Reports

MNU_EANALYZE_OPENMY

Save My Reports

MNU_EANALYZE_SAVEMY

Open Dynamic Report Template

MNU_EANALYZE_REPORTWIZARD

Open Report Library

MNU_EANALYZE_OPENSTANDARD

Audit Reports

MNU_EANALYZE_VIEWAUDIT

Using Report Help

MNU_EANALYZE_HELP

 

 

Open Web-Ready File from BPC Web

MNU_EPUBLISH_OPENPUBLICATION

Save as Web-Ready File

MNU_EPUBLISH_PUBLISHSHEET

Book Publication Wizard

MNU_EPUBLISH_PUBLISHBOOK_WIZARD

Create New Book

MNU_EPUBLISH_PUBLISHBOOK_NEW

Edit Book

MNU_EPUBLISH_PUBLISHBOOK_EDIT

Save Book

MNU_EPUBLISH_PUBLISHBOOK_SAVE

Save As Book

MNU_EPUBLISH_PUBLISHBOOK_SAVEAS

Validate Book

MNU_EPUBLISH_PUBLISHBOOK_VALIDATE

Offline Distribution Wizard

MNU_EPUBLISH_OFFLINE_WIZARD

Manage Distribution List - New

MNU_EPUBLISH_OFFLINE_NEW

Manage Distribution List - Edit

MNU_EPUBLISH_OFFLINE_EDIT

Manage Distribution List - Save

MNU_EPUBLISH_OFFLINE_SAVE

Manage Distribution List - Save As

MNU_EPUBLISH_OFFLINE_SAVEAS

Manage Distribution List - Validate

MNU_EPUBLISH_OFFLINE_VALIDATE

View BPC Web

MNU_EPUBLISH_VIEWeDASH

Publishing Help

MNU_EPUBLISH_HELP

 

 

Park N Go

MNU_ETOOLS_PARKNGO

Expand All

MNU_ETOOLS_EXPAND

Refresh Workbook

MNU_ETOOLS_REFRESH

Drill Down

MNU_ETOOLS_DRILLDOWN

Drilldown Back

MNU_ETOOLS_DRILLDOWN_BACK

Drill Down Forward

MNU_ETOOLS_DRILLDOWN_FORWARD

Drill Through

MNU_ETOOLS_DRILLTHROUGH

Select Member

MNU_ETOOLS_MEMBERSELECTOR(xxxxxxx)

Function Wizard

MNU_ETOOLS_FUNCTIONWIZARD

Refresh Dimension Members

MNU_ETOOLS_UPDATEAPPINFO

Data Manager

MNU_ETOOLS_DATAMANAGER

Workbook Options

MNU_ETOOLS_WBOPTION

Open Dynamic Templates

MNU_ETOOLS_OPENSTANDARD

Save Dynamic Templates

MNU_ETOOLS_SAVESTANDARD

Open Custom Menu

MNU_ETOOLS_PSMANAGER_OPEN

Test Current Worksheet

MNU_ETOOLS_PSMANAGER_COMPILE

Save Custom Menu

MNU_ETOOLS_PSMANAGER_SAVE

Change Application Set

MNU_ETOOLS_CHANGEAPP

Client Options

MNU_ETOOLS_OPTION

Journal

MNU_ETOOLS_JOURNAL

View BPC Action Pane

MNU_ETOOLS_TASKPANE

BPC for Office Help

MNU_ETOOLS_HELP

About BPC

MNU_ETOOLS_ABOUT

 

 

Run Package

MNU_eData_RUNPACKAGE

Packages Schedule Status

MNU_eData_PackageSechedules

View Status

MNU_eData_ViewStatus

Organize Package List

MNU_eData_OrganizePackage

Manage Team User Package Access

MNU_eData_ManageSitePackage

Data Preview

MNU_eData_DataPreview

Data Upload

MNU_eData_DataUPLoad

Data Download

MNU_eData_DataDownLoad

New Transformation File

MNU_eData_NewTransformation

Manage Transformation Files

MNU_eData_OpenTransformation

Validate and Process Transformation File

MNU_eData_SaveTransformation

Copy Transformation File

MNU_eData_SaveAsTransformation

New Conversion File

MNU_eData_NewConversionFile

Manage Conversion File

MNU_eData_OpenConversionFile

Validate and Process Conversion File

MNU_eData_SaveConversionFile

Copy Conversion File

MNU_eData_SaveAsConversionFile

Add Conversion Sheet

MNU_eData_NewConversionSheet

Clear Save Prompt Values

MNU_eData_ClearPromptValue

Data Manager Help

MNU_eData_Help

About Data Manager

MNU_eData_About

Show Member List

MNU_eData_Showmemberlist

 

 

Enjoy!

Comments

Actions

Filter Blog

By date:
By tag: