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

Discussion Topic  [CLOSED] Intermediate SQL Question involving Partition/Over (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I have two tables. The first looks like this: Unit Status 1001 A 1002 A......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] SET LINES=99999; not working, I keep getting repeating Header names every (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Thanks Danny and Waz, works now....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] SET LINES=99999; not working, I keep getting repeating Header names every (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Hello, I have the following code: -DEFAULT &LOOKBACKDAYS = 365; -SET &TODAY = EDIT(&MDYY,'99$$$$$$......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Can you sort across by date? (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I'm using the following line: ACROSS STATUS_CHANGE_DATE_MODIFIED AS 'Month' Giving me the below ou......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Switching Servers (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I found a kind of embarrassingly easy fix; I was doing what I was doing because I only needed to acc......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Switching Servers (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I simply want to join the file created from the first query to a table that resides on server2. Uti......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Switching Servers (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
I am trying to write a query utilizing data from two servers. My code looks like this: SQL SQLORA ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] PivotTable Error Message in Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Haha that name is from long, long ago when I played youth soccer, I just kept using it for all my me......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] PivotTable Error Message in Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Today is Pivot Table day for me, apparently. I am trying to run the below code: TABLE FILE HOLD1 P......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Over 66,000 rows. Thanks, I will check with Tech Support....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Thanks Tony. What you have there using the sample code is exactly what I am trying to do - but for ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Thanks Tony. I get the totals now, however in the Excel file that opens up only Columns A and B are......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CASE OPENED] Pivot Table Mechanics and Formatting (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Hello, I have the following code and its output as far as the data goes is what I would expect: TA......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Using -IF...THEN GOTO...ELSE GOTO on Compound reports (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
That works, thank you. I think I had an incomplete understanding of what TABLE HOLD can do. As you ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Using -IF...THEN GOTO...ELSE GOTO on Compound reports (in WebFOCUS/FOCUS Forum on Focal Point ) by intsoccersuperstar
Hello, I am a WebFOCUS newbie trying to get up to speed quickly. Thanks in advance for any help or ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata  

Focal Point    Focal Point Forums    Search    Search Results

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