asked on June 10, 2019
Hi,
We are using csv connection for pivot table. I have State and County presents in the data.
For Example My data looks like below:
State
County
New York
Albany
New York
Allegany
New York
Bronx
Tennessee
Anderson
Tennessee
Bedford
Tennessee
Benton
I have kept State and County in filter section. It is working fine.
State Dimension is showing : New York and Tennesse.
County Dimension is showing : Albany, Allegany,Bronx,Anderson,Bedford,Benton.
Once i select only new york state from my state filter, in county filter it should show only Counties of new york, but it is showing counties of other sates also, basically cascading effect between two filters are not working.Is there a way to get the cascading effect from one filter to other in filter section.
Regards,
TEG
⋅ June 12, 2019
Hello,
Thank you for writing to us.
We suggest defining a hierarchical connection between these dimensions. Here is how it will look like in your CSV file:
State, State:County New York, Albany Tennessee, Anderson
Please let us know if such an approach works for you.
Regards,
Tanya
⋅ August 7, 2019
hello Tanya,
I have a similar type of requirement but with .net db connection with flexMonster compressed data (instead of CSV).
Can you please help me on how can I achieve this?
Thanks
⋅ August 8, 2019
Hello,
Thank you for your question.
We kindly suggest using : in SQL query alias to define a hierarchical connection between dimensions.
Please consider the following example:
SELECT category AS ‘Category’, subcategory AS ‘+Category:Subcategory’
FROM table_name;
The hierarchy structure is defined with query alias. The Category field is the first level of the hierarchy and Subcategory is the second level of the hierarchy.
Please let us know if this works fine for you.
Best Regards,
Vera
