﻿<?xml version="1.0" encoding="utf-8"?><XmlProjectInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Id="1102ff96-fab7-4b54-a4a2-2e9c1e4f3668" Name="TEMPLATE - PLEASE RENAME" Type="0" OutputPath="build\" DefaultPublishProfile="Default" Version="2.12.3497.0" NotReplaceMacroInPreview="false" DisableMacroExtensions="false" TargitDbVersion="Version_1_334"><FileSystemObjects><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.XmlProjectModelInfo"><XmlProjectModelInfo FileName="TEMPLATE - PLEASE RENAME.impm" BuildAction="Yes" Id="fe27f2a9-6315-4c26-ba78-fa0d275f1a0e" Created="2019-03-22T11:55:13.6072774+01:00" CreatedBy="MDBG\UZ4G" Edited="2023-03-15T21:26:53.226827+01:00" EditedBy="TARGIT-INET\jesper_e" IsOpened="true" CubeName="TEMPLATE - PLEASE RENAME" PublishToServer="true" Is32BitExecutionMode="false" IsBaseScriptLocked="false" ExecuteOnScheduleOnly="false" IsStandard="false" RetryAttempts="0" RetryIntervalMins="0" RestartOnServiceFailure="true" RemoveDatabaseFromScheduler="false"><Instructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Debug" Id="fbb4e829-95c7-4d11-bde7-0f81a341ff02" IsExpanded="true"><InnerInstructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="DebugInfo" Id="bad3d013-57b4-409d-92d0-855e0cfb9266" Query="DECLARE @DebugInfo as INT&#xD;&#xA;&#xD;&#xA;/* DebugInfo: &#xD;&#xA;1 will keep temp,STAGE and WORK tables in final database. &#xD;&#xA;0 removes temp tables */&#xD;&#xA;SET @DebugInfo = 0" IsDisableMacro="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="SET Culture" Id="427448c1-b262-4678-aa26-9ab16683a23b" Query="SET CULTURE 'da-dk'" IsDisableMacro="false" /></IStorageInfo></InnerInstructions></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Load data" Id="ad9df14e-9b0a-4b37-ab5a-79e952e46161" IsExpanded="true"><InnerInstructions /></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="WORK" Id="a0b61297-05a7-476c-96ad-9fc43fba38b3" IsExpanded="true"><InnerInstructions /></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Populate Dimensions" Id="37ce5169-894f-4881-a52c-2f156e6795bb" IsExpanded="true"><InnerInstructions /></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Populate Facts" Id="80196813-97b5-4783-a420-39388aad3237" IsExpanded="false"><InnerInstructions /></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Consistency Check" Id="38698a9b-030a-45b7-92b9-1489754889de" IsExpanded="false"><InnerInstructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="1" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="Update all string columns" Id="5f899400-de91-4a7d-84e0-79083a65e62e" Query="declare @TmpTableName as String&#xD;&#xA;declare @TmpColumnName as String&#xD;&#xA;declare @Statement as String&#xD;&#xA;&#xD;&#xA;import [targittmp__BusinessTables] = me.{SELECT * FROM INFORMATION_SCHEMA.TABLES where STARTSWITH(Table_Name,'DIM_')=true or STARTSWITH(Table_Name,'FACT_')=true}&#xD;&#xA;&#xD;&#xA;while [targittmp__BusinessTables].EOF=false&#xD;&#xA;&#xD;&#xA;  set @TmpTableName =  [targittmp__BusinessTables].[Table_Name]&#xD;&#xA;&#xD;&#xA;  import [targittmp__TableColumns] = me.{select * from INFORMATION_SCHEMA.COLUMNS where Table_Name = '@@TmpTableName' and Data_Type = 'String'}&#xD;&#xA;&#xD;&#xA;  while [targittmp__TableColumns].EOF=false&#xD;&#xA;&#xD;&#xA;    set @TmpColumnName = [targittmp__TableColumns].[Column_Name]&#xD;&#xA;&#xD;&#xA;    set @Statement = '{update ' + @TmpTableName + ' set ' +  @TmpColumnName + ' = ''- n/a -'' where ISNULLOREMPTY(' + @TmpColumnName + ')=true}'&#xD;&#xA;&#xD;&#xA;    scriptExec @Statement&#xD;&#xA;&#xD;&#xA;    print @Statement&#xD;&#xA;&#xD;&#xA;  movenext [targittmp__TableColumns]&#xD;&#xA;  loop&#xD;&#xA;  drop [targittmp__TableColumns]&#xD;&#xA;&#xD;&#xA;movenext [targittmp__BusinessTables]&#xD;&#xA;loop&#xD;&#xA;drop [targittmp__BusinessTables]&#xD;&#xA;" IsDisableMacro="false" /></IStorageInfo></InnerInstructions></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Calender" Id="4b18f21b-f2fa-41fc-8553-2648ebfe870e" IsExpanded="false"><InnerInstructions /></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Postprocess" Id="7a60f3b8-ac7c-4887-bd83-c53f44b8d4dc" IsExpanded="false"><InnerInstructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="Clone tables for use in data model" Id="3dd7f804-94f2-4e38-9bc7-e3c4df1dbe3a" Query="// IMPORT [DIM_TableName] = me.{select * from DIM_Period}&#xD;&#xA;" IsDisableMacro="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="DEBUG - CLEANUP" Id="36cb95de-c03c-4e6f-83e7-00cb5886b807" Query="TRY&#xD;&#xA; If @DebugInfo = 0 THEN&#xD;&#xA; // DROP Stage_&#xD;&#xA;&#xD;&#xA; END IF&#xD;&#xA;END TRY&#xD;&#xA;CATCH &#xD;&#xA; // Commands to execute when an error occurs &#xD;&#xA; PRINT 'Error Dropping tables'&#xD;&#xA;END CATCH" IsDisableMacro="false" /></IStorageInfo></InnerInstructions></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlGroupInstructionInfo"><XmlGroupInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.GroupToolSurfaceViewModel" Name="Index" Id="0f7039f2-f509-4c3e-84ec-093a8987b78d" IsExpanded="false"><InnerInstructions><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="Index on FACT tables" Id="86f657d7-c2f5-4683-8aa6-425b8afd70ce" Query="// CREATE CLUSTERED INDEX ON [FACT_TableName] (ColumnName)&#xD;&#xA;" IsDisableMacro="false" /></IStorageInfo></InnerInstructions></XmlGroupInstructionInfo></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlScriptInstructionInfo"><XmlScriptInstructionInfo Visibility="1" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.ScriptToolSurfaceViewModel" Name="- - BREAK POINT WITH SAVE - -" Id="344fc8ad-ce57-48a5-8e3d-4df6fa47ff7d" Query="save&#xD;&#xA;exit 0" IsDisableMacro="false" /></IStorageInfo><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Instructions.XmlInstructionInfo"><XmlInstructionInfo Visibility="0" IsLocked="false" ToolSurfaceViewModelClass="TARGIT.InMemory.ETL.Studio.ViewModels.ToolSurfaces.SaveToolSurfaceViewModel" Name="Save Database" Id="128ddc89-56b9-4a93-aa57-c60bc1a1dbe7" /></IStorageInfo></Instructions><Schedules /></XmlProjectModelInfo></IStorageInfo></FileSystemObjects><PublishProfiles><IStorageInfo AssemblyQualifiedName="TARGIT.InMemory.ETL.Studio.Configuration.Xml.Publish.XmlPublishProfileInfo"><XmlPublishProfileInfo Name="Default"><PublishStrategyInfo xsi:type="XmlSchedulerServicePublishStrategyInfo" Server="localhost" OpenOutputFolderInWindowsExplorer="false" ExecuteAndFetchResultsLocally="false" DeleteAllExistingFiles="false"><Folder Id="ea108ab1-cc39-486e-9c0d-0a63a0cc8dfd" Name="Public" /></PublishStrategyInfo></XmlPublishProfileInfo></IStorageInfo></PublishProfiles><DataSources /><Macros /><Synchronization IsEnabled="false" /></XmlProjectInfo>