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

Discussion Topic  RE: [CLOSED] Adding subquery result to rows of table, hopefully on a metadata level (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Hi Chuck, Not sure what you mean, I'm trying to add this subquery at the synonym level so I'm reall......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Adding subquery result to rows of table, hopefully on a metadata level (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
What is the most graceful way to add a subquery to a table beyond adding a subquery to the synonym? ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Questions on grouping / coloring slices in pie charts (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Hi, I have created some pie charts and while they have come together I chose to go the route of edi......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Yep, thanks for your help....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
I have a series of the following: !IBI.FIL.foccache/temp1 !IBI.FIL.foccache/temp2 !IBI.FIL.foccache......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
I have a prepared htm document in baseapp that is essentially a tr html element. I want to take a co......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
If I store a .htm file in baseapp is there a way to copy and rename it into foccache?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Thanks Addy - I tried removing the dash but same results. Martin - I'll go down your suggestion som......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Just to follow up - so when I see my blanks it seems to be when TMP_RESULTS is completely empty. If ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Unfortunately the NODATA didn't work. I started going down the other route but in hopes that I'm jus......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Thoughts on handling empty result set case for metrics (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Good Evening, For the report I am building there are a series of metrics that each print a row of d......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Question about replicating subquery with additional where clauses (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Looks like the following does the trick, thanks for your help! ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Question about replicating subquery with additional where clauses (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Right, so what would the syntax look like for supporting a join to the child?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Question about replicating subquery with additional where clauses (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Or, is the following sufficient and FOCUS is smart enough to pick up the join between CAR and CHILD.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Question about replicating subquery with additional where clauses (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Martin - okay, so what if the join is occuring on a child of CAR? So would it be something like: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Question about replicating subquery with additional where clauses (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
I am translating a SQL query into Focus-eze and in my select fields I want to include a sub query. T......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Trouble with getting distinct value list with row counts (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Follow up: I went the ranked route. W.r.t. the 'BY' route though, I thought 'BY' is used for sortin......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Trouble with getting distinct value list with row counts (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Worked, thanks!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Trouble with getting distinct value list with row counts (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Hi, Trying to do a distinct on a table field to receive the distinct values then add a row counter ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Creating HOLD file to store results from loop (in WebFOCUS/FOCUS Forum on Focal Point ) by Sean Sweeney
Works, thanks!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders