Static Source

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Tables>
    <Dimension Name="DimStatus" ConnectionName="FederalReserveInstruments">
      <!-- This sample demonstrates a static source in Biml.
      Notice that there are the same number of ColumnValue elements in each ColumnValues list, for each Row. -->
      <Sources>
        <StaticSource Name="StaticSource">
          <Rows>
            <Row>
              <ColumnValues>
                <ColumnValue ColumnName="StatusID" Value="-1" />
                <ColumnValue ColumnName="DisplayName" Value="N'Unknown'" />
              </ColumnValues>
            </Row>
            <Row>
              <ColumnValues>
                <ColumnValue ColumnName="StatusID" Value="1" />
                <ColumnValue ColumnName="DisplayName" Value="N'Active'" />
              </ColumnValues>
            </Row>
            <Row>
              <ColumnValues>
                <ColumnValue ColumnName="StatusID" Value="2" />
                <ColumnValue ColumnName="DisplayName" Value="N'Discontinued'" />
              </ColumnValues>
            </Row>
          </Rows>
        </StaticSource>
      </Sources>
      <Columns>
        <Column Name="StatusID" />
        <Column Name="DisplayName" DataType="String" Length="32" />
      </Columns>
    </Dimension>
  </Tables>
</Biml>