With EPM 10.0, reporting in BPC has changed significantly. All the EV functions now have their EPM counterparts. It is very important to know all the changes with respect to functions with the new 10.0 version.
Function categories in EPM 10.0 are divided into three groups:
- EVFunctions – These refer to the obsolete EV functions. EVFunctions are primarily used in migration projects when we migrate EVDRE reports to new EPM reports.
- EPMFunctions – These refer to the delivered EPM functions. These are a must know if we have to build BPC reports from scratch using EPM 10.0. From EPM 10.0, the names of functions begin with EPM.
- FPMXLClient.TechnicalCategory – These are primarily for internal use.
The following EV Functions are not supported in EPM 10.0:
EvALK |
EvASV |
EvBLK |
EvCLK |
EvDLK |
EvENE |
EvEXP |
EvHOT |
EvINP |
EvLIK |
EvLST |
EvMEM |
EvMSG |
EvNXP |
EvPLK |
EvPOV |
EvPXR |
EvSEN |
EvSET |
EvSLK |
OsAMT |
Below is the list of various EVDRE functions and their corresponding EPM functions. This can be a useful guide if we are familiar with the prior versions of BPC and are new to EPM 10.0 reporting and would like to know the new functions for reporting.
Here is the cross-reference between 10.0 and 7.X functions:
EPM 10.0 FUNCTIONS |
EV 7.X FUNCTIONS |
EPMModelCubeDesc |
EVAPD |
EPMModelCubeID |
EVAPP |
EPMEnvDatabaseDesc |
EVASD |
EPMEnvDatabaseID |
EVAST |
EPM Comparison |
EVBET |
EPMBook |
EVBNV |
EPMSaveComment |
EVCOM |
EPMCommentPartialContext |
EVCGP |
EPMCommentFullContext |
EVCGT |
EPMWorkStatus |
EVCLK |
EPMContextMember |
EVCVW |
EPMMemberDesc |
EVDES |
EPMDimensionType |
EVDIM |
EPMDocumentList |
EVDNV |
EPMRetrieveData |
EVGET |
EPMScaleData |
EVGTS |
EPMURL |
EVHNV |
EPMLink |
EVHOT |
EPMSelectMember |
EVMBR |
EPMExecuteAPI |
EVMNU |
EPMCopyRange |
EVRNG |
EPMMemberProperty |
EVPRO |
EPMRefreshTime |
EVRTI |
EPMSaveData |
EVSND |
EPMServer |
EVSVR |
EPMMemberOffset |
EVTIM |
EPMUser |
EVUSR |
excellent blog, it saved me time trying to figure out all of the functions
thank you
THIS IS GREAT WORK VINAY.
THANKS.
It would be great if you can provide appropriate syntax for each.
Thanks.
EVRNG is EPMCellRanges not EPMCopyRange
EVCLK is not an EV function IN bpc10
EVLCK is EPMWorkStatus
Hi,
thanks for the important information.
Do you have any links to documentation that can prove your statements?