MDX語法中，crossjoin({集合1},{[維度名稱].[..]})的含義
?? 維度名稱][..]表示當(dāng)前維度不參與計算 ，相當(dāng)于只有集合1，沒有維度名稱].[..]這個集合
這種用法主要用在如果同一個columns里面有多個crossjoin，第一個不需要多維計算 ，即上面的情形 但是第二個crossjoin要做多維計算的情形中


With
member [貸款狀態(tài)].[正常貸款余額] as '[貸款狀態(tài)].[所有 貸款狀態(tài)].[正常]',solve_order =1
member [貸款狀態(tài)].[逾期余額] as '[貸款狀態(tài)].[所有 貸款狀態(tài)].[逾期]',solve_order =1
member [貸款狀態(tài)].[呆滯余額] as '[貸款狀態(tài)].[所有 貸款狀態(tài)].[呆滯]',solve_order =1
member [貸款狀態(tài)].[呆帳余額] as '[貸款狀態(tài)].[所有 貸款狀態(tài)].[呆帳]',solve_order =1
member [貸款狀態(tài)].[不良貸款余額] as '[貸款狀態(tài)].[所有 貸款狀態(tài)].[逾期]+[貸款狀態(tài)].[所有 貸款狀態(tài)].[呆滯]+[貸款狀態(tài)].[所有 貸款狀態(tài)].[呆帳]',solve_order =2

member [貸款狀態(tài)].[正常逾期] as '[貸款狀態(tài)].[所有 貸款狀態(tài)].[正常]+ [貸款狀態(tài)].[所有 貸款狀態(tài)].[逾期]',solve_order =1

member [貸款狀態(tài)].[不良] as '[貸款狀態(tài)].[所有 貸款狀態(tài)].[逾期]+[貸款狀態(tài)].[所有 貸款狀態(tài)].[呆滯]+[貸款狀態(tài)].[所有 貸款狀態(tài)].[呆帳]',solve_order =2,format = '#,#0.00'

member [Measures].[本期戶數(shù)] as '(ClosingPeriod([日期].[日],[日期].CurrentMember), [Measures].[客戶數(shù)])',solve_order =1,format = '#,#0'
member [Measures].[上期余額] as 'iif([日期].CurrentMember.Level.name="日",(ClosingPeriod([日期].[日],ParallelPeriod([日期].[月],1,[日期].CurrentMember)), [Measures].[I_余額])/10000,(ClosingPeriod([日期].[日],[日期].CurrentMember.prevmember), [Measures].[I_余額])/10000)',solve_order =1,format = '#,#0'
member [Measures].[發(fā)放] as '(ClosingPeriod([日期].[日],[日期].CurrentMember), [Measures].[I_放款])/10000',solve_order =1,format = '#,#0.00'
member [Measures].[本月發(fā)放] as '([放款標(biāo)志].[所有 放款標(biāo)志].[所有發(fā)放貸款].[本年發(fā)放貸款].[本月發(fā)放貸款],[Measures].[發(fā)放])',solve_order =2,format = '#,#0.00'
member [Measures].[收回] as '(ClosingPeriod([日期].[日],[日期].CurrentMember), [Measures].[I_還款金額])/10000',solve_order =1,format = '#,#0.00'
member [Measures].[本月收回] as 'sum(mtd(),[Measures].[收回])',solve_order =2,format = '#,#0.00'
member [Measures].[收回不良] as '([貸款狀態(tài)].[不良],[Measures].[本月收回])',solve_order =3,format = '#,#0.00'
member [Measures].[月末余額] as '(ClosingPeriod([日期].[日],[日期].CurrentMember), [Measures].[I_余額])/10000',solve_order =1,format = '#,#0.00'
member [Measures].[正常余額] as '([Measures].[月末余額],[貸款狀態(tài)].[正常貸款余額])',solve_order =3,format = '#,#0.00'
member [Measures].[不良余額] as '([Measures].[月末余額],[貸款狀態(tài)].[不良貸款余額])',solve_order =3,format = '#,#0'
member [科目].[貸 款] as '[科目].&[1] - [科目].&[9]',solve_order =1,format = '#,#0'
member [科目].[貼 現(xiàn)] as '([科目].&[9])',solve_order =1,format = '#,#0'
member [科目].[合 計] as '[科目].&[1]',solve_order =1,format = '#,#0'
member [逾期天數(shù)].[..] as '[逾期天數(shù)].[所有 逾期天數(shù)]',solve_order =1,format = '#,#0'
member [Measures].[貸款余額分布] as '([Measures].[月末余額],[貸款狀態(tài)].[正常逾期])',solve_order =1,format = '#,#0.00'
member [逾期天數(shù)].[正常] as '[逾期天數(shù)].[所有 逾期天數(shù)]-[逾期天數(shù)].[所有 逾期天數(shù)].[90天以內(nèi)]-[逾期天數(shù)].[所有 逾期天數(shù)].[90到180天]-[逾期天數(shù)].[所有 逾期天數(shù)].[180到270天]-[逾期天數(shù)].[所有 逾期天數(shù)].[270到360天]-[逾期天數(shù)].[所有 逾期天數(shù)].[360天以上]'
//member [逾期天數(shù)].[正常] as '[逾期天數(shù)].[所有 逾期天數(shù)].[未逾期]+ [逾期天數(shù)].[所有 逾期天數(shù)].[一年內(nèi)到期]+ [逾期天數(shù)].[所有 逾期天數(shù)].[三年內(nèi)到期]+ [逾期天數(shù)].[所有 逾期天//數(shù)].[三年以上到期]',solve_order =1,format = '#,#0'

Select non empty {Crossjoin({[科目].[貸 款],[科目].[貼現(xiàn)]},{[全行客戶經(jīng)理].[所有 全行客戶經(jīng)理].children,[全行客戶經(jīng)理].[所有 全行客戶經(jīng)理]}),([科目].[合 計],[全行客戶經(jīng)理].[所有 全行客戶經(jīng)理])} on rows,
{[Measures].[本期戶數(shù)],[Measures].[上期余額],[Measures].[本月發(fā)放],[Measures].[本月收回],[Measures].[月末余額],Crossjoin({[Measures].[貸款余額分布]},{[逾期天數(shù)].[正常],[逾期天數(shù)].[所有 逾期天數(shù)].[90天以內(nèi)],[逾期天數(shù)].[所有 逾期天數(shù)].[90到180天],[逾期天數(shù)].[所有 逾期天數(shù)].[180到270天],[逾期天數(shù)].[所有 逾期天數(shù)].[270到360天],[逾期天數(shù)].[所有 逾期天數(shù)].[360天以上]})} on columns
From? [信貸財務(wù)信息分析]
Where ([日期].[所有 日期].[2005年].[2季度],[余額狀況].[所有 余額狀況].[余額不為0],[營業(yè)網(wǎng)點].&[0001])