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 ... 31 32 33 34 35 36 37 ... 61
Go
Search
Tools
Search Results: (1213 matches) New Search Login/Join 

Discussion Topic  RE: [SHARING] Help with preventing cartesian scans of OLAP database? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Yes, WHERE TOTAL is required for filtering on a COMPUTEd field and is not applied until after data r......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SHARING] Help with preventing cartesian scans of OLAP database? (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
It's difficult to know for certain without seeing the SQL trace, but I suspect the sort on a DEFINEd......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Color Coding for Column Total (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSE] Debugging a procedure- How to display variable setting (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Include FROMDATE in your report output: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Clear the page (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You could simply -SET the values of the variables to blank: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] extracting current year data to the hold file (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try changing SQLORA to SQLODBC....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] extracting current year data to the hold file (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Is your database Oracle? If so, try this. Your DBA should also be able to help you with this inform......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]-WRITE an END to the file (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Did you try removing this unnecessary line of code? ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [OPEN case]get rid of trailing blank with Microsoft SQLServer analysis server in OLAP (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Just to be clear, I am suggesting that you open a case with IBI - not me....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [OPEN case]get rid of trailing blank with Microsoft SQLServer analysis server in OLAP (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I would open a case with IBI Tech Support....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [OPEN case]get rid of trailing blank with Microsoft SQLServer analysis server in OLAP (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I suspect the extra space/null is caused by your COMPUTE. Column Country_Region is 14 long, not 15.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Across with subfoot on noprint field (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You might consider adding a Total Premium column (TP) to your output. Then SUBTOTAL becomes an easy......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Coordinated Compound report with other, non-BY values (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You might consider using a standard drilldown approach to accomplish the task. Using your example: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]across percentage recalculation (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Or this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]across percentage recalculation (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Here's one approach - a little cumbersome, but it works. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Render HTML tags in PDF document created by Composer (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
This link ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] run time (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
When doing development work against a relational data source, you should always have SQL traces turn......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] CASE STATEMENT and CUSTOM VALUE (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I'm certainly not always right! But ARGLEN has been around a long time and I was certain it would w......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] CASE STATEMENT and CUSTOM VALUE (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] CASE STATEMENT and CUSTOM VALUE (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try function ARGLEN....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 31 32 33 34 35 36 37 ... 61 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders