[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] naming multiple reports
- Subject: RE: [sqr-users] naming multiple reports
- From: "Jamie Harris" <jharris@frederick.edu>
- Date: Sat, 29 Jan 2005 12:17:56 -0500
- Delivery-date: Sat, 29 Jan 2005 12:17:38 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
That might work, but I think I'll just stick with the default names. :)
Thanks though.
-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------
>>> steve.cavill@infoclarity.com.au 01/28/05 7:23 PM >>>
Yes that is a problem if the command line is too long.
Maybe you could modify the Process Scheduler SQR execution script to
rename
the .lis files after SQR has finished?
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 Jamie Harris
Sent: Saturday, 29 January 2005 9:13 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] naming multiple reports
What if you had multiple reports "open" at once and needed to be able to
use
the "use-report" command to go between them?
I have a report that produces a report of successes, a report of errors
and
a report of warnings. Each row of data could potentially be one of the
three, so I can't simply process all of report 1's data then say
"new-report" to start the next one.
I haven't been able to find a way to do that without specifying with -f
all
the different names and the path to put them in (which results in a
command
line that's too long for the Peoplesoft process scheduler).
Any thoughts?
-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------
>>> jwomeldo@fastenal.com 1/28/2005 12:18 PM >>>
Use the New-Report command as described in this document:
http://www.ontko.com/sqr/sqrcard4.html
-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Susan
Haberman
Sent: Friday, January 28, 2005 10:26 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] naming multiple reports
Hi,
I am trying to name multiple reports instead of using the default naming
convention reportname_instance_#.lis
In the process scheduler manager>use>process definitions>override
options I
have tried several options:
1) Parameter List: Append -MR 5 -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis This sqr runs successfully but uses default
name.
2) Command Line: Append -MR 5 -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis and
Command Line: Override -MR 5 -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis and
Parameter List: Append -MR 5
Command Line: Append -FDedReg.lis -FLibMut.lis -FCombFnd.lis
-Fcwufcu.lis -Fwsecu.lis
These processes error with the following message: Process Request shows
status of 'INITIATED' or 'PROCESSING' but no longer running
Has anyone successfully managed to rename the output files? We are
running
Oracle on a Unix server.
Thanks for your help!
_______________________________________________
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