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 email@example.com for further assistance. Reference the community FAQ to learn more about the community.
I'm currently configuring our environment to allow users to choose to which database they'd like to execute their reports. As we are using the portal/view functionality, I'd like to set a dropdown list in the banner area containing the different databases. End goal: Whenever the user chooses a database - all subsequent reports execute on that db
What I've done so far is: - set the global variable via edasprof: -SET &&G_ENV = 'INT' - created an html file with dropdownlist via composer to set the global variable via an included fex:
- created a seperate fex to set the connection details via the global variable:
ENGINE SQLORA SET CONNECTION_ATTRIBUTES DWH DWDVL/user1,pwd1
ENGINE SQLORA SET CONNECTION_ATTRIBUTES ODS DSDVL/user2,pwd2
Now for the inevitable questions: - how do I go about putting the html-file in the banner area of the portal? (can I copy-paste? whereto?) - what is the 'scope' of the engine command? (per WF-server, WF-client or browser session?)This message has been edited. Last edited by: Peter,
Prod: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode Test: WebFOCUS 8.0.06 on Win2008/Tomcat7/LDAP Mode
The way I resolved this many years ago was to create separate Synonyms for each table in each database. In that case, the databases were in different geographic locations, so we used a 2 letter location prefix (MI for Miami etc) for each table.
Usage went something like this, where &LOV_PRE = 'MI" and passed in from the launch page
-SET &MYTABLE = &LOC_PRE || 'CAR';
TABLE FILE &MYTABLE.EVAL
NOTE: You have to take Particular care to ensure that ALL tables in ALL databases are always EXACTLY the same schema for this to work. If one location / database makes a schema change and that is not replicated across ALL databases, and the MFD's updated accordinly, eventually your reports will crash due to FORMAT and / or USAGE errors when the .mas file no longer matches the table or your reports are using functions that require the input format to be specified.
It ain't pretty, but it worked.
Robert F. Bowley Jr. Owner TaRa Solutions, LLC
In WebFOCUS since 2001
Posts: 132 | Location: Gadsden, Al | Registered: July 22, 2005
Thank you all for the suggestions. I ended up setting the attributes of the connection depending on the global variable I defined via "_site_profile = -INCLUDE setconnection.fex" Upside: I didn't need to modify any of the reports, applications or master files and connection remains valid for entire time when logged on Downside: doesn't work for report caster (separate includes needed in reports)
Also, instead of using the banner area, I rather used the portal functionality to show a block that remains visible at all times... Reason: For using the banner area, I needed a 'pure' html page, but I wanted to include WF-variables to set default values...
Lastly, I used the following two elements to call a fex from the html-page: