Questions tagged [cube]
Cube or OLAP cube, is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases. Used on the SQL server family of products.
cube
1,336
questions
0
votes
0
answers
13
views
Content Download speed is too slow on Digital Ocean Droplet using Nginx for reverse proxy
I have a node server (Cube JS: https://github.com/cube-js/cube) deployed on Digital Ocean Droplet served through PM2,Using Nginx for reverse proxy.
Tested on 15mb network
Content download speed goes ...
0
votes
0
answers
17
views
Derived column from 2 dimensions in SSAS Cube
I have two dimension, say "Dimension1" and "Dimension2" in the SSAS cube. I would like to add a derived column in Dimension1 lets say col3 with the logic coalesce (Dimension1.col1, ...
0
votes
0
answers
33
views
I can't remove the gaps between the edges of the cube in a sprite made from an SVG image
Most learned friends
I have an SVG cube icon. I made a sprite out of it, but there are gaps between the edges of the cube that take on the background color of the div in which the cube is located. How ...
-2
votes
0
answers
42
views
How to trace the SSAS cube refresh failure details if we are refreshing the cube from a SQL Server Agent jobs
We have a tabular model cube that is refreshed each day via an SQL Agent job calling an SSAS Command. The command is simply:
{ "refresh": { "type": "full", "objects&...
0
votes
0
answers
15
views
Regarding SSAS data cube
if we have db view used in dsv , that uses some function to calculate the columns.
And there is any requirements to change the column (no column name and type chaged ) then I need to re deploy the ...
0
votes
0
answers
84
views
cube js : Error while creating connection, Model files not found
I am getting error while creating the connection to Postgres using cube playground. I am running cube locally and postgres is running in docker. In the docker log I can see errr as
Error: Model files ...
0
votes
0
answers
19
views
MDX query for a set with nested conditions depending on parameters
I want to define a MDX-Set with nested conditions. I have two parameters: @parYearMonthBusinessMonth_From and @parYearMonthBusinessMonth_To.
My script for the set:
SET [OrdersLocal] AS
Filter(
[Orders]...
0
votes
0
answers
13
views
How do i count the number of order that each customer have?
Here i what i get so far
So i want to do a MDX query that can group and count the number of Order of each customer name? How can i do that ?
I want something like this
Customer name
Number of order
...
0
votes
0
answers
31
views
Analysis Services and Power BI refreshes after publishing
We had three reports connected to Tyler Munis that were hosted locally. The cubes connected and refreshed fine when it was set up this way. Now that we have moved to the cloud, the desktop Power BI ...
0
votes
0
answers
28
views
Calculated table summarizecolumns
I created a table using SUMMARIZECOLUMNS in dax studio.It works.
But when I added the table in my SSAS tabular cube using tabular editor by right click add a calculated table.
When I copy the code in ...
0
votes
0
answers
9
views
Always Rotate Cube Forward Relative to Observer
I want to rotate a cube forward relative to the camera (observer);
In psuedo-code:
rotateCubeForward(backward){
rotation.x += 90degress * backward;
}
rotateCubeForward(1)
rotateCubeForward(-1)
And ...
0
votes
0
answers
10
views
Poor Performance when display a degenerate dimension next to other dimension
I have a table with "Open Order" records which stores the orders still under delivery and also containing customer IDs and Product IDs for that Order. for Customer and product IDs I already ...
-1
votes
1
answer
28
views
Extending Docker image not running on AWS Fargate
I'm trying to run CubeJS on AWS Fargate, if I use the image cubejs/cube:v0.33.33 directly on in a JSON file on Fargate it runs fine, but I need to extend that image so I can include configuration ...
0
votes
1
answer
49
views
BigQuery Returns Different Results On every execution for Exactly same query when using LIMIT
On running the exactly same query I get different results.
Details:
Total results are 64155
since I am using Cube.js as my backend with big Query which has retrieval limit of 50k rows per query , I ...
0
votes
0
answers
30
views
OLAP Cube process error (A connection could not be made to the data source with the DataSourceID of 'Example_SQL', Name of 'ExampleSQL'.)
I have an Analysis Services Multidimensional Project, I added a data source, data source view, and cube, from dimensions > properties > explore data > I got all data from DB.
From cube ...