how to use the SQL Server CUBE to generate multiple grouping sets.
Shathana. S.R. Answered question May 27, 2023
In Solution Explorer, right-click Cubes, and then click New Cube. On the Select Creation Method page of the Cube Wizard, select Use existing tables, and then click Next. You might occasionally have to create a cube without using existing tables. To create an empty cube, select Create an empty cube.
Shathana. S.R. Answered question May 27, 2023