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     RECORLIMIT not working with Dimensional master file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
RECORLIMIT not working with Dimensional master file
 Login/Join
 
madhavi
Member
posted
I have a master file from which has multi path relations between segments
SEGMENT=EMPLOYEE
SEGMENT=TRAINING, PARENT=EMPLOYEE
SEGMENT=COURSES, PARENT=TRAINING
SEGMENT=BENIFITS, PARENT=EMPLOYEE
SEGMENT=APPRAISALS, PARENT=EMPLOYEE

When I issue a TABLE request on the above master file, I make use of RECORDLIMIT (To get the first N rows)

TABLE FILE EMPLOYEE
PRINT EMPLOYEE.FIRSTNAME
EMPLOYEE.LASTNAME
TRAINING.DURATION
COURSE.COURSENAME
BENIFITS.BONUS
APPRAISALS.RATING
WHERE RECORDLIMIT EQ 1000
END

When I turn on the trace and see the Query generated by this request, the query looks perfectly fine except it does not have FIRST 1000 Clause, which I understand is a feature of READLIMIT key word and not RECORDLIMIT key word.

But my problem is, even though that query from the console results in around 20k rows in the database, my report output only shows 300-500 records.

Can any one help with this.

Thanks
Madhavi
 
Posts: 3 | Registered: June 08, 2006Report This Post
susannah
Expert
posted Hide Post
How many records are actually in your employee file?
is it possible that you have only 3-400 records in total?
change your RECORDLIMIT to 10
run it
see what happens



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
madhavi
Member
posted Hide Post
Susannah,

Thanks for your reply.
The problem with my master file is that I did not use SEGTYPE="U" for the child segments.

Without that, RECORDLIMIT is being translated to the total number of rows read from each one of the tables.

As I had 4 segments in the master file, the total number of records fetched are 1000 together from all tables.

But as per the relationships, I expect 1000 employee records.

And, in multidimentional master files having SEGTYPE='S0' is not going to make much sense in the output data any way.

So, this resolved my problem.

Thanks
Madhavi
 
Posts: 3 | Registered: June 08, 2006Report 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     RECORLIMIT not working with Dimensional master file

Copyright © 1996-2020 Information Builders