830da5da-e9dd-4da1-abd1-feb4c3d2ecae 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 1 ID ID bigint ID bigint bigint 0 0 0 false false false true true None 1 false false 81824b87-b9a3-4523-974c-f1102294314f 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 2 Description Description varchar(50) Description varchar varchar(50) 50 0 0 false false false true true None 2 false false 2bd79ea8-5bcd-4cb1-91e8-d51f5179b5fa 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 3 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false b9ba4366-1e4c-44ce-9144-a1f30ec242c8 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 4 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 906cfa9c-57f2-4015-91e4-af640bacdb09 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 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 23c8fdbe-c539-40fb-a829-aa11cc29508b 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 6 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false e17ee5a8-c6c8-4144-bc32-a3377e60df1a 32254ef5-4402-4220-80bf-2b6072d6e2c5 1 ID ID bigint ID bigint bigint 0 0 0 false false false true true None 1 false false 046c2135-2e30-4a23-8f85-6ce3cd1a0bb9 32254ef5-4402-4220-80bf-2b6072d6e2c5 2 Description Description varchar(50) Description varchar varchar(50) 50 0 0 false false false true true None 2 false false d3c08ae1-df65-4ef4-a048-a866f60ccfae 32254ef5-4402-4220-80bf-2b6072d6e2c5 3 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false f59dd7d3-d500-4577-8f70-bc3cdfe9846d 32254ef5-4402-4220-80bf-2b6072d6e2c5 4 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false e174306e-b8ab-4b6d-866e-50fb68c3093e 32254ef5-4402-4220-80bf-2b6072d6e2c5 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 35cd8b57-cfa2-4cd5-bca0-f1ac05f7f764 32254ef5-4402-4220-80bf-2b6072d6e2c5 6 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 3120830e-1eb9-45ed-8070-c5895fd4abae 1 DateValue DateValue datetime DateValue datetime datetime 0 0 0 false false true true false None 1 false false ff5b7695-e44e-4a4d-9c9f-cea216f1c072 3120830e-1eb9-45ed-8070-c5895fd4abae 2 DayOfMonth DayOfMonth bigint DayOfMonth bigint int 0 0 0 false false false true false None 2 false false 7d5825a3-cd14-4a79-a87e-e2cf1cec5784 3120830e-1eb9-45ed-8070-c5895fd4abae 3 MonthName MonthName nvarchar(50) MonthName nvarchar nvarchar(50) 50 0 0 false false false true false None 3 false false ed548a3e-2d78-40b8-a316-0f691e7033f4 3120830e-1eb9-45ed-8070-c5895fd4abae 4 MonthNumber MonthNumber bigint MonthNumber bigint int 0 0 0 false false false true false None 4 false false 0920b282-1f77-4a7f-9cfa-593c613f0fce 3120830e-1eb9-45ed-8070-c5895fd4abae 5 QuarterNumber QuarterNumber bigint QuarterNumber bigint int 0 0 0 false false false true false None 5 false false d35a3c09-67ac-4d41-99c1-8eacaae4fbf7 3120830e-1eb9-45ed-8070-c5895fd4abae 6 QuarterName QuarterName nvarchar(50) QuarterName nvarchar nvarchar(50) 50 0 0 false false false true false None 6 false false 01ab27e1-357c-41bb-a75f-6f371a2fe46f 3120830e-1eb9-45ed-8070-c5895fd4abae 7 YearValue YearValue bigint YearValue bigint int 0 0 0 false false false true false None 7 false false 184c6696-54d8-49b1-9ae2-aeb9ec7c1136 3120830e-1eb9-45ed-8070-c5895fd4abae 8 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false f358e475-e4d8-40ae-85e8-b6d857546d69 3120830e-1eb9-45ed-8070-c5895fd4abae 9 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 037f6a0c-6c09-456d-b661-4ac377e7aec5 3120830e-1eb9-45ed-8070-c5895fd4abae 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 e139542c-0568-4656-9aa9-f3c80f1cba55 3120830e-1eb9-45ed-8070-c5895fd4abae 11 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 3c002da0-db3f-4df9-8af6-052cff4c1a30 6df0d239-7bae-4a25-84df-de609f4b33d2 1 Date Date datetime Date datetime datetime 0 0 0 false false false true true None 1 false false dd8eb490-b4b3-42cd-b3a5-c85d4e8c2d83 6df0d239-7bae-4a25-84df-de609f4b33d2 2 Value Value decimal(38,2) Value decimal decimal(38,2) 0 2 38 false false false true true None 2 false false 1db96f60-f558-474a-8cbc-b9f01e5a5d7d 6df0d239-7bae-4a25-84df-de609f4b33d2 3 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 3840332c-608c-4eac-b886-5d1a649ce81a 6df0d239-7bae-4a25-84df-de609f4b33d2 4 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false 13b34dfa-c628-469d-ad72-2bba372ad6c8 6df0d239-7bae-4a25-84df-de609f4b33d2 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 cbef8118-85e1-408a-b22a-0a92f0db89e0 6df0d239-7bae-4a25-84df-de609f4b33d2 6 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 00a4f70f-b440-4893-9617-6cb762dab8ae 9e717592-df1f-4970-894e-f14cf17d9d54 1 ID_Aggregation bigint ID_Aggregation bigint bigint 0 0 19 false false false false false None 0 false false ffb59ce5-ac8f-4ee7-a270-af241716d3ac 9e717592-df1f-4970-894e-f14cf17d9d54 2 ID_Comparison bigint ID_Comparison bigint bigint 0 0 19 false false false false false None 0 false false f72c6bb0-4bf7-45d0-9d30-3b270ae9a50e 9e717592-df1f-4970-894e-f14cf17d9d54 3 Description varchar(63) Description varchar varchar 63 0 0 false false false false false None 0 false false 6df0d239-7bae-4a25-84df-de609f4b33d2 e8784ef6-9173-48c1-b81f-b2e40e022d58 FactTable dbo FactTable true 4 DataWarehouse AsProject AsProject false false true true false false false 3120830e-1eb9-45ed-8070-c5895fd4abae e8784ef6-9173-48c1-b81f-b2e40e022d58 Time dbo Time true 3 Time AsProject AsProject false false true true false false false 32254ef5-4402-4220-80bf-2b6072d6e2c5 e8784ef6-9173-48c1-b81f-b2e40e022d58 TimeAggregations dbo TimeAggregations true 1 DataWarehouse AsProject AsProject false false true true false false false 9e717592-df1f-4970-894e-f14cf17d9d54 e8784ef6-9173-48c1-b81f-b2e40e022d58 TimeCalculationsV dbo TimeCalculationsV New View false 1 DataWarehouse AsProject AsProject false false false false 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 e8784ef6-9173-48c1-b81f-b2e40e022d58 TimeComparison dbo TimeComparison true 2 DataWarehouse AsProject AsProject false false true true false false false 9e717592-df1f-4970-894e-f14cf17d9d54 false 53768bd2-6d76-4c2a-8982-7dff65d702f2 91047194-894a-40a8-95b8-284f51e86c45 TimeCalculationsExample TimeCalculationsExample true false false true -1 false 5f7ae99b-014d-42ef-bc29-d31735f5081b 53768bd2-6d76-4c2a-8982-7dff65d702f2 TimeCalculations Time YMD false TimeXtender.DataManager.Measure_BusinessFunction 3 false dc2c6e7a-1cf4-4503-87b1-ba6f7e56a958 53768bd2-6d76-4c2a-8982-7dff65d702f2 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 3120830e-1eb9-45ed-8070-c5895fd4abae Days true Count TimeXtender.DataManager.Measure 1 false d9a83c42-04b9-478c-8f71-6f6260960ac6 53768bd2-6d76-4c2a-8982-7dff65d702f2 dd8eb490-b4b3-42cd-b3a5-c85d4e8c2d83 6df0d239-7bae-4a25-84df-de609f4b33d2 Value true Sum TimeXtender.DataManager.Measure 2 false 72fdb5de-83a3-4988-ad7f-a6c05208c765 91047194-894a-40a8-95b8-284f51e86c45 Time Time Hidden false -1 d1556940-54ca-405c-9e5b-aa826574e35e 91047194-894a-40a8-95b8-284f51e86c45 TimeCalculations Hidden false -1 4072a189-3e5b-4bd2-b1f2-5bcf03709556 72fdb5de-83a3-4988-ad7f-a6c05208c765 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 3120830e-1eb9-45ed-8070-c5895fd4abae 3120830e-1eb9-45ed-8070-c5895fd4abae 1 DateValue false true Key Key false Never Date false false false false false true 3fb8ff25-35fd-462d-899f-dd4e896af3d7 72fdb5de-83a3-4988-ad7f-a6c05208c765 ff5b7695-e44e-4a4d-9c9f-cea216f1c072 ff5b7695-e44e-4a4d-9c9f-cea216f1c072 3120830e-1eb9-45ed-8070-c5895fd4abae 3120830e-1eb9-45ed-8070-c5895fd4abae 2 Day false false Key Key false Never Days false false false false false true a14295e5-fee2-40e8-b64f-448401f03216 72fdb5de-83a3-4988-ad7f-a6c05208c765 7d5825a3-cd14-4a79-a87e-e2cf1cec5784 ed548a3e-2d78-40b8-a316-0f691e7033f4 3120830e-1eb9-45ed-8070-c5895fd4abae 3120830e-1eb9-45ed-8070-c5895fd4abae 3 Month false false Key Name false Never Months false false false false false true c547da8b-ebdb-4585-af67-8e0423cd0a22 72fdb5de-83a3-4988-ad7f-a6c05208c765 d35a3c09-67ac-4d41-99c1-8eacaae4fbf7 0920b282-1f77-4a7f-9cfa-593c613f0fce 3120830e-1eb9-45ed-8070-c5895fd4abae 3120830e-1eb9-45ed-8070-c5895fd4abae 4 Quarter false false Key Name false Never Quarters false false false false false true e342c1c4-16ff-4f8e-9f86-7511c7f0e17e 72fdb5de-83a3-4988-ad7f-a6c05208c765 01ab27e1-357c-41bb-a75f-6f371a2fe46f 01ab27e1-357c-41bb-a75f-6f371a2fe46f 3120830e-1eb9-45ed-8070-c5895fd4abae 3120830e-1eb9-45ed-8070-c5895fd4abae 5 Year false false Key Key false Never Years false false false false false true bbd81b6a-d5f7-49e2-b82a-4f0f44a9590f d1556940-54ca-405c-9e5b-aa826574e35e 00a4f70f-b440-4893-9617-6cb762dab8ae 00a4f70f-b440-4893-9617-6cb762dab8ae 9e717592-df1f-4970-894e-f14cf17d9d54 9e717592-df1f-4970-894e-f14cf17d9d54 1 CalculationID false true Key Key false Never false false false false false true d5e03f00-330f-4689-8504-5fd3b3230927 d1556940-54ca-405c-9e5b-aa826574e35e 046c2135-2e30-4a23-8f85-6ce3cd1a0bb9 e17ee5a8-c6c8-4144-bc32-a3377e60df1a 32254ef5-4402-4220-80bf-2b6072d6e2c5 32254ef5-4402-4220-80bf-2b6072d6e2c5 2 Aggregation false false Key Name false Never false false false true false true 21a3a32f-f836-47e7-8700-423883f8dafa d1556940-54ca-405c-9e5b-aa826574e35e 81824b87-b9a3-4523-974c-f1102294314f 830da5da-e9dd-4da1-abd1-feb4c3d2ecae 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 3 Comparison false false Key Name false Never false false false true false true a6eaec93-cdfe-4db3-8468-fac6996978a6 TimeCalculations false Normal 0 true false false 12.4.8.64 4.3.1.32 0 9999-12-31T23:59:59.997+01:00 Error true true false sI/XY39zZEWhNY6NOZfTtPAnm26KTUx2fnGDnb8jM9aCk5Nq/m4/pUqPt2Ugx2Pl2uqjvg/ir0z7rE4KdugYlUBgvbaic8bSWoA18NCBHOcWn0bwnOITMIBGVfPtz0Q3NpKzyMaqwxp850YM8EYwwwQjebwP1PVNctUpdgzuqk9+forBKXRAiWRe844nkXF9CAshaC8vTuwcD1ROAniylauKlwornTsMulKY4TP1riUa61hKuZIFfzyvFTKOGXplqL8SFdV91T2SD1PTLkHGkbC3ehmuZPcotVaD7XO2TfqVxBAv/4cX9SO/e4fXvOhQ false Error false false 3120830e-1eb9-45ed-8070-c5895fd4abae 2000-01-01T16:43:34+01:00 2013-12-31T16:43:34+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 2afb2601-b885-477a-a50d-f76bcc38e631 a6eaec93-cdfe-4db3-8468-fac6996978a6 DWH false 1 00a4f70f-b440-4893-9617-6cb762dab8ae 9e717592-df1f-4970-894e-f14cf17d9d54 ffb59ce5-ac8f-4ee7-a270-af241716d3ac 9e717592-df1f-4970-894e-f14cf17d9d54 f72c6bb0-4bf7-45d0-9d30-3b270ae9a50e 9e717592-df1f-4970-894e-f14cf17d9d54 91047194-894a-40a8-95b8-284f51e86c45 a6eaec93-cdfe-4db3-8468-fac6996978a6 2afb2601-b885-477a-a50d-f76bcc38e631 00000000-0000-0000-0000-000000000000 false OLAP . OLAP false false Not_Set false e8784ef6-9173-48c1-b81f-b2e40e022d58 2afb2601-b885-477a-a50d-f76bcc38e631 00000000-0000-0000-0000-000000000000 false . true QmEvtm671whyw2kZhSr/xw== dwh 100 15 As_Parent 300000 Not_Set 863e44be-cd4a-4517-8364-edf5027f8f08 53768bd2-6d76-4c2a-8982-7dff65d702f2 72fdb5de-83a3-4988-ad7f-a6c05208c765 Time e42ffdcb-7451-4cbd-b98e-5be071cd533e 53768bd2-6d76-4c2a-8982-7dff65d702f2 d1556940-54ca-405c-9e5b-aa826574e35e TimeCalculations 322bdd9e-d981-4bc5-97d8-4b89bc147f74 e42ffdcb-7451-4cbd-b98e-5be071cd533e 21a3a32f-f836-47e7-8700-423883f8dafa dc7e0a51-6497-4e73-b177-c4d86fb10bb2 863e44be-cd4a-4517-8364-edf5027f8f08 a14295e5-fee2-40e8-b64f-448401f03216 df2cfc82-6545-432b-80b9-a37d9c085d1b e42ffdcb-7451-4cbd-b98e-5be071cd533e bbd81b6a-d5f7-49e2-b82a-4f0f44a9590f 1760cdf5-8637-4f6d-ae3b-6e7455f72ed0 863e44be-cd4a-4517-8364-edf5027f8f08 4072a189-3e5b-4bd2-b1f2-5bcf03709556 a2117abd-37e6-4b4e-a61b-25535573b849 e42ffdcb-7451-4cbd-b98e-5be071cd533e d5e03f00-330f-4689-8504-5fd3b3230927 10a1262d-dae8-49fa-a416-df127c89bc79 863e44be-cd4a-4517-8364-edf5027f8f08 e342c1c4-16ff-4f8e-9f86-7511c7f0e17e 3fb70910-0f80-45c0-b187-0012936b5af4 863e44be-cd4a-4517-8364-edf5027f8f08 c547da8b-ebdb-4585-af67-8e0423cd0a22 1f84b206-0ff2-4cfc-9ab3-757ada9c8f6e 863e44be-cd4a-4517-8364-edf5027f8f08 3fb8ff25-35fd-462d-899f-dd4e896af3d7 5888888f-1c8c-4104-a059-b0af748a5316 d1556940-54ca-405c-9e5b-aa826574e35e 32254ef5-4402-4220-80bf-2b6072d6e2c5 e17ee5a8-c6c8-4144-bc32-a3377e60df1a 9e717592-df1f-4970-894e-f14cf17d9d54 00a4f70f-b440-4893-9617-6cb762dab8ae e31213a8-ed1c-4a34-99bd-ffbad7c120f8 d1556940-54ca-405c-9e5b-aa826574e35e 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 830da5da-e9dd-4da1-abd1-feb4c3d2ecae 9e717592-df1f-4970-894e-f14cf17d9d54 ffb59ce5-ac8f-4ee7-a270-af241716d3ac 9e717592-df1f-4970-894e-f14cf17d9d54 CREATE View TimeCalculationsV AS SELECT a.ID as ID_Aggregation, s.ID as ID_Comparison, CAST( s.ID AS VARCHAR ) + ' - ' + CAST( a.ID AS VARCHAR ) AS Description FROM TimeAggregations_V a CROSS JOIN TimeComparison_V s 697ee263-efd5-4bd8-bdef-3e03fdfa116f 53768bd2-6d76-4c2a-8982-7dff65d702f2 3120830e-1eb9-45ed-8070-c5895fd4abae false 076ba97f-d720-485a-8e53-9b3a7ca293ed 53768bd2-6d76-4c2a-8982-7dff65d702f2 6df0d239-7bae-4a25-84df-de609f4b33d2 false 7412864a-12cf-4b68-b565-1a20ce73b24b a14295e5-fee2-40e8-b64f-448401f03216 ed548a3e-2d78-40b8-a316-0f691e7033f4 b5110df9-67af-4b14-9165-d1e495103178 c547da8b-ebdb-4585-af67-8e0423cd0a22 0920b282-1f77-4a7f-9cfa-593c613f0fce 2b724e33-49fe-4ae1-b43c-375f28daf025 bbd81b6a-d5f7-49e2-b82a-4f0f44a9590f 00a4f70f-b440-4893-9617-6cb762dab8ae 033cf31d-8f49-4fb5-a4d9-c9e294887248 e342c1c4-16ff-4f8e-9f86-7511c7f0e17e 01ab27e1-357c-41bb-a75f-6f371a2fe46f 1c486d7f-a691-41b0-a539-dae0474a3a18 4072a189-3e5b-4bd2-b1f2-5bcf03709556 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 bb17c53a-edf6-4e51-921a-e976a8d7678e d5e03f00-330f-4689-8504-5fd3b3230927 e17ee5a8-c6c8-4144-bc32-a3377e60df1a 31120da2-59c6-45e2-a69f-a2b6d3393424 bbd81b6a-d5f7-49e2-b82a-4f0f44a9590f ffb59ce5-ac8f-4ee7-a270-af241716d3ac 938d82c2-a1eb-4662-88dd-c1d7ff6d4f27 3fb8ff25-35fd-462d-899f-dd4e896af3d7 ff5b7695-e44e-4a4d-9c9f-cea216f1c072 e9e83208-3091-4780-a87f-98314451b2f3 21a3a32f-f836-47e7-8700-423883f8dafa 830da5da-e9dd-4da1-abd1-feb4c3d2ecae f7331d31-6b6a-4304-a267-efa203fb5842 a14295e5-fee2-40e8-b64f-448401f03216 9510fc86-8cdd-4718-9143-cb09a637888b 2 Month false fce842f8-5b77-41a3-a958-a13361bb1d3d e342c1c4-16ff-4f8e-9f86-7511c7f0e17e 9510fc86-8cdd-4718-9143-cb09a637888b 1 Year false 95b7789f-51f3-41d1-ba87-b47fda77e36f 3fb8ff25-35fd-462d-899f-dd4e896af3d7 9510fc86-8cdd-4718-9143-cb09a637888b 3 Day false 9510fc86-8cdd-4718-9143-cb09a637888b 72fdb5de-83a3-4988-ad7f-a6c05208c765 Time - YMD false 25987264-f580-40d6-b40f-16b58d44a9fb 53768bd2-6d76-4c2a-8982-7dff65d702f2 863e44be-cd4a-4517-8364-edf5027f8f08 697ee263-efd5-4bd8-bdef-3e03fdfa116f false ad3b2691-2b3f-4348-974e-789e7e6369dc 53768bd2-6d76-4c2a-8982-7dff65d702f2 863e44be-cd4a-4517-8364-edf5027f8f08 076ba97f-d720-485a-8e53-9b3a7ca293ed false 8a6b88d5-ba5c-4453-ac32-ef3f58ce0cba ad3b2691-2b3f-4348-974e-789e7e6369dc 3c002da0-db3f-4df9-8af6-052cff4c1a30 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 e180bc04-302d-437f-a8c7-6743deb2d34f 25987264-f580-40d6-b40f-16b58d44a9fb 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 8e53ceb3-f84f-45a9-a4f2-8791fa8884a5 e180bc04-302d-437f-a8c7-6743deb2d34f 4072a189-3e5b-4bd2-b1f2-5bcf03709556 8a6b88d5-ba5c-4453-ac32-ef3f58ce0cba 4072a189-3e5b-4bd2-b1f2-5bcf03709556 4072a189-3e5b-4bd2-b1f2-5bcf03709556 3fb8ff25-35fd-462d-899f-dd4e896af3d7 a14295e5-fee2-40e8-b64f-448401f03216 c547da8b-ebdb-4585-af67-8e0423cd0a22 e342c1c4-16ff-4f8e-9f86-7511c7f0e17e bbd81b6a-d5f7-49e2-b82a-4f0f44a9590f d5e03f00-330f-4689-8504-5fd3b3230927 d5e03f00-330f-4689-8504-5fd3b3230927 bbd81b6a-d5f7-49e2-b82a-4f0f44a9590f 21a3a32f-f836-47e7-8700-423883f8dafa d5e03f00-330f-4689-8504-5fd3b3230927 2e95d309-3553-43f4-a357-b150089088a4 2758bbd7-7297-4dd3-9edd-0aea89ad9fa9 <NewDataSet><TimeComparison_CustomData><ID>0</ID><Description>Period</Description></TimeComparison_CustomData><TimeComparison_CustomData><ID>1</ID><Description>Previous Year</Description></TimeComparison_CustomData><TimeComparison_CustomData><ID>2</ID><Description>Diff. Over Previous Year</Description></TimeComparison_CustomData><TimeComparison_CustomData><ID>3</ID><Description>Diff. % Over Previous Year</Description></TimeComparison_CustomData></NewDataSet> a26dd508-491a-4ccb-82eb-d43055e1a61d 32254ef5-4402-4220-80bf-2b6072d6e2c5 <NewDataSet><TimeAggregations_CustomData><ID>0</ID><Description>Period</Description></TimeAggregations_CustomData><TimeAggregations_CustomData><ID>1</ID><Description>Year To Date</Description></TimeAggregations_CustomData><TimeAggregations_CustomData><ID>2</ID><Description>Last 12 Months</Description></TimeAggregations_CustomData><TimeAggregations_CustomData><ID>3</ID><Description>Total Year</Description></TimeAggregations_CustomData><TimeAggregations_CustomData><ID>4</ID><Description>Running Total</Description></TimeAggregations_CustomData></NewDataSet> dafa71a9-fc51-4bbf-b72b-a107aa0efedf 6df0d239-7bae-4a25-84df-de609f4b33d2 <NewDataSet><FactTable_CustomData><Date>2009-01-01</Date><Value>100</Value></FactTable_CustomData><FactTable_CustomData><Date>2009-02-01</Date><Value>110</Value></FactTable_CustomData><FactTable_CustomData><Date>2010-01-01</Date><Value>120</Value></FactTable_CustomData><FactTable_CustomData><Date>2010-02-01</Date><Value>130</Value></FactTable_CustomData><FactTable_CustomData><Date>2011-01-01</Date><Value>100</Value></FactTable_CustomData><FactTable_CustomData><Date>2011-02-01</Date><Value>110</Value></FactTable_CustomData></NewDataSet> c35b3cd2-4877-4c8f-90b6-25a538fea639 5825e3fd-72f0-4461-a450-74a6f87c4e0e 863e44be-cd4a-4517-8364-edf5027f8f08;9510fc86-8cdd-4718-9143-cb09a637888b PeriodHierarchy Hirachy Time Hierarchy to be used for the dynamic time calculations 0 c0dde17b-176a-442e-be60-27768831dc97 5825e3fd-72f0-4461-a450-74a6f87c4e0e Comparison ComparisonLevel Member Name of the Comparison level in the Time Calculation dimension 6 4369cfb9-26fa-4c6f-81df-3d8dbccc9471 5825e3fd-72f0-4461-a450-74a6f87c4e0e TimeCalculations CalcDimName Member Name of the Time Calculation shell dimension 2 0999ca88-07ed-4135-bae8-730e0d8db3d3 5825e3fd-72f0-4461-a450-74a6f87c4e0e Aggregation AggregationLevel Member Name of the Aggregation level in the Time Calculation dimension 3 ea7c65b8-97ac-467d-ac91-7c0553cf315c 5825e3fd-72f0-4461-a450-74a6f87c4e0e Month PeriodAllMonthMember Member Name of the Month all member in the time dimension 5 1f1914b1-7690-4527-8062-8f56edde63c4 5825e3fd-72f0-4461-a450-74a6f87c4e0e Year PeriodAllYearMember Member Name of the Year all member in the time dimension 4 9caabb26-774d-4a87-a6fd-9e872b89913a 5825e3fd-72f0-4461-a450-74a6f87c4e0e 863e44be-cd4a-4517-8364-edf5027f8f08;3fb8ff25-35fd-462d-899f-dd4e896af3d7 PeriodLowestLevel Dimension_Level Lowest level in the time dimension 1 5825e3fd-72f0-4461-a450-74a6f87c4e0e 5f7ae99b-014d-42ef-bc29-d31735f5081b TimeCalculations Null, Visible=0 ; /////////////////////////////////////////////////////////////////////////////////////// // // Aggregations // /////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////// // // RUNNING TOTAL - ID = 4 In TimeAggregations Table // /////////////////////////////////////////////////////////////////////////////////////// SCOPE ( PeriodHierarchy.MEMBERS, PeriodLowestLevel.MEMBERS ); ( CalcDimName.AggregationLevel.&[4]) = Aggregate ( { CalcDimName.AggregationLevel.DefaultMember } * { NULL : PeriodHierarchy.CurrentMember } ); /////////////////////////////////////////////////////////////////////////////////////// // // YEAR TO DATE - ID = 1 In TimeAggregations Table // /////////////////////////////////////////////////////////////////////////////////////// ( CalcDimName.AggregationLevel.&[1] ) = Aggregate( { CalcDimName.AggregationLevel.DefaultMember } * PeriodsToDate( PeriodHierarchy.[Year], PeriodHierarchy.CurrentMember ) ); /////////////////////////////////////////////////////////////////////////////////////// // // LAST 12 MONTHS (ROLLING 12 MONTHS) - ID = 2 In TimeAggregations Table // /////////////////////////////////////////////////////////////////////////////////////// ( CalcDimName.AggregationLevel.&[2] ) = Aggregate( { CalcDimName.AggregationLevel.DefaultMember } * { ParallelPeriod( PeriodHierarchy.[Year], 1, PeriodHierarchy ).NextMember : PeriodHierarchy.CurrentMember } ); /////////////////////////////////////////////////////////////////////////////////////// // // TOTAL YEAR - ID = 3 In TimeAggregations Table // /////////////////////////////////////////////////////////////////////////////////////// ( CalcDimName.AggregationLevel.&[3] ) = ( CalcDimName.AggregationLevel.DefaultMember, Ancestor( PeriodHierarchy.CurrentMember, PeriodHierarchy.[Year] ) ); /////////////////////////////////////////////////////////////////////////////////////// // // Tuple (All years, All Months) is the default number (keeps compatibility with OWC11) // /////////////////////////////////////////////////////////////////////////////////////// ( PeriodAllYearMember, PeriodAllMonthMember, Except( CalcDimName.AggregationLevel.AggregationLevel.MEMBERS, CalcDimName.AggregationLevel.DefaultMember ) ) = CalcDimName.AggregationLevel.DefaultMember; END SCOPE; /////////////////////////////////////////////////////////////////////////////////////// // // End Aggregations // /////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////// // // Comparison // /////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////// // // PREVIOUS YEAR - ID = 1 In TimeComparison Table // /////////////////////////////////////////////////////////////////////////////////////// SCOPE (PeriodHierarchy.MEMBERS, PeriodLowestLevel.MEMBERS); ( CalcDimName.ComparisonLevel.&[1], CalcDimName.AggregationLevel.Members ) = ( CalcDimName.ComparisonLevel.DefaultMember, ParallelPeriod( PeriodHierarchy.[Year], 1, PeriodHierarchy.CurrentMember) ); END SCOPE; /////////////////////////////////////////////////////////////////////////////////////// // // DIFF. OVER PREVIOUS YEAR - ID = 2 In TimeComparison Table // /////////////////////////////////////////////////////////////////////////////////////// SCOPE (CalcDimName.ComparisonLevel.&[2]) ; THIS = IIF( IsEmpty( CalcDimName.ComparisonLevel.DefaultMember ) OR IsEmpty( CalcDimName.ComparisonLevel.&[1] ), NULL, CalcDimName.ComparisonLevel.DefaultMember - CalcDimName.ComparisonLevel.&[1] ); NON_EMPTY_BEHAVIOR(THIS) = CalcDimName.ComparisonLevel.DefaultMember; END SCOPE; /////////////////////////////////////////////////////////////////////////////////////// // // DIFF. % OVER PREVIOUS YEAR - ID = 3 In TimeComparison Table // /////////////////////////////////////////////////////////////////////////////////////// SCOPE (CalcDimName.ComparisonLevel.&[3]) ; THIS = IIF( IsEmpty( CalcDimName.ComparisonLevel.&[2] ) OR IsEmpty( CalcDimName.ComparisonLevel.&[1] ), NULL, CalcDimName.ComparisonLevel.&[2] / CalcDimName.ComparisonLevel.&[1] ); NON_EMPTY_BEHAVIOR(THIS) = CalcDimName.ComparisonLevel.DefaultMember; FORMAT_STRING(THIS) = 'Percent'; END SCOPE; /////////////////////////////////////////////////////////////////////////////////////// // // Tuple (All years, All Months) is the default number (keeps compatibility with OWC11) // /////////////////////////////////////////////////////////////////////////////////////// ( PeriodAllYearMember, PeriodAllMonthMember, Except( CalcDimName.ComparisonLevel.ComparisonLevel.MEMBERS, CalcDimName.ComparisonLevel.DefaultMember ) ) = CalcDimName.ComparisonLevel.DefaultMember; /////////////////////////////////////////////////////////////////////////////////////// // // End Comparison // /////////////////////////////////////////////////////////////////////////////////////// // // // CREATE MEMBER CURRENTCUBE.[Measures].[DummyTX] AS Null MDX used for setting up dynamic time calculations. EX.: YTD, Running Total, Previous Year, Difference this year/last year