FAQ Database Discussion Community


Get the amount of days in a month - mdx

sql-server,tsql,mdx,cube
In TSQL I can do this to get the amount of days in some month: declare @date as datetime set @date = '2015-02-06' select datediff(day, dateadd(day, 1-day(@date), @date), dateadd(month, 1, dateadd(day, 1-day(@date), @date))) How can I get the same functionality in MDX? P.S. I need the result to be an...

3D Cube Drawing, Only One Side Is Always On Top

c++,opengl,3d,cube
I was working with OpenGL C++ drawing shapes, specifically cubes. In my current project, I managed to draw a cube correctly, but only the side of the cube that gets drawn last doesn't go transparent when the camera is directly on it. The first two sides of the cube go...

SQL SSAS Cube Deploy Error:

sql-server-2012,ssas,cube,bids,sql-server-2012-datatools
I am trying to deploy a cube I created in SQL Server Data Tool using AdventureWorksDW2008R2, I used windows authentication login the database engine with all permissions granted to it. and yet I still get these arrors in the picture below when deploying the cube. Anyone Can point out which...

Set 0 for specific value MDX query

sql,sql-server-2008,ssas,mdx,cube
I've been looking around for the answer but I didn't find anything. Sorry if the answer has been given elsewhere. Here is my problem : I have a calculated member which is the number of items (of the current member) divided by the total number of items (sumitem). with member...

Missing tag in xmla to deploy assembly

dll,ssas,clr,.net-assembly,cube
I am trying to deploy a custom .NET assembly to my SSAS database. While doing so, I am facing Clr Assembly must have main file specified error and changing the target framework as given in the marked answer didn't solve it. I also checked whether the dll was blocked as...

Qt, C++, 3D Matrix Cube

c++,qt,matrix,3d,cube
I am not a very experienced Qt C++ Programmer, but unfortunately I have to create a 3D Cube containing 8x8x8 points. I already found the Qt tutorial to create a simple cube, but I am completely lost on how to make it hollow and draw the 512point matrix within the...

[SSAS CUBE Partition Strategy for large historical data]

process,ssas,cube,partition
I have a big cube with 2.5 million new data per day. 19 million a week. Those data are historical data, no update , no remove and no change.So what's best partition strategy for this kind of data ? You can see only one week there are a lot of...

tabular in-memory vs multidimensional and molap-mode

ssas,cube,tabular,in-memory,rolap
I have a question regarding the ssas-models tabular and multidimensional cube. I've read that both models can work in a real-time-mode (direct query mode & rolap). My questions concerns the tabular model in in-memory-cache-mode and the multidimensional model in molap-mode. How recent is the data there? Can I define myself...

What cube deployment changes will force a reprocess?

ssas,cube,ssas-2008
Sometimes when I deploy a cube that has been changed (from BIDS), I can continue to browse the existing cube data. Other times, the engine insists I reprocess the data before I can browse the cube. I can't find a definitive resource showing which changes require a data reprocess and...

Cube in OpenGL ES 2.0 does not draw the given textures

java,android,textures,opengl-es-2.0,cube
Normally I would not bother you with my questions, but this time I'm rather desperate. First of all, I'm fairly new to OpenGL so please don't shoot me if I've made some rookie mistakes. I've seen some examples already, but some of the example code is not understandable for me....

Creating A Cube Using Only CSS Gradients

html,css,graphics,3d,cube
I've tried numerous ways using linear-gradients to create several stripes layered on top of each other and have gotten very close but seem to be stuck on the top face. I'm trying to accomplish this using gradients be it linear or radial so that I can eventually upgrade them to...

What does the SSAS setting None in AggregateFunction do?

excel,ssas,pivot-table,cube
As I understand Microsoft's explanation setting the AggregateFunction of a measure to "None" should null out the value unless you are viewing the data at the lowest possible level. (i.e. the data element is a copy of the value in one exact cell in the cube). I've created a fact...

How to calculate a random point inside a cube

math,vector,3d,cube
I'm trying to figure out the math to find a random point inside a cube. I have something small but it can't take into account the rotation of the cube. Here are some images of my results. Here you can see the cube is rotated to some degree but when...

Sharepoint RDL report referring a new cube in the SSAS DB fails to execute the query to a shared data source

sharepoint,reporting-services,datasource,cube,rdl
A shared data source, already present in our SharePoint server, - works fine for other old reports, which refer old Cube in the same Analysis Services DB. I don't get, why this new SSRS report using new Cube in the same initial catalog on the same server does not work...

Row and column total in dynamic pivot

sql-server-2008,pivot,cube,dynamic-pivot
In SQL Server 2008, I have a table (tblStock) with 3 columns: PartCode (NVARCHAR (50)) StockQty (INT) Location (NVARCHAR(50)) some example data below: PartCode StockQty Location ......... ......... ......... A 10 WHs-A B 22 WHs-A A 1 WHs-B C 20 WHs-A D 39 WHs-F E 3 WHs-D F 7 WHs-A...

Checking if the a number is a whole cube [duplicate]

python,math,cube
This question already has an answer here: Python rounding error with float numbers [duplicate] 2 answers I'm a beginner in python and have written a code to check if a number is a cube of a whole number. The code seems to be working fine for some values, however...

Change the database in Microstrategy Intelligent Cube

report,cube,microstrategy
How to change the database of an already created Intelligent Cube in Microstrategy? I have a cube which is getting data from Tables in production. We have same tables in other database as well. Is there any way i can modify the cube to use the new database?...