☝️Small business or a startup? See if you qualify for our special offer.
+

Multiple dimensions and it's data in flat strcture

Answered
Hari asked on February 28, 2025

Hi, I'm new to Flexmonster Pivot Table. My use case is somewhat similar to a pivot table, but my data is slightly different. I just want to check if Flexmonster will support my specific requirements with minimal changes to my database design or with no changes at all

Region Dimension taxo table
id    name                   parentid
1     Global                 null
2   America                1
3   NorthAmerica        2
Product Dimension taxo table
id    name                   parentid
1     Equaties               null
2   cashEquaties    1
3   FX                   2
4   derivatives       2

like i have multiple dimension 

my data for able dimension in different table something like below 

Region   Product  value
2           3          10
2           4          20

if i want to use pivot table how can prepare my data 

 

2 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster March 3, 2025

Hello, Hari!

Thank you for writing to us.

Here is how you can prepare your data for Flexmonster without database design changes:

  1. Flexmonster supports working with a single-table dataset. To show data from multiple tables, you should write a query with JOIN clauses based on ID columns and include the readable names from different tables based on IDs.
  2. Once your data is joined, you can serve it in a JSON or CSV format supported by Flexmonster. For this, you should set up an API endpoint that queries the data from your database and sends it to the Flexmonster component.

Please let us know if you need any further assistance.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster March 11, 2025

Hello, Hari!

Hope you are doing well.
We are wondering if you could connect your data to Flexmonster.
Please let us know if you need any further assistance.

Best Regards,
Maksym

Please login or Register to Submit Answer