Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] dropdown list based on userid

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] dropdown list based on userid
 Login/Join
 
ReddyP
Gold member
posted
We are trying to pass user id via the link and based on the user id we need to populate the dropdown values.
I did this using !ibi.fil.
and including the html page in a fex.
I am calling the fex to execute.
Everything works up to this point.
But, when I try to run the report by selecting a value, it does not work. The report is not taking parameter value at all.
Please help.

Thank you.

This message has been edited. Last edited by: ReddyP,


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Report This Post
dburton
Gold member
posted Hide Post
Hi ReddyP,

Are you using BI Dashboard?
Are you trying to get the users login ID from the BID through Managed Reporting?

Can you get the user id before you call the other procedure?

Can you post some of the code where you are trying to launch the other procedure and passing it the parameter?

Dave


WebFOCUS 7.7.03
Windows Web Server 2008
MS SQL Server 2000
Excel,CSV,PDF,HTML
 
Posts: 71 | Location: Kingston, ON | Registered: May 03, 2011Report This Post
ReddyP
Gold member
posted Hide Post
Hello dburton,
I am using the report as a self service app.
For now, we resolved this issue using asp page that would have redirect URL to the self-service app with concatenated user ID at the end of the URL.
Thank you.


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Report This Post
GamP
Virtuoso
posted Hide Post
Be sure, if you use htm files to call fexes, to do this from within a form. Also within the form all variables will have to be defined, otherwise they won't be passed to the fex.
The alternative to this is, as you found, appending the needed variabels to the URL yourself by mrans of asp or javascript or some such mechanism.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Dan Pinault
Guru
posted Hide Post
ReddyP,
It sounds to me like you are doing this in reverse order from what I'm used to. If you create an HTML Launch Page with the drop-down lists and then use a .fex to populate the drop-down list you should be able to filter the results of the fex based on the user.
Another option would be to create user profiles and declare filters against your data sources.
Dan


7.7.05M/7.7.03 HF6 on Windows Server 2003 SP2 output to whatever is required.
 
Posts: 393 | Location: St. Paul, MN | Registered: November 06, 2007Report This Post
ReddyP
Gold member
posted Hide Post
Thank you Gamp and Dan for your suggestions.
Dan, my problem is to get the windows user login ID. Our reporting server is set to posts mode and we are passing the reporting server credentials via the admin console.
Whenever, I use the getuser function, I get the reporting server login ID but not the user who is actually going to run the report.
That is why we had to use ASP redirect route.
Once we get the user ID, rest of the process is the same as you explained.
Thanks.


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] dropdown list based on userid

Copyright © 1996-2020 Information Builders