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

Perspective

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Cubes>
        <Cube Name="Adventure Works" ConnectionName="AdvWorksCube">
            <Perspectives>
                <!--
                This is a sample perspective for this Adventure Works cube. With Biml, it's easy to reference cube objects within the perspective. 
                -->
                <Perspective Name="Direct Sales" DefaultMeasureName="FactInternetSales.Internet Sales Amount">
                    <Actions>
                        <Action ActionName="Internet Details" />
                    </Actions>
                    <Calculations>
                        <Calculation CalculationName="[Internet Gross Profit]" />
                    </Calculations>
                    <Kpis>
                        <Kpi KpiName="Growth in Customer Base" />
                    </Kpis>
                    <MeasureGroups>
                        <MeasureGroup CubeMeasureGroupName="Fact Internet Sales 1">
                            <Measures>
                                <Measure MeasureName="FactInternetSales.Internet Order Quantity" />
                                <Measure MeasureName="FactInternetSales.Internet Tax Amount" />
                                <Measure MeasureName="FactInternetSales.Internet Freight Cost" />
                                <Measure MeasureName="FactInternetSales.Internet Standard Product Cost" />
                                <Measure MeasureName="FactInternetSales.Internet Transaction Count" />
                                <Measure MeasureName="FactInternetSales.Internet Extended Amount" />
                            </Measures>
                        </MeasureGroup>
                    </MeasureGroups>
                    <Dimensions>
                        <Dimension CubeDimensionName="Sales Territory">
                            <Attributes>
                                <Attribute AttributeName="DimSalesTerritory.Sales Territory Region" />
                                <Attribute AttributeName="DimSalesTerritory.Sales Territory Country" />
                            </Attributes>
                            <Hierarchies>
                                <Hierarchy HierarchyName="DimSalesTerritory.Sales Territory" />
                            </Hierarchies>
                        </Dimension>
                    </Dimensions>
                </Perspective>
            </Perspectives>
            <MdxScripts>
                <MdxScript Name="MdxScript1" Default="true">
                    <MdxScriptItems>
                        <CalculatedMember Name="[Internet Gross Profit]" FormatString="Currency" ParentDimensionName="Measures" AssociatedMeasureGroupName="Fact Internet Sales 1">
                            <MdxScript>[Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost]</MdxScript>
                            <NonemptyBehaviors>
                                <NonemptyBehavior MeasureName="FactInternetSales.Internet Sales Amount" />
                                <NonemptyBehavior MeasureName="FactInternetSales.Internet Total Product Cost" />
                            </NonemptyBehaviors>
                        </CalculatedMember>
                    </MdxScriptItems>
                </MdxScript>
            </MdxScripts>
            <CubeMeasureGroups>
                <CubeMeasureGroup Name="Fact Internet Sales 1" FactName="FactInternetSales">
                    <Measures>
                        <Measure MeasureName="FactInternetSales.Internet Sales Amount" />
                        <Measure MeasureName="FactInternetSales.Internet Order Quantity" />
                        <Measure MeasureName="FactInternetSales.Internet Extended Amount" />
                        <Measure MeasureName="FactInternetSales.Internet Tax Amount" />
                        <Measure MeasureName="FactInternetSales.Internet Freight Cost" />
                        <Measure MeasureName="FactInternetSales.Internet Unit Price" />
                        <Measure MeasureName="FactInternetSales.Internet Total Product Cost" />
                        <Measure MeasureName="FactInternetSales.Internet Standard Product Cost" />
                        <Measure MeasureName="FactInternetSales.Internet Transaction Count" />
                    </Measures>
                </CubeMeasureGroup>
            </CubeMeasureGroups>
            <CubeDimensions>
                <CubeDimension Name="Sales Territory" DimensionName="DimSalesTerritory">
                    <Attributes>
                        <Attribute AttributeName="DimSalesTerritory.Sales Territory Region" />
                        <Attribute AttributeName="DimSalesTerritory.Sales Territory Country" />
                        <Attribute AttributeName="DimSalesTerritory.Sales Territory Group" />
                    </Attributes>
                    <Hierarchies>
                        <Hierarchy HierarchyName="DimSalesTerritory.Sales Territory" />
                    </Hierarchies>
                </CubeDimension>
            </CubeDimensions>
            <Actions>
                <DrillThrough Name="Internet Details" Caption="Drillthrough..." Default="false" Target="Adventure Works.Fact Internet Sales 1" TargetType="Cells"/>
                <DrillThrough Name="Finance Details" Target="Adventure Works.Fact Finance" Caption="Drillthrough..." Default="true" CaptionIsMdx="false" Invocation="Interactive" TargetType="Cells"/>
            </Actions>
            <Kpis>
                <Kpi Name="Growth in Customer Base" AssociatedMeasureGroupName="Fact Internet Sales 1" StatusGraphic="RoadSigns"/>
            </Kpis>
        </Cube>
    </Cubes>
</Biml>

© Varigence