schema.xml
<Dimension name="4. Department">
<Hierarchy hasAll="true">
<Level name="group1" column="group1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
<MemberFormatter>
<Script language="JavaScript">
if (member.getName().toUpperCase().indexOf("NULL") >= 0) { return "OTHER" }
else { return member.getName();}
</Script>
</MemberFormatter>
</Level>
<Level name="group2" column="group2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
<MemberFormatter>
<Script language="JavaScript">
if (member.getName().toUpperCase().indexOf("NULL") >= 0) { return "OTHER" }
else { return member.getName();}
</Script>
</MemberFormatter>
</Level>
<Level name="group3" column="group3" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
<MemberFormatter>
<Script language="JavaScript">
if (member.getName().toUpperCase().indexOf("NULL") >= 0) { return "OTHER" }
else { return member.getName();}
</Script>
</MemberFormatter>
</Level>
<Level name="group4" column="group4" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
<MemberFormatter>
<Script language="JavaScript">
if (member.getName().toUpperCase().indexOf("NULL") >= 0) { return "OTHER" }
else { return member.getName();}
</Script>
</MemberFormatter>
</Level>
<Level name="partner" column="partner" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />
<Level name="owner_alias" column="owner_alias" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" />
<Level name="account_id" column="account_id_2" type="String" uniqueMembers="true" />
</Hierarchy>
</Dimension>
- MemberFormatterで指定
- javascriptで変更できる.
- nullの場合は,OTHERに変えるとか
- 他のlanguageで何か使えるかは???