If we need to vote, why not set up one of those surveys on their page. We have done that for voting on SQR classes, etc. That would get the feedback without...
2851
Barb Van Horn
barb.vanhorn@...
Sep 1, 2000 12:50 pm
Performance issues aside, I believe there is a physical limit of 15 tables for query. However, you can create views to get around this....
2852
snafissi@...
Sep 1, 2000 1:13 pm
Try this: Go to Utilities-Use-Query Security and you will see Maximum joins allowed which a 9 means unlimited. ....just my 2 cents worth. Sina ... From: Barb...
2853
ktulucsa@...
Sep 1, 2000 4:06 pm
Hi all. How can I print SPF without SQR Viewer? Error Printer say: Cannot open the printer file: \\xxx\printer.spf (2) No such file or directory. How I can...
2854
SEEMA POWAR
seepow@...
Sep 1, 2000 4:06 pm
Hi I am working on the Expense WorkFlow ..The expense sheets are not self-approved ..so here I have a case where the Triggering panel is different from the...
2855
Coulthard, John
jcoulthard@...
Sep 1, 2000 4:06 pm
I am chiming in, I would be interested in participating in the Study Group. ... From: Bryan deSilva [mailto:improvisations@...] Sent: Thursday,...
2856
rwright@...
Sep 1, 2000 4:06 pm
Actually, whether or not you can get around the limit by using views depends upon the database. DB2/400 limits you to x number of joined tables including those...
2857
gary.asuncion@...
Sep 1, 2000 4:06 pm
Walt- Actually, we just want to stop/restart the process scheduler in the same batch. If the process scheduler goes down during off hours for some reason, we...
2858
Stephen Keen
stephen_keen@...
Sep 1, 2000 4:06 pm
Hello Kathy, There are a maximum number of tables you can join, but not one based on performance. Performance will be based on indexes, network performance,...
2859
Amy Harvel
aharvel@...
Sep 1, 2000 4:06 pm
Could we please do that? I just wanted to know how other classify their DBA - not generate a huge controversy!! ______________________________ Reply Separator...
2860
gary.asuncion@...
Sep 1, 2000 4:27 pm
Hi- To my knowledge there's two ways to do it without SQR viewer: 1) Run the process to a *.lis file instead of an *.spf file. Print that file from DOS...
2861
Jenny Mckeon
mckeon@...
Sep 1, 2000 4:27 pm
Another way to get around the limit might be to join as many tables as possible (up to the limit) in your first select, inserting the retrieved rows into a...
2862
Ginny Dugan-Earley
vduganea@...
Sep 1, 2000 4:27 pm
We are using a product called Check-Eze. We evaluated them and Bottomline. Bottomline had many more features and seemed easier to use. Check-Eze was a lot...
2863
Ginny Dugan-Earley
vduganea@...
Sep 1, 2000 4:28 pm
We've told our users "not more than 5", but it really depends on the tables they're using. If they join 5 tables that all have large amounts of data, the...
2864
Barb Van Horn
barb.vanhorn@...
Sep 1, 2000 4:33 pm
Another note on performance. We have security turned on so anytime you use the Personal Data, Job Data or Employees tables you can plan on going to lunch...
2865
mahonj@...
Sep 1, 2000 5:47 pm
True. We use views to those 3 very primary hr tables so that query doesn't include the security views in the where clause. I believe Peoplesoft delivers...
2866
Sreeni Reddy
sreenireddy@...
Sep 1, 2000 5:47 pm
Hi Cathy The Maximum Table joins in Quary is database specific. I think for Oracle you can go upto 15 table joins. Like Bryan rightly said, one will have ...
2867
Jeff Hill
jhillohio@...
Sep 1, 2000 5:47 pm
Good afternoon all. I am investigating the use of Multiple Component functionality in PS 7.5. If anyone has used this, I'm interested in finding out how it...
2868
Marrette, Lee
lee.marrette@...
Sep 1, 2000 11:45 pm
Hi all, When we run a Crystal Report from PeopleSoft, we are now getting a Crystal window asking for the same report parameters we entered on the PeopleSoft ...
2869
plavert2@...
Sep 2, 2000 7:02 pm
Remember if you are doing this with PS Query you are losing some joins to security tables that query does automatically, and there may be others I forget. Paul...
2870
joanne_gray2000@...
Sep 4, 2000 5:14 pm
Is anyone familiar with a listserv that was created specifically for sharing training materials? It was created following this year's higher ed sig. Thanks!...
2871
pquarnstrom-judkins@...
Sep 4, 2000 5:15 pm
I was wondering if anyone out there is using Essbase with Peoplesoft HR. I have seen it used and associated with financials system but not HR. If you do use...
2872
Bryan deSilva
improvisations@...
Sep 4, 2000 5:20 pm
John: This one (SQR) or the next? Bryan ... From: sentto-1271405-778-967824384-improvisations=compuserve.com@... om ...
2873
Bryan deSilva
improvisations@...
Sep 4, 2000 5:31 pm
Hello everyone, and welcome to the 15th week of our eStudy Group! Please start a thread with the heading "SQR-15 your topic here" as described in the study...
2874
Bryan deSilva
improvisations@...
Sep 4, 2000 6:00 pm
Joe: Did you get my last message? I’ve not used them and it doesn’t seem as if many have. Perhaps it would be a good exercise to get one a try. Have you ...
2875
Barb Van Horn
barb.vanhorn@...
Sep 5, 2000 5:36 pm
We would like to start using self-service. However, I can't find any information on how the security is handled. Do we have to set up an entry in Security...
2876
snafissi@...
Sep 5, 2000 5:54 pm
Hi there, Open up your Crystal reports process-definition within Process-Scheduler. Then go to the middle panel: Process-Definition-Options and there you will ...
2877
Amy Harvel
aharvel@...
Sep 5, 2000 5:56 pm
Check your process definition - is it set to append the values from the run control panel? ______________________________ Reply Separator...
2878
dewhite@...
Sep 5, 2000 5:57 pm
Hi Bryan, Joe, & whoever is left of the study group! I am really still interested in participating, but this 7.51 upgrade has made it virtually impossible to...
2879
Joe Johnson
jej1216@...
Sep 5, 2000 5:57 pm
Apologies for the double post to two groups - Here is my problem: I am trying to set up an SQR to run on the server daily at 7AM. The SQR sets the record...
