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

member [Measures].[公司貸款余額] as '([客戶(hù)分類(lèi)].[所有 客戶(hù)分類(lèi)].[企業(yè)客戶(hù)],[Measures].[貸款余額])',solve_order =1,format = '#,#0.00'
member [Measures].[個(gè)人消費(fèi)貸款余額] as '([客戶(hù)分類(lèi)].[所有 客戶(hù)分類(lèi)].[個(gè)人客戶(hù)],[Measures].[貸款余額])',solve_order =1,format = '#,#0.00'
member [擔(dān)保方式].[合計(jì)] as '[擔(dān)保方式].[所有 擔(dān)保方式]',solve_order =1,format = '#,#0.00'

member [營(yíng)業(yè)網(wǎng)點(diǎn)].[合計(jì)] as '[營(yíng)業(yè)網(wǎng)點(diǎn)].&[0001]'

Select
{[營(yíng)業(yè)網(wǎng)點(diǎn)].&[0001].children,[營(yíng)業(yè)網(wǎng)點(diǎn)].[合計(jì)]} on rows,
crossjoin({[Measures].[貸款余額],[Measures].[公司貸款余額],[Measures].[個(gè)人消費(fèi)貸款余額]},{[擔(dān)保方式].[所有 擔(dān)保方式].children,[擔(dān)保方式].[合計(jì)]}) on columns
From? [信貸財(cái)務(wù)信息分析]

Where ([日期].[所有 日期].[2005年].[4季度].[10月],[余額狀況].[所有 余額狀況].[余額不為0])


crossjoin函數(shù)里面是兩個(gè)set,可以顯示出set{公司貸款余額,個(gè)人消費(fèi)貸款余額},{抵押,質(zhì)押,保證,擔(dān)保合計(jì)}這兩個(gè)set和所有營(yíng)業(yè)網(wǎng)點(diǎn)的三維數(shù)據(jù)出來(lái).展現(xiàn)效果見(jiàn)相冊(cè).