With a “ragged” hierarchy we often need a way to make sure that the hierarchy is displayed in a user friendly fashion when measures can be linked to any level (including parents). There are two established solutions 1) The Pure DAX approach Alberto was one of the first to publish a DAX workaround for the … Continue reading Should I use HideMemberIf for Tabular Model
Tag: Tabular
I’ve been diving deep into how long Analysis Services can take to open a connection for a few months now and thanks to some tips from many people (Alberto Ferrari, Greg Galloway, Darren Gospel to name a few) here are some ideas to improve performance. 1. Make sure your network is not slow OK, sounds … Continue reading Optimising Connections to SSAS (MOLAP/Tabular)