Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums    Search    Search Results
Page 1 3 4 5 6 7 8 9 ... 20
Go
New
Search
Tools
Search Results: (393 matches) New Search Login/Join 

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: [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: [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]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: Join a CX Group: WebFOCUS Page Designer 8203, 8204, and Beyond (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
I'm interested in joining this group....
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

Discussion Topic  RE: [CLOSED] simple vs recomputed (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
If you have a compute with for instance this calculation: CAR.BODY.DEALER_COST / CAR.BODY.RETAIL_CO......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 3 4 5 6 7 8 9 ... 20 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.