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
0
votes
1 answer

On The Fly Dynamic Schemas

I am looking through Dynamic Cube Creation and was wondering - is there a way to get a cube created post Cube process startup? In this use case, we have multiple schemas being created on the fly as users navigate through a front end app, and, will…
steamrolla
  • 2,373
  • 1
  • 29
  • 39
0
votes
2 answers

Filter data dynamically based on a hierarchical user id in cube.js

I have two tables called Writers and Publications where there is a foreign key publications.writer_id = writers.id Writers id (int) parent_id (int) role (varchar) name (varchar) path (ltree) 1 ADMIN Firstname Lastname 2 1 EDITOR Anon…
0
votes
1 answer

How to run cubeJS-Backend application using express

I am trying to run cubeJs-backend application using express. I have added code changes like below. I have created cube.js file with the below code const express = require('express'); const path = require('path'); const expressApp =…
Rewa
  • 1
  • 2
0
votes
1 answer

Error: Unable to detect column types for pre-aggregation on empty values in readOnly mode [CubeJs]

Using mongo Bi connector via Atlas as source database Using mysql for pre-aggregation
Atishay
  • 175
  • 7
0
votes
1 answer

Security Context with several elements on CubeJS

Currently working on Cube.JS and I'm building a cube within I want to restrict the data to an user based on his gender. So I end up with : cube(`Data`, { sql: `select * from my_table where ${SECURITY_CONTEXT.user_gender.filter(user_gender)}`, …
Bilel
  • 3
  • 1
0
votes
1 answer

Filter/update already rendered chart.js in react.js

I'm new here, because I have decided to dive into programming, so I can fill free time between treatments in the hospital. I'm absolutely new in the programming field with no previous coding background. The summary: I am working on a simple page,…
0
votes
1 answer

CubeJS Multitenant: How to use COMPILE_CONTEXT as users access the server with different Tokens?

We've been getting started with CubeJS. We are using BiqQuery, with the following heirarchy: Project (All client) Dataset (Corresponding to a single client) Tables (Different data-types for a single client) We'd like to use COMPILE_CONTEXT…
0
votes
0 answers

Is `<` an unsupported expression in rollupJoin's?

I am trying to use a rollupJoin pre-aggregation as per this example but instead of joining on an ID I am attempting to join using dates, i.e. something like: joins: { Weeks: { relationship: 'belongsTo', sql: `${Weeks.startAt} <…
Atticus
  • 147
  • 1
  • 9
0
votes
1 answer

Serverless Cube.js - No messages published to SNS

Trying to turn a containerized Cube.js deployment into a serverless one. I’m getting Continue wait on every API call, and I notice the cubejsProcess lambda is never invoked. I checked SNS reachability by (successfully) publishing a message to it…
Bananin
  • 69
  • 8
0
votes
1 answer

Error when creating Cube.js API - Failure at cubestore

I'm working with Cube.js as part of an effort to create a database with front-end visualization. I'm new to the whole system, and am attempting to follow a tutorial posted here: https://d3-dashboard.cube.dev/setting-up-a-database-and-cube-js I have…
casemax
  • 1
  • 1
  • 2
0
votes
1 answer

Why do I get syntax error from VueSourceSnippet.js when creating a Cube.js Dashboard App?

I have followed the steps here https://cube.dev/docs/getting-started to create the project scaffolding and then have started the dev server from the project directory with $npm run dev Now, within the developer application being served at…
0
votes
1 answer

Is it possible to add a callback method in the backend to perform once a query finishes?

I'm setting up a service that will email a user the data generated by a Cubejs query. I'd like to have Cubejs notify the email-sending service (perhaps through SNS) that new data is available for sending: Is this possible? Are there better options…
Bananin
  • 69
  • 8
0
votes
1 answer

Getting Configuration file config.hocon does not exist when running Docker image (Snowplow, Scala)

Using an AWS EC2 with Docker installed, I am trying to run a docker image using the following code: docker run \ -v $PWD/scala-stream-collector-config:/snowplow/config \ -p 8080:8080 \ snowplow/scala-stream-collector-kinesis:1.0.1 \ --config…
0
votes
0 answers

How to put meta into cube's schema when i use playground/generate-schema to generate schema automatically?

The cubejs is great. I can use api which is '/playground/generate-schema' to generate schema automatically.It works great. But now I want to add meta to dimensions like this: --- before --- dimensions:{ ... level: { sql: `level`, …
radiorz
  • 1,459
  • 4
  • 18
  • 36
0
votes
1 answer

How to implement subqueries in cube.js

I'm struggling to see how I would represent the following type of postgres SQL query in a cube.js schema: SELECT CASE WHEN COUNT(tpp.net_total_amount) > 0 THEN SUM(tpp.net_total_amount) / COUNT(tpp.net_total_amount) ELSE …
Euge
  • 1
  • 3
1 2 3
8
9