Make Your Reports More Active - Revision history

WikiSysop at 19:17, 25 February 2015

2015-02-25T19:17:14Z

← Older revision		Revision as of 19:17, 25 February 2015
Line 52:		Line 52:
	Return to [[PeopleSoft Users Companion Extras]]		Return to [[PeopleSoft Users Companion Extras]]

-	''The [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] is ~~short~~ Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''	+	''The [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] is a Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''

WikiSysop at 08:48, 18 February 2015

2015-02-18T08:48:09Z

← Older revision		Revision as of 08:48, 18 February 2015
Line 20:		Line 20:
	* Attachment URL - a link to an attachment held within the PeopleSoft system.		* Attachment URL - a link to an attachment held within the PeopleSoft system.
	* External URL, Free Form URL - for connecting to external systems.		* External URL, Free Form URL - for connecting to external systems.
		+
		+	==Adding a Link to a Page==

	If you click on the Component URL, you get a page which presents you with the following options:		If you click on the Component URL, you get a page which presents you with the following options:
Line 33:		Line 35:
	Once these items have been entered, you can then set up the connection between fields in the query and the fields that you would enter on the component search page. Without these values, the link simply sends you to that search page.		Once these items have been entered, you can then set up the connection between fields in the query and the fields that you would enter on the component search page. Without these values, the link simply sends you to that search page.

		+	==Connecting Query Data to the Page==
	To really get the most out of this feature, you will want each link to connect to something on that row. Time to use the buttons at the bottom of the page.		To really get the most out of this feature, you will want each link to connect to something on that row. Time to use the buttons at the bottom of the page.

WikiSysop at 08:18, 13 February 2015

2015-02-13T08:18:17Z

← Older revision		Revision as of 08:18, 13 February 2015
Line 48:		Line 48:

	Return to [[PeopleSoft Users Companion Extras]]		Return to [[PeopleSoft Users Companion Extras]]
		+
		+	''The [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] is short Kindle eBook packed with hints and tips on using the PeopleSoft web more effectively. Get your copy today.''

WikiSysop at 18:41, 10 February 2015

2015-02-10T18:41:06Z

← Older revision		Revision as of 18:41, 10 February 2015
Line 16:		Line 16:
	The screen will change, and you will get a screen with a set of links describing the different types of links you can use:		The screen will change, and you will get a screen with a set of links describing the different types of links you can use:

-	- Component URL - a link to a particular page - with keys supplied from the Query.	+	* Component URL - a link to a particular page - with keys supplied from the Query.
-	- Query URL - a link to another Query - if that query has prompts, you can supply those from the parent query.	+	* Query URL - a link to another Query - if that query has prompts, you can supply those from the parent query.
-	Attachment URL - a link to an attachment held within the PeopleSoft system.	+	* Attachment URL - a link to an attachment held within the PeopleSoft system.
-	External URL, Free Form URL - for connecting to external systems.	+	* External URL, Free Form URL - for connecting to external systems.

	If you click on the Component URL, you get a page which presents you with the following options:		If you click on the Component URL, you get a page which presents you with the following options:

WikiSysop at 18:39, 10 February 2015

2015-02-10T18:39:49Z

← Older revision		Revision as of 18:39, 10 February 2015
Line 16:		Line 16:
	The screen will change, and you will get a screen with a set of links describing the different types of links you can use:		The screen will change, and you will get a screen with a set of links describing the different types of links you can use:

-	Component URL - a link to a particular page - with keys supplied from the Query.	+	- Component URL - a link to a particular page - with keys supplied from the Query.
-	Query URL - a link to another Query - if that query has prompts, you can supply those from the parent query.	+	- Query URL - a link to another Query - if that query has prompts, you can supply those from the parent query.
	Attachment URL - a link to an attachment held within the PeopleSoft system.		Attachment URL - a link to an attachment held within the PeopleSoft system.
	External URL, Free Form URL - for connecting to external systems.		External URL, Free Form URL - for connecting to external systems.

WikiSysop at 18:38, 10 February 2015

2015-02-10T18:38:48Z

← Older revision		Revision as of 18:38, 10 February 2015
Line 1:		Line 1:
-	This page is additional information for readers of	+	This page is additional information for readers of the [[PeopleSoft Users Companion]]

	=Make Your Reports More Active=		=Make Your Reports More Active=
Line 46:		Line 46:

	Try it - I'll bet you will always want to make your reports more active.		Try it - I'll bet you will always want to make your reports more active.
		+
		+	Return to [[PeopleSoft Users Companion Extras]]

WikiSysop at 18:35, 10 February 2015

2015-02-10T18:35:38Z

← Older revision		Revision as of 18:35, 10 February 2015
Line 1:		Line 1:
		+	This page is additional information for readers of
		+
	=Make Your Reports More Active=		=Make Your Reports More Active=

WikiSysop: /* How do you add links to a Query? */

2015-02-10T18:29:18Z

How do you add links to a Query?

