Home      Functions     Common Solutions      Contact      MDX Functions: - Select a function - - View all functions - AddCalculatedMembers Aggregate AllMembers Ancestor Ancestors Ascendants Avg Axis BottomCount BottomPercent BottomSum CalculationCurrentPass CalculationPassValue Children ClosingPeriod CoalesceEmpty Correlation Count (Dimension) Count (Hierarchy Levels) Count (Set) Count (Tuple) Cousin Covariance CovarianceN Crossjoin Current CurrentMember CurrentOrdinal CustomData DataMember DefaultMember Descendants Dimension Dimensions Distinct DistinctCount DrilldownLevel DrilldownLevelBottom DrilldownLevelTop DrilldownMember DrilldownMemberBottom DrilldownMemberTop DrillupLevel DrillupMember Error Except Exists Extract Filter FirstChild FirstSibling Generate Head Hierarchize Hierarchy IIf Intersect IsAncestor IsEmpty IsGeneration IsLeaf IsSibling Item (Member) Item (Set) KPICurrentTimeMember KPIGoal KPIStatus KPITrend KPIValue KPIWeight Lag LastChild LastPeriods LastSibling Lead Leaves Level Levels LinkMember LinRegIntercept LinRegPoint LinRegR2 LinRegSlope LinRegVariance LookupCube Max MeasureGroupMeasures Median Members (Set) Members (String) MemberToStr MemberValue Min Mtd Name NameToSet NextMember NonEmpty NonEmptyCrossjoin OpeningPeriod Order Ordinal ParallelPeriod Parent PeriodsToDate Predict PrevMember Properties Qtd Rank RollupChildren Root SetToArray SetToStr Siblings Stdev StdevP StripCalculatedMembers StrToMember StrToSet StrToTuple StrToValue Subset Sum Tail This ToggleDrillState TopCount TopPercent TopSum TupleToStr Union UniqueName UnknownMember Unorder UserName ValidMeasure Value Var VarP VisualTotals Wtd Ytd
MDX Functions All MDX Functions KPI Functions Metadata Functions Navigation Functions Other Functions Set Functions Statistical Functions String Functions SubCube Functions Time Functions UI Functions Value Functions   Common Solutions Common Solutions   Resource Links MDX Books MDX Related Software MDX Related Blogs   Other Links Contact Us	Welcome to MDXpert.com This site currently focuses on MDX that is specifically related to Microsoft Analysis Services.  In the future we plan to add MDX information that is applicable to Hyperion and SAP, as well as other major OLAP vendors. All MDX statements on this site can be executed against the Adventure Works database which is the sample database for Microsoft SQL Server Analysis Services 2005 (SSAS).  You can download the Adventure Works database along with installation instructions here.     Back
Copyright 2008 by MDXpert.com.   Terms of Use                              Privacy Statement   Site Powered By - WinHost.Com