Import a formula into a calculated metric definition
Directly import any formula that is stored in Microsoft Excel spreadsheets into a calculated metric definition. This import helps in quickly building your formula for performing calculations.
Antes de Iniciar
Role required: system admin
Por Que e Quando Desempenhar Esta Tarefa
Sometimes, you might have a formula saved in a spreadsheet that you want to include into a calculated metric definition for use in formula building. In these instances, the formula import functionality proves beneficial. It's
crucial to verify that the spreadsheet includes the following columns with precisely the same column names.
- Name
- Frequency
- Formula
- Calculation level
- Domain area
Procedimento
- Navigate to .
- Select Metric definition data source.
- Select the Manage attachment icon and upload the file that contains the formula.
- Select the Load All Records related link.
- Select Run Transform.
- Select Transform.
Resultado
The calculated metric definition becomes available with the formula in the list of all the metric definitions.