Skip to Content

Use a document-leve input control to filter multiple tables that have a linked dimension

I have a Webi report (4.2 SP4) that contains two queries:

  • Query 0 - PATIENT_ID, GENDER, MRN, PATIENT_NAME, CSN
  • Query 1 - PATIENT_ID, SURGERY_ID, SURGERY_DATE

Each query contains the `PAT_ID` field.

The document has two reports, each that contains a table that has the data elements of the respective queries:

I created a linked dimension on the `PATIENT_ID` field, and added that to each table (removing the non-linked `PATIENT_ID` field):

Finally, I created a document-level input control on the GENDER field:

When I select M, the table that contains that field is filtered to only show the Males:

However, the table on the second report does NOT change to reflect this filter (it should not display any records):

Am I doing something wrong?

Perhaps linked dimensions don't act in a manner that I was hoping that they would (i.e. like a table join).

Is there anyone way to get this to work?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 22 at 04:43 PM

    try with adding Gender object in the second table and right click and hide this.After that check if input control is working or not.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22 at 11:04 AM

    Can you make sure when you define the input control, on Assign Report Elements "Whole document" option is selected?

    Add comment
    10|10000 characters needed characters exceeded