PS Query Transformations - Revision history

WikiSysop: /* Other Links */

2017-05-08T06:15:49Z

‎Other Links

2016-12-28T18:54:10Z

2016-12-28T18:53:29Z

2016-12-28T18:47:56Z

2016-12-28T18:47:28Z

2016-12-28T18:46:13Z

2016-12-28T18:45:39Z

2016-12-28T18:43:55Z

2016-12-28T18:42:22Z

2016-12-28T18:26:45Z

← Older revision		Revision as of 06:15, 8 May 2017
Line 49:		Line 49:

	Return to [[PeopleSoft Query]]		Return to [[PeopleSoft Query]]
		+
		+	* [http://www.springboardsolutions.com/peoplesoft/Getting-More-Out-Of-PeopleSoft-Query.zip UKOUG15 Presentation: Getting More Out of PeopleSoft Query]
		+	* [http://www.springboardsolutions.com/peoplesoft/Transforming-Your-PeopleSoft-Query.zip UKOUG16 Presentation: Transforming Your PeopleSoft Query]
		+
		+	[[PeopleSoft Users Companion Extras]]

@@ Line 1: / Line 1: @@
 Using the Transformations tab within [[PeopleSoft]] [[PeopleSoft Query|Query]], you can create files of the following types:
-[[File:Sample-Report.PNG|400px|thumbnail|link=http://bit.ly/PS_XSLT_BOOK|Sample "Transformed" HTML Report]]
+[[File:Sample-Report.PNG|350px|thumbnail|link=http://bit.ly/PS_XSLT_BOOK|Sample "Transformed" HTML Report]]
 * Text format - e.g. CSV, fixed columns

@@ Line 7: / Line 7: @@
 * XML - e.g. SpreadsheetML (to produce formatted Excel spreadsheets).
-A single PeopleSoft Query can have multiple transformations attached to it. When scheduling the Query, you can decide which transformation will be used to format the output.
+A single PeopleSoft Query can have multiple transformations attached to it. When scheduling the Query, you can decide which transformation will be used to format the output. Within Query itself, you can view previews of the transformed output, but these only use the first 50 rows of the Query.
 The Transformations tab uses the XSLT language (eXtensible Stylesheet Language - Transformations) - a specialised language for transforming XML documents into other formats (or further XML).
-Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the XML file format for pagelets is slightly different from Query. However, both can be processed using XSLT (eXtensible Stylesheet Language - Transformations).
+You still have all the processing capabilities of SQL in Query, and then you can add formatting using XSLT.
-−
 You still have all the capabilities of SQL in Query, and then you can add formatting using XSLT.
-−
-−
-−

@@ Line 1: / Line 1: @@
 Using the Transformations tab within [[PeopleSoft]] [[PeopleSoft Query|Query]], you can create files of the following types:
-[[File:Sample-Report.PNG|200px|thumbnail|link=http://bit.ly/PS_XSLT_BOOK|Sample "Transformed" HTML Report]]
+[[File:Sample-Report.PNG|400px|thumbnail|link=http://bit.ly/PS_XSLT_BOOK|Sample "Transformed" HTML Report]]
 * Text format - e.g. CSV, fixed columns

@@ Line 1: / Line 1: @@
 Using the Transformations tab within [[PeopleSoft]] [[PeopleSoft Query|Query]], you can create files of the following types:
-[[File:Sample-Report.PNG|200px|frame|link=http://bit.ly/PS_XSLT_BOOK|Sample "Transformed" HTML Report]]
+[[File:Sample-Report.PNG|200px|thumbnail|link=http://bit.ly/PS_XSLT_BOOK|Sample "Transformed" HTML Report]]
 * Text format - e.g. CSV, fixed columns