|
<< Click to Display Table of Contents >>
Usage via Functions |
In addition to executing queries via Ribbon, in Excel 2007 or later, users can also write functions directly on Excel cells or use them in VBA Script, in Excel XP or later.
Unlike the queries performed using the Ribbon, for functions data is returned in Excel's Multi-Array Formula format. This means that users must previously allocate cells to display the results of the applied formula. This way, every operation involving Excel's Multi-Array Formula format must be performed by pressing the SHIFT and CTRL keys simultaneously.
NOTE |
For more information about Excel's Multi-Array Formulas format, please check the documentation on Microsoft Developer Network. |
To use EPM functions in Excel, there are some types of components:
•AutomationAddIn.EpmFunctions: Functions equivalent to the functions available on the Ribbon
•EpmAggregate: Query function with the possibility of aggregating data. For a more detailed description of all aggregation functions, please check topic Creating a Dataset on chapter EPM Dataset Analysis of Manual do Usuário do Elipse Plant Manager
•EpmQuery: Function that brings to Excel data from a Dataset previously created in EPM Studio
•EpmRawByNumberOfValues: Function that retrieves a certain amount of non-aggregated data, for one or more variables, based on an informed date
•EpmRawByPeriod: Function that retrieves non-aggregated data, for one or more variables, from a certain period
•EpmHDA.Raw: Function more specific to non-aggregated data, with more flexibility to define the format of results
•ByNumberOfValues: Equivalent to the EpmRawByNumberOfValues function, but users can define a Layout to place results
•ByPeriod: Equivalent to the EpmRawByPeriod function, but users can define a Layout to place results
•Recent24Hours: Function that retrieves non-aggregated data, for one or more variables, from the last 24 hours
•Recent30Days: Function that retrieves non-aggregated data, for one or more variables, from the last 30 days
•Recent7Days: Function that retrieves non-aggregated data, for one or more variables, from the last seven days
•RecentHour: Function that retrieves non-aggregated data, for one or more variables, from the last hour
•RecentPeriod: Function that retrieves non-aggregated data, for one or more variables, from the last informed period, that is, the current time minus a user-defined value
NOTES |
•All functions have a parameter with the name of the connection to a EPM Server that must be used. If this name is not used, these functions use the name of the connection defined as default. •Functions with an AutomationAddIn.EpmFunctions type always use the Layout defined as default, while functions with an EpmHDA.Raw type use a user-defined Layout. If it is not defined, the default Layout is also used. |