← Older revision		Revision as of 18:29, 10 February 2015
Line 21:		Line 21:
	If you click on the Component URL, you get a page which presents you with the following options:		If you click on the Component URL, you get a page which presents you with the following options:

-	Portal Name - leave blank to use the one in use by the system or find this in the URL - normally "EMPLOYEE" for HRMS.	+	* Portal Name - leave blank to use the one in use by the system or find this in the URL - normally "EMPLOYEE" for HRMS.

-	Node Name - leave blank or, in most cases, set to the local default node - click the search button and sort the results by default local node (double click the "Default Local Node" heading). There will be one node with the value "1" in this column - that's our man!	+	* Node Name - leave blank or, in most cases, set to the local default node - click the search button and sort the results by default local node (double click the "Default Local Node" heading). There will be one node with the value "1" in this column - that's our man!

-	Psc and content reference - at first leave these blank.	+	* Psc and content reference - at first leave these blank.

-	The Menu Name, Market, Component and Page can be obtained navigating to the page in question and pressing Cntrl-Shift-J.	+	* The Menu Name, Market, Component and Page can be obtained navigating to the page in question and pressing Cntrl-Shift-J.

	Once these items have been entered, you can then set up the connection between fields in the query and the fields that you would enter on the component search page. Without these values, the link simply sends you to that search page.		Once these items have been entered, you can then set up the connection between fields in the query and the fields that you would enter on the component search page. Without these values, the link simply sends you to that search page.

WikiSysop: Created page with "=Make Your Reports More Active= When asked for a new report, I often ask the question, "what will you do with the information?". The answer can often lead to an interesting disc..."

2015-02-10T08:16:13Z

Created page with "=Make Your Reports More Active= When asked for a new report, I often ask the question, "what will you do with the information?". The answer can often lead to an interesting disc..."

New page

=Make Your Reports More Active=

When asked for a new report, I often ask the question, "what will you do with the information?". The answer can often lead to an interesting discussion and explores what is really required.

With operational reports and exception reports, the answer is typically, "I take a look at the records and then decide on what needs to be done".

PeopleSoft Query has a great piece of functionality that can accelerate this process for the report recipient - drilling links (or Drilling URLs). A simple device - the ability to put a link straight to a page with all the relevant details. No more copy and paste, no more using a ruler to remember which lines have been checked. These links will also appear in the Excel output.

==How do you add links to a Query?==

Open your query, click on the "Expressions" tab, add a new expression.
You should now see the new expressions dialog. Select "Drilling URL" from the "Type" drop down (that normally starts with "Character").

The screen will change, and you will get a screen with a set of links describing the different types of links you can use:

Component URL - a link to a particular page - with keys supplied from the Query.
Query URL - a link to another Query - if that query has prompts, you can supply those from the parent query.
Attachment URL - a link to an attachment held within the PeopleSoft system.
External URL, Free Form URL - for connecting to external systems.

If you click on the Component URL, you get a page which presents you with the following options:

Portal Name - leave blank to use the one in use by the system or find this in the URL - normally "EMPLOYEE" for HRMS.

Node Name - leave blank or, in most cases, set to the local default node - click the search button and sort the results by default local node (double click the "Default Local Node" heading). There will be one node with the value "1" in this column - that's our man!

Psc and content reference - at first leave these blank.

The Menu Name, Market, Component and Page can be obtained navigating to the page in question and pressing Cntrl-Shift-J.

Once these items have been entered, you can then set up the connection between fields in the query and the fields that you would enter on the component search page. Without these values, the link simply sends you to that search page.

To really get the most out of this feature, you will want each link to connect to something on that row. Time to use the buttons at the bottom of the page.

The first of these is "Search Keys". This button produces a grid of the search keys for the page in question, you can then enter the fields or expressions from your query that you want to use to complete the search dialog. Just as when you complete a search page by typing in the values, you can leave some of the fields blank. If the keys are not complete, then the link will show the half completed search page, rather than taking you directly to the targeted page.

Note: in some versions of PeopleTools, you need to check the "Selection Flag" for the row of the grid you want to complete, otherwise the "Field Name" and "Key Values" get muddled.

The other button to use is the "Map Columns" button. This allows you to associate the link with particular columns in the output. You could have different links for different columns, but too many and confuse poor Yuri the User as to which link does what (was it Employee ID that took me to the Job page or was it Department ID?). If you do want to have many links from one query, you could add columns that describe where the link would take the user. You can also add the Drilling URL expression as a field, but they have a tendency to be very long and unwieldy.

Another way around this is to establish a mini convention - Employee ID always takes you to the Biographical Details, Employee Record Number takes you to Job page etc.

As seen before, you can also run another Query, show an attachment, or connect to another system. All this from the results which could be in HTML format, PDF or Excel. The Query could be scheduled and the Excel results emailed to the user - and so the spreadsheet reconnects the recipient with PeopleSoft - enabling them to continue the next step in the process seamlessly. Wow.

Try it - I'll bet you will always want to make your reports more active.