SQL Server · SSAS

How to Implement Slowly Changing Dimension Type 2 in SQL Server Analysis Services

The other day somebody asked me how I could implement Slowly Changing Dimension Type 2 (SCD Type 2) in SSAS. I wasn’t able to give the answer right there and then, so I decided to create a demo video to answer his question and as a note to myself for future uses. This is my first ever demo… Continue reading How to Implement Slowly Changing Dimension Type 2 in SQL Server Analysis Services

Automation · Continuous Integration · Deployment · SSAS

Deploy a SQL Server Analysis Services Project using PowerShell

Step 1: Build SQL Server Analysis Services solution using devenv /build, for example “<path>\devenv.com” AdventureWorksSSAS.sln /build Development In the bin folder of your solution, you should find <projName>.asdatabase, <projName>.deploymentoptions, <projName>.deploymenttargets and <projName>.configsettings XML files Step 2: Generate XMLA script using Microsoft.AnalysisServices.Deployment.exe Microsoft.AnalysisServices.Deployment.exe <path>\AdventureWorksSSAS.asdatabase /s:GenerateXmla.log /o:SSASDatabase.xmla Step 3. Execute XMLA on target server using PowerShell script. [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices.AdomdClient”) # Read the target server from .deploymenttargets… Continue reading Deploy a SQL Server Analysis Services Project using PowerShell

SSAS

All You Need To Know To Start Learning SQL Server Analysis Services

I have this rare opportunity to provide basic SSAS training to developers from another team. Being busy with my own projects, my manager and their manager agreed to have the training for only 3 hours. I met the would be trainees and their manager to understand their expectations, the developer profiles and the modeling technique their… Continue reading All You Need To Know To Start Learning SQL Server Analysis Services