With
member [Measures].[贷款余额] as '(ClosingPeriod([日期].[日],[日期].CurrentMember), [Measures].[I_余额])/10000',solve_order =1,format = '#,#0.00'

member [Measures].[公司贷款余额] as '([客户分类].[所有 客户分类].[企业客户],[Measures].[贷款余额])',solve_order =1,format = '#,#0.00'
member [Measures].[个人消费贷款余额] as '([客户分类].[所有 客户分类].[个人客户],[Measures].[贷款余额])',solve_order =1,format = '#,#0.00'
member [担保方式].[合计] as '[担保方式].[所有 担保方式]',solve_order =1,format = '#,#0.00'

member [营业网点].[合计] as '[营业网点].&[0001]'

Select
{[营业网点].&[0001].children,[营业网点].[合计]} on rows,
crossjoin({[Measures].[贷款余额],[Measures].[公司贷款余额],[Measures].[个人消费贷款余额]},{[担保方式].[所有 担保方式].children,[担保方式].[合计]}) on columns
From  [信贷财务信息分析]

Where ([日期].[所有 日期].[2005年].[4季度].[10月],[余额状况].[所有 余额状况].[余额不为0])


crossjoin函数里面是两个set,可以显示出set{公司贷款余额,个人消费贷款余额},{抵押,质押,保证,担保合计}这两个set和所有营业网点的三维数据出来.展现效果见相册.