1

Closed

Names of identity relationships do not include column name when created in SQL Server

description

Names of identity relationships do not include identity column name when created in SQL Server.
In Vulcan Version 2.5.0.29194 when Identity relationship is included in a dimension definition it only takes Name attribute of the identity tag when creating a relation omitting identity column name.
So in the example below Identity in sql server will be DimAccount_Identity and not DimAccount_Identity_AccountID as it was in Vulcan 2.0.
 
Expected behavior: Full Identity name should include column name as well
 
<?xml version="1.0" encoding="utf-8"?>
<Vulcan xmlns="http://tempuri.org/vulcan2.xsd">
<Dimensions>
<Dimension ConnectionName="DataWarehouse" Name="DimAccount">
  <Columns>
    <Column Name="AccountID" Type="Int32" />
    <Column Name="AccountName" Type="WStr" Length="200" />
  </Columns>
  <Keys>
    <Identity Name="DimAccount_Identity" Clustered="true">
      <Columns>
        <Column ColumnName="AccountID" SortOrder="Asc" />
      </Columns>
    </Identity>
  </Keys>
  <Sources>
    <StaticSource Name="StaticSourceValues">
      <Rows>
        <Row>
          <ColumnValues>
            <ColumnValue ColumnName="AccountID" Value="1" />
            <ColumnValue ColumnName="AccountName" Value="'Unknown'" />
          </ColumnValues>
        </Row>  
      </Rows>
    </StaticSource>
  </Sources>
</Dimension>
</Dimensions>
 
</Vulcan>
Closed Sep 10, 2009 at 3:08 AM by vsabella

comments

vsabella wrote Sep 10, 2009 at 3:08 AM

by design, vulcan 2.5 does not perform any "magic" on names you provide.

wrote Sep 10, 2009 at 3:08 AM

wrote Feb 13, 2013 at 9:39 PM

wrote May 16, 2013 at 2:49 AM