解决方案:
<Formula> IIf([Measures].[惠及企业数]=0, 0, [Measures].[惠企金额]/[Measures].[惠及企业数] )
</Formula>
一个完整的schemal文件:
<?xml version="1.0"?>
<Schema name="zhida">
<Dimension name="Time" type="TimeDimension">
<Hierarchy hasAll="false">
<Table name="BB_MV_ZD_HQLM_HZ_CUBE"/>
<Level name="年" column="YEAR" uniqueMembers="true" levelType="TimeYears" type="Numeric"/>
</Hierarchy>
</Dimension>
<Dimension name="地区">
<Hierarchy hasAll="true" allMemberName="All 省">
<Table name="BB_MV_ZD_HQLM_HZ_CUBE"/>
<Level name="省" column="SHENG" uniqueMembers="false"/>
<Level name="市" colu