Home - Archive by category: SSAS

Hernoemen van velden in SSAS

Zul je altijd zien: Je kubus is net in gebruik genomen. De eerste rapporten zijn er tegenaan gebouwd. Op dat moment blijkt de naamgeving toch niet 100% te kloppen. Hoe voorkom je dat alle bestaande rapportages nu breken, maar je wel flexibel bent in het wijzigen van namen van measures en kolommen / attributen?
Read More

3 Important Lessons about Test Automation in Business Intelligence

As you might know, I’m keeping an eye on how I can automate my Data Warehousing testing. In “Automated Testing for the Data Warehouse” my observation was In essence, testing a Data Warehouse isn’t that complex It turns out I’m not the only one thinking about this (really? ūüėČ ). Some time ago¬†I listened to[...]
Read More

VSTS Continuous MSBuild for DWH / BI

Wait, didn’t I post this already several weeks ago? Well, almost. A few weeks ago, I showed how to set up a build agent using Unfortunately, I ran into some problems like failing builds not reporting failure and SSAS Tabular projects not building correctly[ref]There’s also some mentions about SSDT 2015 projects not being supported,[...]
Read More

VSTS Continuous Build for DWH / BI

In my earlier post “Automated Deployments using Visual Studio” I metioned that the method described was a workaround because I hadn’t figured out how to do a continuous build in VSTS (Visual Studio Team Services) yet. With hindsight, that workaround was not really needed: VSTS build turns out to be s√≥ easy, that it’s ridiculous[...]
Read More

Automated Deployments using Visual Studio

In my earlier post “Automated Testing for¬†the Data Warehouse“, I sketched the outlines of¬†what would be needed in order to achieve¬†automated testing for your Data Warehouse solutions. Today, I want to look at the first step: build & deploy. Between the previous post and the current one, some¬†useful content about this has been written already[...]
Read More

Automated Testing for the Data Warehouse

Case: we’ve integrated two sources of customers. We want to add a third source. Q: How do we¬†at the same time¬†know that our¬†current integration and solutions will continue to work while at the same time¬†integrating the new sources? A:¬†Test it. Q: How do we get faster deployments and more stability? A: Automate the tests, so[...]
Read More

Moving BI to the cloud: Consider this…

While looking into the possibilities of moving my customer’s BI infrastructure into the cloud, my primary question was how to handle the lack of cloud SSAS. But there’s a lot more to keep in mind. Here’s a few things that I think should be thought of from an architectural point of view: not only in[...]
Read More

Moving BI to the Cloud: Ditch SSAS?

Some time ago I read Chris Webb blogged “Thoughts On The Power BI Announcements At The MS Data Insights Summit“, where between the lines was this rather interesting point: For the last few years my customers have asked me when MS was going to release SSAS in the cloud and I‚Äôve always replied that Power[...]
Read More

Latest Posts