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

How to use pivotConfig in Cube.js?

My resultSet looks like this: 0: Object { "Error.type": "A", "Error.criticity": "ORANGE", "Error.count": 10 } ​​ 1: Object { "Error.type": "B", "Error.criticity": "ORANGE", "Error.count": 8 } ​​ 2: Object { "Error.type": "B", "Error.criticity":…
Étienne
  • 73
  • 1
  • 8
0
votes
0 answers

CubeJS PostgresDriver fails authentication but it works in terminal

I can connect to my database just fine by entering psql -U -W -h localhost -p -d . However, when I set up that same connection in a Cubejs backend, queries like http://localhost:4000/cubejs-api/v1/load?query=... return…
Bananin
  • 69
  • 8
0
votes
1 answer

Error wil generating the schema fils for a mongodb data base with cubejs and mongobi

I am beginner into mongodb and big data systems. I try to develop a dashboard for an application that I develop locally. Using cubejs and mongodb for BI, by following the following blog : I install the cubejs by : npm install -g cubejs-cli After…
0
votes
1 answer

Cube.js Playground: Error while loading DB schema

I am currently learning Javascript/HTML/CSS in order to build some data dashboard. I have found this tutorial https://d3-dashboard.cube.dev/setting-up-a-database-and-cube-js Currently I am getting stuck at this part: The next step is to create a…
Thibaut
  • 11
  • 3
0
votes
0 answers

CubeJS how to pass dynamic column name in join?

I have Calendar table and I want to join this table with multiple time dimensions present in parent cube(Employee). For example. cube(`Employee`, { sql: `SELECT * FROM \`DEMO\`.\`Employee\``, joins: { Calender: { relationship:…
Harshal Nathe
  • 95
  • 1
  • 8
0
votes
1 answer

LEFT OUTER JOIN with CubeJs

I'm trying to achieve this query in CubeJS which does a LEFT OUTER JOIN with itself. SELECT COUNT(DISTINCT EC."accId") FROM public."orders" EC LEFT OUTER JOIN public."orders" NC ON NC."accId" = EC."accId" AND…
ryanleong
  • 1
  • 2
0
votes
1 answer

Cubejs Type declaration in measures for round up decimal values

is there any method to roundup the decimal values for example in measures i am defining BaseAmount:{ sql:'BaseAmount', type:sum }, I am getting sum of all baseAmount value like this 693.3399999999993 because here I mentioned…
0
votes
1 answer

Outer join using Cube.js

I am using Cube.js for fetching the data from Postgres. By default, cube.js does a left join on 2 selected tables. Is there any way to get the result by Full Outer Join? User Register Table ID TIME 1 10.00 3 9.00 Last Active Table ID TIME 1 …
hiren shah
  • 33
  • 6
0
votes
2 answers

Error in render: "TypeError: Cannot read property 'seriesNames' of undefined"

Received a data from api, while trying to render in charts.(I am using highcharts). Its' showing some error in console. Data is rendered perfectly in chart. But i don't know why error is showing in console. Need to clear this. Please help…
0
votes
1 answer

How to fix 'Invalid query format' offset is not allowed in Cube.js

I'm getting below error when I added 'offset' property in JSON query of CubeJS. It gives me a proper response when I added only 'limit' property in JSON query. but gives an error when I added 'limit' with 'offset'…
Harshal Nathe
  • 95
  • 1
  • 8
-1
votes
1 answer

Fetch realtime data from database using CubeJs

I'm using cubejs with React. I want to display real time data. I tried using React lifecycle methods & state , where the component is triggered every 2 seconds. But it does not work.
-2
votes
1 answer

Cube JS doesn't fetch new records when cubeJs backend API is called

I have connected my local Database wrote schemas to fetch data and generate visualizations. But I observed that the data is not being fetched every time I hit cube.js backend. It is not being updated. I have to restart the server every time to get…
sandeep addala
  • 117
  • 1
  • 9
1 2 3
8
9