Display problems? View this newsletter in your browser.

SQLBI

Oct 28, 2014


NEXT WORKSHOPS:
Advanced DAX
  Nov 24 - Munich
  Nov 25 - Warsaw
  Dec 2 - Copenhagen
  Dec 3 - Oslo
  Dec 8 - Stockholm
SSAS Tabular
  Nov 17 - Zurich
  Jan 26 - Online
Power Pivot
  Video Courses

  Nov 10 - Online

DAX does not directly support parent-child hierarchies.
To obtain a browsable hierarchy in the data model, you have to naturalize a parent-child hierarchy.
DAX provides specific functions to naturalize a parent-child hierarchy using calculated columns. The complete pattern also includes measures that improve the visualization of ragged hierarchies in Power Pivot.

» READ ARTICLE

In his blog post, Marco Russo discusses the current state of adoption of Multidimensional and Tabular models in SQL Server Analysis Services.

» READ POST
Last seats available in 2014

If you want to attend a course about SSAS Tabular and Advanced DAX in Europe, we have the last seats available in Zurich, Munich, Copenhagen, Oslo and Stockholm.

Early bird rates are expiring soon, so don’t wait and register today!

» FIND OUT MORE

Take a look at Power Pivot Workshop video course, it includes 3 different units from basics to advanced topics!

» WATCH NOW


SQLBI is a brand of Loader. 2006-2014 © All rights are reserved.
We are Microsoft SSAS Maestro        We are Microsoft Gold Partner in Data Platform + Business Intelligence        We are Microsoft Most Valuable Professional
You are receiving this mail because we have registered your interest in SQLBI.
If our records are wrong or you'd like to make a change to the type of emails you receive, unsubscribe