File Library

Mastering MDX for Analytics and Reporting
Topic: Webinars
Owner: Jennifer Hanks
Date: 2017-10-31
Subtopic: EPM

Jennifer Hanks, Key Performance Ideas

MDX is often used in ASO cube member formulas, but did you know you can also use MDX to write reports and Smart View queries? Did you know that these reports and queries can be written against both BSO and ASO cubes? 
MDX can seem daunting, but with a basic understanding of syntax and functions, MDX is not that difficult. Join us for our webinar and learn what you need to get started writing MDX reports and queries that can supplement your reporting and add a new tool to your reporting tool set. 
Presented by Jennifer Hanks at Kscope 17 and awarded best presentation of the BI & Reporting Track, Jennifer will share: 

  • Best practices for building formulas, including examples to visualize the appropriate approach 
  • A comparison of MDX to BSO formulas and the conversion of BSO to ASO, specifically instances where very distinct differences can occur, and how to make the   process run smoothly 
  • How to use MDX editor to write queries and reports against both BSO and ASO cubes

The goal of this webinar is to help attendees brainstorm new formulas their leadership might find useful, particularly when reviewing how other companies have built and leverage MDX on a daily basis for trend analysis, salary projections, turnover analysis, forecasting, and budgeting purposes using KPIs, and more. 

Download File   Mastering MDX for Analytics and Reporting J Hanks KPI 103117.mp4
Download File Download PDF File   Mastering MDX for Analytics and Reporting_20171031.pptx

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database