Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Classic Parent-Child hierarchy

Resolved
Vsev asked on April 24, 2017

Hi team.
How can I create a classical hierarchy of Parent-child in flexmonster?
For example:
id   idParent
1     null
2     3
3     1
4     2
…..
N  M
And get the result in dimensions view:
1
   3
       2
           4    
…..
               M
                   N
 

1 answer

Public
Dmytro Zvazhii Flexmonster April 24, 2017

Hello Vsev,
Thank you for your question. We recommend you using the JSON data source for such case. Please have a look at our documentation page http://www.flexmonster.com/doc/data-types-in-json/. The first object of the data array allows setting the necessary configuration. Please have a look at the following sample:
{
     "Color": {type: "string"},
     "Country":{type: "level", hierarchy: "Geography", level: "Country"},
     "State": {type: "level", hierarchy: "Geography", level: "State", parent: "Country"},
     "City": {type: "level", hierarchy: "Geography", parent: "State"},
     "Price": {type: "number"},
     "Quantity": {type: "number"}
}

Let us know if you have additional questions here.
Best regards,
Dmytro.

Please login or Register to Submit Answer