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     [CLOSED] Filtering a WebFOCUS View in the Master File

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Filtering a WebFOCUS View in the Master File
 Login/Join
 
IBForum
Gold member
posted
I have an .ACX and .MAS file that points to and defines a Sybase table to WebFOCUS. The Sybase table hold daily prices for a security. The Sybase table also contains the current month's month-end date which holds the most recently updated price for a particular security. In other words, the 8/31/2009 record in the Sybase table would contain the closing price from yesterday, 8/24/2009. My question is...is it possible for me to filter out all the daily prices and only include the month-end prices at the .MAS file level? I know that each report FEX could be easily programmed to only include month-end dates, but I'd like to do it at a level further up...as if we had created a separate database table that only contained month-end dates going back to inception. Hopefully, this makes sense. I played around with defining a FILTER in the .MAS file, but it returned 0 records in my TABLE request.

This message has been edited. Last edited by: Kerry,


WF 8.1.05, Windows Server 2012 R2
 
Posts: 50 | Registered: March 26, 2004Report This Post
mgrackin
Virtuoso
posted Hide Post
What is your goal? Are you trying to reduce the amount of records returned from the database? It sounds like the following code will do this for you in a FOCEXEC.

TABLE FILE SYBASEDB
SUM MAX.MTHEND_PRICE
BY MTHEND_DATE
END

This should translate into SQL that brings back only one record for each month.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
IBForum
Gold member
posted Hide Post
The goal was to reduce the number of records returned, but do it thru the .MAS or .ACX file...not in the FOCEXEC. Also, the only date field available in the file changes daily, so I have to create a month-end date to evaluate against for the selection criteria. Leap years may be tricky.


WF 8.1.05, Windows Server 2012 R2
 
Posts: 50 | Registered: March 26, 2004Report This Post
Doug
Expert
posted Hide Post
1) Perhaps your DBA can create a VIEW for you that accomplishes this. you can use Micky's code as a base for your request.
2) "Leap years may be tricky": Not really tricky... With Smart Dates...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gobinath Velusamy
Platinum Member
posted Hide Post
Hi

Instead of using Master file use the Sqlpassthrough to reduce the number of records to webfocus server


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Report 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     [CLOSED] Filtering a WebFOCUS View in the Master File

Copyright © 1996-2020 Information Builders