Calculate Revenue and COGS true 4 KEPION08\Ian Britz 2020-06-08T20:42:51.873 1 Assumption - Writeback 1 MemberLabel 0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 AccountID 0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 TimeID 0 0 TableColumn Parameter 00000000-0000-0000-0000-000000000000 1 EntityID 0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 ProductID 0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 ScenarioID 0 0 TableColumn Native 00000000-0000-0000-0000-000000000000 0 Value 0 0 TableColumn Native 00000000-0000-0000-0000-000000000000 0 Comment 0 false AccountID 0 SmallInt 0

18241b02-62c3-48ad-854a-dd33c75becfe 0 Account.Account None TableColumn 00000000-0000-0000-0000-000000000000 false false AccountID 00000000-0000-0000-0000-000000000000 TimeID 0 Integer 0

b643583b-58de-48d1-94b5-8fe52a3c947e 1 Time.Months None TableColumn 00000000-0000-0000-0000-000000000000 false false TimeID 00000000-0000-0000-0000-000000000000 ProductID 0 SmallInt 0

33339629-d117-41ec-a163-ba6807bd0e93 3 Product.SKUs None TableColumn 00000000-0000-0000-0000-000000000000 false false ProductID 00000000-0000-0000-0000-000000000000 ScenarioID 0 SmallInt 0

be2c1c54-352e-4bee-bc99-cbc526d7eb7c 4 Scenario.Scenario None TableColumn 00000000-0000-0000-0000-000000000000 false false ScenarioID 00000000-0000-0000-0000-000000000000 Value 0 Double 0

378cfcd5-5314-4650-88de-9f2dc022402a 5 None TableColumn 00000000-0000-0000-0000-000000000000 false false Value 00000000-0000-0000-0000-000000000000 AccountID f2ac9b68-4394-40c3-bac1-19fbcf806d9a TimeID 034e0628-65a2-46fd-b105-fbf504302aba EntityID fb80e594-b814-470f-a953-3b42f24ca1f7 ProductID ecb2f170-b477-488e-af61-919ae2c81fef ScenarioID 0861ebe6-d9eb-491c-987d-87585b10c7cf Value 20eaa994-91e3-4e10-828c-30cf9e64752f Comment 7f6ba341-412c-4e15-8237-978f64ec36f7 CoreMG 8 Writeback Pivot Volume, Price, Cost 2 MemberLabel 1 0 InheritedColumn Members 18241b02-62c3-48ad-854a-dd33c75becfe 0 0 0 InheritedColumn Members b643583b-58de-48d1-94b5-8fe52a3c947e 0 0 0 InheritedColumn Members 9956f768-3bec-4358-82ac-9ef0ab9d2232 0 0 0 InheritedColumn Members 33339629-d117-41ec-a163-ba6807bd0e93 0 0 0 InheritedColumn Members be2c1c54-352e-4bee-bc99-cbc526d7eb7c 0 0 0 InheritedColumn Native 378cfcd5-5314-4650-88de-9f2dc022402a 0 0 false [33] 119361e9-1b4e-4c17-b88b-cd25b90d759e [34] b8f48913-8207-42a1-9515-d440cfeb1d34 [37] 912ff79c-1095-47ba-90d9-7d9904fa4e60 1 Volume 0 true Price 0 true Cost 0 true 18241b02-62c3-48ad-854a-dd33c75becfe 18852fb0-50ba-4103-ab63-f012acef86f2 b643583b-58de-48d1-94b5-8fe52a3c947e 76c4f484-dc0a-49ec-b9c5-02edfa959b55 ffdce9bb-5859-456f-8f47-0780c40b8ac1 1d744209-2cb7-4baa-89e3-207651b2cb3b 33339629-d117-41ec-a163-ba6807bd0e93 4d8dafaf-862a-4761-88d4-4347081e520a be2c1c54-352e-4bee-bc99-cbc526d7eb7c 0f434e9d-a85d-4872-ab1a-ad5b3936d1b4 378cfcd5-5314-4650-88de-9f2dc022402a f6f3fcb1-6053-4468-a5d6-0209ecee74f0 2f9f52b3-5db1-4e37-a79c-a75f62476cdc 9e964f4c-ffe1-4799-a70d-52c184b8a4ab 9956f768-3bec-4358-82ac-9ef0ab9d2232 b9e769cc-c1fe-4854-9ac5-1d5e8789df18 MemberLabel Volume MemberName Volume UniqueName [Account].[Account].&[33] Caption Volume IsLeaf true MemberId 33 MemberLabel Price MemberName Price UniqueName [Account].[Account].&[34] Caption Price IsLeaf true MemberId 34 MemberLabel Cost MemberName Cost UniqueName [Account].[Account].&[37] Caption Cost IsLeaf true MemberId 37 378cfcd5-5314-4650-88de-9f2dc022402a 18241b02-62c3-48ad-854a-dd33c75becfe Calculate Revenue and COGS 3 MemberLabel 2 0 InheritedColumn Members 76c4f484-dc0a-49ec-b9c5-02edfa959b55 0 0 0 InheritedColumn Members 4d8dafaf-862a-4761-88d4-4347081e520a 0 0 0 InheritedColumn Members 0f434e9d-a85d-4872-ab1a-ad5b3936d1b4 0 0 0 InheritedColumn Native 119361e9-1b4e-4c17-b88b-cd25b90d759e 0 0 0 InheritedColumn Native b8f48913-8207-42a1-9515-d440cfeb1d34 0 0 0 InheritedColumn Native 912ff79c-1095-47ba-90d9-7d9904fa4e60 0 0 false TimeID 0 Integer 0

