MDX 几个比率问题

最新推荐文章于 2021-04-10 22:46:58 发布

jackfor001

最新推荐文章于 2021-04-10 22:46:58 发布

阅读量989

点赞数

分类专栏： MDX 文章标签： hierarchy table encoding schema

MDX 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

维度配置

view plaincopy to clipboardprint?
<?xml version="1.0" encoding="UTF-8"?>

<Schema>

    <Parameter name="tt" type="Table" />

    <Parameter name="Company" type="Table" />

    <Parameter name="Fact" type="Table" />

    <Dimension name="tt" caption="时间" table="tt" primaryKey="month" type="Time">

        <Hierarchy>

            <Level name="Year" column="month" type="Years" />

            <Level name="Month" column="month" type="Months" />

        </Hierarchy>

    </Dimension>



    <Dimension name="Company" caption="组织" table="Company"

        primaryKey="FID">

        <Hierarchy>

            <Level name="Company" column="FID" childColumn="fid" parentColumn="fparentId">

                <Property name="name" column="fname" />

            </Level>

        </Hierarchy>

    </Dimension>

    <Cube name="Fact" caption="收入" table="Fact">

        <DimensionUsage name="tt" foreignKey="Ftt" />

        <DimensionUsage name="Company" foreignKey="FCompanyID" />

        <Measure name="famount" caption="金额" column="famount" aggregator="sum" formatString="#,##0.00"/>

    </Cube>

</Schema>

<?xml version="1.0" encoding="UTF-8"?>

</Hierarchy>

</Dimension>

<Dimension name="Company" caption="组织" table="Company"

primaryKey="FID">

</Level>

</Hierarchy>

</Dimension>

</Cube>

</Schema>MDX环比

view plaincopy to clipboardprint?
with member Company.[增长环比] as '((tt.currentmember,measures.famount)-(tt.PrevMember,measures.famount))/(tt.PrevMember,measures.famount)',formatString='0.00%',solve_order=1 select {Company.members,Company.[增长环比]} on rows, tt.members on columns from fact

with member Company.[增长环比] as '((tt.currentmember,measures.famount)-(tt.PrevMember,measures.famount))/(tt.PrevMember,measures.famount)',formatString='0.00%',solve_order=1 select {Company.members,Company.[增长环比]} on rows, tt.members on columns from fact其它

view plaincopy to clipboardprint?
with member item.[合计] as 'sum(item.levels(0).members)' member measures.[zb] as '(item.currentmember,measures.famount)/(item.[合计],measures.famount)',formatString='0.00%',caption='成本占比%' member measures.[增长率] as '((tt.[2008年6月],measures.famount)-(tt.[2007年6月],measures.famount))/(tt.[2007年6月],measures.famount)',formatString='0.00%',solve_order=2 member measures.[成本占比变化] as '(tt.[2008年6月],measures.[zb])-(tt.[2007年6月],measures.[zb])',formatString='0.00%',solve_order=2 member tt.[同期比] as '0',solve_order=1 select {item.levels(0).members,item.[合计]} on rows, union(tt.members*{measures.members,measures.[zb]}, {tt.[同期比]}*{measures.[增长率],measures.[成本占比变化]}) on columns from Fact

with member item.[合计] as 'sum(item.levels(0).members)' member measures.[zb] as '(item.currentmember,measures.famount)/(item.[合计],measures.famount)',formatString='0.00%',caption='成本占比%' member measures.[增长率] as '((tt.[2008年6月],measures.famount)-(tt.[2007年6月],measures.famount))/(tt.[2007年6月],measures.famount)',formatString='0.00%',solve_order=2 member measures.[成本占比变化] as '(tt.[2008年6月],measures.[zb])-(tt.[2007年6月],measures.[zb])',formatString='0.00%',solve_order=2 member tt.[同期比] as '0',solve_order=1 select {item.levels(0).members,item.[合计]} on rows, union(tt.members*{measures.members,measures.[zb]}, {tt.[同期比]}*{measures.[增长率],measures.[成本占比变化]}) on columns from Fact示例

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/redvalley/archive/2008/06/18/2560638.aspx