ea2f29cc-065e-453b-9910-9e225c86bdd1 c369c106-47c7-4a67-b61f-9e225c7f79ca 1 TransactionDate TransactionDate datetime TransactionDate datetime datetime 0 0 0 false false false true true None 2 false false 7a25ac10-9a1a-429c-b472-9e225c8d0eb3 c369c106-47c7-4a67-b61f-9e225c7f79ca 2 Company Company varchar(50) Company varchar varchar(50) 50 0 0 false false false true true None 1 false false bca82505-b593-4da1-b79b-9e225c9a80c3 c369c106-47c7-4a67-b61f-9e225c7f79ca 3 ValueInCompanyCurr ValueInCompanyCurr decimal(38,2) ValueInCompanyCurr decimal decimal(38,2) 0 2 38 false false false true true None 3 false false c59b1697-8500-4e0f-81d1-a0904c8b197e c369c106-47c7-4a67-b61f-9e225c7f79ca 4 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 7a5d937c-a234-4edf-ae4d-a0904c8b197f c369c106-47c7-4a67-b61f-9e225c7f79ca 5 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 9bae0902-1a0b-4117-8acf-a0904c8b1980 c369c106-47c7-4a67-b61f-9e225c7f79ca 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 992fbc26-ad57-47c3-83c9-a0904c8b1981 c369c106-47c7-4a67-b61f-9e225c7f79ca 7 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 5276bd5f-e738-46cf-8fe0-9e225caf255a 56324cba-93e4-44ce-b184-9e225ca8e329 1 Company Company varchar(50) Company varchar varchar(50) 50 0 0 false false true true true None 1 false false 03912a54-ce6b-4503-bb6d-9e225cb31404 56324cba-93e4-44ce-b184-9e225ca8e329 2 CompanyCurr CompanyCurr varchar(50) CompanyCurr varchar varchar(50) 50 0 0 false false false true true None 3 false false 2adbc7fa-6e9a-4b3c-bc9e-9e225cbd0bad 56324cba-93e4-44ce-b184-9e225ca8e329 3 CompanyName CompanyName varchar(50) CompanyName varchar varchar(50) 50 0 0 false false false true true None 2 false false 9f2cb22b-41ae-4dc7-adc8-a0904c8b197a 56324cba-93e4-44ce-b184-9e225ca8e329 4 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 36cfbefe-d2ec-40cd-b457-a0904c8b197b 56324cba-93e4-44ce-b184-9e225ca8e329 5 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false c81253c6-1068-4da6-aaf0-a0904c8b197c 56324cba-93e4-44ce-b184-9e225ca8e329 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 511ea701-7077-4578-93a8-a0904c8b197d 56324cba-93e4-44ce-b184-9e225ca8e329 7 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false cba5b9ba-3b17-4604-b0e4-9e225d55c39e 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 1 Company Company varchar(50) Company varchar varchar(50) 50 0 0 false false false true true None 1 false false 797a3dc3-55cc-4d4b-bc5d-9e225d595a75 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 2 CurrencyCode CurrencyCode varchar(50) CurrencyCode varchar varchar(50) 50 0 0 false false false true true None 2 false false 9bea40d0-bd5b-48cf-aa6e-9e225d604a93 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 3 ExchangeRate ExchangeRate decimal(38,5) ExchangeRate decimal 0 5 38 false false false true true None 3 false false 310e4bbb-5a02-484b-854a-9e225d64b7d0 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 4 DateFrom DateFrom datetime DateFrom datetime datetime 0 0 0 false false false true true None 4 false false 73e28948-c0af-427c-9c4d-9e225d67b763 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 5 DateTo DateTo datetime DateTo datetime datetime 0 0 0 false false false true true None 5 false false fd8dfb73-8265-4d76-9fb0-a0904c8b1982 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 6 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 46ebbb39-6856-4a12-815b-a0904c8b1983 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 7 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 80faace0-447d-4f98-bddc-a0904c8b1984 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 8 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 00ecf132-8f1c-4152-9554-a0904c8b1985 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 9 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 85afedd8-e23f-4a18-a5d7-9e225dfe6387 0f0e67f2-d999-4628-9e98-9e225df42adc 1 CurrencyCode CurrencyCode varchar(50) CurrencyCode varchar varchar(50) 50 0 0 false false true true true None 1 false false f55265ca-efff-4dfd-89f4-9e225e0300e5 0f0e67f2-d999-4628-9e98-9e225df42adc 2 CurrencyName CurrencyName varchar(50) CurrencyName varchar varchar(50) 50 0 0 false false false true true None 2 false false 07813cba-9856-4591-b8e5-a0904c8b1986 0f0e67f2-d999-4628-9e98-9e225df42adc 3 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 840aaee2-33ba-4128-866c-a0904c8b1987 0f0e67f2-d999-4628-9e98-9e225df42adc 4 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 2fbb0ce8-3481-44d5-b5c6-a0904c8b1988 0f0e67f2-d999-4628-9e98-9e225df42adc 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 fff5429c-c10b-4665-bb8a-a0904c8b1989 0f0e67f2-d999-4628-9e98-9e225df42adc 6 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 3c437bc9-a02c-4fe2-a3e1-9e225e623285 4b0a6917-c596-4be4-9d45-9e225e622f15 1 DateValue DateValue datetime DateValue datetime datetime 0 0 0 false false true true false None 1 false false 141d9778-cbb1-4807-bed6-9e225e6232ad 4b0a6917-c596-4be4-9d45-9e225e622f15 2 DayOfMonth DayOfMonth bigint DayOfMonth bigint int 0 0 0 false false false true false None 2 false false 956d18a1-2f07-45cf-bb76-9e225e6232d5 4b0a6917-c596-4be4-9d45-9e225e622f15 3 MonthName MonthName nvarchar(50) MonthName nvarchar nvarchar(50) 50 0 0 false false false true false None 3 false false 5fb1cfc5-69b5-49a0-b782-9e225e6232fd 4b0a6917-c596-4be4-9d45-9e225e622f15 4 MonthNumber MonthNumber bigint MonthNumber bigint int 0 0 0 false false false true false None 4 false false 81aaa017-89c4-4e27-b0ab-9e225e623325 4b0a6917-c596-4be4-9d45-9e225e622f15 5 QuarterNumber QuarterNumber bigint QuarterNumber bigint int 0 0 0 false false false true false None 5 false false 718e15d7-faeb-4d5a-9b3a-9e225e62334d 4b0a6917-c596-4be4-9d45-9e225e622f15 6 QuarterName QuarterName nvarchar(50) QuarterName nvarchar nvarchar(50) 50 0 0 false false false true false None 6 false false 3d6790ba-3a25-4cff-b6dc-9e225e623375 4b0a6917-c596-4be4-9d45-9e225e622f15 7 YearValue YearValue bigint YearValue bigint int 0 0 0 false false false true false None 7 false false 8680e965-7389-4871-a1a7-a0904c8b1707 4b0a6917-c596-4be4-9d45-9e225e622f15 8 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 1a435eb7-f2a3-4522-8c74-a0904c8b1977 4b0a6917-c596-4be4-9d45-9e225e622f15 9 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false ea89ea0c-aeaa-4475-ae2d-a0904c8b1978 4b0a6917-c596-4be4-9d45-9e225e622f15 10 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 6a4ed9fc-7a35-4be8-8015-a0904c8b1979 4b0a6917-c596-4be4-9d45-9e225e622f15 11 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 8af9bd73-721b-44a1-b8c7-9e226162c5aa c85122fb-7667-4c1b-9d7f-9e226140682a 1 Company varchar(50) Company varchar varchar 50 0 0 false false false false false None 0 false false 49a1fef4-881e-4c1a-9421-9e226162c64a c85122fb-7667-4c1b-9d7f-9e226140682a 2 FromCurrency varchar(3) FromCurrency varchar varchar 3 0 0 false false false false false None 0 false false aa58af19-3121-4305-b4b8-9e226162c64b c85122fb-7667-4c1b-9d7f-9e226140682a 3 ToCurrency varchar(50) ToCurrency varchar varchar 50 0 0 false false false false false None 0 false false 5e07c041-8693-492a-844f-9e226162c672 c85122fb-7667-4c1b-9d7f-9e226140682a 4 ExhangeRateDate datetime ExhangeRateDate datetime datetime 0 0 0 false false false false false None 0 false false dcfd65ed-ea2a-4674-b85b-9e226162c69a c85122fb-7667-4c1b-9d7f-9e226140682a 5 ExchangeRate decimal(38,5) ExchangeRate decimal decimal 0 5 38 false false false false false None 0 false false 56324cba-93e4-44ce-b184-9e225ca8e329 c625b623-fdf3-454b-8890-9e225c6e4611 Companies dbo Companies true 2 DataWarehouse AsProject AsProject false false true true false false false 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 c625b623-fdf3-454b-8890-9e225c6e4611 ExchangeRates dbo ExchangeRates true 4 DataWarehouse AsProject AsProject false false true true false false false c85122fb-7667-4c1b-9d7f-9e226140682a c625b623-fdf3-454b-8890-9e225c6e4611 ExchangeRatesDaily dbo ExchangeRatesDaily New View false 1 DataWarehouse AsProject AsProject false false false false c369c106-47c7-4a67-b61f-9e225c7f79ca c625b623-fdf3-454b-8890-9e225c6e4611 FactTable dbo FactTable true 3 DataWarehouse AsProject AsProject false false true true false false false 0f0e67f2-d999-4628-9e98-9e225df42adc c625b623-fdf3-454b-8890-9e225c6e4611 ReportingCurrencies dbo ReportingCurrencies Currencies true 5 DataWarehouse AsProject AsProject false false true true false false false 4b0a6917-c596-4be4-9d45-9e225e622f15 c625b623-fdf3-454b-8890-9e225c6e4611 Time dbo Time true 1 Time AsProject AsProject false false true true false false false c85122fb-7667-4c1b-9d7f-9e226140682a false 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed 9f6a38d6-05c3-4d24-8eeb-9e2261991312 CurrencyConversion CurrencyConversion true false false true -1 false 6105e07c-5f88-43b9-b767-9e226e1ea9b0 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed Value in Reporting Currency true TimeXtender.DataManager.Measure_BusinessFunction 3 false d1326da3-ba00-4af5-a8cd-9e226424422c 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed bca82505-b593-4da1-b79b-9e225c9a80c3 c369c106-47c7-4a67-b61f-9e225c7f79ca Value in Company Currency true Sum TimeXtender.DataManager.Measure #,0.00 1 false d7bddf3f-29d5-463f-9eda-9e2264303c43 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed dcfd65ed-ea2a-4674-b85b-9e226162c69a c85122fb-7667-4c1b-9d7f-9e226140682a ExchangeRate false Sum TimeXtender.DataManager.Measure 2 false 5106a889-4b77-4cf3-a767-9e22619eb4ca 9f6a38d6-05c3-4d24-8eeb-9e2261991312 Company Visible false -1 a46413bf-b9a2-4a70-b88a-9e2261dcbd42 9f6a38d6-05c3-4d24-8eeb-9e2261991312 Reporting Currency Hidden false -1 5b9d96f7-e072-4a20-8696-9e22634df7d7 9f6a38d6-05c3-4d24-8eeb-9e2261991312 Time Time Visible false -1 f9632135-bf4b-4cb6-95a6-9e2261a97112 5106a889-4b77-4cf3-a767-9e22619eb4ca 2adbc7fa-6e9a-4b3c-bc9e-9e225cbd0bad 5276bd5f-e738-46cf-8fe0-9e225caf255a 56324cba-93e4-44ce-b184-9e225ca8e329 56324cba-93e4-44ce-b184-9e225ca8e329 1 Company false true Name Name false Never false false false true false true 36d322bd-9458-4551-88bc-9e2261b5d9ca 5106a889-4b77-4cf3-a767-9e22619eb4ca 03912a54-ce6b-4503-bb6d-9e225cb31404 03912a54-ce6b-4503-bb6d-9e225cb31404 56324cba-93e4-44ce-b184-9e225ca8e329 56324cba-93e4-44ce-b184-9e225ca8e329 2 Company Currency false false Key Key false Never false false false true false true fc5bdac3-bd34-47dc-8492-9e2261e7487a a46413bf-b9a2-4a70-b88a-9e2261dcbd42 f55265ca-efff-4dfd-89f4-9e225e0300e5 85afedd8-e23f-4a18-a5d7-9e225dfe6387 0f0e67f2-d999-4628-9e98-9e225df42adc 0f0e67f2-d999-4628-9e98-9e225df42adc 1 Reporting Currency false true Name Name false Never false false false true false true 099a056c-19f8-4ecd-b5a7-9e22634df8c7 5b9d96f7-e072-4a20-8696-9e22634df7d7 3c437bc9-a02c-4fe2-a3e1-9e225e623285 3c437bc9-a02c-4fe2-a3e1-9e225e623285 4b0a6917-c596-4be4-9d45-9e225e622f15 4b0a6917-c596-4be4-9d45-9e225e622f15 1 DateValue false true Key Key false Never Date false false false false false true 738c05f5-30ba-4c3c-bcf0-9e22634dfa2f 5b9d96f7-e072-4a20-8696-9e22634df7d7 141d9778-cbb1-4807-bed6-9e225e6232ad 141d9778-cbb1-4807-bed6-9e225e6232ad 4b0a6917-c596-4be4-9d45-9e225e622f15 4b0a6917-c596-4be4-9d45-9e225e622f15 2 Day false false Key Key false Never Days false false false false false true 6b863016-8887-41d6-b86c-9e22634dfa57 5b9d96f7-e072-4a20-8696-9e22634df7d7 956d18a1-2f07-45cf-bb76-9e225e6232d5 5fb1cfc5-69b5-49a0-b782-9e225e6232fd 4b0a6917-c596-4be4-9d45-9e225e622f15 4b0a6917-c596-4be4-9d45-9e225e622f15 3 Month false false Key Name false Never Months false false false false false true 50dce042-9aab-4a3c-9de1-9e22634dfa7f 5b9d96f7-e072-4a20-8696-9e22634df7d7 718e15d7-faeb-4d5a-9b3a-9e225e62334d 81aaa017-89c4-4e27-b0ab-9e225e623325 4b0a6917-c596-4be4-9d45-9e225e622f15 4b0a6917-c596-4be4-9d45-9e225e622f15 4 Quarter false false Key Name false Never Quarters false false false false false true 982e30b6-e07b-46a1-b5c1-9e22634dfaa7 5b9d96f7-e072-4a20-8696-9e22634df7d7 3d6790ba-3a25-4cff-b6dc-9e225e623375 3d6790ba-3a25-4cff-b6dc-9e225e623375 4b0a6917-c596-4be4-9d45-9e225e622f15 4b0a6917-c596-4be4-9d45-9e225e622f15 5 Year false false Key Key false Never Years false false false false false true bde4efb3-c90b-49c8-b939-9e225c64434f CurrencyConversion true Normal 0 true false false 12.4.8.32 4.4.2.32 0 9999-12-31T23:59:59.997+01:00 Relation false false false ZYsqu7A6AYHwTI5jRvSuIIO49gEWjNJjQfT/QYkPhjECF4Cj27EwbHv/jrlnAKTuLhwc0rcEunaUBfGwqE4fqA7RuJnaVrot++TJynroiZ3JLURQ/87dk7oJNs9NK6WnQRQ9IJqc8urlaJrlI2ugDSktT7S4Aw0CECkT1VFGi5yZ8iEgZnkJpeBsNvm613kPJ2+sHj7oqzCVXAjMd1P+xVos0wg5NGCn5JszCnzEyK098e7e54AK3q1yVOvKLM3L0OJfy/ad+YMeGO9YF+ZPvPd6MCChmsYqEmqT5dRjInz3C8aySU25gjNG06LAm6hx false Error false false 4b0a6917-c596-4be4-9d45-9e225e622f15 2010-01-01T10:59:01+01:00 2010-12-31T10:59:01+01:00 true January 1 false true true true true false false Monday false false true false false false false false false false -1 -1 48e99c13-4547-4361-ae4c-9e225c6e42c9 bde4efb3-c90b-49c8-b939-9e225c64434f DWH false 1 8af9bd73-721b-44a1-b8c7-9e226162c5aa c85122fb-7667-4c1b-9d7f-9e226140682a 49a1fef4-881e-4c1a-9421-9e226162c64a c85122fb-7667-4c1b-9d7f-9e226140682a aa58af19-3121-4305-b4b8-9e226162c64b c85122fb-7667-4c1b-9d7f-9e226140682a 5e07c041-8693-492a-844f-9e226162c672 c85122fb-7667-4c1b-9d7f-9e226140682a dcfd65ed-ea2a-4674-b85b-9e226162c69a c85122fb-7667-4c1b-9d7f-9e226140682a 9f6a38d6-05c3-4d24-8eeb-9e2261991312 bde4efb3-c90b-49c8-b939-9e225c64434f 48e99c13-4547-4361-ae4c-9e225c6e42c9 00000000-0000-0000-0000-000000000000 false OLAP . OLAP false DWH DSV false Not_Set false c625b623-fdf3-454b-8890-9e225c6e4611 48e99c13-4547-4361-ae4c-9e225c6e42c9 00000000-0000-0000-0000-000000000000 false . true QmEvtm671whyw2kZhSr/xw== DWH 100 15 As_Parent 0 Not_Set adc2b310-4649-4a7b-94ab-9e226433bc22 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed 5106a889-4b77-4cf3-a767-9e22619eb4ca Company 2c7df321-c20e-467d-998d-9e2264351553 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed a46413bf-b9a2-4a70-b88a-9e2261dcbd42 Reporting Currency 6d1b1522-20fb-4f42-a6da-9e2264365673 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed 5b9d96f7-e072-4a20-8696-9e22634df7d7 Time 37964540-bd84-436b-9557-9e226433bc9a adc2b310-4649-4a7b-94ab-9e226433bc22 f9632135-bf4b-4cb6-95a6-9e2261a97112 43bab6e1-b8cb-475e-b094-9e226433bd3a adc2b310-4649-4a7b-94ab-9e226433bc22 36d322bd-9458-4551-88bc-9e2261b5d9ca 45584c99-f5cf-41c1-a04f-9e2264351554 2c7df321-c20e-467d-998d-9e2264351553 fc5bdac3-bd34-47dc-8492-9e2261e7487a d1ba6cba-b6e2-407c-bf36-9e226436569b 6d1b1522-20fb-4f42-a6da-9e2264365673 099a056c-19f8-4ecd-b5a7-9e22634df8c7 bfbcfa8d-2538-4532-aa76-9e22643656eb 6d1b1522-20fb-4f42-a6da-9e2264365673 738c05f5-30ba-4c3c-bcf0-9e22634dfa2f 620ce635-b787-47a6-a856-9e226436573b 6d1b1522-20fb-4f42-a6da-9e2264365673 6b863016-8887-41d6-b86c-9e22634dfa57 4eb7177a-9c96-483d-a42a-9e226436578b 6d1b1522-20fb-4f42-a6da-9e2264365673 50dce042-9aab-4a3c-9de1-9e22634dfa7f ff53a15f-3c98-44e1-bdb6-9e22643657db 6d1b1522-20fb-4f42-a6da-9e2264365673 982e30b6-e07b-46a1-b5c1-9e22634dfaa7 c85122fb-7667-4c1b-9d7f-9e226140682a CREATE VIEW ExchangeRatesDaily AS SELECT b.Company as Company ,'MST' as FromCurrency ,b.currencycode as ToCurrency ,a.datevalue as ExhangeRateDate ,b.ExchangeRate as ExchangeRate from dbo.Time a left join dbo.ExchangeRates b on a.DateValue > b.DateFrom and a.DateValue <= b.DateTo where b.currencycode is not null 132e6cc1-6519-4817-a9fb-9e2263ebf905 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed c369c106-47c7-4a67-b61f-9e225c7f79ca false 43554e4c-6248-4b83-8646-9e2263ebf8b5 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed c85122fb-7667-4c1b-9d7f-9e226140682a false c4caaefc-9784-47ad-8073-0bc1dbbeb1a1 f9632135-bf4b-4cb6-95a6-9e2261a97112 5276bd5f-e738-46cf-8fe0-9e225caf255a cde2f1cf-5ddb-4113-ac5a-c01e67de0992 36d322bd-9458-4551-88bc-9e2261b5d9ca 03912a54-ce6b-4503-bb6d-9e225cb31404 d9acdfc8-fb20-488f-8932-c23991d570d8 fc5bdac3-bd34-47dc-8492-9e2261e7487a 85afedd8-e23f-4a18-a5d7-9e225dfe6387 b609b3f3-cbdc-48e5-969f-8d58810a59fd 099a056c-19f8-4ecd-b5a7-9e22634df8c7 3c437bc9-a02c-4fe2-a3e1-9e225e623285 032a017d-0c16-4fec-987c-5d6a07a1fbc1 738c05f5-30ba-4c3c-bcf0-9e22634dfa2f 141d9778-cbb1-4807-bed6-9e225e6232ad ed2f7e91-cced-47f1-96b3-8ecd702f281a 6b863016-8887-41d6-b86c-9e22634dfa57 5fb1cfc5-69b5-49a0-b782-9e225e6232fd fdd83e68-9bb8-4567-9370-7fe1100a475d 50dce042-9aab-4a3c-9de1-9e22634dfa7f 81aaa017-89c4-4e27-b0ab-9e225e623325 0b1ff13a-1093-4f0a-8754-7c7df4e474b1 982e30b6-e07b-46a1-b5c1-9e22634dfaa7 3d6790ba-3a25-4cff-b6dc-9e225e623375 5116f37a-5208-48c6-b2aa-9e2263576e5c 738c05f5-30ba-4c3c-bcf0-9e22634dfa2f fba7219c-7b92-4884-8053-9e2263576b8b 4 Day false e841dfa2-d6d5-4204-92b4-9e2263576e5b 6b863016-8887-41d6-b86c-9e22634dfa57 fba7219c-7b92-4884-8053-9e2263576b8b 3 Month false 8d825b7f-36e5-40b8-8be1-9e2263576e33 50dce042-9aab-4a3c-9de1-9e22634dfa7f fba7219c-7b92-4884-8053-9e2263576b8b 2 Quarter false 98d614d9-1311-4bba-b54b-9e2263576dbb 982e30b6-e07b-46a1-b5c1-9e22634dfaa7 fba7219c-7b92-4884-8053-9e2263576b8b 1 Year false fba7219c-7b92-4884-8053-9e2263576b8b 5b9d96f7-e072-4a20-8696-9e22634df7d7 Time false 9cc7a0f5-7f28-4e83-bb9d-9e22644ab828 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed adc2b310-4649-4a7b-94ab-9e226433bc22 43554e4c-6248-4b83-8646-9e2263ebf8b5 false c290e0c5-6d7a-47e8-bc0a-9e22644aba30 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed adc2b310-4649-4a7b-94ab-9e226433bc22 132e6cc1-6519-4817-a9fb-9e2263ebf905 false aae5f33a-14f3-40ab-94c8-9e22644ab990 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed 2c7df321-c20e-467d-998d-9e2264351553 43554e4c-6248-4b83-8646-9e2263ebf8b5 false c674e307-748d-4409-93d7-9e22644ab9e0 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed 6d1b1522-20fb-4f42-a6da-9e2264365673 43554e4c-6248-4b83-8646-9e2263ebf8b5 false 93f81b3f-5bb9-44df-b9b0-9e22644aba59 353a1b14-8a2c-4f5e-a648-9e2263ebf7ed 6d1b1522-20fb-4f42-a6da-9e2264365673 132e6cc1-6519-4817-a9fb-9e2263ebf905 false 97572c20-0727-408b-8f9e-9e22644aba80 93f81b3f-5bb9-44df-b9b0-9e22644aba59 ea2f29cc-065e-453b-9910-9e225c86bdd1 3c437bc9-a02c-4fe2-a3e1-9e225e623285 e6f32bda-b2fc-4c48-a628-9e22644aba58 c290e0c5-6d7a-47e8-bc0a-9e22644aba30 7a25ac10-9a1a-429c-b472-9e225c8d0eb3 5276bd5f-e738-46cf-8fe0-9e225caf255a 0bc6fe66-6c46-431e-aa5c-9e22644ab8f0 9cc7a0f5-7f28-4e83-bb9d-9e22644ab828 8af9bd73-721b-44a1-b8c7-9e226162c5aa 5276bd5f-e738-46cf-8fe0-9e225caf255a 75f35f8c-e6e7-4504-82af-a0904c95bbde aae5f33a-14f3-40ab-94c8-9e22644ab990 aa58af19-3121-4305-b4b8-9e226162c64b 85afedd8-e23f-4a18-a5d7-9e225dfe6387 ea027eb7-51b2-489b-9e9b-9e22644ab9e1 c674e307-748d-4409-93d7-9e22644ab9e0 5e07c041-8693-492a-844f-9e226162c672 3c437bc9-a02c-4fe2-a3e1-9e225e623285 0bc6fe66-6c46-431e-aa5c-9e22644ab8f0 f9632135-bf4b-4cb6-95a6-9e2261a97112 e6f32bda-b2fc-4c48-a628-9e22644aba58 f9632135-bf4b-4cb6-95a6-9e2261a97112 75f35f8c-e6e7-4504-82af-a0904c95bbde fc5bdac3-bd34-47dc-8492-9e2261e7487a ea027eb7-51b2-489b-9e9b-9e22644ab9e1 099a056c-19f8-4ecd-b5a7-9e22634df8c7 97572c20-0727-408b-8f9e-9e22644aba80 099a056c-19f8-4ecd-b5a7-9e22634df8c7 f9632135-bf4b-4cb6-95a6-9e2261a97112 36d322bd-9458-4551-88bc-9e2261b5d9ca fc5bdac3-bd34-47dc-8492-9e2261e7487a 099a056c-19f8-4ecd-b5a7-9e22634df8c7 738c05f5-30ba-4c3c-bcf0-9e22634dfa2f 6b863016-8887-41d6-b86c-9e22634dfa57 50dce042-9aab-4a3c-9de1-9e22634dfa7f 982e30b6-e07b-46a1-b5c1-9e22634dfaa7 e39c4f5d-1d7b-42cc-afc9-9e225ef31b32 c369c106-47c7-4a67-b61f-9e225c7f79ca <NewDataSet><FactTable_CustomData><Company>TDK</Company><TransactionDate>2010-10-01</TransactionDate><ValueInCompanyCurr>1000</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TDK</Company><TransactionDate>2010-11-01</TransactionDate><ValueInCompanyCurr>1000</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TDK</Company><TransactionDate>2010-12-01</TransactionDate><ValueInCompanyCurr>1000</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TDE</Company><TransactionDate>2010-10-15</TransactionDate><ValueInCompanyCurr>150</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TDE</Company><TransactionDate>2010-11-15</TransactionDate><ValueInCompanyCurr>150</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TDE</Company><TransactionDate>2010-12-15</TransactionDate><ValueInCompanyCurr>150</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TUS</Company><TransactionDate>2010-10-30</TransactionDate><ValueInCompanyCurr>200</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TUS</Company><TransactionDate>2010-11-30</TransactionDate><ValueInCompanyCurr>200</ValueInCompanyCurr></FactTable_CustomData><FactTable_CustomData><Company>TUS</Company><TransactionDate>2010-12-30</TransactionDate><ValueInCompanyCurr>200</ValueInCompanyCurr></FactTable_CustomData></NewDataSet> 11013328-969c-4c75-855f-9e225d47d02a 56324cba-93e4-44ce-b184-9e225ca8e329 <NewDataSet><Companies_CustomData><Company>TUS</Company><CompanyName>timeXtender USA</CompanyName><CompanyCurr>USD</CompanyCurr></Companies_CustomData><Companies_CustomData><Company>TDK</Company><CompanyName>timeXtender Denmark</CompanyName><CompanyCurr>DKK</CompanyCurr></Companies_CustomData><Companies_CustomData><Company>TDE</Company><CompanyName>timeXtender Germany</CompanyName><CompanyCurr>EUR</CompanyCurr></Companies_CustomData></NewDataSet> 8dcca7dd-5b60-4a8d-8800-9e22609ca457 8dae33d0-d8ac-4f22-954f-9e225d4ff4e8 <NewDataSet><ExchangeRates_CustomData><Company>TDK</Company><CurrencyCode>DKK</CurrencyCode><ExchangeRate>100</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TDK</Company><CurrencyCode>EUR</CurrencyCode><ExchangeRate>750</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TDK</Company><CurrencyCode>USD</CurrencyCode><ExchangeRate>600</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TDE</Company><CurrencyCode>EUR</CurrencyCode><ExchangeRate>100</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TDE</Company><CurrencyCode>DKK</CurrencyCode><ExchangeRate>13,33333</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TDE</Company><CurrencyCode>USD</CurrencyCode><ExchangeRate>80</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TUS</Company><CurrencyCode>USD</CurrencyCode><ExchangeRate>100</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TUS</Company><CurrencyCode>DKK</CurrencyCode><ExchangeRate>16,66667</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData><ExchangeRates_CustomData><Company>TUS</Company><CurrencyCode>EUR</CurrencyCode><ExchangeRate>125</ExchangeRate><DateFrom>1900-01-01</DateFrom><DateTo>9999-12-31</DateTo></ExchangeRates_CustomData></NewDataSet> 91934c8f-1bfa-471e-a06b-9e225e19a221 0f0e67f2-d999-4628-9e98-9e225df42adc <NewDataSet><ReportingCurrencies_CustomData><CurrencyCode>DKK</CurrencyCode><CurrencyName>Danske Kroner</CurrencyName></ReportingCurrencies_CustomData><ReportingCurrencies_CustomData><CurrencyCode>EUR</CurrencyCode><CurrencyName>Euro</CurrencyName></ReportingCurrencies_CustomData><ReportingCurrencies_CustomData><CurrencyCode>USD</CurrencyCode><CurrencyName>American Dollar</CurrencyName></ReportingCurrencies_CustomData></NewDataSet> 20671158-f347-4940-b8a3-9e226e1ea9d8 bec97bf1-dca9-4522-9894-9e226e1ea9b1 2c7df321-c20e-467d-998d-9e2264351553 ReportingCurrencyDimension Dimension The Dimension that contains the Reporting Currencies 0 29a69317-b51c-48ef-a80c-9e226e1eaa50 bec97bf1-dca9-4522-9894-9e226e1ea9b1 6d1b1522-20fb-4f42-a6da-9e2264365673;fba7219c-7b92-4884-8053-9e2263576b8b TimeDimensionHierarchy Hirachy The Time Dimension Hierarchy that will be used to do the calculation 1 a7eee2f1-64e0-4f19-b21c-9e226e1eaa78 bec97bf1-dca9-4522-9894-9e226e1ea9b1 adc2b310-4649-4a7b-94ab-9e226433bc22;f9632135-bf4b-4cb6-95a6-9e2261a97112 CompanyDimension Dimension_Level The Dimension that contains the companies and their default currency 2 7ce84dd6-5c9e-4696-afdc-9e226e1eaaa0 bec97bf1-dca9-4522-9894-9e226e1ea9b1 d1326da3-ba00-4af5-a8cd-9e226424422c BaseMeasure Measure The Measure in default currency that will be the input for the calculation 3 18120683-fa44-4a03-8143-9e226e1eaaf0 bec97bf1-dca9-4522-9894-9e226e1ea9b1 d7bddf3f-29d5-463f-9eda-9e2264303c43 ExchRateMeasure Measure The Measure that contains the exchangerate (often a hidden measure) 4 bec97bf1-dca9-4522-9894-9e226e1ea9b1 6105e07c-5f88-43b9-b767-9e226e1ea9b0 Measure in Reporting Currency Iif ( IsLeaf(ReportingCurrencyDimension.CurrentMember), Iif ( IsLeaf(TimeDimensionHierarchy.CurrentMember) And IsLeaf(CompanyDimension.CurrentMember), (BaseMeasure/ExchRateMeasure)*100, Sum( CrossJoin( {Descendants(TimeDimensionHierarchy.CurrentMember,,Leaves)}, {Descendants(CompanyDimension.CurrentMember,,Leaves)} ), (BaseMeasure/ExchRateMeasure)*100 ) ), Null ), NON_EMPTY_BEHAVIOR = { BaseMeasure } Described in a seperate document!