I just wanted to discuss with you all on how to handle Aggregated tables in WEBFOCUS.
If we create a synoym (say DAILY_BATCHES) which contains data at a daily level and give it to a adhoc user he will create his own reports and will run it. If the users gives the date range for 1 or more month then it is very tough to pull out the data.
Instead if we create a table BATCHES_MONTHLY and create a corresponding synonym in WEBFOCUS, it would solve the problem even if the user enters a huge range.
Now I wanted to find out how we can change the underlying master file to be used when the user runs the report. If user enters a range for 1 or more months then it should use the synonym BATCHES_MONTHLY otherwise it should use DAILY_BATCHES.
How do we control such a behaviour. Please express your thoughts on how we can achieve this.
Thanks, AmarnathThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.7 Unix Excel/Html
April 17, 2009, 06:37 PM
GinnyJakes
You can use an amper variable in the request to hold the filename and alter its contents based on the input. E.g.