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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
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