Can you set a session variable or are there any automatically generated when a table row is selected?
I know this is possible in the protocol, but wondering if this can be done without modifying it.
The requirement is to filter a second table based on the row selected in the first table, with no relations between the tables apart from some of the columns that aren't PK or DK have the same information in.
Hi Philip,
For parameter controls, this functionality would require adjusting the protocol directly.
However, an alternative approach could be to use child shapes. You can generate a shape for each row, and when clicked, it sets a session variable.
This can be achieved by using the Selectable feature: https://docs.dataminer.services/user-guide/Basic_Functionality/Visio/miscellaneous/Making_shapes_selectable.html
Thank Sebastiaan,
I ended up using child shapes, but using ParameterControl for each column instead.