asked on September 29, 2017
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!
⋅ 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.
⋅ October 3, 2017
Please find the attached .CSV file here.
⋅ 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 Field 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!
⋅ 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 Field 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!
⋅ 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
⋅ 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.
Is it possible to recreate what we had in OLAP using CSV?
⋅ October 6, 2017
Here is a screenshot of the CSV result
⋅ October 10, 2017
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.
⋅ June 29, 2018
I have similar question. How do I add multilevel hierarchy to data already converted into OCSV format
⋅ July 2, 2018
Hello Tunde,
Please note, that we have already answered the similar question here: https://www.flexmonster.com/question/how-do-i-define-hierarchy-on-ocsv-data-generated-from-sql-server-database/.
Regards,
Dmytro
