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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.