Home
  •  

Data Warehouse Properties

Microsoft.SystemCenter.DataWarehouse.Settings (Report)

This report shows Data warehouse properties and grooming settings.

Element properties:

AccessibilityPublic
VisibleTrue

Report Localization:

R.Description
The data warehouse properties and grooming settings report.
R.DescriptionTitleClick on plus sign to see a full description for this report
R.GeneratedTimeLabelReport Time
R.PageFormatPage {0} of {1}
R.TimeZoneFormatAll dates and times are shown in {0}
R.TitleData Warehouse Properties Report

Source Code:

<Report ID="Microsoft.SystemCenter.DataWarehouse.Settings" Accessibility="Public" Visible="true">

  <Dependencies>

    <Report>Microsoft.SystemCenter.DataWarehouse.DatabaseSettings</Report>

    <ReportParameterControl>Reporting!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.TimeZonePicker</ReportParameterControl>

  </Dependencies>

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="1">

    <Controls>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.TimeZonePicker">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

        </ReportParameters>

      </Control>

    </Controls>

  </ParameterBlock>

  <Definition>

    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

      <DataSources>

        <DataSource Name="DataWarehouseMain">

          <rd:DataSourceID>e4235c51-407f-4065-8519-a1e57374bc45</rd:DataSourceID>

          <DataSourceReference>Data Warehouse Main</DataSourceReference>

        </DataSource>

      </DataSources>

      <InteractiveHeight>11in</InteractiveHeight>

      <ReportParameters>

        <ReportParameter Name="LT_Report">

          <DataType>String</DataType>

          <DefaultValue>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

            </DataSetReference>

          </DefaultValue>

          <ValidValues>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

              <LabelField>ValueName</LabelField>

            </DataSetReference>

          </ValidValues>

          <Hidden>true</Hidden>

        </ReportParameter>

        <ReportParameter Name="Database">

          <DataType>Integer</DataType>

          <DefaultValue>

            <DataSetReference>

              <DataSetName>DatabaseList</DataSetName>

              <ValueField>MemberDatabaseRowId</ValueField>

            </DataSetReference>

          </DefaultValue>

          <Prompt>[Database]</Prompt>

          <ValidValues>

            <DataSetReference>

              <DataSetName>DatabaseList</DataSetName>

              <ValueField>MemberDatabaseRowId</ValueField>

              <LabelField>DisplayName</LabelField>

            </DataSetReference>

          </ValidValues>

          <MultiValue>true</MultiValue>

          <Hidden>true</Hidden>

        </ReportParameter>

        <ReportParameter Name="TimeZone">

          <DataType>String</DataType>

          <Prompt>[Time Zone]</Prompt>

        </ReportParameter>

        <ReportParameter Name="TimeZoneName">

          <DataType>String</DataType>

          <Nullable>true</Nullable>

          <AllowBlank>true</AllowBlank>

          <Prompt>[Time Zone Name]</Prompt>

        </ReportParameter>

        <ReportParameter Name="Interactive">

          <DataType>Boolean</DataType>

          <Nullable>true</Nullable>

          <DefaultValue>

            <Values>

              <Value>=False</Value>

            </Values>

          </DefaultValue>

          <Prompt>Interactive</Prompt>

          <Hidden>true</Hidden>

        </ReportParameter>

      </ReportParameters>

      <rd:DrawGrid>true</rd:DrawGrid>

      <InteractiveWidth>8.5in</InteractiveWidth>

      <rd:GridSpacing>0.05in</rd:GridSpacing>

      <rd:SnapToGrid>true</rd:SnapToGrid>

      <rd:ReportID>ab518a51-343d-46c4-b1f8-4ec65faafd95</rd:ReportID>

      <CodeModules>

        <CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>

      </CodeModules>

      <DataSets>

        <DataSet Name="LT_Report_Query">

          <Fields>

            <Field Name="ValueXml">

              <DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>

            </Field>

            <Field Name="ValueName">

              <Value>="LT"</Value>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>ReportDisplayStringGet</CommandText>

            <QueryParameters>

              <QueryParameter Name="@ManagementGroupGuid">

                <Value>=Code.GetCallingManagementGroupId()</Value>

              </QueryParameter>

              <QueryParameter Name="@ManagementPackSystemName">

                <Value>Microsoft.SystemCenter.DataWarehouse.Reports</Value>

              </QueryParameter>

              <QueryParameter Name="@ReportSystemName">

                <Value>Microsoft.SystemCenter.DataWarehouse.Settings</Value>

              </QueryParameter>

              <QueryParameter Name="@LanguageCode">

                <Value>=Code.GetReportLocLanguageCode()</Value>

              </QueryParameter>

              <QueryParameter Name="@Scope">

                <Value>R.%</Value>

              </QueryParameter>

            </QueryParameters>

          </Query>

        </DataSet>

        <DataSet Name="DatabaseList">

          <Fields>

            <Field Name="MemberDatabaseRowId">

              <DataField>MemberDatabaseRowId</DataField>

              <rd:TypeName>System.Int32</rd:TypeName>

            </Field>

            <Field Name="ServerName">

              <DataField>ServerName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="DatabaseName">

              <DataField>DatabaseName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="DisplayName">

              <Value>=Code.FormatString("{1} ({0})", Fields!ServerName.Value, Fields!DatabaseName.Value)</Value>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>SELECT        MemberDatabaseRowId, ServerName, DatabaseName

