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 ... 6 7 8 9 10 11 12 ... 23
Go
Search
Tools
Search Results: (454 matches) New Search Login/Join 

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
DB_EXPR will work like this in the sql quer if this is the code: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Well it's not a matter of how WebFOCUS works, Oracle just doesn't multiple values per cell. Perhaps......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
That depends on the Database and Adapter. Some databases support multiple values for one cell. Norma......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
for example: DEFINE FILE TABLE TEST/I11 WITH ID = DB_EXPR(select max(value) from table); END...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] How common is using SQL based synonyms? (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
A good Masterfile can be difficult on some databases and I think you have this with any tool. Genera......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] How common is using SQL based synonyms? (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
In 99% of cases I've seen, masterfiels are created on tables....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] display of decimals in edit bar or function bar (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
With this code I see 6 decimals in Excel (2016) ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Creating a hold file/master file with static data(not from database) (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
There is no advantage to store this data in a holdfile just because it's static. Just define a list ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved]WebFocus Repository tables, how to determine if chart or report. (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
table wf_objectprops, filter on PROPERTY = OutputFormat, in PROPVALUE you'll see the format. JSCHART......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Extract month and year from date (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Extract month and year from date (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Better use DTPART in order to get SQL optimization: DEFINE FILE ... YEAR/I4=DTPART(DATETIMECOLUMN,Y......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Adding a -SET Statement in InfoAssist+ (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Or use a Reporting Object if you only want reports or diagrams, do your -SET there in the preprocess......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved]flattening out data using an across hold file (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Or use format FOCUS: TABLE FILE CAR SUM SALES BY COUNTRY ACROSS CAR ON TABLE HOLD FORMAT FOCUS END ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Compound Reports PCHOLD Format Alpha (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Try this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Printing 2 tables as a DOC format (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Because doc is a file, you first need to combine it in one file: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How do I split Column heading (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Something like this? ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Is there a HOLD format that does not create a file? (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
to my experience, creating a small HOLD file doesn't take a lot of resources. On Linux, the BINARY o......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Inserting USERNAME in the synonym (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
What is your usecase, do you want to show the user that is loggedon in the report?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Hyperstage Performance Active Reports (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Jenni do you have Infoassist+ ? If yes, then better use Visualisations for this....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Dotted line chart stacked on area chart in infoassist (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Yes, check out the last tab, there you can choose a type for each measure....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 6 7 8 9 10 11 12 ... 23 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders