131 questions
0
votes
0
answers
114
views
Apache Superset SQL query filtering
I'm new to Cube / Superset so bear with me. I've the following cube defined in Cube:
cubes:
- name: items
sql: >
SELECT DISTINCT
...
FROM
...
WHERE
lt.package_org_id = '{{ ...
0
votes
0
answers
44
views
How to validate cube.js schema when you have jinja syntax {{ }} in sql of the cubes
what is the go-to way to validate the schema with
npx cubejs-cli validate -p config/schema
when you have a cube like this example from the docs https://cube.dev/docs/reference/data-model/context-...
0
votes
0
answers
53
views
How to configure a separate Database for storing Pre-Aggregations in Cube.js?
I have a PostgreSQL database testdb (hosted on 10.55.55.55) as my data source, where I have read-only access.
I also have another PostgreSQL database cubejs running on the same server where Cube.js is ...
1
vote
1
answer
605
views
How to configure Cube.js pre-aggregations to refresh every 12 hours or at a specific time (e.g., 4:00 AM UTC)?
I’m working on a Cube.js project where I need to configure pre-aggregations to refresh at regular intervals, specifically every 12 hours or at a specific time like 4:00 AM UTC. I’ve set up a cube to ...
1
vote
2
answers
754
views
Docker images unable to talk to each other
I am trying to make two images depend on each other. One acts as the master and the other one is a worker. Here are the two Dockerfiles
FROM cubejs/cubestore:v0.31.58-arm64v8
ENV CUBESTORE_WORKERS=...
1
vote
1
answer
342
views
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 "...
0
votes
0
answers
140
views
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 ...
0
votes
1
answer
677
views
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 ...
0
votes
2
answers
617
views
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 ...
1
vote
1
answer
485
views
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 ...
1
vote
1
answer
1k
views
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
2
answers
2k
views
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 ...
3
votes
1
answer
578
views
cube.js playground not plotting data correctly
I am using cube.js to compare the change in data over the time by plotting it as a line graph .
Step 1 :
After generating cube.js schema successfully , data looks like this:
Step 2 :
Now, while I am ...
1
vote
0
answers
292
views
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 ...
1
vote
1
answer
607
views
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) ?
0
votes
2
answers
1k
views
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
...
4
votes
2
answers
565
views
How to format dates on frontend
I am using the React (recharts) integration of cube and was wondering how to format dates or "weeks" instead of having the full ISOdate.
For example Week 39 instead of 2021-09-27T00:00:00....
2
votes
1
answer
4k
views
getting this error while trying to run cube js
I'm getting this error while trying to run cube js with the default command in the getting started docs. I've started this in a folder and running it in docker.
Warning. There is no cube.js file. ...
1
vote
1
answer
2k
views
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 ...
1
vote
0
answers
321
views
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 ...
1
vote
2
answers
893
views
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. ...
1
vote
1
answer
306
views
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 ...
0
votes
1
answer
801
views
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 ...
1
vote
2
answers
526
views
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 ...
0
votes
0
answers
105
views
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: '...