<Biml xmlns="http://schemas.varigence.com/biml.xsd"> <Connections> <Connection Name="ProdConnection" ConnectionString="Provider=SQLNCLI10.1;Data Source=Localhost;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=Products" /> </Connections> <Databases> <Database Name="ProdDB" ConnectionName="ProdConnection" /> </Databases> <Schemas> <Schema Name="ProdSchema" DatabaseName="ProdDB" /> </Schemas> <Dimensions> <Dimension Name="DimProduct" SchemaName="ProdDB.ProdSchema"> <Columns> <Column Name="ProductID" /> <Column Name="ProductName" DataType="String" Length="50" /> <Column Name="CategoryName" DataType="String" Length="50" /> <Column Name="SubcategoryName" DataType="String" Length="50" /> </Columns> <Attributes> <Attribute Usage="Key" Name="ProductName"> <KeyColumns> <KeyColumn ColumnName="ProductID" /> </KeyColumns> <NameColumn ColumnName="ProductName" /> </Attribute> <Attribute Name="Category Name"> <KeyColumns> <KeyColumn ColumnName="CategoryName" /> </KeyColumns> </Attribute> <Attribute Name="Subcategory Name"> <KeyColumns> <KeyColumn ColumnName="SubcategoryName" /> </KeyColumns> </Attribute> </Attributes> <Relationships> <Relationship Name="Category Name" ParentAttributeName="Subcategory Name" ChildAttributeName="Category Name" /> <Relationship Name="Subcategory Name" ParentAttributeName="ProductName" ChildAttributeName="Subcategory Name" /> </Relationships> <AttributeHierarchies> <Hierarchy Name="Categories"> <Levels> <Level Name="Category Name" AttributeName="Category Name" /> <Level Name="Subcategory Name" AttributeName="Subcategory Name" /> <Level Name="ProductName" AttributeName="ProductName" /> </Levels> </Hierarchy> </AttributeHierarchies> </Dimension> </Dimensions> </Biml>
A key thing to notice in this Biml snippet is that the dimension doesn't point to a connection directly. Instead, the dimension references a schema, that references a database, that references the connection.
Comments
There are no comments yet.