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     [SOLVED] Setting up Alerts
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Setting up Alerts
 Login/Join
 
Member
posted
I'd like to learn how to set up Alerts... I referenced the BI Portal v8.2.2 PDF (https://webfocusinfocenter.informationbuilders.com/wfappent/pdfs2/wfbiportal.pdf) on how to do so, and I started by creating my Alert Test file in InfoAssist. The code for my Test file is as follows:

ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE transmetric/vwrevdetail
SUM VWREVDETAIL.VWREVDETAIL.TOTALREV
BY VWREVDETAIL.VWREVDETAIL.PERIODENDING
ON TABLE HOLD
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
END

-RUN


When trying to run that, I get the following error message:

No output was returned
Possible causes:
- Output was directed to a destination such as a file or printer
Detail:
0 NUMBER OF RECORDS IN TABLE= 187 LINES= 187
ACCESS LIMITED BY PASSWORD

I have Analyst access rights and am able to open and run this file outside of Alerts.

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


WebFOCUS Enterprise Edition Product 8.2
 
Posts: 3 | Location: Dallas, TX | Registered: May 28, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Edit vwrevdetail.mas and see if your id has DBA access to read the data it describes.


WebFOCUS 8206, Unix, Windows
 
Posts: 1660 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Even with your limited access, it seems that the test file is working : it return 187 lines.
Except if you're not supposed to be limited, all seems good to continue defining your Alert.

The goal of the Test file is to return a true/false condition to then have the Alert report performed or not.
In your case the answer is "true" since it returned 187 lines.
But you don't have any conditions or rules applied which may be missing into your Test file.
Except if the "test" is to see if data exist in the source file otherwise you should include a condition that will make the result (-IF &LINES EQ 0) to true only when requested.

You need the -IF &LINES EQ 0 statement (and following steps) to have you Alert properly defined.
See section "Reference: Alert Assist Sample Code Created With InfoAssist+" (page 237...) from referenced document of your post.


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2165 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
Thank you, MartinY! Your response was helpful - it appears to be all set up!


WebFOCUS Enterprise Edition Product 8.2
 
Posts: 3 | Location: Dallas, TX | Registered: May 28, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by drewtollenaar:
Thank you, MartinY! Your response was helpful - it appears to be all set up!


Please update your first post then add [SOLVED] at the beginning of the subject


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2165 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Setting up Alerts

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.