Northwind Customer OLAP Cube Build Notes

Synopsis: We create a table in Northwind that data analysts can use for business intelligence.

Advantages: Move analysis out of the production database; Fix a data picture at a point in time; Relieve analysts of complex query development; Hide production DB details & data from analysts

Mechanics of build

Connecting in, e.g., Excel: Server is vm-1

To test analyst access:

Open a command window

runas /user:danalyst cmd
rem danalyst password is AIST6410

"C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

"C:\Program Files\Microsoft Office\Office16\EXCEL.EXE"

rem this exits the danalyst command window
exit

rem this exits your user command window
exit