Report Portal

Fact Table Range Groups Created Easily in SSAS Tabular

This is one very cool feature that I wanted to share in my SQL Saturday #168 session on SSAS Tabular but ran out of time. Often in a data warehouse project you will receive a request to group certain values in a fact table into range groups.

For example: Sales Amounts into categories of "Small", "Medium", or "Large" and the corresponding range values for price will be 0-$50, $51-100, $101-$1,000,000.

Read more...

Tags: excel, design, dax, tabular

 

2007-2015 VidasSoft Systems Inc.