Please enable JavaScript to view this site.

QPR Knowledge Base 2019.1

Navigation: AfMO Training Guide

Loops

 Scroll Prev Top Next More

In this chapter, we will repeat the measure page created in the Tags topic for all measures under the Customer and Process perspectives. By using loops, it is possible to repeat some content, for example tags, for all the members of some set, for example all the scorecards in a set of scorecards.

 

mouse_24 Exercise 5: Create a Loop That Repeats the Measure Page Created in the Tags Topic for All Measures Under the 'Customer' and 'Internal Processes' Perspectives.

 

BTN_AR131. Open the designed report document that was created in the Tags topic.
BTN_AR132. Select both tag holders in the document:

pic_tag_holders_selected

 

BTN_AR133. On the QPR tab of the ribbon, click btn_insert_loop Insert Loop and select "Selected Objects". The Insert Loop pane opens.
BTN_AR134. Select "QPR Metrics Models" from the 'Search From' drop-down menu and expand the hierarchy by clicking the btn_expand_model_hierarchy button:

pic_insert_loop_search_from_expanded

 

BTN_AR135. Select 'QPR Add-In for Microsoft Office Training Model' from the list:

pic_insert_loop_search_from_selected

 

BTN_AR136. From the 'Scope' drop-down menu, expand the hierarchy by clicking the btn_expand_model_hierarchy button, and uncheck everything else but 'Company scorecard':

pic_insert_loop_scope

 

BTN_AR137. Make sure that the 'Include References' check box is unchecked.
BTN_AR138. Click the Search button.
BTN_AR139. From the Search Results, select 'Marketing Costs' and click Add:

pic_insert_loop_add_marketing_costs

BTN_AR1310. Add also the 'New leads', 'On-time delivery (%)', 'Customer satisfaction', 'Number of individual customer feedbacks', and 'Number of reclamations' measures:

pic_insert_loop_measures_added

 

BTN_AR1311. Click the Insert Tags button.
BTN_AR1312. Notice how the FullIds in the tags are replaced by the 'object' variable defined in the first tag:

pic_insert_loop_fullid_before

Before

 

pic_insert_loop_fullid_after

After

BTN_AR1313. On the Home tab of the ribbon, right-click 'Heading 2' and select 'Modify...'. The Modify Style dialog opens.
BTN_AR1314. From the Format drop-down menu, select 'Paragraph...'. The Paragraph dialog opens.
BTN_AR1315. Switch to the 'Line and Page Breaks' tab.
BTN_AR1316. Select the 'Page break before' check box
BTN_AR1317. Click OK to close the Paragraph dialog, and again OK to close the Modify Style dialog.
BTN_AR1318. Make sure only the '[Property: Name]' tag holder in the document is selected, and on the Home tab of the ribbon click 'Heading 2'.
BTN_AR1319. Save the document. It will be used later.
BTN_AR1320. On the QPR tab of the ribbon, click btn_publish Publish and define a name and a location to the report. The report is then created and it should show the measure graphs with their names, each on their own page:

pic_insert_loop_published

 

For more information, see the Loops topic in QPR Add-In for Microsoft Office - User's Guide.