MDX Designer

• Design simple query
• Apply inner MDX Functions
• Generate - Top 10 Cities and for each Top 5 Product subcategories
• Top 15 Customers for year 2001 compared with 2000 and percentage difference
• Date Parts - Today, Yesterday, Last Month, Last Quarter ...      

          Inner Query

• Create and use Inner Query

          Create local calculated elements

• Create member
• Create Set
• Create Named Set
• Create Member from Set  

          Tuple Generator

• Create tuple

          Time MDX Functions

• FromDate - ToDate member
• LastPeriods member
• PeriodsToDate member

          Member MDX Functions 

• NextMember and PrevMember
• First and LastChilde combined with CHILDREN or Descendants
• CHILDREN
• Descendants
• Find members and make selection   

          Member Properties 

• Use as measure or filter data set

          Functions

• Contribution function

          KPIs

• KPIs

          Save and use Designer

• Save and use Designer