PeopleSoft Books - Revision history

WikiSysop: /* Transforming Your PeopleSoft Query */

2016-12-15T21:21:28Z

‎Transforming Your PeopleSoft Query

WikiSysop: /* Transforming Your PeopleSoft Query */

2016-12-15T21:20:48Z

‎Transforming Your PeopleSoft Query

WikiSysop: /* Transforming Your PeopleSoft Query */

2016-12-15T20:23:20Z

‎Transforming Your PeopleSoft Query

WikiSysop: /* Transforming Your PeopleSoft Query */

2016-12-15T20:22:53Z

‎Transforming Your PeopleSoft Query

WikiSysop: /* Transforming Your PeopleSoft Query */

2016-12-15T20:21:43Z

‎Transforming Your PeopleSoft Query

WikiSysop: /* Using Functions in PeopleSoft Query */

2016-12-14T18:46:14Z

‎Using Functions in PeopleSoft Query

WikiSysop: 1 revision imported

2016-03-25T08:51:03Z

1 revision imported

WikiSysop: /* Using Functions in PeopleSoft Query */

2015-08-18T20:17:04Z

‎Using Functions in PeopleSoft Query

New page

== Using Functions in PeopleSoft Query ==

{| class="wikitable"
|-
|[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg|190px|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]]

|Amazon Kindle: [http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query]

At the heart of a PeopleSoft Query is a SQL query. Knowing some extra tricks with SQL functions will go a long way to extracting the exact results you need.

But isn't SQL hard? So completely difficult that only Einstein after 3 Red Bulls could possibly stand a chance of putting a query together? This book aims to dispel this myth and help you increase the number of tasks you can complete with PeopleSoft Query.

Harness the power of PeopleSoft Query using the database (both Oracle and SQL Server), use this book to take the raw Query results and fashion them.
|}

== PeopleSoft Users Companion ==

{| class="wikitable"
|-
|[[File:PeopleSoftUserCompanion.jpg|190px|link=http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24]]

|Amazon Kindle: [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion]

This book is packed full of hints and tips for users of the Oracle PeopleSoft applications. The hints and tips can be applied to HR, Campus, Financials and CRM.

The Oracle PeopleSoft applications are very versatile and powerful. A little knowledge of tricks and techniques can help you make more of the system, and get things completed faster.

These tricks will save you time - some every day, some occasionally. Some ideas you may have been vaguely aware of, but not seen how they can be used.

|}

== Peoplesoft for the Oracle DBA ==

{| class="wikitable"
|-
|[[File:Book1.png]]

|Amazon: [http://www.amazon.co.uk/gp/product/1590594223?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=1590594223 Peoplesoft for the Oracle DBA]

This is an excellent text for PS Admins and developers that want to know more about what goes on under the covers.

* Background of how PeopleSoft makes use of particular Oracle database features.
* Understanding the PeopleSoft Application Server - covers how the Oracle Tuxedo transaction monitor is used by PS App Servers.
* Performance Monitoring - techiques for understanding the many traces and logs and understanding what they mean.
* Performance Tuning - Some tricks and techniques for improving the performance of various components of PeopleSoft.

|}

== PeopleSoft Developers Guide for PeopleTools and PeopleCode ==

{| class="wikitable"
|-
|[[File:Book2.png]]

|Amazon: [http://www.amazon.co.uk/gp/product/0071496629?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=0071496629 PeopleSoft Developer's Guide for PeopleTools & PeopleCode]

A good all round how-to guide - covers:

* Building a page in Application Designer.
* Writing PeopleCode
* Building processes in Application Engine and SQR
* Reporting in XML Publisher.

|}

== PeopleSoft PeopleTools: Tips and Techniques ==

{| class="wikitable"
|-
|[[File:Book3.png]]

|Amazon: [http://www.amazon.co.uk/gp/product/0071664939?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=0071664939 PeopleSoft PeopleTools Tips & Techniques]

A text of best practices and some expert tricks and techniques such as:

* Using object orientated Application Packages.
* Add AJAX to your pages to reduce network round trips
* Using Java from within PeopleCode
* Extending Integration Broker with home grown connectors

A great source book!

|}

@@ Line 3: / Line 3: @@
 {| class="wikitable"
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|228px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|226px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Amazon Kindle: [http://bit.ly/PS_XSLT_BOOK Transforming Your PeopleSoft Query]

@@ Line 3: / Line 3: @@
 {| class="wikitable"
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|230px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|228px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Amazon Kindle: [http://bit.ly/PS_XSLT_BOOK Transforming Your PeopleSoft Query]
-Make your PeopleSoft Queries truly come to life! Using the Transformation tab of PeopleSoft Query, you can now create formatted reports. You can turn your query results into HTML that could be used in a pagelet. You can add summaries, counts and headers to your results. Or you could create a Microsoft Excel spreadsheet with formatting and formulae to decrease or remove manual polishing afterwards.
+Make your PeopleSoft Queries truly come to life! Using the Transformation tab of PeopleSoft Query, you can now create formatted reports.
 |}

@@ Line 3: / Line 3: @@
 {| class="wikitable"
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|210px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|230px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Amazon Kindle: [http://bit.ly/PS_XSLT_BOOK Transforming Your PeopleSoft Query]

@@ Line 3: / Line 3: @@
 {| class="wikitable"
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|190px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|210px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Amazon Kindle: [http://bit.ly/PS_XSLT_BOOK Transforming Your PeopleSoft Query]

@@ Line 3: / Line 3: @@
 {| class="wikitable"
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|90px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|190px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Amazon Kindle: [http://bit.ly/PS_XSLT_BOOK Transforming Your PeopleSoft Query]
@@ Line 9: / Line 9: @@
 Make your PeopleSoft Queries truly come to life! Using the Transformation tab of PeopleSoft Query, you can now create formatted reports. You can turn your query results into HTML that could be used in a pagelet. You can add summaries, counts and headers to your results. Or you could create a Microsoft Excel spreadsheet with formatting and formulae to decrease or remove manual polishing afterwards.
-|}== Using Functions in PeopleSoft Query ==
+|}
 {| class="wikitable"

← Older revision		Revision as of 18:46, 14 December 2016
Line 1:		Line 1:
−	== Using Functions in PeopleSoft Query ==	+	== Transforming Your PeopleSoft Query ==
		+
		+	{\| class="wikitable"
		+	\|-
		+	\|[[File:Transform-PeopleSoft-Query.JPG\|90px\|link=http://bit.ly/PS_XSLT_BOOK]]
		+
		+	\|Amazon Kindle: [http://bit.ly/PS_XSLT_BOOK Transforming Your PeopleSoft Query]
		+
		+	Make your PeopleSoft Queries truly come to life! Using the Transformation tab of PeopleSoft Query, you can now create formatted reports. You can turn your query results into HTML that could be used in a pagelet. You can add summaries, counts and headers to your results. Or you could create a Microsoft Excel spreadsheet with formatting and formulae to decrease or remove manual polishing afterwards.
		+
		+	\|}== Using Functions in PeopleSoft Query ==

	{\| class="wikitable"		{\| class="wikitable"

← Older revision	Revision as of 08:51, 25 March 2016
(No difference)