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

Script Command

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Cubes>
        <Cube Name="Adventure Works" ConnectionName="AdvWorksCube">
            <MdxScripts>
                <MdxScript Name="MdxScript1" Default="true">
                    <MdxScriptItems>
                        <!--
                        Biml ScriptCommands have names along with MdxScripts blocks.
                        When multiple calculations are defined in a MdxScriptItems collection, their order matters.
                        -->
                        <ScriptCommand Name="Calculate">
                            <MdxScript>/*-- Aggregate leaf data -----------------------------------------------*/
                                Calculate</MdxScript>
                        </ScriptCommand>
                        <ScriptCommand Name="Alter Cube">
                            <MdxScript>
                                /*-- Set default member for the Destination Currency cube dimension ----*/
                                Alter Cube
                                CurrentCube
                                Update Dimension [Destination Currency].[Destination Currency],
                                Default_Member = [Destination Currency].[Destination Currency].[US Dollar]</MdxScript>
                        </ScriptCommand>
                        <ScriptCommand Name="Scope">
                            <MdxScript>
                                /*-- Set language property for the Destination Currency cube dimension --*/
                                Scope
                                (

                                [Destination Currency].[Destination Currency Code].Members,
                                [Destination Currency].[Destination Currency].[Destination Currency].Members

                                )</MdxScript>
                        </ScriptCommand>
                    </MdxScriptItems>
                </MdxScript>
            </MdxScripts>
            <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>
            </CubeDimensions>
        </Cube>
    </Cubes>
</Biml>

© Varigence