Hello, I have a question about how USERELATIONSHIP works when all relationships are initially deactivated.
As an example, I have prepared a simple data model (all relationships are deactivated!):
dimproduct:
factonlinesales:
I have set up a simple RLS role.
Without using USERELATIONSHIP, I only see Deluxe products:
Since RLS filters my dimension table. Great!
However, when I add USERELATIONSHIP:
I start seeing Economy products!
Can someone explain why this happens? It looks like a bug because I expected to get the sales total only for Deluxe.
Yes, I understand that RLS propagates through active relationships, but there are no active relationships in my model!
I want to filter my dimension table using RLS, and I expect this filtered dimension table to also filter my fact table.