c4149f67-9eb1-49f7-bf2e-ba32267fd828 0 Time.Months None InheritedColumn 76c4f484-dc0a-49ec-b9c5-02edfa959b55 false false 00000000-0000-0000-0000-000000000000 ProductID 0 SmallInt 0

3062e75f-cbf9-4467-a893-e2e92f17ef08 2 Product.SKUs None InheritedColumn 4d8dafaf-862a-4761-88d4-4347081e520a false false 00000000-0000-0000-0000-000000000000 ScenarioID 0 SmallInt 0

756f0f75-7a38-45db-a211-4a05aa9c21a8 3 Scenario.Scenario None InheritedColumn 0f434e9d-a85d-4872-ab1a-ad5b3936d1b4 false false 00000000-0000-0000-0000-000000000000 Gross Sales Before Returns 0 Double 0

a34ede4c-9411-43ea-9c75-aa3a9fdc6356 4 Sum ${119361e9-1b4e-4c17-b88b-cd25b90d759e}*${b8f48913-8207-42a1-9515-d440cfeb1d34} UserDefinedExpression 00000000-0000-0000-0000-000000000000 true false 00000000-0000-0000-0000-000000000000 Cost of Goods Sold 0 Double 0

60b3591f-817a-4b59-9c8a-6c42600a9f71 5 Sum ${119361e9-1b4e-4c17-b88b-cd25b90d759e}*${912ff79c-1095-47ba-90d9-7d9904fa4e60} UserDefinedExpression 00000000-0000-0000-0000-000000000000 true false 00000000-0000-0000-0000-000000000000 2 Unpivot Revenue and COGS 4 MemberLabel 3 false 3 c4149f67-9eb1-49f7-bf2e-ba32267fd828 ecc12157-4f6e-49a1-afe0-f49030f4ef99 bd697c8e-8a8d-4d85-b7d5-aef45b0cc0f1 2537f84a-d952-45ab-be0e-8d7fb88dd0dd 3062e75f-cbf9-4467-a893-e2e92f17ef08 df74611f-cf6a-454d-8058-e9edde2de51b 756f0f75-7a38-45db-a211-4a05aa9c21a8 1df8bb98-c11f-4003-9c4d-6602b757f276 a34ede4c-9411-43ea-9c75-aa3a9fdc6356 547a4f2c-aedd-49e3-ad13-526a86d91b34 60b3591f-817a-4b59-9c8a-6c42600a9f71 9ee5d547-b953-4bb0-ac1c-1b1e114be2b3 7717ac29-e5d9-43c2-9962-d5cd63abe8d0 0d30e84d-6928-4845-b738-42dd02520b95 45beb955-6e37-4b14-be9d-e96cd72dbc9d 599130a1-f3f9-4aa5-98e1-65ff0dbb8181 true AccountID fe7a3769-9fd0-4ec9-969f-bcf796ea1c3f a34ede4c-9411-43ea-9c75-aa3a9fdc6356 60b3591f-817a-4b59-9c8a-6c42600a9f71 Account.Account Value ee7d66ec-77ba-4bf4-a463-ad48b6b4175b Delete Reporting - Calculated 5 MemberLabel 4 false AccountID cb39db32-e327-47ee-a422-b7b3f31ccdb4 TimeID b0ceeadf-a3fa-4b86-affd-be7ae84c137b EntityID e5c0fb9e-c2fa-4fae-918a-1895d1e1429d ProductID 16591cb9-bc27-4ff5-b06a-dafaec153904 ScenarioID 94b73643-565a-4578-a220-8ceee82556d2 Value 4272f6e5-dfb2-427e-abfe-228676953ee0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 AccountID 0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 TimeID 0 0 TableColumn Parameter 00000000-0000-0000-0000-000000000000 1 EntityID 0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 ProductID 0 0 TableColumn Members 00000000-0000-0000-0000-000000000000 0 ScenarioID 0 0 TableColumn Native 00000000-0000-0000-0000-000000000000 0 Value 0 CoreMG 5 Reporting Calculated Insert Reporting - Calculated 6 MemberLabel 5 false AccountID AccountID TimeID TimeID EntityID @EntityID ProductID ProductID ScenarioID ScenarioID Value Value 4 true false CoreMG 5 Calculated true Procedure 7 MemberLabel 6 false 5 0 4 6 1 4 Revenue_and_COGS 0 0001-01-01T00:00:00 EntityID Entity 0 Entity MemberLabel Canada MemberName Canada UniqueName [Entity].[Entity].&[2] Caption Canada IsLeaf true MemberId 2 1 0 false 0 Hierarchy