Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone
I'm having a very strange behavior with the filters in a document, and I wonder if anyone know that is.
In the data model, I have two T1 and T2 concatenated facts tables, these share some fields and not others.
In this case I'm only working with the data of T1, which has a field A that is not in T2.
When I select a value in field A, and do other filters in other fields, then try to change the value of field A, and what happens is that erases all previously made filters. Theoretically should delete only those who do not have data in common with the new selection in field A, but it is clearing all filters.
If I not load the table T2, I get proper operation, but by concatenating the fact table T2 is when the problem appears.
Has happened? You know it can be?
Thank you very much!
Regards
Try to preview the data from table viewer...
ctrl_T and then right click on fact table and preview the data.. see if the selection you are making is associated with the other selections or not..
HTH
Sushil
Sushil Hi, thanks for the reply.
Yes, the data are associated.
In the dashboard, do some filters, and then I change the value of the field A and see that under both values, I have applied filters that good. The issue is when I add a filter that is linked only to a some values of field A and then change the value of A. This should delete only the data that is not linked. But it is deleting everything.
Thanks for your help
hmmm..
is it possible for you to post the sample app.. so that i can see what is actually happening ..?
also let me know the scenario where you are getting the issue.