sql - What is the difference between cube, rollup and groupBy …
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 noticed …
sql - OLAP Cube deployment issues - Stack Overflow
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 …
Raising numbers to fractional powers in SQL - Stack Overflow
4 I'm trying to raise a series of numbers to a fractional (1/5) power in MS SQL, yet I'm getting a 'domain error' when applying to a negative base. This shouldn't be a problem since I'm raising …
sql - Understanding the differences between CUBE and ROLLUP
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 …
sql - When to use GROUPING SETS, CUBE and ROLLUP - Stack …
Aug 13, 2014 · I have recently learned about GROUPING SETS, CUBE and ROLLUP for defining multiple grouping sets in sql server. What I am asking is under what circumstances do we use …
Connect to SQL Server Analysis Cube with Python (Anaconda)
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 …
sql - View MDX query generated while browsing a cube in SSMS
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 server …
sql - Rollup function - Replace NULL - Stack Overflow
I seem to be having trouble with the final pieces of my SQL. When implementing the group by with roll up function within my SQL NULL appears. How can one modify NULL so that it is replaced …
How to refresh ssas cube database/table for report
1 The problem: My SSRS report based on my Cube is not getting the latest data from the table associated with the Cube. How do I either a) tell the report to use the latest table data, or b) …
Why do i get the error message 'cube either does not exist or has …
Found what the problem was,the cube i was pointing/rather selecting the Measures from in SQL has a different name other than the name of the cube itself,which is model.