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

Aggregation Design

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Cubes>
        <Cube Name="Adventure Works" ConnectionName="AdvWorksCube">
            <CubeMeasureGroups>
                <CubeMeasureGroup Name="Fact Currency Rate" FactName="FactCurrencyRate">
                    <!-- 
                    In Biml, Aggregations are defined within an AggregationDesign. 
                    Along with generating aggregations in Mist, you can define your own directly in Biml.
                    -->
                    <AggregationDesigns>
                        <AggregationDesign Name="Currency Rate AggregationDesign">
                            <Aggregations>
                                <Aggregation Name="UsageBased_1">
                                    <Dimensions>
                                        <Dimension CubeDimensionName="Adventure Works.Destination Currency">
                                            <Attributes>
                                                <Attribute AttributeName="DimDestinationCurrency.Destination Currency" />
                                            </Attributes>
                                        </Dimension>
                                        <Dimension CubeDimensionName="Adventure Works.Date">
                                            <Attributes>
                                                <Attribute AttributeName="DimDate.Calendar Quarter of Year" />
                                            </Attributes>
                                        </Dimension>
                                    </Dimensions>
                                </Aggregation>
                                <Aggregation Name="UserAggregation_2">
                                    <Dimensions>
                                        <Dimension CubeDimensionName="Adventure Works.Date">
                                            <Attributes>
                                                <Attribute AttributeName="DimDate.Date" />
                                                <Attribute AttributeName="DimDate.Day Name" />
                                            </Attributes>
                                        </Dimension>
                                    </Dimensions>
                                </Aggregation>
                            </Aggregations>
                        </AggregationDesign>
                    </AggregationDesigns>
                </CubeMeasureGroup>
            </CubeMeasureGroups>
            <CubeDimensions>
                <CubeDimension Name="Destination Currency" DimensionName="DimDestinationCurrency">
                    <Attributes>
                        <Attribute AttributeName="DimDestinationCurrency.Destination Currency" />
                        <Attribute AttributeName="DimDestinationCurrency.Destination Currency Code" />
                        <Attribute AttributeName="DimDestinationCurrency.Locale" />
                    </Attributes>
                </CubeDimension>
                <CubeDimension Name="Date" DimensionName="DimDate"/>
            </CubeDimensions>
        </Cube>
    </Cubes>
</Biml>

© Varigence