Not used Essbase member formula a great deal, at least not complex formula.
Whenever I try to do a formula on a member that is calculated, it doesn't seem to work. Why is that? Is it something to do with blocks not being present so it misses it? Tried calc and store but it seems to store the data and never calc again unless you clear it?
Have tried various 'two-pass' combinations but doesn't seem to work either.
Am working in Planning but I'm pretty sure that's not the issue as I've faced similar in Essbase before and just used the base data instead of the calculated field. Is pretty inefficient though..
If you need versions etc then let me know but I think this is a fairly generic question.