All the fields should be associated automatically during loading. Not sure if I understand you problem correctly, but you may want to put a table chart with all the fields as dimension. The way Qix engine works is kinda different from traditional database/data warehouse, think about filtering instead of selecting.
Sorry, I might not explain my question properly. This is an example of my data set, when I click on the 'PEP' bar in the bar chart, I should expected to see 8 lines in the table. But I think due to formula issue in the measure, the filter does not work out properly. Thus, I am trying to solve the issue.