Power of MDX at your palm

MDX Designer in CubePlayer is best tool to learn and understand MDX

Learn MDX

Designer in CubePlayer will allow you to use full power of MDX command language without need to learn MDX itself. To use functions or to create calculated members, measures, sets or even named sets you need one or two clicks with mouse.

MDX Designer
Build your query in symbolic way and we will take care about MDX for you.
Redo-Undo feature will help you to easier test or correct your queries.

Features listed here do not require knowledge of writing MDX commands.

Inner Query:
CubePlayer supports usage and creation of inner queries in designer. This way created object can be used in designer and in editor.

Time Functions:

• FromDate-ToDate, LastPeriods, PeriodsToDate, ParallelPeriods

Time Functions:

• DateParts-Today, Yesterday, This Week, Last Week, This Quarter, Last Quarter, This Month, Last Month, This Year, Last Year or calulate any Date Part from TODAY  

Member Functions:

• Descendants, CHILDREN, NextMember, PrevMember, FirstChild, LastChild 

External (Set) Functions - applied to whole axis:

• TopCount, TopSum, TopPercent
• BottomCount, BottomSum, BottomPercent
• Order, Head, Tail, Filter

Dimension Functions - applied to all dimension members on axis:

• TopCount, TopSum, TopPercent
• BottomCount, BottomSum, BottomPercent
• Order, Head, Tail, Filter

Inner (element) Functions - applied to member or level:

• TopCount, TopSum, TopPercent
• BottomCount, BottomSum, BottomPercent
• Order, Head, Tail, Filter

Generate

• allow to combine top 5 elements from one dimension with top 10 elements for each member from previous dimension and so on ... 

Hierachize

• allow to order by hierarchy

NONEMPTY

• use NONEMPTY MDX function in combination with tuples (members,levels, measures)

Remove functions 

• allows to remove member or members from axis/dimension/hierarchy/member.CHILDREN; removed member(s) can be from same or different dimension/hierarchies 

Order by Alphabet

• alows to order dimension by Member.Names 

Create local calculated elements:

• Local calculated member
• Local calculated measure
• Local calculated set
• Local calculated Named set
• Local tuples

Create on the fly:

• tuples
• sets
• named sets
• aggregate members 

Member properties:

• use as filter
• use as measure

Designer

 View them or use them as measure

• Use KPI as measure
• Brows all KPIs 

Brows all KPIs