Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
3 days ago

SetDataCell on AdjInput & OwnPreAdj

Hi All - I have a question on the SetDataCell Does the below work? I am trying to write 1 to an account. api.Data.SetDataCell("S#UltOwnShipConsolTracker:V#YTD:A#DirectOwnership:F#None:O#AdjInput:I#N...
Application Properties
Consolidation
MikeG's avatar
MikeG
Contributor III
2 days ago

Hi Krishna​ , you would need adjust your Cube Properties.  on the Cube Properties tab, what do you have set for your Consolidation Algorithm Type?   I believe you would need to change this to Custom - then attach the Finance Business Rule on the Cube as Business Rule 1 - and handle/address your Custom calc to correctly calc C#OwnerPreAdj.  

Take a look in the Admin Guide so you understand the Data Unit Calculation Sequence to understand the order in which Member Formulas run, and Business Rules attached to the Cube execute.  Sequence matters when doing custom consolidation rules.

Regards,

Mike G