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

Dynamic table name in cube.js generated sql queries

How can I dynamically change table name in the sql statements generated by cubejs? I query open search via sql interface. Our index name consists of name + date partition, e.g. transactions_2023_01_31. How can I append this date partition to the…
PeterS
  • 181
  • 1
  • 11
0
votes
0 answers

Cube JS dashboard app failing to load dashboard

I'm trying to make a basic dashboard with cube.js (which I am new to). When clicking the "Add to Dashboard" button in the GUI for a chart, it comes up with an error saying that the dashboard app wasn't found in the "dashboard-app" directory.…
Jack Gee
  • 136
  • 6
0
votes
0 answers

How to solve Actuals + Budget requirement

This is for a financial application using cube.js. Actuals and Budget are in separate tables, each with Time and Account as dimensions. Suppose I would create 2 cubes, one for Actuals and one for Budget. It is possible to have Actuals with no Budget…
AllenLu
  • 1
0
votes
0 answers

Can we Connect Cubejs As Analysis service in Excel?

I want to use CubeJS as Analysis service in Excel just like we do with SSAS and Power BI. Is there any possibility for that? I couldn't find anything in documentation regarding that. Thanks in advance. Someone on internet suggested we can connect it…
Hassan Akhlaq
  • 21
  • 1
  • 4
0
votes
0 answers

How to modify Cube.js schema to fix "column must appear in the GROUP BY clause or be used in an aggregate function" error?

I encounter an issue using Cube.js with avg measures. This is an example of two cubes, "Posts" and "Comments", with the following schema: const schemaName = 'my_schema' cube('Posts', { sql: `SELECT * FROM ${schemaName}.posts`, joins: { …
ecavard
  • 151
  • 2
  • 10
0
votes
0 answers

Unable to establish a connection between Apache Superset and cube js using SQL API

We have deployed cube.js using docker in one of the linux machines (Ubuntu). We have deployed Apache Superset in another linux machine (Ubuntu). We are trying to establish a connection between "Apache Superset" and "cube.js" using SQL API, but for…
Thirumalai Muthu Palani
  • 83
  • 3
  • 9
0
votes
1 answer

Cube.dev - how to have the parameter "today date" in rolling window?

I have a PostgreSQL database in which users can order from a start date to an end date. I want to know, for each day, how many users would be able to order. Let's make an example,…
EuberDeveloper
  • 874
  • 1
  • 14
  • 38
0
votes
0 answers

How to use dynamic username for postgresql database connection in power bi based on user

I am using Power BI with cube.js as the data source. The connection to Cube is set up using the PostgreSQL connector in Power BI. I am trying to figure out, how I can change the username, which is being used for the data source connection based on…
Martin Brummerstedt
  • 161
  • 9
0
votes
1 answer

Why am I getting an "Invalid token" when requesting the cube.js API?

I have deployed cube.js via a Helm chart I've created to an AWS EKS cluster. One of the first errors I encountered was that the environment variable CUBEJS_API_SECRET is required. In a docker-compose deployment this secret is automatically…
user4601931
  • 4,982
  • 5
  • 30
  • 42
0
votes
0 answers

cube.js API load endpoint responds with 413

When calling the load endpoint with a query > ~1700 bytes, we are receiving a 413 (request entity too large) error. We have narrowed it down to between 1706 and 1758. Steps to reproduce the behavior: post large query to…
Dan Fitzpatrick
  • 11
  • 3
0
votes
0 answers

Boolean logic operators in filters on Cube.js measure

I know that one can use boolean logic operators in filters on queries, such as the following (taken from the docs): { or: [ { member: 'visitors.source', operator: 'equals', values: ['some'], }, { and: [ …
Atticus
  • 147
  • 1
  • 9
0
votes
1 answer

How to integrate cube.js API in simple javascript code?

How to integrate cube.js API in simple javascript code? I just want to use cube.js API in my simple html and js page. Can anybody help me with that? In cube.js docs, they integrate it with react, vue and angular.
Mukhtar Hussain
  • 1
  • 2
0
votes
0 answers

Cubejs Access Other Cubes By Variable

Given the following Cube, I can use a function to create dynamic measures. cube(`Creatives`, { sql: `SELECT * FROM public.creatives`, joins: { Events: { relationship: `hasMany`, sql: `${Events}.creative_id = ${CUBE}.id`, }, …
Ben Swinburne
  • 25,669
  • 10
  • 69
  • 108
0
votes
1 answer

Cube.js This Week/This Month

Is it possible to calculate some metrics (count, sum) for a specific time period like Today/This Week/This Month/Last Month in Cube.js. Is rollingWindow what I need? I tried it but it doesn't return me right data. Documentation is a bit confusing…
Muhamed Muhamedagić
  • 1
  • 2
0
votes
1 answer

Frontend integration on React 18.1.0

I'm not able to write the code inside the index.js file. I wrote the code as per the code sandbox section of cube docs. It sends a console warning that my app may work as React 17. When I followed 18.1.0 conventions the page was shown loading and…
Dhiman Saha
  • 1
1 2 3
…
8 9