How to get a formula member to total?
Hello,
I have a Planning application, and I created a member with a formula, FTE_1950_hours, of type Dynamic Calc and Store.
Then I realized I needed this to total, so I created another member, FTE_1950_total_hours, as a parent to FTE_1950_hours. I originally made this parent member Dynamic. So I did a database refresh and a calc all, and no value is being rolled up to the parent, FTE_1950_total_hours.
In Planning, I tried changing the member type of FTE_1950_total_hours to Never Share, and then I tried Store, but when I refresh the database, Essbase does not update the member. If I try to update the member directly in Essbase Admin Console, it tells me, "FTE_1950_hours: The member is defined as a Dynamic Calc member, it is an only child, and its parent is not defined as a Dynamic Calc member", so I cannot change the member type of the parent.