Suppose I am an OBIEE Admin. My user id is ‘Administrator’ and password is ‘Administrator’.
There is a user called ?sandip?. I know the user id of user which is ‘sandip’ but do not know the password.
I want to run the logical query of user ‘sandip’ from my user login (Administrator/Administrator ).
How can I add user id ‘sandip’ in the logical query (of user ‘sandip’) and run from Administrator’s (my) login?
I have tried in the following way.
run the following command in the command prompt (where userid/passowrd is Administrator/Administrator).
nqcmd -d AnalyticsWeb -u Administrator -p Administrator -s q1.sql
The q1.sql contains the following logical statement.
SELECT Products.Type saw_0, Products.Brand saw_1 FROM Paint ORDER BY saw_0, saw_1;
How can I add user id ‘sandip’ in the above logical query so that it runs the logical query of user ‘sandip’ only? (Note: I do not know the password user ‘sandip’).
Please also let me know any other way apart from using iBot.
