I am currently implementing SAP BPC project to replace Hyperion Enterprise. There is an option in Hyperion Enterprise in Entity dimension where you can specify an entity (child or parent node) to be subtracted from its parent rather than the natural way of adding in SAP BPC. I know in SAP BPC, the natural way the hierarchy works is that all the base level nodes are added to its parent level which in turn are added to its parent level and so on and so forth.
I was wondering if there is a way to accommodate "Subtract from parent" functionality of Hyperion Enterprise in SAP BPC. One way I can think of is to write a script logic to multiply the numbers submitted to that entity by -1 which will make sure that we are subtracting this entity while rolling up.
Does anyone know of a better way?
Please let me know.