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.
We're currently working on a Windows environment with WebFOCUS 5.3 on Unix, is there an example someone can show me of how to create an MFD either from an Excel file with the fixed width fields, or flat file? I am working on a report that requires reference to a large number of records and I am literally hard coding them into the WHERE statement, this would be the place for a Master file instead.This message has been edited. Last edited by: gregson06,
Do you have a reporting server running on windows?. Please be aware that this is only possible when you a reporting server on windows. Please refere to the link below for creating an ODBC connection for an excel spread sheet.
I found out how to do this, but I had to use a text file. "newtofocus" may be onto something because I haven't been able to get the access file to work, but I did get a text file to do the trick, I just exported it in a fixed width format and I mapped the MFD to point to that file in a unix directory. Fun stuff, just hope to get an MFD to point outside into a Windows box, that would be phenomenal if that would be possible.
greg, you have to create an odbc system data source for excel or access; you don't for a csv export from excel or for any text file; when you create the system data source , you specify the range name in the excel sheet, and that is what the master file will read.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
If you want to access Excel, Access or for that matter any data source not resident on your reporting platform then the option you have is to install a sub server on the platform where the data source is located.
Once you have that it's a very simple job to set up a master on the reporting server that reads the file directly from the sub server.
Naturally you take a small performance hit but it means that you are always hitting the live data and not a copy/extract that you might have forgotten to update.
Focal Point Forums 
