Follow these steps to create a cube in SQL Server-

  • First Data Source should be created
  • Then create a Data Source View.
  • Specify Dimensions
  • Create a Cube (Cube name, type, and database type should be unique )
  • After deploying, process the cube.
BY Best Interview Question ON 09 Jan 2021