{ "type" : "dataRule", "metadata" : [{"kind":4,"id":10,"active":true,"modifiedDate":{"value":1765208784350},"modifiedBy":"Keziah Patha","name":"Calculating Revenue and COGS","systemCategory":0,"components":[{"kind":1,"componentId":1,"displayMode":2,"name":"Assumption - Writeback","systemCategory":0,"filters":[{"columnType":1,"tableColumn":"AccountId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"columnType":1,"tableColumn":"ScenarioId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"columnType":1,"tableColumn":"TimeId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"parameterId":1,"columnType":1,"tableColumn":"EntityId","inheritedColumnId":"00000000000000000000000000000000","expressionType":3,"systemCategory":0},{"columnType":1,"tableColumn":"ProductId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"columnType":1,"tableColumn":"Value","inheritedColumnId":"00000000000000000000000000000000","expressionType":2,"systemCategory":0},{"columnType":1,"tableColumn":"Comment","inheritedColumnId":"00000000000000000000000000000000","expressionType":2,"systemCategory":0}],"modelId":13,"measureGroupName":"CoreMG","partitionName":"Writeback","targetColumns":[{"kind":1,"id":"501f8f412dd4b005de5378b5546c3770","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":"b620bb29adeec92b26611031f978bec9","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":"85d13303487b6a372515b2e9f3d6657a","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":"6181949050a40af7d3b88ad60b3f7836","order":4,"reference":"Product.SKUs","dBType":2,"name":"ProductId","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"ProductId","member":{},"sourceType":0},{"kind":1,"id":"5086a99c2900b5f4076fab95951370a8","order":5,"dBType":5,"name":"Value","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":1,"tableColumn":"Value","member":{},"sourceType":0}],"inheritedColumnIdMappings":[["ProductId","aec5ab3e84b2096eba9696ed5a1712a4"],["Comment","5c3c152cd77925de38a36e437d1fab80"],["TimeId","b705cf8192ba41ee5d0e3d1b3b772a44"],["AccountId","d7ae79822a1eda26e4d268598be27876"],["Value","b592e3ec5392188dc284260251122326"],["ScenarioId","dbb047eb8126e20cb382ace4784aa6d9"],["EntityId","bebeecd9c378207413008cc45fd56835"]]},{"kind":8,"componentId":2,"displayMode":2,"order":1,"name":"Pivot Volume, Price and Cost","systemCategory":0,"dataSourceId":1,"targetColumns":[{"kind":1,"id":"16b85bf4a13e18858e9f06516d70cbb8","order":1,"reference":"Scenario.Scenario","dBType":2,"name":"ScenarioId","systemCategory":0,"inheritedColumnId":"b620bb29adeec92b26611031f978bec9","aggregationFunction":0,"expressionType":2,"sourceType":0},{"kind":1,"id":"8293e1b85da7e1608010d9c033183202","order":2,"reference":"Time.Months","dBType":3,"name":"TimeId","systemCategory":0,"inheritedColumnId":"85d13303487b6a372515b2e9f3d6657a","aggregationFunction":0,"expressionType":2,"sourceType":0},{"kind":1,"id":"2e88cf4fe424825d12bf64d075a3bd3a","order":4,"reference":"Product.SKUs","dBType":2,"name":"ProductId","systemCategory":0,"inheritedColumnId":"6181949050a40af7d3b88ad60b3f7836","aggregationFunction":0,"expressionType":2,"sourceType":0},{"kind":1,"id":"9d52d55ca3076e1dafed5176aa879696","order":2147483647,"dBType":5,"name":"Volume","systemCategory":0,"aggregationFunction":0,"expressionType":3,"expression":"[33]","sourceType":0},{"kind":1,"id":"6bbd60e3df84aa953505e79e046acbab","order":2147483647,"dBType":5,"name":"Price","systemCategory":0,"aggregationFunction":0,"expressionType":3,"expression":"[34]","sourceType":0},{"kind":1,"id":"d07546a465ca06d178e9201606e4abd6","order":2147483647,"dBType":5,"name":"Cost","systemCategory":0,"aggregationFunction":0,"expressionType":3,"expression":"[35]","sourceType":0}],"inheritedColumnIdMappings":[["85d13303487b6a372515b2e9f3d6657a","8293e1b85da7e1608010d9c033183202"],["6181949050a40af7d3b88ad60b3f7836","2e88cf4fe424825d12bf64d075a3bd3a"],["5086a99c2900b5f4076fab95951370a8","b62d9d79f2e7d83cd04fa2e18154cdb7"],["501f8f412dd4b005de5378b5546c3770","e7f6e4aca833eb3445d5233fff874d4e"],["f8e00e24459768a62466b5d2a4a2a2d2","cbdb6d86969196c5a6784cb4963b4bc4"],["b620bb29adeec92b26611031f978bec9","16b85bf4a13e18858e9f06516d70cbb8"]],"pivotSourceColumnId":"501f8f412dd4b005de5378b5546c3770","pivotAggregationColumnId":"5086a99c2900b5f4076fab95951370a8","members":[{"entries":[["MemberLabel",{"type":1,"stringValue":"Volume","doubleValue":0}],["MemberName",{"type":1,"stringValue":"Volume","doubleValue":0}],["UniqueName",{"type":1,"stringValue":"[Account].[Account].&[33]","doubleValue":0}],["Caption",{"type":1,"stringValue":"Volume","doubleValue":0}],["IsLeaf",{"type":2,"booleanValue":true,"doubleValue":0}],["MemberId",{"type":3,"int32Value":33,"doubleValue":0}]]},{"entries":[["MemberLabel",{"type":1,"stringValue":"Price","doubleValue":0}],["MemberName",{"type":1,"stringValue":"Price","doubleValue":0}],["UniqueName",{"type":1,"stringValue":"[Account].[Account].&[34]","doubleValue":0}],["Caption",{"type":1,"stringValue":"Price","doubleValue":0}],["IsLeaf",{"type":2,"booleanValue":true,"doubleValue":0}],["MemberId",{"type":3,"int32Value":34,"doubleValue":0}]]},{"entries":[["MemberLabel",{"type":1,"stringValue":"Cost","doubleValue":0}],["MemberName",{"type":1,"stringValue":"Cost","doubleValue":0}],["UniqueName",{"type":1,"stringValue":"[Account].[Account].&[35]","doubleValue":0}],["Caption",{"type":1,"stringValue":"Cost","doubleValue":0}],["IsLeaf",{"type":2,"booleanValue":true,"doubleValue":0}],["MemberId",{"type":3,"int32Value":35,"doubleValue":0}]]}],"defaults":[{"isEnabled":true,"column":"Volume","defaultValue":"0"},{"isEnabled":true,"column":"Price","defaultValue":"0"},{"isEnabled":true,"column":"Cost","defaultValue":"0"}],"cachedPivotColumnIdMappings":[["[33]","9d52d55ca3076e1dafed5176aa879696"],["[35]","d07546a465ca06d178e9201606e4abd6"],["[34]","6bbd60e3df84aa953505e79e046acbab"]]},{"kind":5,"componentId":3,"displayMode":2,"order":2,"name":"Calculate Revenue and COGS","systemCategory":0,"dataSourceId":2,"targetColumns":[{"kind":1,"id":"c7c229f7ac4fcbd834ef21fbab536791","reference":"Scenario.Scenario","dBType":2,"name":"ScenarioId","systemCategory":0,"inheritedColumnId":"16b85bf4a13e18858e9f06516d70cbb8","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":2,"member":{},"sourceType":0},{"kind":1,"id":"3ba68b5950c23af86a7a982e1dc8ce30","order":1,"reference":"Time.Months","dBType":3,"name":"TimeId","systemCategory":0,"inheritedColumnId":"8293e1b85da7e1608010d9c033183202","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":2,"member":{},"sourceType":0},{"kind":1,"id":"ec5fc10452ef464acad7aef3736bb9f9","order":3,"reference":"Product.SKUs","dBType":2,"name":"ProductId","systemCategory":0,"inheritedColumnId":"2e88cf4fe424825d12bf64d075a3bd3a","unionColumnId":"00000000000000000000000000000000","aggregationFunction":0,"expressionType":2,"member":{},"sourceType":0},{"kind":1,"id":"e0d6835451585e986da731467e0b69ec","aliasId":-1,"order":7,"dBType":5,"name":"Gross Sales Before Returns","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","isEnforceType":true,"aggregationFunction":1,"expressionType":3,"expression":"${9d52d55c-a307-6e1d-afed-5176aa879696}*${6bbd60e3-df84-aa95-3505-e79e046acbab}","member":{},"sourceType":0},{"kind":1,"id":"6d4a5f4063984473b1ac0ab9d3aa3c28","aliasId":-1,"order":8,"dBType":5,"name":"Cost of Goods Sold","systemCategory":0,"inheritedColumnId":"00000000000000000000000000000000","unionColumnId":"00000000000000000000000000000000","isEnforceType":true,"aggregationFunction":1,"expressionType":3,"expression":"${9d52d55c-a307-6e1d-afed-5176aa879696}*${d07546a4-65ca-06d1-78e9-201606e4abd6}","member":{},"sourceType":0}]},{"kind":10,"componentId":4,"displayMode":2,"order":3,"name":"Unpivot Revenue and COGS","systemCategory":0,"dataSourceId":3,"removeZeros":true,"targetColumns":[{"kind":1,"id":"a8f4da2d2de4e6d199505e26de17f707","reference":"Scenario.Scenario","dBType":2,"name":"ScenarioId","systemCategory":0,"inheritedColumnId":"c7c229f7ac4fcbd834ef21fbab536791","aggregationFunction":0,"expressionType":2,"sourceType":0},{"kind":1,"id":"b8f7336e010964d43e7f5b7694e6f512","order":1,"reference":"Time.Months","dBType":3,"name":"TimeId","systemCategory":0,"inheritedColumnId":"3ba68b5950c23af86a7a982e1dc8ce30","aggregationFunction":0,"expressionType":2,"sourceType":0},{"kind":1,"id":"6400629fc459727ff6670ee8d8eb37c8","order":3,"reference":"Product.SKUs","dBType":2,"name":"ProductId","systemCategory":0,"inheritedColumnId":"ec5fc10452ef464acad7aef3736bb9f9","aggregationFunction":0,"expressionType":2,"sourceType":0},{"kind":1,"id":"8f5593b6b9727b9c387c3a83d2451b19","order":2147483646,"reference":"Account.Account","dBType":0,"name":"AccountId","systemCategory":0,"aggregationFunction":0,"expressionType":3,"expression":"DIM.[MemberId]","sourceType":0},{"kind":1,"id":"de5ede99829af45065621eecbbfef099","order":2147483647,"dBType":5,"name":"Value","systemCategory":0,"aggregationFunction":0,"expressionType":3,"expression":"[(Value)]","sourceType":0}],"inheritedColumnIdMappings":[["3ba68b5950c23af86a7a982e1dc8ce30","b8f7336e010964d43e7f5b7694e6f512"],["e0d6835451585e986da731467e0b69ec","42a48edf4b6872709b7503e78d0dd31d"],["4b54fbfdcd5e36888a24b566f821f192","b563e5855f5ee9a605e2eea59a7a0cf6"],["ec5fc10452ef464acad7aef3736bb9f9","6400629fc459727ff6670ee8d8eb37c8"],["6d4a5f4063984473b1ac0ab9d3aa3c28","5271fa4f28932068b8c4d05411338d66"],["c7c229f7ac4fcbd834ef21fbab536791","a8f4da2d2de4e6d199505e26de17f707"]],"unpivotValue":"Value","unpivotColumn":"AccountId","unpivotValueId":"de5ede99829af45065621eecbbfef099","unpivotColumnId":"8f5593b6b9727b9c387c3a83d2451b19","unpivotColumnMemberList":"Account.Account","unpivotColumnIds":["e0d6835451585e986da731467e0b69ec","6d4a5f4063984473b1ac0ab9d3aa3c28"]},{"kind":11,"componentId":5,"displayMode":2,"order":4,"name":"Delete Reporting - Calculated","systemCategory":0,"filters":[{"columnType":1,"tableColumn":"AccountId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"columnType":1,"tableColumn":"ScenarioId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"columnType":1,"tableColumn":"TimeId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"parameterId":1,"columnType":1,"tableColumn":"EntityId","inheritedColumnId":"00000000000000000000000000000000","expressionType":3,"systemCategory":0},{"columnType":1,"tableColumn":"ProductId","inheritedColumnId":"00000000000000000000000000000000","expressionType":1,"systemCategory":0},{"columnType":1,"tableColumn":"Value","inheritedColumnId":"00000000000000000000000000000000","expressionType":2,"systemCategory":0}],"modelId":5,"measureGroupName":"CoreMG","partitionName":"Calculated","deleteColumnIdMappings":[["ProductId","a5277421c3cdb803f9aca5ace02914ec"],["TimeId","03a3f05251f21ebabc924b7525d37ca4"],["AccountId","4304e3249cf45706c7f9b2cb36f64933"],["Value","3da9cfde4e6c2bb73fb4be64d5e13146"],["ScenarioId","83764503a4bcf638b0ab8c4e25d58ae9"],["EntityId","b097a5cb7ebe241dead994ee95da0719"]],"modelName":"Reporting"},{"kind":12,"componentId":6,"displayMode":2,"order":5,"name":"Insert Reporting - Calculated","systemCategory":0,"dataSourceId":4,"modelId":5,"measureGroupName":"CoreMG","partitionName":"Calculated","removeZeros":true,"groupBy":true,"columnMappings":[["ProductId","ProductId"],["TimeId","TimeId"],["AccountId","AccountId"],["Value","Value"],["ScenarioId","ScenarioId"],["EntityId","@EntityID"]]},{"kind":3,"componentId":7,"displayMode":2,"order":6,"name":"Procedure","systemCategory":0,"spName":"Revenue_and_COGS","actions":[{"componentId":5,"ruleId":10,"systemCategory":0},{"componentId":6,"ruleId":10,"order":1,"systemCategory":0}]}],"applicationParameters":[{"parameterType":1,"dimension":"Entity","hierarchy":"Entity","floatValue":0,"hierarchyMembers":[{"entries":[["MemberLabel",{"type":1,"stringValue":"Canada","doubleValue":0}],["MemberName",{"type":1,"stringValue":"Canada","doubleValue":0}],["UniqueName",{"type":1,"stringValue":"[Entity].[Entity].&[2]","doubleValue":0}],["Caption",{"type":1,"stringValue":"Canada","doubleValue":0}],["IsLeaf",{"type":2,"booleanValue":true,"doubleValue":0}],["MemberId",{"type":3,"int32Value":2,"doubleValue":0}]]}],"order":1,"name":"EntityID","systemCategory":0,"id":1}],"postExecutionClearType":0,"postExecutionApplyType":0,"workflowExecution":0}]}