81,094
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="gb2312"?>
<Function creater="管理员" createtime="2008-11-26 11:24:49" desc="税务部门收入报表(按税种)" funcgroup="mdx_default" id="20081126112449453" modify="20100725" modifytime="20100725" name="税务部门收入报表(按税种)" version="5.1">
<Parameters>
<Parameter name="p3" type="number" default="ID_MONTH" nullvalue=""/>
<Parameter name="p1" type="number" default="ID_YEAR" nullvalue=""/>
<Parameter name="p2" type="number" default="ID_QUART" nullvalue=""/>
</Parameters>
<Conditions cols="4">
<Condition name="时间" ref="时间" cols="2"/>
<Condition name="企业状态" ref="纳税人状态" cols="2"/>
<Condition name="注册类型" ref="注册类型" cols="4"/>
<Condition name="国标行业" ref="国标行业" cols="4"/>
<Condition name="国库" ref="国库" cols="2"/>
</Conditions>
<DrillThrough>
<Measure name="月累计" funcgroup="query_default" functype="Q" funcid="20081126101952875"/>
<Measure name="当月收入" funcgroup="query_default" functype="Q" funcid="20081126100933656"/>
</DrillThrough>
<Mdx><![CDATA[
with member [Measures].[当月收入] as '[Measures].[本月一般口径金额]'
member [Measures].[去年同期] as '([Measures].[本月一般口径金额], ParallelPeriod([时间].[年]))'
member [Measures].[当月增减] as '([Measures].[当月收入] - [Measures].[去年同期])'
member [Measures].[当月增幅%] as '([Measures].[当月增减] / [Measures].[去年同期])', format_string = "Percent"
member [Measures].[月累计] as '[Measures].[月累计一般口径金额]'
member [Measures].[月累计去年同期] as '([Measures].[月累计一般口径金额], ParallelPeriod([时间].[年]))'
member [Measures].[月累计增减] as '([Measures].[月累计] - [Measures].[月累计去年同期])'
member [Measures].[月累计增幅%] as '([Measures].[月累计增减] / [Measures].[月累计去年同期])', format_string = "Percent"
select {[Measures].[当月收入], [Measures].[去年同期], [Measures].[当月增减], [Measures].[当月增幅%], [Measures].[月累计], [Measures].[月累计去年同期], [Measures].[月累计增减], [Measures].[月累计增幅%]} ON columns,
{[税种].[税种合计], [税种].[税种合计].[地税], [税种].[税种合计].[国税]} ON rows
from [税款月汇总表]
where [时间].[时间合计].[@@@p1@@@年].[@@@p2@@@季].[@@@p3@@@月]
]]></Mdx>
</Function>