09dcb6fc-b678-4f50-bd0c-9e235ebda391 b4e67503-0758-4d68-9169-9e235eb58fe9 1 Qty Qty bigint Qty bigint bigint 0 0 0 false false false true true None 1 false false a46a6525-ee70-414c-a55c-9e235ec1d4d9 b4e67503-0758-4d68-9169-9e235eb58fe9 2 Products Products bigint Products bigint bigint 0 0 0 false false false true true None 2 false false 8d74d22c-ef7e-4a16-934c-9e235ec6b4f9 b4e67503-0758-4d68-9169-9e235eb58fe9 3 Customers Customers bigint Customers bigint bigint 0 0 0 false false false true true None 3 false false 6d493467-d107-42a3-b8f0-a0904ca857f0 b4e67503-0758-4d68-9169-9e235eb58fe9 4 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 66fee6d6-e3ee-4d86-8345-a0904ca857f1 b4e67503-0758-4d68-9169-9e235eb58fe9 5 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 1e137dd5-ee4d-49b2-b0b9-a0904ca85818 b4e67503-0758-4d68-9169-9e235eb58fe9 6 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false d74172f4-50a0-4212-a1a1-a0904ca85819 b4e67503-0758-4d68-9169-9e235eb58fe9 7 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 9a0e779e-386a-4bf9-945a-9e235eda1c29 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 1 Id Id bigint Id bigint bigint 0 0 0 false false false true true None 1 false false 23125a65-7419-45bf-89c1-9e235edc2b31 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 2 Name Name varchar(50) Name varchar varchar(50) 50 0 0 false false false true true None 2 false false a3473dfe-51a9-4bf2-a182-a0904ca8581a 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 3 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false b630d9f3-4fa5-412f-baf6-a0904ca8581b 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 4 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 2b8fb4ee-9f02-4419-90e0-a0904ca8581c 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 5 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false 388c06fb-7f3f-4d4d-9fcc-a0904ca8581d 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 6 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 9dbf5126-4af6-410a-adfa-9e235ee25fce 2c571f6e-837b-40c1-876e-9e235ed475e9 1 Id Id bigint Id bigint 0 0 0 false false false true true None 1 false false 2b1c63e5-63fa-401b-986f-9e235ee650cf 2c571f6e-837b-40c1-876e-9e235ed475e9 2 Name Name varchar(50) Name varchar varchar(50) 50 0 0 false false false true true None 2 false false 84ce1ed5-6100-43cf-b14d-a0904ca8581e 2c571f6e-837b-40c1-876e-9e235ed475e9 3 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false d93ec03a-caf0-4413-ba8f-a0904ca8581f 2c571f6e-837b-40c1-876e-9e235ed475e9 4 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 342d5bb8-408e-4b46-ac91-a0904ca85840 2c571f6e-837b-40c1-876e-9e235ed475e9 5 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false 7297af74-9aff-4156-9a3f-a0904ca85841 2c571f6e-837b-40c1-876e-9e235ed475e9 6 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 eace38ca-3635-4f15-b395-9e235ea597a1 Customers dbo Customers true 2 DataWarehouse AsProject AsProject false false true true false false false b4e67503-0758-4d68-9169-9e235eb58fe9 eace38ca-3635-4f15-b395-9e235ea597a1 factOrders dbo factOrders true 1 DataWarehouse AsProject AsProject false false true true false false false 2c571f6e-837b-40c1-876e-9e235ed475e9 eace38ca-3635-4f15-b395-9e235ea597a1 Products dbo Products true 3 DataWarehouse AsProject AsProject false false true true false false false 54700991-680c-492d-b4bc-9e235f3ebaa3 b4e67503-0758-4d68-9169-9e235eb58fe9 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 Customers false Error 37eb5b2c-101c-434e-abec-9e235f3d45f1 b4e67503-0758-4d68-9169-9e235eb58fe9 2c571f6e-837b-40c1-876e-9e235ed475e9 Products false Error eb4684b3-c309-4d86-9909-9e235f688c65 04f7a7e4-11dc-4563-8336-9e235f43057f factOrders factOrders true false false true -1 false b53848f5-b95e-462a-8b95-9e235f9e55e5 eb4684b3-c309-4d86-9909-9e235f688c65 Percent of total Customer true TimeXtender.DataManager.Measure_BusinessFunction Percent 2 false 834ccb1a-e674-44d8-8088-9e235fafd608 eb4684b3-c309-4d86-9909-9e235f688c65 Columns true TimeXtender.DataManager.Measure_BusinessFunction Percent 3 false b38da28c-d2dd-40c4-a80c-9e235fbcfc9e eb4684b3-c309-4d86-9909-9e235f688c65 Rows true TimeXtender.DataManager.Measure_BusinessFunction Percent 4 false 64739d79-a590-4355-b47a-9e235f6d14d2 eb4684b3-c309-4d86-9909-9e235f688c65 09dcb6fc-b678-4f50-bd0c-9e235ebda391 b4e67503-0758-4d68-9169-9e235eb58fe9 Qty true Sum TimeXtender.DataManager.Measure #,# 1 false 6a5d3903-85ac-4773-85d7-9e235f4a549f 04f7a7e4-11dc-4563-8336-9e235f43057f Customers Visible false -1 cda77794-1522-4eda-8c40-9e235f53e615 04f7a7e4-11dc-4563-8336-9e235f43057f Products Visible false -1 a1592412-7ea4-456f-a21a-9e235f4b96d7 6a5d3903-85ac-4773-85d7-9e235f4a549f 23125a65-7419-45bf-89c1-9e235edc2b31 9a0e779e-386a-4bf9-945a-9e235eda1c29 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 1 Customer false true Key Name false Never false false false true false true fcf1a2be-9869-4a76-b090-9e235f55392e cda77794-1522-4eda-8c40-9e235f53e615 2b1c63e5-63fa-401b-986f-9e235ee650cf 9dbf5126-4af6-410a-adfa-9e235ee25fce 2c571f6e-837b-40c1-876e-9e235ed475e9 2c571f6e-837b-40c1-876e-9e235ed475e9 1 Product false true Key Name false Never false false false true false true d126a437-f47b-4be7-a703-9e235e9e9ba9 Percentages true Normal 0 true false false 12.4.8.32 4.4.5.32 0 9999-12-31T23:59:59.997+01:00 Error true true false LpfF12aIyNXO8MbDO3IGTQkiT5oDOLHruwDLn84RAeElYZmsL976llraKVkW2YcTNzCuuBexJIfxWC6d4JSDIlCg+z70MDcO1POVk3uybKqGTwC9V9x5I3vnfiafdM2SA2uVnq1BtkBuQSQQbPMpEFvqo227+F9Ma/a+AhnlaIyHfYZl2RVvI0g9UzIkaQCPvXshApa6HPYLNaZzsSKEJBKszWkOpHuvf8U4b82dw3NAsXz7wfgshbDLAtTvOnHgHGbuhWed+s7LEY9UtHeiD7biHQkdNoZZzMdP+Fua5jzyYwMmXhJsr1vCfyPGlJlF false Error false false 771748a6-f3ab-4224-97be-9e235ea596d9 d126a437-f47b-4be7-a703-9e235e9e9ba9 DWH false 1 bcb0715b-5b86-46a0-9c14-9e235f3d4709 37eb5b2c-101c-434e-abec-9e235f3d45f1 a46a6525-ee70-414c-a55c-9e235ec1d4d9 9dbf5126-4af6-410a-adfa-9e235ee25fce 323900f0-359d-4113-9e61-9e235f3ebacb 54700991-680c-492d-b4bc-9e235f3ebaa3 8d74d22c-ef7e-4a16-934c-9e235ec6b4f9 9a0e779e-386a-4bf9-945a-9e235eda1c29 04f7a7e4-11dc-4563-8336-9e235f43057f d126a437-f47b-4be7-a703-9e235e9e9ba9 771748a6-f3ab-4224-97be-9e235ea596d9 00000000-0000-0000-0000-000000000000 false OLAP . OLAP false DWH DSV false Not_Set false eace38ca-3635-4f15-b395-9e235ea597a1 771748a6-f3ab-4224-97be-9e235ea596d9 00000000-0000-0000-0000-000000000000 false . true QmEvtm671whyw2kZhSr/xw== DWH 100 15 As_Parent 0 Not_Set 0f65218a-a313-49b3-9f61-9e235f70d4eb eb4684b3-c309-4d86-9909-9e235f688c65 6a5d3903-85ac-4773-85d7-9e235f4a549f Customers ed88653b-99aa-4fde-9ea9-9e235f72142b eb4684b3-c309-4d86-9909-9e235f688c65 cda77794-1522-4eda-8c40-9e235f53e615 Products a13c164f-189a-42a0-b251-9e235f70d58b 0f65218a-a313-49b3-9f61-9e235f70d4eb a1592412-7ea4-456f-a21a-9e235f4b96d7 8c4a5779-be42-40e5-b76c-9e235f72142c ed88653b-99aa-4fde-9ea9-9e235f72142b fcf1a2be-9869-4a76-b090-9e235f55392e 0e5a1910-2fbe-4775-a61d-9e235f688d05 eb4684b3-c309-4d86-9909-9e235f688c65 b4e67503-0758-4d68-9169-9e235eb58fe9 false 52d462c4-ecb9-449f-b14b-bf5fb564a186 a1592412-7ea4-456f-a21a-9e235f4b96d7 9a0e779e-386a-4bf9-945a-9e235eda1c29 a433b1dc-22b3-412c-8be5-1bc5cb6c4ab1 fcf1a2be-9869-4a76-b090-9e235f55392e 9dbf5126-4af6-410a-adfa-9e235ee25fce 5e3e40ee-faa9-4485-bb10-9e235f799c7d eb4684b3-c309-4d86-9909-9e235f688c65 0f65218a-a313-49b3-9f61-9e235f70d4eb 0e5a1910-2fbe-4775-a61d-9e235f688d05 false dae39d7c-89e2-4d35-9ab4-9e235f799d95 eb4684b3-c309-4d86-9909-9e235f688c65 ed88653b-99aa-4fde-9ea9-9e235f72142b 0e5a1910-2fbe-4775-a61d-9e235f688d05 false c4d69f3b-28c2-4c4a-9350-9e235f799dbd dae39d7c-89e2-4d35-9ab4-9e235f799d95 a46a6525-ee70-414c-a55c-9e235ec1d4d9 9dbf5126-4af6-410a-adfa-9e235ee25fce a9ee6fc3-3a33-4bcf-ab3c-9e235f799d1d 5e3e40ee-faa9-4485-bb10-9e235f799c7d 8d74d22c-ef7e-4a16-934c-9e235ec6b4f9 9a0e779e-386a-4bf9-945a-9e235eda1c29 a9ee6fc3-3a33-4bcf-ab3c-9e235f799d1d a1592412-7ea4-456f-a21a-9e235f4b96d7 c4d69f3b-28c2-4c4a-9350-9e235f799dbd fcf1a2be-9869-4a76-b090-9e235f55392e a1592412-7ea4-456f-a21a-9e235f4b96d7 fcf1a2be-9869-4a76-b090-9e235f55392e 9bdb3464-40c9-4d35-843a-9e235efbfa85 b4e67503-0758-4d68-9169-9e235eb58fe9 <NewDataSet><factOrders_CustomData><Qty>10</Qty><Products>2</Products><Customers>1</Customers></factOrders_CustomData><factOrders_CustomData><Qty>15</Qty><Products>3</Products><Customers>1</Customers></factOrders_CustomData><factOrders_CustomData><Qty>12</Qty><Products>0</Products><Customers>1</Customers></factOrders_CustomData><factOrders_CustomData><Qty>18</Qty><Products>1</Products><Customers>2</Customers></factOrders_CustomData><factOrders_CustomData><Qty>22</Qty><Products>2</Products><Customers>1</Customers></factOrders_CustomData><factOrders_CustomData><Qty>11</Qty><Products>3</Products><Customers>3</Customers></factOrders_CustomData><factOrders_CustomData><Qty>32</Qty><Products>1</Products><Customers>0</Customers></factOrders_CustomData><factOrders_CustomData><Qty>15</Qty><Products>0</Products><Customers>1</Customers></factOrders_CustomData></NewDataSet> 56ffcef9-7035-479c-953a-9e235f22e49c 2dc8d400-36e3-4e39-bcdd-9e235ecde0e9 <NewDataSet><Customers_CustomData><Id>0</Id><Name>PowerShoes</Name></Customers_CustomData><Customers_CustomData><Id>1</Id><Name>BootStore</Name></Customers_CustomData><Customers_CustomData><Id>2</Id><Name>Sneakers4Kidz</Name></Customers_CustomData><Customers_CustomData><Id>3</Id><Name>BadBoots</Name></Customers_CustomData></NewDataSet> 4cd7d283-30d0-4445-9302-9e235f38a22b 2c571f6e-837b-40c1-876e-9e235ed475e9 <NewDataSet><Products_CustomData><Id>0</Id><Name>Blue Sneaker</Name></Products_CustomData><Products_CustomData><Id>1</Id><Name>Leather Boot</Name></Products_CustomData><Products_CustomData><Id>2</Id><Name>Black Shoe</Name></Products_CustomData><Products_CustomData><Id>3</Id><Name>Yellow Shoe</Name></Products_CustomData></NewDataSet> 19528c22-79bd-413a-856c-9e235f9e57ed d3a90767-acd5-4900-85db-9e235f9e55e6 64739d79-a590-4355-b47a-9e235f6d14d2 Measure Measure 0 694ac80b-8200-47af-9b70-9e235f9e588d d3a90767-acd5-4900-85db-9e235f9e55e6 0f65218a-a313-49b3-9f61-9e235f70d4eb;a1592412-7ea4-456f-a21a-9e235f4b96d7 DimensionHierarchy Dimension_Level 1 4c66c57f-ed8e-4473-9dea-9e235fafd658 c0f80f9e-a4ef-4e33-a746-9e235fafd609 64739d79-a590-4355-b47a-9e235f6d14d2 Number Measure Amount or quantity 0 fac33464-366e-4d4b-96c0-9e235fbcfd16 e84961d3-5ca8-4223-ab66-9e235fbcfc9f 64739d79-a590-4355-b47a-9e235f6d14d2 Number Measure The measure the use for the calculation 0 d3a90767-acd5-4900-85db-9e235f9e55e6 b53848f5-b95e-462a-8b95-9e235f9e55e5 Percent of total (Measure)/Sum(DimensionHierarchy.[(All)],(Measure)) How many percent does the current member of a dimension contriute towards the total for the dimension. Example: In a Color dimension, how many percent does the color Red contribute with to the total. Note: Use % in Format String to get the result as a percentage. c0f80f9e-a4ef-4e33-a746-9e235fafd609 834ccb1a-e674-44d8-8088-9e235fafd608 Percent for Columns Case when isempty(Number) then 0 else iif(isempty(Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent),1,Number/(Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent,Number)) End Displays the percentage of the selected measure, as a part of the column total instead of grand total Remember to set the Format string to 'Percent'! e84961d3-5ca8-4223-ab66-9e235fbcfc9f b38da28c-d2dd-40c4-a80c-9e235fbcfc9e Percent for Rows Case when isempty(Number) then 0 else iif(isempty(Axis(0).Item(0).Item(0).Dimension.CurrentMember.Parent),1,Number/(Axis(0).Item(0).Item(0).Dimension.CurrentMember.Parent,Number)) End Displays a percentage of the row total instead of the grand total Remember to set the Format string to 'Percent'!