on 02-20-2014 10:44 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.