How do I create a report that shows both circulation activity and item details such as Publication Date?
Applies to
- WorldShare Reports
- Report Designer
Answer
You will need to have Report Designer (the Report Launch Pad) to create this report. It requires two universe to be merged, so the different types of data can be combined and produced in the one report.
This type of report is useful, if wanting a report to use for stocktaking or weeding purposes, if you haven't used the Inventory option.
Steps:
Create the Circulation Item status Report first
- Go to Analytics > Reports > Report Launch Pad.
- Go to Application > Web Intelligence > Select New > Universe > OK.
- Select the Circulation Item Status Universe.
- Drag and Drop Data Elements from the Yellow folders you wish to have in this report into the Reports Object field .
- Select data elements such as , Item Branch Name, Item OCLC Number , Item Title, Item Barcode, Item Current Status , Item Title.
- Then select Item last issued Date from the Dates/Time folder and then from the Measures folder select Item Issued Count.
- Add in your filter the time frame you wish to use for Item last issued Date using the options Between or Less than , Greater than .
- Use Refresh to check the data that is being brought in to ensure it is what you require.
- Select Run Query > results will be displayed > you can adjust the column widths as required.
Now create the Second universe to be merged - (LHR Item Detail )
- Click on the icon to Edit Data Provider. The query panel will appear.
- Click on Add Query from the universe and choose the LHR Item Detail Universe.
- Bring in the objects you’d like to use from this Universe. Item barcode (is required) Publication Date.
- Note one of the objects chosen must also be in the other Universe to ensure a match can be made - such as item Barcode.
- Click Run Queries.
- Choose to Include the result objects in the document without generating a table.
- Merge the queries by going to Data Access > Data Objects > Merge.
- Choose Item Barcode from the Query 1 , hold down Ctrl, and click Item Barcode from Query 2 > OK.
Now you need to create a New Variable to get the Publication Date added to & displayed in this report.
To create the new Variables for the data you want to see in this report, do the following :
- From the icons on the left, select the Select the Available objects icon > scroll down to Variables.
- Right click on Variables > New.
- Under Qualification select Detail.
- To create the new variable e.g. Published Date type a unique name for this variable, such as this one (one that does not already exist in the databases - can't use Publication Date.
- For the Associated Dimension > Item barcode (merged dimension) from the drop-down list.
- To create the required Formula type = [Query 2]. then select the correct Available Object from the list below of available objects (it needs to be the associated matching object, in this case it would be Publication Date.
- You can check you have written the query correctly by selecting the ‘green tick’ to test.
- Select OK.
- Select the new variable under the Variables folder > Published Date and drag into a new column where you want it to display.
- Save As with a name that reminds you what it reports on and save to your institutions folder.
- Export to Excel to reorganize any column you require ordered.