Grouping Transactions by Age of Customers in DAX
Grouping transactions by customers’ age requires a computation made row by row at transaction level. DAX offers an elegant solution… Read More »
Import Data from Tabular Model in Excel Using a DAX Query
When you use Excel to connect to a Tabular database in Analysis Services, you get a PivotTable as a result.… Read More »
Parallelize ProcessAdd with AMO
In this article we see a function to enable parallelism in commands sent to Analysis Services by using the AMO… Read More »
Best Practices Using SUMMARIZE and ADDCOLUMNS
Everyone using DAX is probably used to SQL query language. Because of the similarities between the Tabular data modeling and… Read More »
Clever Hierarchy Handling in DAX
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are… Read More »
Incremental Processing in Tabular Using Process Add
In Analysis Services 2012 you can process a table in a Tabular model by several ways: you can process the… Read More »
Memory Settings in Tabular Instances of Analysis Services
Memory settings in Analysis Services might be an important tuning of a correct setup, both for production and developer machines.… Read More »
Automate PowerPivot Data Refresh in Excel
In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data… Read More »
Separate date and time in PowerPivot (and BISM tabular)
In PowerPivot you can import data from several sources and it is often the case that you import a DateTime… Read More »
Drillthrough for BISM Tabular and attribute keys in SSAS Denali
In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL… Read More »
DateTool dimension: an alternative Time Intelligence implementation
Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity)… Read More »