I am wondering how I access the expanded dimension table that are presented in the query builder when defining the relationship between master a detail records.
So far I
1, Create the master detail page with the two tables that have a relationship
2, Edit the row select event of the master table
3, Within the Invoke step I open the Query Builder and define the filter condition between the master and detail table
In the query builder the dimension tables associated with the detail table are presented and I check them.
However the detail table does not contain these values and when I try to add columns I cannot see them in the property drop down of that new column if i open the link dialog I cannot find them in any of the field hierarchies of the set property to dialog.
This feels like one of those, ‘once you know you will wonder why it wasnt obvious’ type questions but I have been wrestling with this for a while.
In short how do I add the values from related dimension tables to the Child data grid of a master detail page?
Help appreciated.