[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Subscription to Exceptions

Subject: RE: [sqr-users] Subscription to Exceptions
From: "Steve Cavill" <steve.cavill@infoclarity.com.au>
Date: Sat, 10 Jul 2004 15:31:29 +1000
Delivery-date: Sat, 10 Jul 2004 00:34:13 -0500
Importance: Normal
In-reply-to: <OF2A9051A1.283826CB-ON65256EC9.00352528-65256EC9.0036904F@lntinfotech.com>
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>

Hi Darshil,
i don't think exception.default=off is a valid string in your
output.properties.   If you don't want an exception, don't write to the
file.
e.g.
 if #cnt_total > #temp
     print 'Exception: Prodline has changed' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has changes'
     close 0
  else
     print 'Exception: Prodline has NO changes ' (1,1)
     !don't create output.properties
  end-if

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
Behalf Of Darshil Mehta
Sent: Tuesday, 6 July 2004 7:55 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Cc: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.;
sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
Subject: RE: [sqr-users] Subscription to Exceptions


A minor correction in code. In else part, I have changed
exception.default=off from exception.default=on.

 if #cnt_total > #temp
     print 'Exception: Prodline has changed' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has changes'
     close 0
  else
     print 'Exception: Prodline has NO changes ' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=off'
     write 0 from 'exception.default.text=Prodline has NO changes'
     close 0
  end-if

Now this code works perfectly on portal. Whenever there is exception,
exception dashboard shows exception. Otherwise it does not.

But when I do following, I do get mails:

On brio portal, under subscription:

- Click subscribe to 'Subscribe to output from <report name>'
- Click 'Only subscribe to exception item'
- Attach output from <report name> to email message

If I don't do above action, I don't get mails. And if I do above action, I
still get mails even there is no exception.

Thanks,
Darshil






"Steve Cavill" <steve.cavill@infoclarity.com.au>
Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
06/07/2004 12:03 PM
Please respond to "This list is for discussion about the SQR database
reporting       language from Hyperion Solutions."


        To:     "This list is for discussion about the SQR database
reportinglanguage from
Hyperion Solutions." <sqr-users@sqrug.org>
        cc:
        Subject:        RE: [sqr-users] Subscription to Exceptions


Your sqr code will ALWAYS generate an exception:
 if #cnt_total > #temp
     print 'Exception: Prodline has changed' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has changes'
     close 0
  else
     print 'Exception: Prodline has NO changes ' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has NO changes'
     close 0
  end-if

The exception is either "Prodline has changes", or "Prodline has NO
changes"

so I think the portal is working correctly.  If one of the above
conditions
is NOT an exception, then don't create the output.properties file for that
condition.

Cheers, Steve.

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
Behalf Of Darshil Mehta
Sent: Tuesday, 6 July 2004 2:08 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Cc: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.;
sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
Subject: RE: [sqr-users] Subscription to Exceptions


Sorry for the confusion !!!

Let me put it this way.

I do get mails when I do following:

On brio portal, under subscription:

- Click subscribe to 'Subscribe to output from <report name>'
- Click 'Only subscribe to exception item'
- Attach output from <report name> to email message

If I don't do above action, I don't get mails. And if I do above action, I
still get mails even there is no exception.

I hope this is more clear.

Darshil





"Steve Cavill" <steve.cavill@infoclarity.com.au>
Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
06/07/2004 07:19 AM
Please respond to "This list is for discussion about the SQR database
reporting       language from Hyperion Solutions."


        To:     "This list is for discussion about the SQR database
reportinglanguage from
Hyperion Solutions." <sqr-users@sqrug.org>
        cc:
        Subject:        RE: [sqr-users] Subscription to Exceptions


Now I'm confused.  Below you say you are getting the email, but earlier
you
said you are not getting the email.  Do you mean you are getting the email
whether there is an exception or not, and that you DO NOT want to get a
message UNLESS there is an exception?  In which case your setup below
looks
correct.
Steve.


-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
Behalf Of Darshil Mehta
Sent: Monday, 5 July 2004 10:26 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Cc: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.;
sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
Subject: RE: [sqr-users] Subscription to Exceptions


I checked both. I get emails whenever do following:

On brio portal, under subscription:

- Click subscribe to 'Subscribe to output from <report name>'
- Click 'Only subscribe to exception item'
- Attach output from <report name> to email message

My object's life is 500 mins.

Is there any code that I have write in .sqr file to get email
notifications only whenever there is exceptions?

Thanks,
Darshil





"Steve Cavill" <steve.cavill@infoclarity.com.au>
Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
30/06/2004 05:52 PM
Please respond to "This list is for discussion about the SQR database
reporting       language from Hyperion Solutions."


        To:     "This list is for discussion about the SQR database
reportinglanguage from
Hyperion Solutions." <sqr-users@sqrug.org>
        cc:
        Subject:        RE: [sqr-users] Subscription to Exceptions


Do you get an email if you just subscribe to the report without
exceptions?
Do any other subscription emails work?
You need to see which is failing, the detection of the exception, or the
sending of the email.
Steve.


-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
Behalf Of Darshil Mehta
Sent: Wednesday, 30 June 2004 6:58 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Subscription to Exceptions


All,

I have one SQR report in which I have written following code:

  if #cnt_total > #temp
     print 'Exception: Prodline has changed' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has changes'
     close 0
  else
     print 'Exception: Prodline has NO changes ' (1,1)
     open 'output.properties' as 0 for-append record=32767:vary
     write 0 from 'exception.default=on'
     write 0 from 'exception.default.text=Prodline has NO changes'
     close 0
  end-if

When I publish this report on Brio Portal with option 'Can have
exception', I can see proper exceptions on my Brio Portal dashboard. But
when I schedule it with email notification, I do not receive any email
regarding exception.

Can anyone suggest what could be the problem? Thanks in advance.


Best regards,

Darshil Mehta


______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

______________________________________________________________________




______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

______________________________________________________________________




______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

______________________________________________________________________




______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

References:
- RE: [sqr-users] Subscription to Exceptions
  - From: "Darshil Mehta" <Darshil.Mehta@lntinfotech.com>

Prev by Date: RE: [sqr-users] Using the LET functions Isnull orNvlwithCHARorVARCHAR database columns
Next by Date: [sqr-users] Remote connection
Previous by thread: RE: [sqr-users] Subscription to Exceptions
Next by thread: [sqr-users] Various printing types in the same program
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page