[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR problem
- Subject: [sqr-users] SQR problem
- From: Sanjay Sambhe <ssambhe@cisco.com>
- Date: Tue, 2 Jan 2007 10:54:42 +0530
- Authentication-results: sj-dkim-7; header.From=ssambhe@cisco.com; dkim=pass (sig from cisco.com/sjdkim7002 verified; );
- Delivery-date: Tue, 02 Jan 2007 00:31:10 -0500
- Dkim-signature: v=0.5; a=rsa-sha256; q=dns/txt; l=5066; t=1167715705;x=1168579705; c=relaxed/simple; s=sjdkim7002;h=Content-Type:From:Subject:Content-Transfer-Encoding:MIME-Version;d=cisco.com; i=ssambhe@cisco.com;z=From:=20Sanjay=20Sambhe=20<ssambhe@cisco.com>|Subject:=20SQR=20problem |Sender:=20;bh=+UgMDD3o+/FEEXvpuGwabcdKJUBwv1uyTtZMLMrFlcA=;b=oEX8mjDmminVKYhl1F9IDZd48EJScLPDKEKG48Lih7qmD50elQE7K1j3gY93uJnsU/9jgPygO65a/2Ycv33VYw5ZvXKug7kp/P5co/ba/1NSLCoed4QkpaIpc32Mh/NS;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AccuLk46zqKA0h5HR6+B93qWjGdDoA==
Hi all,
while debugging, I have came accross one statement in SQR i.e
[PS_CS_EMPL_EVT_T01 X : $e.cs_event_view_name].
Here both are the record names. $e.cs_event_view_name is view in PS which is
dynamically selected in another procedure.
Can anybody please explain what is the logic behind this?
BEGIN-SELECT
X.EMPLID &x.emplid
X.CS_EVENT_TYPE &x.cs_event_type
TO_CHAR(trunc(X.CS_EVENT_ENTRY_DT),'YYYY-MM-DD')
&x.cs_event_entry_dt
TO_CHAR(trunc(X.CS_EVENT_EFFDT),'YYYY-MM-DD') &x.cs_event_effdt
X.CS_PRIORITY_FLAG &x.cs_priority_flag
X.CS_EVENT_PARAM &x.cs_event_param
show 'Processing Employee: ' &x.emplid ', Event: ' &x.cs_event_type ',
Effdt: ' &x.cs_event_effdt
show '&x.cs_priority_flag ' &x.cs_priority_flag ',&x.cs_event_param '
&x.cs_event_param
do Insert-Employee-Event
FROM
[PS_CS_EMPL_EVT_T01 X : $e.cs_event_view_name]
WHERE
not exists (select * from ps_cs_wr_tbl where emplid = x.emplid) and ( !**
entire line for Transition project **
(X.CS_EVENT_EFFDT between trunc(SYSDATE)-{RECENCY_DAYS} and
trunc(SYSDATE)+#future_days)
OR
(X.CS_EVENT_ENTRY_DT >= trunc(SYSDATE)-{RECENCY_DAYS} AND
X.CS_EVENT_EFFDT <= trunc(SYSDATE)+#future_days)) !** ) For
Transition project **
END-SELECT
Thanks and Regards,
ss
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users