Tuesday, May 26, 2026

SQL 2025 master class LAB 04 Simple MDX check

SMSS 

connect analysis services

windows/Multi

delete database

load down AdventureWorksDW2019

 https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2019.bak

Download and unzip "adventure-works-multidimensional-model-project" from https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services.

Double click Enterprrise \ AWDW2019Multidimensional-EE.sln

open AdventureWorksDW21019 under Data Sources

Change provider to  Net Providers SQLClient Data Provider

Test Connection