Inspired by the DBA tools (https://dbatools.io/) library for automating all things SQL Server DBEngine I created some Powershell Library functions to automate SSIS Build and Deployment. We use this on projects to move SSIS closer to the world of DevOps and that magic “10 deploys a day”. These Powershell functions work well when added to … Continue reading Automating SSIS Build and Deployment with Powershell
Category: BI
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