cancel
Showing results for 
Search instead for 
Did you mean: 

Local member formulas

Former Member
0 Kudos

We have rows and columns hard coded with required dimension members, the intersection is data which is fully based on 'EPMtreivedata' function.

In such a report in between 2 column we need to insert formulas. Is it possible to insert the formulas as local member based formula?

Can a 'local member formula' work on a report fully based on EPMretrievedata function.

Appreciate inputs

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

If you use only EPMretrievedata then you don't have EPM report - then you can't use local members!

You have to use ordinary Excel formulas.

What is the reason to use EPMretrievedata? It's very slow and can be replaced by static EPM report where you can use local members.

B.R. Vadim

Answers (1)

Answers (1)

Former Member
0 Kudos


hi,

If the formula used in the Local members contains standard excel formulae like Sum, Average etc. it can be added in the report/input schedule using local members.