Mastering MDX for Analytics and Reporting
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. Watch the 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 shares:
- 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.
Watch a replay today!
Posted on Tue, August 1, 2017
by Anne Stein