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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Is there any documentation on how the Internal Matrix is built?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Is there any documentation on how the Internal Matrix is built?
 Login/Join
 
awardb
Member
posted
I am researching an issue we are having with FOC153, which appears to have to do with the size of the internal matrix. I am looking for documentation on how that matrix is built and what the size limits is for version 7.7.3. Any input would be most appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,


Release 8.1.05
Windows
Excel, HTML, PDF, AHTML, COMT
 
Posts: 5 | Registered: July 31, 2013Report This Post
Francis Mariani
Expert
posted Hide Post
These are the limits as specified in the manual:

quote:
The following limits apply to TABLE requests:

Number of verb objects referenced in a TABLE request: 1024 (495 for MATCH requests)
Number of columns of report output: 1024
Total length of all fields in the request or in a single Master File: 256K
Total number of sort fields (combined BY and ACROSS): 128

An internal sort will be generated automatically under some circumstances, and these have to be counted in the total. HOLD FORMAT FOCUS/XFOCUS will add FOCLIST as a BY field in order to ensure uniqueness.
Maximum size of the output record: 256K (FORMAT/USAGE)
Maximum size of the output file: FOCUS partition 2GB, XFOCUS 32GB
Maximum size of internal expression representation of a single DEFINE, COMPUTE, -SET, or WHERE phrase: 64K

The internal representation is generated in polish postfix notation, which is significantly smaller than the entered expression. In addition, the constants in expressions (as in DECODE or IF…THEN..ELSE conditions) are stored outside of the expression representations, reducing the space requirement for the expression representation itself.
Maximum number of segments in a structure or file: 1024

This means that a total of 1023 JOINs can be in effect at any one given time.
Maximum size of Alphanumeric fields: 4K characters ( in UTF, this means 12K bytes)
Maximum number of display commands in a TABLE request: 16


quote:
(FOC153) VERB OBJECTS TIMES RETRIEVED COLUMNS EXCEEDS MAXIMUM
The combination of ACROSS and the number of verb objects will
produce more than the maximum number of output columns allowed
in the report. Reduce the number of verb objects. See the
documentation for further details

If you have an ACROSS in the request, a FOC153 error most likely means you have too many distinct ACROSS values.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
j.gross
Virtuoso
posted Hide Post
Remarks:

1. The quote neglects to mention that FOCLIST is only generated with PRINT; not with aggregating verbs.

2. If you have a very wide record, but portions of it are constant within high-order sort breaks, try to re-express the request as a multi-verb request. -- The "internal matrix" is hierarchical (a multi-segment straigh-line FOCUS file), so you can save space in a major way by promoting common data up the ladder.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
awardb
Member
posted Hide Post
Thank you all for your input. This is very helpful.


Release 8.1.05
Windows
Excel, HTML, PDF, AHTML, COMT
 
Posts: 5 | Registered: July 31, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Is there any documentation on how the Internal Matrix is built?

Copyright © 1996-2020 Information Builders