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    Search    Search Results
Page 1 ... 25 26 27 28 29 30 31 ... 61
Go
Search
Tools
Search Results: (1213 matches) New Search Login/Join 

Discussion Topic  RE: [CLOSED] Duplicate file check (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Building on Sandy's suggestion... If your input file has a synonym/master, you can TABLE it to get ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Changing the Order of tabs when using BYTOC (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I used SALES instead of SEATS because a COUNTRY can have more than one number of SEATS and Excel wil......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]AVE in the Subtotal and Rounding down (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Yes, average in a SUBTOTAL is possible. And the space immediately after the AVE. and SUM. prefixes ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Date Format (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
This might work. Add function LCWORD if you need the month in proper case. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Insert Multiple Records into Existing Focus File (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If it is a FOCUS file, as opposed to a HOLD file, you will need to use MODIFY to insert records: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Date Conversion (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
WebFOCUS can format a SmartDate as 'Mmm, YY' or as 'MM YY', but for some reason it cannot chew ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Subtracting Dates to get Days Difference (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
For date in mm/dd/yyyy format try: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Subtracting Dates to get Days Difference (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
One method is convert your dates to SmartDates so you can add and subtract the dates with simple ari......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Keyfiels Lenght in segment (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If you are adding an index to your FOCUS file (ON TABLE HOLD FORMAT FOCUS INDEX ....), any field nam......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [COLSED]Conditional Row? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Adding more DEFINEs or COMPUTEs may solve the problem, but it is impossible to know exactly what sol......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [COLSED]Conditional Row? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Add a DEFINE or COMPUTE to set ITEMCODE = NATIONAL_Brand for the SUBFOOT. The StyleSheet parameter ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [COLSED]Conditional Row? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You might be able to use SUBFOOT with a WHEN clause. For example: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Creating a Flag (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
As long as the data is already sorted by VIN, NAME, and DATE, this should be easy to do with a DEFIN......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How to show a report and a graphic in the same Window (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
A very basic technique is to use the bar graph function built into TABLE FILE StyleSheet. The sampl......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] BY HIGHEST (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Have you tried: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Ways to trap for a bad date in Data Migrator? (in iWay Software Product Forum on Focal Point) by Dan Satchell
Prior ro using DATECVT, as Clif suggests, you might use the CHKFMT function to ensure the incoming d......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [SOLVED] LENGTH OF FIELDS ON FOCUS DATA PATH EXCEEDS 32K BYTES (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try SET HOLDLIST = PRINTONLY. Without this command I believe WebFOCUS will place both the original ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Not able to get a distinct count on a field (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Based on your sample output above, it appears you want the distinct count to appear for only the fir......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Not able to get a distinct count on a field (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I am confused by your request. I would assume order number to be be unique for every order. Therefo......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Adding a new coulmn to a table (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Can you use a number instead of a letter as a label? If so, the LIST command is an easy solution. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 25 26 27 28 29 30 31 ... 61 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders