We are using csv connection for pivot table. I have State and County presents in the data.
For Example My data looks like below:
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.
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.
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?
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’
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.