资源描述：
《microsof sql server 2008 mdx step by step（下）》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、76PartIMDXFundamentals8.AlterthequerytodisplaythemembersfromalllevelsoftheProductCategoriesuser-hierarchy:SELECT{([Date].[Calendar].[CY2002]),([Date].[Calendar].[CY2003]),([Date].[Calendar].[CY2004])}ONCOLUMNS,{[Product].[ProductCategories].Members}ONROWSFROM[Step-by-Step]
2、WHERE([Geography].[Country].[UnitedStates])9.Executethequeryandevaluatetheresults.NoticethenumberofmembersreturnedalongtheROWSaxis.Byremovingthelevelidentifier,eachmemberofeachlevelintheuser-hierarchyisreturnedintheset,regardlessoftheattribute-hierarchyfromwhichthememberisd
3、erived.TheMeasureGroupMeasuresFunctionTheMembersfunctionreturnsallmembersstoredwithinahierarchy.WhenusedwiththeMeasuresattribute-hierarchy,theMembersfunctionreturnsallmeasureswithinacubewithoutregardforthemeasuregroupswithwhichtheyareassociated.Toreturnallmeasuresassociate
4、dwithaspecificmeasuregroup,usetheMeasureGroupMeasuresfunction.MeasureGroupMeasures(MeasureGroupName)MeasureGroupMeasures(MeasureGroupName)TheMeasureGroupMeasuresfunctiontakesasitsloneparameterastringsupplyingthenameofthemeasuregroupfromwhichmeasuresshouldbeextracted:SELECT{
5、[Product].[Category].Members}ONCOLUMNS,{MeasureGroupMeasures("ResellerSales")}ONROWSFROM[Step-by-Step]Chapter4WorkingwithSets77TheCrossjoinFunctionFrequently,youwillwanttocombinethetuplesofonesetwiththetuplesofanothertoformmorecomplex,multiparttuples.ThisisdoneusingtheCros
6、sjoinfunction.Crossjoin({Set1},{Set2}[,Crossjoin({Set1},{Set2}[,....{Setn}){Setn})TheCrossjoinfunctiontakesasitsparameterstwoormoresets.Eachtupleofeachsetiscombinedwiththetuplesoftheothersetsinamultiplicativeoperation.AnalysisServicessupportstheuseofacross-joinoperator(*),
7、employingthesamecharacterasisusuallyreservedformultiplication,asasubstitutefortheformaluseoftheCrossjoinfunction.BuildasetusingtheBuildasetusingtheCrossjoinCrossjoinfunctionfunction1.Ifyouhavenotalreadydoneso,opentheMDXQueryEditortotheMDXStep-by-Stepdatabase.2.Inthecodepan
8、e,enterthefollowingquery:SELECT{([Date].[Calendar].[CY2002]),([Date].[Calendar].[CY2003])
