Role checker and Universe
hi guys i have a few tables joined in universe, cant go bex route, here is my question
here is how i think the universe works, reads the whole universe, checks the user id, checks allowed data to be looked at and bring the data back.
i have a authorization table, the authorization tables checks user id and allowed data to be looked at from the sap DSO , then allows the universe to bring the data back to webi.
the issue it, its making the report run very slow,
question is is there a way to set up a universe that it first reads the table which has only allowed data to be looked at then read the 2nd table which has the transaction of the all the data for it to filter through to bring back to webi.
query stripping and other things have been done to the webi, universe