The Varigence company brand logo
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Products
BimlFlexBimlStudioBimlExpress
Pricing
Solutions
IndustriesUse Cases
Resources
DocumentationKnowledge BaseBlog
About
CompanyContact Us
Schedule Demo
Account
Schedule Demo
Account

Partition - Query Source

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <Connection Name="AdventureWorksDW2008" ConnectionString="Data Source=(local);Initial Catalog=AdventureWorksDW2008;Provider=SQLNCLI10.1;Integrated Security=SSPI;" />
    </Connections>
    <Cubes>
        <Cube Name="Adventure Works" ConnectionName="AdvWorksCube">
            <CubeMeasureGroups>
                <CubeMeasureGroup Name="Fact Internet Sales 1" FactName="FactInternetSales">
                    <Partitions>
                        <!-- This Biml partition uses a Query Source to specify the query and SQL connection that provide data for the partition. -->
                        <Partition Name="Internet_Sales_2004" EstimatedRows="32265">
                            <ProactiveCaching />
                            <QuerySource ConnectionName="AdventureWorksDW2008">
                                <Query>SELECT [dbo].[FactInternetSales].[ProductKey],[dbo].[FactInternetSales].[OrderDateKey],[dbo].[FactInternetSales].[DueDateKey]
                                    FROM [dbo].[FactInternetSales]
                                    WHERE OrderDateKey &gt;= '20040101' AND OrderDateKey &lt;= '20041231'</Query>
                            </QuerySource>
                        </Partition>
                    </Partitions>
                </CubeMeasureGroup>
            </CubeMeasureGroups>
        </Cube>
    </Cubes>
</Biml>

© Varigence