快速打造web-based高效能决策支援系统进阶开发技巧深度

快速打造web-based高效能决策支援系统进阶开发技巧深度内容摘要：

ildren, {Food,Drink}) ON COLUMNS, CrossJoin ([Store Type].Children, {[Store Sales],[Store Cost]}) ON ROWS FROM SALES MDX 實例十二 Select {Profit} on Columns, UNION(TopCount([Store Name].Members, 5, (Profit,[1997].[Q1])), TopCount([Store Name].Members,5,(Profit,[1997].[Q2]))) on Rows from Sales Show me all Store Names who are either Top 5 in Q1 or Top 5 in Q2, in terms of Profit MDX 實例十三 Select {Profit} on Columns, INTERSECT(TopCount([Product Name].Members, 10, (Profit,[1998].[Q1])), TopCount([Product Name].Members,10 ,(Profit,[1998].[Q2]))) on Rows from Sales Show me which of the Top 10 Products in Q1 were also in the Top 10 in Q2, in terms of Profit MDX 實例十四 SELECT ORDER( {[Education Level].MEMBERS}, [Promotions].[All Promotions], ASC) ON COLUMNS, NON EMPTY ORDER ( {}, [Education Level].[All Education Level], DESC) ON ROWS FROM Sales WHERE ([Store Sales]) Calculated Member  通常為 Measures dimension 的 members  可屬於任何 dimension  純計算 , 不影響 Cube 之空間大小 MDX 實例十五 WITH MEMBER [Time].[97 to 98] AS 39。 [Time].[1998] [Time].[1997]39。 MEMBER [Measures].[Profit] AS 39。 [Measures].[Store Sales] [Measures].[Store Cost]39。 SELECT {[Measures].[Store Sales], [Measures].[Store Cost], [Measures].[Profit]} ON COLUMNS, {[Time].[1997], [Time].[1998], [Time].[97 to 98]} ON ROWS FROM Sales MDX 實例十六 WITH MEMBER [Time].[97 to 98] AS 39。 [Time].[1998] / [Time].[1997]39。 , SOLVEORDER = 1 MEMBER [Measures].[Profit] AS 39。 [Measures].[Store Sales] [Measures].[Store Cost]39。 SELECT {[Measures].[Store Sales], [Measures].[Store Cost], [Measures].[Profit]} ON COLUMNS, {[Time].[1997], [Time].[1998], [Time].[97 to 98]} ON ROWS FROM Sales MDX 實例十七  同類函數 :  NextMember, CurrentMember WITH MEMBER AS 39。 ([Store Sales]) / ([Store Sales], )39。 , FORMAT_STRING = 39。 .00%39。 SELECT {DESCENDANTS ( [Time], [Month] )} ON COLUMNS, { [Store Sales], PercentGrowth } ON ROWS From Sales MDX 實例十八 WITH MEMBER AS 39。 IIF ( IsEmpty (),1, ([Store Sales]) / ([Store Sales], ))39。 , FORMAT_STRING = 39。 .00%39。 SELECT {DESCENDANTS ( [Time], [Month] )} ON COLUMNS, { [Store Sales], PercentGrowth } ON ROWS From Sales Microsoft 資料連接策略 Client Applications ActiveX Data Objects (Extensions : ADO MD, ADO Exchange, ADO AD) OLE DB ODBC OLE DB for Active Directory RDBMS OLE DB for OLAP OLAP Server OLE DB for Exchange Exchange Server Active Directory ADO MD  存取 OLAP 的 Automation 介面  使用 VB, C++, Java, VBScript, Jscript  能運用在任何 OLE DB for OLAP provider Metadata ADO MD。