Table names missing from the filter panel.

[Mihai Daniel OLTEANU]

Hello all,

I'm doing some maintenance for a report designed by someone else.

I've found the error which is related to "Relations". So all I have to do is to configure the filtering relations like in the example below (example from a different dashboard) and normally everything should work properly.

 

The problem is that in the dashboard I must do this corrections the tables names are missing from the filter panel and this brings a big problem for me because I do not have available/displayed the icons where to configure the filtering relations, even though I have an active relation in my dashboard.

So, in the filter panel are displayed all columns from all tables (over each other) but without displaying the table are coming from.

Have you ever faced this kind of problem?

Thanks in advance,

Mihai

[Fredrik Rosell]

Hello Mihai,

If you take a look under Edit menu > Organize Filters, are there e.g. any data tables that are unchecked? I have not been able to reproduce the issue you describe using the settings available there, but filter organization seems like one possible area to explore. Your current version/the history of versions the analysis has been edited in might be a factor.  

If it's possible to share the analysis file - it would really help to have access to it - I recommend opening a case with Spotfire Support (https://support.tibco.com/).

Best Regards

Fredrik

   

[Mihai Daniel OLTEANU]

Hello Fredrik,

I already verified the "Organize filters..." menu and everything is ok there, meaning all the tables are checked.

So, I repeat ... the tables names are not displayed in the filter panel area ... whereas theirs columns are displayed. (see print screen) 

Unfortunately I cannot share the analysis file due to some confidentiality matters.

I will contact the support team.

Thank you,

Mihai

[Jose Leviaguirre]

Hello Mihai, Can you create a blank page and refresh the browser either by Tools > Development > Reload Browser or by pressing Ctrl+Alt+Shift+F5

[Fredrik Rosell]

>I will contact the support team.

Great! This should be easier to troubleshoot through that channel.

Best Regards

Fredrik

[Mihai Daniel OLTEANU]

Hello Jose,

Thanks for your reply.

Unfortunately this does not work either.

[Senthil Selvaraj]

I have the same problem. Once you hide all filters for the users to share/deploy the analysis with others, the "Filtering in related data tables" icon disappears. I cannot bring it back. The only option is to recreate the whole analysis. Please share if there is any solution for this. Thanks!

[Fredrik Rosell]

Hello Senthil,

Regarding "I cannot bring it back" - what happens if you show at least one filter for the data table of interest again?

Right-click in the Filters panel > Organize Filters...

All filters hidden:

Show one filter => that data table (and "filtering in related data tables" icon) becomes visible.

[Senthil Selvaraj]

That doesn't work, either. I found the reason. I will respond to Mihai Daniel.

[Senthil Selvaraj]

I found that this happens when at least one of the tables in Data Table Properties has the option "Show in user interface" unchecked. Enable "Show in user interface" in Data Table Properties for all tables included in the analysis.

Please let me know if this works for anyone.