Automating Creation of SSAS Offline Cubes
Immigration, Refugees and Citizenship Canada
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.