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     [CLOSED] Filtering a WebFOCUS View in the Master File
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Filtering a WebFOCUS View in the Master File
 Login/Join
 
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, 2004Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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, 2004Reply With QuoteReport This Post
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: 3106 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.