Creating a Dimension

gravatar

cell

This is a sample dimension with attributes, hierarchies, and relationships.

published 09.07.12

last updated 09.09.12


Share

                            


<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.

You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.

Comments

There are no comments yet.