Maxime Gagné

Automating Creation of SSAS Offline Cubes

Immigration, Refugees and Citizenship Canada

  • Industry: IT Services
Repair old solution for generating SSAS offline cube.

Project Requirements

  • Convert old .NET Framework code to .NET Core.
  • Creating automation.
  • Sending cubes to Team Foundation Server

Technologies Used

  • NET Core, .NET Framework, MS SQL Server, SSAS & PowerShell

Project Overview

Old solution that generates Offline Cube from an Analisys Service Database in .NET Framework was not user friendly and broken. I was in charge of the repair of the solution and the convertion from old .NET Framework to modern .NET Core. Connection to database was also repaired at the same time with AMO.NET and ADOMD.NET. I optimized the solution so it became frendly to users without programming knoledge. On top of that, I created a PowerSell Script to Automate the task and send the Offline Cube to Team Foundation Server.

Want my help on your project?