Hyperion Planning (MOSC)

MOSC Banner

How to get a formula member to total?

edited Aug 18, 2015 9:23AM in Hyperion Planning (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center