Skip to main content
OCLC Support

How do I create a report to show Duplicate titles in different Shelving location?

Applies to
  • WorldShare Reports
  • Report Designer
Answer

You can create a report by using the Report Designer in Analytics and by using the LHR Item Detail Universe and by adding in a subquery filter.
 

Steps to create this report:
 

1. Go to Analytics > Reports > Report LaunchPad.

2. Select Application > Web Intelligence > New > Universe > OK.

3. Select LHR Item Detail Universe > OK.

4. Select the Result objects (what you want to see in your report);
     You can either double-click on each of the required objects or drag it across to the Result Object box for them to appear.

5. Select the Title folder > OCLC number > Double click on the Report Object.

6. Select the Title folder > Title > Double click on the Report Object.

7. Select the Title folder > Author Name > Double click on the Report Object.

8. Select the LHR Item Detail folder > LHR Control number > Double click on the Report Object.

9. Select the LHR Item Detail folder > LHR Item Branch Name > Double click on the Report Object.

10. Select the LHR Item Detail folder > LHR Permanent Shelving Location > Double click on the Report Object.

11. Select the LHR Item Detail folder > LHR Item Barcode > Double click on the Report Object.

12. Select the Measures folder > LHR Item Count.

 

Now you need to set the special filter to bring in all Titles  with more than only 1 Holding (LHR):

  1. Select OCLC number in the Report objects box, so highlighted
     
  2. Select the Add a Subquery icon at the top of the Query Filters box.

    clipboard_e18001a221bcfc52fead643098b3a2142.png
     
  3. Select the Title folder > OCLC number > and drag it across into the filter box

    clipboard_e720496e222238491b17de088f94144f5.png
     
  4. Select the Measures folder > Select the LHR Item Count > drag next to where in the sub-query box

    clipboard_ef508dbbecc18eee5d35eda91fd248d02.png
     
  5. Select Greater than & type 1.
     
  6. Select Refresh to see what data will be pulled in.
  7.  If satisfied with the data being returned, select Run Query.

  8. To stretch out the columns, hover the mouse pointer near the blue column edges and drag sideways.

  9. You can export your report to Excel, using the export options.

  10. You should always save these created reports in your 2.0 Folder giving them a name that helps you remember what it was created for.

Additional information

Export your Report 

Page ID
39460