FROM            vMemberDatabase

ORDER BY DatabaseName, ServerName</CommandText>

          </Query>

        </DataSet>

        <DataSet Name="DatabaseInfo">

          <Fields>

            <Field Name="MemberDatabaseRowId">

              <DataField>MemberDatabaseRowId</DataField>

              <rd:TypeName>System.Int32</rd:TypeName>

            </Field>

            <Field Name="ServerName">

              <DataField>ServerName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="DatabaseName">

              <DataField>DatabaseName</DataField>

              <rd:TypeName>System.String</rd:TypeName>

            </Field>

            <Field Name="DefaultDatabaseInd">

              <DataField>DefaultDatabaseInd</DataField>

              <rd:TypeName>System.Boolean</rd:TypeName>

            </Field>

            <Field Name="MasterDatabaseInd">

              <DataField>MasterDatabaseInd</DataField>

              <rd:TypeName>System.Boolean</rd:TypeName>

            </Field>

          </Fields>

          <Query>

            <DataSourceName>DataWarehouseMain</DataSourceName>

            <CommandText>SELECT        MemberDatabaseRowId, ServerName, DatabaseName, DefaultDatabaseInd, MasterDatabaseInd

FROM            vMemberDatabase

WHERE        (MemberDatabaseRowId IN (@Database))</CommandText>

            <QueryParameters>

              <QueryParameter Name="@Database">

                <Value>=Parameters!Database.Value</Value>

              </QueryParameter>

            </QueryParameters>

          </Query>

        </DataSet>

      </DataSets>

      <Code><Script>

	  Const LocTableStringQuery As String = "R/S[@N='{0}']/text()"



	  Const TimeZoneParameterName As String = "TimeZone"



	  Dim LocTables As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)

	  Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation

	  Dim ReportCulture As System.Globalization.CultureInfo



	  Public Function GetLocTables() As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)

	  If IsNothing(LocTables) Then LocTables = new System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()

	  Return LocTables

	  End Function



	  Public Function GetReportCulture() As System.Globalization.CultureInfo

	  If IsNothing(ReportCulture) Then ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))

	  Return ReportCulture

	  End Function

	  

	  Public Function GetCallingManagementGroupId() As String

	  Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId

	  End Function



	  Public Function GetReportLocLanguageCode() As String

	  Return GetReportCulture().ThreeLetterWindowsLanguageName

	  End Function



	  Public Function GetLocTable(Name As String) As Microsoft.EnterpriseManagement.Reporting.XmlStringTable

	  Dim LocTable As Microsoft.EnterpriseManagement.Reporting.XmlStringTable



	  If Not GetLocTables().TryGetValue(Name, LocTable) Then

	  LocTable = New Microsoft.EnterpriseManagement.Reporting.XmlStringTable(LocTableStringQuery, Report.Parameters(Name).Value)

	  LocTables.Add(Name, LocTable)

	  End If



	  Return LocTable

	  End Function



	  Public Function GetReportTimeZone() As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation

	  If IsNothing(ReportTimeZone) Then ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation.FromValueString(Report.Parameters(TimeZoneParameterName).Value)

	  Return ReportTimeZone

	  End Function



	  Public Function ToDbDate(ByVal DateValue As DateTime) As DateTime

	  return GetReportTimeZone.ToUniversalTime(DateValue)

	  End Function



	  Public Function ToReportDate(ByVal DateValue As DateTime) As DateTime

	  return GetReportTimeZone.ToLocalTime(DateValue)

	  End Function



	  Public Function FormatDateTime(Format As String, Value As DateTime) As String

	  return Value.ToString(Format, GetReportCulture())

	  End Function



	  Public Function FormatNumber(Format As String, Value As Decimal) As String

	  return Value.ToString(Format, GetReportCulture())

	  End Function



	  Public Function FormatString(Format As String, ParamArray Values() as  Object) As String

	  return String.Format(GetReportCulture(), Format, Values)

	  End Function



	  Public Function NullFormatString(Format As String, Value as  String) As String

	  return IIF(String.IsNullOrEmpty(Value), String.Empty, String.Format(GetReportCulture(), Format, Value))

	  End Function

  </Script></Code>

      <Width>8.55in</Width>

      <Body><Script>

        <ReportItems>

          <CustomReportItem Name="ForceYukonEngine">

            <Type>ForceYukonEngine</Type>

            <Top>0 mm</Top>

            <Left>0 mm</Left>

            <Height>0.01 mm</Height>

            <Width>0.01 mm</Width>

            <Visibility>

              <Hidden>true</Hidden>

            </Visibility>

            <CustomData>

              <DataSetName>DatabaseInfo</DataSetName>

              <DataColumnGroupings>

                <DataGroupings>

                  <DataGrouping>

                    <Static>true</Static>

                  </DataGrouping>

                </DataGroupings>

              </DataColumnGroupings>

              <DataRowGroupings>

                <DataGroupings>

                  <DataGrouping>

                    <Static>true</Static>

                  </DataGrouping>

                </DataGroupings>

              </DataRowGroupings>

              <DataRows>

                <DataRow>

                  <DataCell>

                    <DataValue>

                      <Value>1</Value>

                    </DataValue>

                  </DataCell>

                </DataRow>

              </DataRows>

            </CustomData>

          </CustomReportItem>

          <List Name="DBList">

            <DataInstanceName>Database</DataInstanceName>

            <Sorting>

              <SortBy>

                <SortExpression>=Fields!DatabaseName.Value</SortExpression>

                <Direction>Ascending</Direction>

              </SortBy>

              <SortBy>

                <SortExpression>=Fields!ServerName.Value</SortExpression>

                <Direction>Ascending</Direction>

              </SortBy>

            </Sorting>

            <ZIndex>5</ZIndex>

            <Left>0.15in</Left>

            <DataSetName>DatabaseInfo</DataSetName>

            <ReportItems>

              <Subreport Name="DatabaseSettingsSubreport">

                <DataElementOutput>Output</DataElementOutput>

                <Parameters>

                  <Parameter Name="Database">

                    <Value>=Fields!MemberDatabaseRowId.Value</Value>

                  </Parameter>

                  <Parameter Name="TimeZone">

                    <Value>=Parameters!TimeZone.Value</Value>

                  </Parameter>

                  <Parameter Name="TimeZoneName">

                    <Value>=Parameters!TimeZoneName.Value</Value>

                  </Parameter>

                  <Parameter Name="Interactive">

                    <Value>=Parameters!Interactive.Value</Value>

                  </Parameter>

                </Parameters>

                <Top>0.1in</Top>

                <ReportName>Microsoft.SystemCenter.DataWarehouse.DatabaseSettings</ReportName>

                <DataElementName>DatabaseReport</DataElementName>

                <Height>0.5in</Height>

              </Subreport>

            </ReportItems>

            <Top>1.8in</Top>

            <Width>8.2in</Width>

            <DataElementName>Databases</DataElementName>

          </List>

          <Rectangle Name="rectangle5">

            <Left>0.15in</Left>

            <ZIndex>4</ZIndex>

            <Top>1.4in</Top>

            <Width>8.05in</Width>

            <Style></Style>

              <BackgroundColor>Gainsboro</BackgroundColor>

              <BorderColor>

                <Default>DarkGray</Default>

              </BorderColor>

              <BorderStyle>

                <Bottom>Solid</Bottom>

              </BorderStyle>

            </Style>

            <Height>0.05in</Height>

          </Rectangle>

          <Rectangle Name="rectangle4">

            <Left>0.15in</Left>

            <ZIndex>3</ZIndex>

            <ReportItems>

              <Textbox Name="reportDescriptionTitle">

                <DataElementOutput>NoOutput</DataElementOutput>

                <Top>0.3in</Top>

                <Width>8in</Width>

                <Style></Style>

                  <Color>DimGray</Color>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <VerticalAlign>Middle</VerticalAlign>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <ZIndex>1</ZIndex>

                <CanGrow>true</CanGrow>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.DescriptionTitle", "[Report Description Title]")</Value>

              </Textbox>

              <Textbox Name="reportTitle">

                <DataElementOutput>Output</DataElementOutput>

                <Top>0.05in</Top>

                <Width>7.8in</Width>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>11pt</FontSize>

                  <FontWeight>700</FontWeight>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <DataElementStyle>ElementNormal</DataElementStyle>

                <CanGrow>true</CanGrow>

                <Left>0.2in</Left>

                <DataElementName>Title</DataElementName>

                <Height>0.25in</Height>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.Title", "[Report Title]")</Value>

              </Textbox>

            </ReportItems>

            <Top>0.7in</Top>

            <Width>8.05in</Width>

            <Style></Style>

              <BackgroundColor>Gainsboro</BackgroundColor>

            </Style>

            <Height>0.5in</Height>

          </Rectangle>

          <Rectangle Name="rectangle3">

            <Left>0.15in</Left>

            <ZIndex>2</ZIndex>

            <Visibility>

              <Hidden>true</Hidden>

              <ToggleItem>reportDescriptionTitle</ToggleItem>

            </Visibility>

            <ReportItems>

              <Textbox Name="reportDescription">

                <DataElementOutput>NoOutput</DataElementOutput>

                <Width>7.8in</Width>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <CanGrow>true</CanGrow>

                <Left>0.2in</Left>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.Description", "[Report Description]")</Value>

              </Textbox>

            </ReportItems>

            <Top>1.2in</Top>

            <Width>8.05in</Width>

            <Style></Style>

              <BackgroundColor>Gainsboro</BackgroundColor>

            </Style>

            <Height>0.2in</Height>

          </Rectangle>

          <Rectangle Name="rectangle2">

            <Left>0.15in</Left>

            <ZIndex>1</ZIndex>

            <ReportItems>

              <Image Name="parameterBottomImage">

                <Sizing>AutoSize</Sizing>

                <Top>0.3in</Top>

                <MIMEType/>

                <Source>External</Source>

                <Style/>

                <ZIndex>3</ZIndex>

                <Value>../gradient_portrait.gif</Value>

              </Image>

              <Textbox Name="ReportGeneratedTime">

                <DataElementOutput>Output</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.05in</Top>

                <Width>6.6in</Width>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <DataElementStyle>ElementNormal</DataElementStyle>

                <ZIndex>2</ZIndex>

                <CanGrow>true</CanGrow>

                <Left>1.4in</Left>

                <DataElementName>Created</DataElementName>

                <Height>0.2in</Height>

                <Value>=Code.FormatDateTime("g", Code.ToReportDate(DateTime.UtcNow))</Value>

              </Textbox>

              <Textbox Name="textbox2">

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.05in</Top>

                <Width>0.1in</Width>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <ZIndex>1</ZIndex>

                <CanGrow>true</CanGrow>

                <Left>1.3in</Left>

                <Height>0.2in</Height>

                <Value>:</Value>

              </Textbox>

              <Textbox Name="textbox1">

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.05in</Top>

                <Width>1.1in</Width>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                  <PaddingBottom>2pt</PaddingBottom>

                </Style>

                <CanGrow>true</CanGrow>

                <Left>0.2in</Left>

                <Height>0.2in</Height>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.GeneratedTimeLabel", "[Report Generated Time Label]")</Value>

              </Textbox>

            </ReportItems>

            <Top>1.45in</Top>

            <Width>8.05in</Width>

            <Height>0.35in</Height>

          </Rectangle>

          <Image Name="banner_image">

            <Sizing>AutoSize</Sizing>

            <Top>0.11042in</Top>

            <Width>8.05in</Width>

            <MIMEType/>

            <Source>External</Source>

            <Style/>

            <Left>0.15in</Left>

            <Height>0.58958in</Height>

            <Value>../banner_portrait.jpg</Value>

          </Image>

        </ReportItems>

        <Height>2.45in</Height>

      </Script></Body>

      <Language>en-US</Language>

      <PageFooter>

        <PrintOnFirstPage>true</PrintOnFirstPage>

        <ReportItems>

          <Textbox Name="textbox8">

            <Top>0.1in</Top>

            <Width>1.7in</Width>

            <Style></Style>

              <Color>DimGray</Color>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

              <TextAlign>Right</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <ZIndex>1</ZIndex>

            <CanGrow>true</CanGrow>

            <Left>6.7in</Left>

            <Height>0.1875in</Height>

            <Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.PageFormat", "{0}/{1}"), Globals!PageNumber, Globals!TotalPages)</Value>

          </Textbox>

          <Textbox Name="textbox37">

            <Top>0.1in</Top>

            <Width>6.5in</Width>

            <Style></Style>

              <Color>DimGray</Color>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

              <PaddingBottom>2pt</PaddingBottom>

            </Style>

            <CanGrow>true</CanGrow>

            <Left>0.15in</Left>

            <Height>0.1875in</Height>

            <Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.TimeZoneFormat", "{0}"), Parameters!TimeZoneName.Value)</Value>

          </Textbox>

        </ReportItems>

        <Height>0.35in</Height>

        <PrintOnLastPage>true</PrintOnLastPage>

      </PageFooter>

      <PageHeight>8.5in</PageHeight>

    </Report>

  </Definition>

  <ReportStrings>

    <ReportString ID="R.Title"/>

    <ReportString ID="R.Description"/>

    <ReportString ID="R.DescriptionTitle"/>

    <ReportString ID="R.PageFormat"/>

    <ReportString ID="R.TimeZoneFormat"/>

    <ReportString ID="R.GeneratedTimeLabel"/>

  </ReportStrings>

</Report>