cancel
Showing results for 
Search instead for 
Did you mean: 

Node-level Calculations / Top-Down Planning

Former Member
0 Kudos

Hi,

I am working with SAP BPC 10 MS and am trying to input values on node-level Elements, in order to perform adjustments on a top-level (node-level) basis.

My intention is to catch the values which have been written to the node within an INSTEAD OF SQL-Trigger.

The trigger then should simply take the node-level value and do some calcutlations, in order to spread the node-value to the underlying base members.

Howeverthe node-level values do not even get passed to the INSTEAD OF Trigger, but are filtered by SAP BPC before they get passed to the Database.

Is there a way to make the SAP EPM AddIn (or maybe the SendGovernour) to pass node-level values to the Database?

Thank you very much for any ideas,

Kind regards

Marco

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186498
Active Contributor
0 Kudos

Hi Marco,

no you cannot write on a parent node only on children, BPC OLAP calculate automatically the total of the node that's why you don't find any data values of nodes in the fact tables.

If you need to write on parent you can create a children say Node_Input, outside of the hierarchy, and write the data on it mantaining it aligned with the node through script logic or adding a dummy children under the node.

Regards

     Roberto