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#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None", 1, False)

My Origin is AdjInput & Consol is OwnerPreAdj

Thanks

Krishna

 

 

Application Properties
Consolidation

1 Reply

  • 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