on 07-19-2012 4:21 AM
Hi,
Is it possible to Prompt a user where he or she can enter her full name and the same be displayed on the report?
I have a report where in we need to display the full name of the user. Initially there was only one user, so I created a variable to display the name of the user.
Now the number of users have increased and I do not want to create separate instances for each user.
Is there any way where we can ask the User to "Enter Your Full Name:" and the same be shown on the report?
Thanks a ton.
If you have a Universe where you can fetch the Company Employee Info. You should create a object using @Variable('BOUSER') in the Universe and use it in your main query. Add another query that only brings User id and Username info filter it on User Id and get the value for this filter from the result of the first query.
Since you will be displaying the User info in the header you dont need to merge dimensions just use the results from the second query in your header.
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is a built-in function to capture the UserID but NOT user Full name. The best way to do this would be to create a table in the database with two columns, one BOBJ UserID and another call BOBJ Full name. Then you create a separate Data Provider that bring in the BOBJ Full Name where it condition can use the dynamic @Variable ('BOUSER').
Good Luck
Ajay Gupta
Hi Raheem,
Please make it clear about what type of data source you are using?
Is it necessary to have full name of the user? or just picking the userid will meet your requirement?
To pick userid, you just need to use "CurrentUser()" webi function.No prompt is needed to get the userid.\
Regards
Sunil Koneru
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
If u have an Object with the list of users then , It is possible
drag and drop the object in queryfilter and make it as prompt and beside there is a question mark click on that and uncheck all the options . and finally the operator should be Match pattern .
It is case sensitive,When you are entering the name manually the name should match with the list of value , if it returns true then value be retrieved .
So my suggestion is to follow up with emp key value.
Hope this helps u
Thanks & Regards
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.