[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Evaluate - When
- Subject: Re: [sqr-users] Evaluate - When
- From: rick.hansen@rsmi.com
- Date: Wed, 20 Apr 2005 10:20:24 -0500
- Delivery-date: Wed, 20 Apr 2005 10:20:57 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
By removing the lines when='D' and when'E', I believe you will actually
change the way this evaluate works.
It appears that the original author does not want anything to occur if D
or E. By removing the when's, then a D or E would fall into the OTHER
clause.
You would think that a break is needed but it appears that the when-other
is handled a little bit differently.
So, the question is: Should anything happen when D or E. If the answer
is no, then I would leave it alone or perhaps put a break after the
when='E' for better clarity. If the answer is, it should do the "other",
then you would want to remove the when's.
Rick Hansen
Sr. Application Systems Analyst
D - (563) 333-2321, F - (563) 324-0211
________________________________________________________________________________
This e-mail is only intended for the person(s) to whom it is addressed and
may contain confidential information. Unless stated to the contrary, any
opinions or comments are personal to the writer and do not represent the
official view of the company. If you have received this e-mail in error,
please notify us immediately by reply e-mail and then delete this message
from your system. Please do not copy it or use it for any purposes, or
disclose its contents to any other person. Thank you for your cooperation.
"radhika reddy" <radhika_05@hotmail.com>
Sent by:
sqr-users-bounces+rick.hansen=rsmi.com@sqrug.org
04/20/2005 10:09 AM
Please respond to "This list is for discussion about the SQR database
reporting language from Hyperion Solutions."
To: sqr-users@sqrug.org
cc:
Subject: [sqr-users] Evaluate - When
Hi,
I am having a problem with delivered SQR. It has Evaluate Statement
which
codes like the following:
Evaluate &Paygroup
when = 'A'
! processing A
break;
when = 'B'
when = 'C'
!processing B or C
Break;
when = 'D'
when = 'E'
when-other
! processing D or E or other
Break;
End-Evaluate
Here when the value of paygroup is B or C it goes into processing B or
C. But when the value is D or E it doesn't go to Processing D or E or
other.
I can remove the lines of code when = 'D' and when = 'E' . But before
making
changes to the delivered one, i would like to know is there any reason for
peoplesoft to code like this?
Any input would be appreciated.
Thanks.
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________
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