Menu
Download Free Trial

Hierarchies in OCSV

Answered

We are using Flexmonster Pivot Table HTML5 v2.221
My question is, reading through the documentation I see how you can set hierarchies and levels using a JSON data source with options such as caption, hierarchy, level, parent, dimensionUniqueName, dimensionCaption. 
However, I do not see a way to implement similar options using an ocsv file source. I was wondering if it was possible. Thanks!

8 answers

Public
Dmytro Zvazhii Flexmonster October 3, 2017

Hello Brody,
Thank you for your question. Please have a look at the attached .CSV file. The first row of the file includes the following fields:
Category
Category:Subcategory
Category:Subcategory:Model
Those fields are the levels of one hierarchy. Such approach is also compatible with the .OCSV data source. You can use our Flexmonster Compressor tool to convert such .CSV file into the .OCSV format. Also, you can try loading the .CSV data file with our component using Connect -> To local CSV after that press Save and you will download the report file with the .OCSV embedded data in it.
Please let us know if it works for you.
Best regards,
Dmytro.

Public
Dmytro Zvazhii Flexmonster October 3, 2017

Please find the attached .CSV file here.

Attachments:
product-data.csv

Public
brodybinks October 6, 2017

Dmytro,
 
Thanks for the response!

from what I’m seeing we have it broken down into category, subcategory, model. and theirs only one column as a subcatergory of column
 
What if instead of this format I wanted to break it down as Bikes(replacing category) and then have bikes:mountain bikes bikes:road bikes and bikes:touring bikes as seperate columns. This way when you expanded the fields list instead of seeing “Category, subcategory, model” you would see the bike types instead, and bypass having to filter after selecting the field. Is this something we could do with flexmonster, or is it not designed to work this way. I hope that question makes sense, let me know if there is anything else you need from me!

Public
brodybinks October 6, 2017

Dmytro,
 
Thanks for the response!

from what I’m seeing we have it broken down into category, subcategory, model. and theirs only one column as a subcatergory of column
 
What if instead of this format I wanted to break it down as Bikes(replacing category) and then have bikes:mountain bikes bikes:road bikes and bikes:touring bikes as seperate columns. This way when you expanded the fields list instead of seeing “Category, subcategory, model” you would see the bike types instead, and bypass having to filter after selecting the field. Is this something we could do with flexmonster, or is it not designed to work this way. I hope that question makes sense, let me know if there is anything else you need from me!

Public
Tanya Gryshko Flexmonster October 6, 2017

Hello, Brody,
Thank you for your specifying your request. Our component is designed to support hierarchies with multiple levels. However, each parent in the hierarchy can have only one child hierarchy. There can be a lot of children but they need to have similar hierarchy name. Please have a look at this sample: http://jsfiddle.net/flexmonster/mr0Lwkab/54/. Here Bikes is the hierarchy parent, Mountain bikes and Touring bikes are children. Both Mountain bikes and Touring bikes have hierarchy name Type .
Please let me know if you have questions.
Regards,
Tanya

Public
brodybinks October 6, 2017

We have an OLAP datasource setup, and in that we are able to display information about Client under client, however when we try to do this in CSV we are not able to get the same result.

  1. In CSV the column head shows as “Client” instead of gender.
  2. Having multiple categories under Client isn’t possible in CSV

Is it possible to recreate what we had in OLAP using CSV?

Attachments:
flexmonsterOLAP.jpg

Public
brodybinks October 6, 2017

Here is a screenshot of the CSV result

Attachments:
flexmonsterCSV.jpg

Public
Dmytro Zvazhii Flexmonster 7 days ago

Hello Brody,
Thank you for writing. This feature is not available for the CSV data source. Please consider the idea of using JSON data source for this case.
Regards,
Dmytro. 

Please login or Register to Submit Answer