Just so we're clear about your requirement:
You are asking about a way to automatically add a WHERE clause to the dimensional source (LTS) when a user accesses subject area A and no WHERE clause when he accesses subject area B?
There is no problem that in both cases will be WHERE. But the WHERE clause should be different in both cases (depend of subject area). I can always put WHRER 1 = 1 instead of blank WHERE
Hello nameless user,
Ok, so it's as I thought. You can achieve this by doing LTS-switching with a fake column which contains the value of a session/request variable. You'll have to make sure though that there's always a value set in that variable (make it a default session variable for everyone for example) since otherwise OBI won't know which LTS to pick.