Stack Overflow
Stack Overflow

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
0 answers

Cube.js schema for Nested Field in Elasticsearch index

Consider I have the following data in my Elastic index. "hits" : [ { "_index" : "cubepoc", "_type" : "_doc", "_id" : "i1", "_score" : 1.0, "_source" : { "pname" : "john doe", "pconcern" : "cough and fever", "product" : [ { "medicine1" : "medomol",…
Vignesh G
  • 151
  • 6
1
vote
1 answer

how to address error cubejs 'From members are not found ... Please make sure join fields are referencing dimensions instead of columns.'

I have the Error: From members are not found in [] for join {"join":{"relationship":"belongsTo"},"from":"Conversations","to":"Advisers","originalFrom":"Conversations","originalTo":"Advisers"}. Please make sure join fields are referencing dimensions…
ManSB
  • 11
  • 2
1
vote
1 answer

How to format time-type data with mongodb and cubejs?

I found this url about this topic: https://cube.dev/docs/types-and-formats#dimensions-formats https://cube.dev/docs/working-with-string-time-dimensions I didnt found the format for time-type. So I try to use sql: PARSE_TIMESTAMP('%Y-%m-%d', date) …
radiorz
  • 1,459
  • 4
  • 18
  • 36
1
vote
0 answers

Build correct schema sql in cubejs

I have a Postgres table like this https://dbfiddle.uk/?rdbms=postgres_11&fiddle=b39a248ac9dde6400795e8a236e58d02 and it works as expected. but when i use that sql query into cubejs seem it work to slow or some time can not load . cube(`State`, { …
DavidKia
  • 11
  • 1
  • 1
1
vote
1 answer

Cube.js issue Error: npm install --save-dev @cubejs-backend/cubestore-driver failed with exit code 1

I have a problem with my first Cube.js project. After the creation with the classic cmd cubejs create hello-world -d postgres I hav this error message: @cubejs-backend/cubestore@0.26.43…
AleSam
  • 11
  • 2
1
vote
1 answer

How to set token after user is logged into the app?

I have a problem with Cube.JS: A very common use case is to only request the CubeJS token once the user is authenticated to my app. Then I can provide a token initialize CubeJS. The way it is on the docs…
HobojoeBr
  • 599
  • 9
  • 23
1
vote
1 answer

How can I handle error `unknown column` from cube.js?

I'm following the tutorial from https://real-time-dashboard.cube.dev/cube-js-api-with-mongo-db, and get dataset from there which look like this below. And my schema set like this below. cube(`Events`, { sql: `SELECT * FROM stats.events`, …
MM YFI
  • 57
  • 2
  • 9
1
vote
1 answer

How to deal with nested hash with dynamic keys(PorstgreSQL JSONB) with the help of Cube.js?

I am quite a newbie to Cube.js. I have been trying to integrate Cube.js analytics functionality with my Ruby on Rails app. The database is PostgreSQL. In a database, there is a certain column called answers_json with jsonb data type which contains a…
riddhi thummar
  • 21
  • 2
1
vote
1 answer

Weighted Average Calculations across various combinations using Cube.js

We have a question on designing schema and handling analytics requirement for our product and would appreciate your advise on this. We are just getting started with Cube.js. Here is our req: We have data (for simplicity...i will use an example)…
bazooka720
  • 21
  • 4
1
vote
1 answer

Vue.js QueryBuilder by Cube.js anonymise columns by local value

I have the following scenario: A user has multiple clients. Those clients generate different reports based on their client id (easy with the filter option). Some columns need to be anonymised based on a flag which is not stored in the database and a…
Daniel
  • 13
  • 3
1
vote
1 answer

cube.js - mongodb DBref field inside schema dimension section

I am trying to create a filter on DBref id field (mongodb). The SQL query generated is given below SELECT `part_r_f_q_dpa`.`partRFQId` `part_r_f_q_dpa__partrfqid`, `part_r_f_q_dpa`.`noOfApproval` `part_r_f_q_dpa__noofapproval`, …
mohan p
  • 41
  • 4
1
vote
1 answer

GCP CLOUD SQL denies permission for pre aggregation

I am trying to use pre aggregations over CLOUD SQL on Google Cloud Platform but the database is denying access and giving error Statement violates GTID consistency. Any help is appreciated.
Prateek Banga
  • 57
  • 6
1
vote
2 answers

Cube.js timing out in serverless environment

I've been following the guide on https://cube.dev/docs/deployment#express-with-basic-passport-authentication to deploy Cube.js to Lambda. I got it working against an Athena db such that the /meta endpoint works successfully and returns schemas. When…
stakolee
  • 893
  • 1
  • 7
  • 20
1
vote
1 answer

Implementing DISTINCT ON in CubeJS

I have a Postgres table like this, with device ID, timestamp, and the status of the device at that time: dev_id | timestamp | status ---------------------------------------- 1 | 2020-08-06 23:00:00 | 1 2 | 2020-08-06…
svakili
  • 1,909
  • 4
  • 19
  • 24
1
vote
1 answer

CubeJS pre aggregation tables being duplicated upon refresh

I'm trying to use CubeJS to speed up queries using the pre aggregation caching. I have defined the following cube: cube({ // assume all measures and dimensions are defined as necessary ... preAggregations: { report: { type:…
D P
  • 125
  • 1
  • 10
1 2 3
…
8 9