Aug 13, 2014 · Firstly, for those who haven't already read up on the subject: Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS That being said, don't think about these grouping options …

Dec 1, 2014 · It said that the ROLLUP clause was similar to the CUBE clause but that it was distinguished from the CUBE clause in the following way: CUBE generates a result set that shows …

Sep 27, 2022 · 63 I can't find any detailed documentation regarding the differences. I do notice a difference, because when interchanging cube and groupBy function calls, I get different results. I …

I often hear comments like: "we need to get the data from the cube". A quick Google search shows way to create a cube, but no definition of what a cube is. What my coworkers means with "extract the …

May 18, 2018 · SQL Server Profiler works on SSAS servers. Select Analysis Services for the Server type in the Connection dialog when initiating a Profiler connection. Select your Analysis Services …

Sep 24, 2013 · 1 I've been provided access to a cube and need to know if I can set up a stored procedure that can connect to a Cube and retrieve the contents (via an MDX Query). I need this to …

I need to make an OLAP cube using a remote database. After I set up the dimensions and measures and create the cube, I can not get the cube to launch to the local server. I keep getting the error, …

Jul 23, 2019 · I am building a multidimensional cube using SSAS, I created the partitions based on a date column, and defined a partition for each day. Source data size is bigger than 2 TB. While …

Oct 24, 2014 · Making an analysis services connection to the cube in SQL Server Management Studio (SSMS), I can right click on the cube and see the property of the last cube processing time exists.

I have used pyodbc+pandas to connect to SQL Server databases and extract data with SQL queries, and the goal now is to do something similar on an SSAS cube, using an MDX query to extract data, …