Questions tagged [cube.js]

For questions specific to the open source modular framework for building analytical web applications called "Cube.js". Where possible also include a tag for the framework specific "Cube.js" wrapper that you may be utilizing. E.g. [reactjs], [vue.js], etc.

Links:

132 questions
1
vote
1 answer

How to access current security context within a driver in cube.js

I'm working on a custom cube.js database driver that uses a private http service which accepts arbitrary, raw sql and returns the result as json. The http service uses Authorization header to identify the user (so that it can enforce appropriate…
riyaz-ali
  • 8,677
  • 2
  • 22
  • 35
1
vote
1 answer

How do I use cube.js to define my own schemas

I want to build schema file from my frontend app just like what happens in cube.js playground in dev mode. Is there any possibility to do so?
1
vote
1 answer

Cube.js React Hook React.useCallback has a missing dependency: 'pivotConfig'. +

I've been trying to create a simple dashboard with Cube.js using windows 10 and Mysql version 8. I originally tried a Js backend, fought with the install for a few days, then tried a docker install but quit after a few hours of error messages, and…
T2029
  • 65
  • 2
  • 9
1
vote
2 answers

cube.js join compile "error does not match any of the allowed types"

I have 2 tables, one contains daily data and the other contains attributes that I would like to use for segmenting data. I got the following Error when I try to compile my cube.js schema. cube.js error Error: Error: Compile errors: DailyVolumes…
bfmcneill
  • 125
  • 13
1
vote
0 answers

Cube.js default value of timeDimensions

I am using the Cube.js react client to change the default timeDimension, dateRange, and granularity of my Query. import { QueryBuilder } from '@cubejs-client/react' here is what timeDimension property on the JSON Query should look…
Ezra Tsai
  • 43
  • 2
1
vote
0 answers

Login failed while connecting to SQL Server database from Cube js

This is the issue I see in the terminal while i run npm run dev I am trying to connect to a SQL Server database. I have changed some settings for my user 'sjeswara' using SSMS which might facilitates connection: Under securities -> Login I have…
Suraj Jeswara
  • 446
  • 2
  • 10
  • 23
1
vote
1 answer

Can cube.js be used to access raw data as well as aggregated data?

For example, if I have a Postgres table with columns for sensor_id, temperature and time_recorded , would I still be able to generate a chart that shows temperature (y) over time (x) ?
1
vote
1 answer

cube.js docker image for aarch64/arm64

I am new to cube.js and trying to see if I can use it for a small personal project (mostly for learning). I'm looking for a docker image that runs on Rasberrypi 64 bit - can anyone point me in the right direction please - or maybe it doesn't exist.…
user12891
  • 23
  • 2
1
vote
2 answers

Error: unexpected response Forbidden Issue with cubejs

I am running the below command to create the service in cubejs but facing forbidden error. Command : cubejs create d3-dashboard -d postgres npm WARN deprecated @hapi/joi@17.1.1: Switch to 'npm install joi' npm ERR! code 1 npm ERR!…
1
vote
1 answer

cube.js: send raw sql query to cube server

Is it possible to send a raw sql request to a cubejs server? The cubejs server would send it as is to the db it is connected to? I have some edge cases where I would like to let the client send raw sql requests instead of using the cube query…
discuss_e
  • 21
  • 1
1
vote
1 answer

cube.js: subquery in FROM clause

How to do a subquery in the FROM clause in cube.js. There is only one table. SELECT col_a FROM (SELECT col_a, col_b FROM table_name WHERE col_c=some_val ORDER BY time DESC) WHERE col_b=some_other_value
discuss_e
  • 21
  • 1
1
vote
0 answers

CubeJS inflated count values due to LEFT JOINs on related cubes

Consider a database schema of the following: An Entity table. A SpecializedEntity table, which has exactly 0 or 1 record for each record in Entity, and a nullable LookupValueId column. A LookupValue table, which has a record for each possible…
Andrew Keller
  • 3,198
  • 5
  • 36
  • 51
1
vote
2 answers

How do I create measures that are not aggregated data?

I have a simple table which has a number(say sales) as one column which describes the sales done for a product. I also have ~25 products. Now, I want to import this sales as a measure into cube. However, i am not sure what it's type and sql…
rspenpal
  • 45
  • 5
1
vote
1 answer

Left outer Join in Cube JS

I have a requirement to join two tables in cube js. First table has list of customers. Second table has list orders with customer ids with purchase date. I have to display the total orders placed by the customer with date filter. If the there is an…
1
vote
2 answers

Plotting multiple lines on a Cube.js line graph

Imagine a simple line graph plotting a person count (y-axis) against a custom time value (x-axis), as such: Suppose you have another dimension, say specific groupings of people, how do you draw a separate line on this graph for each group?
Atticus
  • 147
  • 1
  • 9
1 2
3
8 9