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
Go
Search
Tools
Search Results: (16 matches) New Search Login/Join 

Discussion Topic  [CLOSED] Keep ACROSS headers after holding (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Hello, I have the following code: TABLE FILE TABLE_ONE SUM NUMBER_OF_RECORDSS AS 'Number' MA......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Intermediate SQL Question involving Partition/Over (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I have two tables. The first looks like this: Unit Status 1001 A 1002 A......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] SET LINES=99999; not working, I keep getting repeating Header names every (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Thanks Danny and Waz, works now....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] SET LINES=99999; not working, I keep getting repeating Header names every (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Hello, I have the following code: -DEFAULT &LOOKBACKDAYS = 365; -SET &TODAY = EDIT(&MDYY,'99$$$$$$......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Can you sort across by date? (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I'm using the following line: ACROSS STATUS_CHANGE_DATE_MODIFIED AS 'Month' Giving me the below ou......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Switching Servers (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I found a kind of embarrassingly easy fix; I was doing what I was doing because I only needed to acc......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Switching Servers (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I simply want to join the file created from the first query to a table that resides on server2. Uti......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Switching Servers (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I am trying to write a query utilizing data from two servers. My code looks like this: SQL SQLORA ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] PivotTable Error Message in Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Haha that name is from long, long ago when I played youth soccer, I just kept using it for all my me......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] PivotTable Error Message in Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Today is Pivot Table day for me, apparently. I am trying to run the below code: TABLE FILE HOLD1 P......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Over 66,000 rows. Thanks, I will check with Tech Support....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Thanks Tony. What you have there using the sample code is exactly what I am trying to do - but for ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Thanks Tony. I get the totals now, however in the Excel file that opens up only Columns A and B are......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Hello, I have the following code and its output as far as the data goes is what I would expect: TA......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Using -IF...THEN GOTO...ELSE GOTO on Compound reports (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
That works, thank you. I think I had an incomplete understanding of what TABLE HOLD can do. As you ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Using -IF...THEN GOTO...ELSE GOTO on Compound reports (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Hello, I am a WebFOCUS newbie trying to get up to speed quickly. Thanks in advance for any help or ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders