{ "type" : "dataRule", "metadata" : [{"kind":3,"id":3,"active":true,"modifiedDate":{"value":1764873242047},"modifiedBy":"Keziah Patha","name":"Calculate Trade Spend","systemCategory":0,"components":[{"kind":1,"componentId":1,"displayMode":2,"name":"Trade Spend - Writeback","systemCategory":0,"modelId":12,"measureGroupName":"CoreMG","partitionName":"Writeback","targetColumns":[{"kind":1,"id":"4c3560a335e14aae36f55b77cbd9b281","reference":"Account.Account","dBType":2,"name":"AccountId","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"AccountId","member":{},"sourceType":0},{"kind":1,"id":"a4e7f876760815fcf8b166437776674e","order":1,"reference":"Scenario.Scenario","dBType":2,"name":"ScenarioId","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"ScenarioId","member":{},"sourceType":0},{"kind":1,"id":"e523cc8042df4e69caeeb809c78ccb3c","order":2,"reference":"Time.Months","dBType":3,"name":"TimeId","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"TimeId","member":{},"sourceType":0},{"kind":1,"id":"a1a71a0c4ca34df60cc93c5ef15fd9e3","order":3,"reference":"Entity.Entity","dBType":2,"name":"EntityId","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"EntityId","member":{},"sourceType":0},{"kind":1,"id":"2e8cba4d984ec5ebe93d2dd8409fd40f","order":4,"reference":"Product.Brands","dBType":2,"name":"ProductId","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"ProductId","member":{},"sourceType":0},{"kind":1,"id":"0399399c70aba8fdab1516cc67a29a0e","order":5,"dBType":5,"name":"Value","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"Value","member":{},"sourceType":0}],"inheritedColumnIdMappings":[["ProductId","d1495619ed48a2b37dab7d43b4eaef34"],["Comment","45d41a4419cfb6e2dbc25b1ea4625f1d"],["TimeId","29aa0f6f4611e80d76a7b8cf7dadc23c"],["AccountId","2051cb647ffba2a075cf59e605255767"],["Value","290bf396a64c04aaac4ddaf91f52e7a6"],["ScenarioId","d1e04e42863cc5aec4294c562b4052d8"],["EntityId","333fc3cfad0a20f61cce1ec0f6a457cc"]]},{"kind":2,"componentId":2,"displayMode":2,"order":1,"name":"Reporting","systemCategory":0,"dataSourceId":1,"modelId":5,"measureGroupName":"CoreMG","removeZeros":true,"columnMappings":[["ProductId","ProductId"],["TimeId","TimeId"],["AccountId","AccountId"],["Value","Value"],["ScenarioId","ScenarioId"],["EntityId","EntityId"]]}],"postExecutionClearType":0,"postExecutionApplyType":0,"workflowExecution":0}]}