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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Limitation with Across
Go
New
Search
Notify
Tools
Reply
  
Limitation with Across
 Login/Join
 
<kj>
posted
Can any one tell me what is the limitation with Acros column in terms of no of columns and verb objects(WebFocus 5.2.1 on Win 2k) ?

I am getting an error
(FOC153) VERB OBJECTS TIMES RETRIEVED COLUMNS EXCEEDS 255: 1056

TABLE FILE EXAMPLE
FIELD1 OVER
FIELD2 OVER
FIELD3 OVER
FIELD4 OVER
FIELD5 OVER
FIELD6 OVER
FIELD7 OVER
FIELD8 OVER
.
.
.
FIELD29 OVER
FIELD30
ACROSS FIELDX
ACROSS FIELDY
ACROSS FIELDZ
END

The combination of across columns I am getting is 22. It is working fine if I can reduce it to 21 or eliminate two fields from display.

Any reply would be greatly appreciated.

Thanks,
kj
 
Reply With QuoteReport This Post
<monte2000>
posted
After reviewing, I believe that release was still limited to 95. With 5.2.3, it went up past 500.

The number of verb object is determined by:

Number of verb objects * number of across1 values * number of across2 values * ...
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
This is a moving target. But, in Release 5.2.3 and up the number of matrix elements should be
1056.
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Limitation with Across

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