Adding Global Collections to Jaspersoft Ad Hoc reports

Document ID : KB000099245
Last Modified Date : 24/09/2018
Show Technical Document Details
Introduction:
Out of Box, CABI Jaspersoft does not have Global Collection option for Ad Hoc Reports. Global Collection as a drop-down for creating Ad Hoc reports must be added manually. This document shows how to do just that.
Instructions:
1. First step is to log into Jaspersoft as superuser. NOTE: This procedure will make changes to the Domains, or data sources for reports. These types of changes can only be done with the superuser account.
User-added image
2. Go to the Domains list.
view domains list

3.  Edit the Alarm Domain.
edit alarm domain

4. Go to Domain Designer
domain designer

5. With the Tables tab selected, move the v_dim_global_collections_member table from the left column over to the right. 
ad gc table

6. Go to the Joins tab. In the left side, find v_dim_device_model. On the right side, find v_dim_global_collection_member.
User-added image

7. Expand the tables and look for model_key on both left and right sides. Select each and click the "join" button.
device model key join
8. Do the same for v_dim_model and v_dim_interface_model. Join the model_key of v_dim_model and v_dim_global_collection_member model_key. Join the model_key of v_dim_interface_model with v_dim_global_collection_member model_key. 

9. Once joined, verify settings in the far right pane. Scroll to bottom.
model keys joined
10. Go to Display tab and Create a New Set. Edit the label to show "Global Collections", ID to show "global_collections" and Description to show "Global Collections".
display tab create new set

11. In Resources pane on the left, expand v_dim_global_collection_member, find "gc_name" and move over into the newly created "Global Collection" set. 
move over gc name

12. You can now click "OK" and "Submit" to save the changes. 

It should now be possible to add Global Collection as an option to any Alarm Domain Ad Hoc reports.

You can repeat the above process to add Global Collections to any other Domain, such as Asset Domain, Availability Domain, etc. 
Additional Information:
IMPORTANT NOTE: Please be aware that running the "Re-Deploy" option under OneClick web page > Administration > Report Manager > Jaspersoft Integration page will OVERWRITE changes made to Domains. If you are making the above changes to add Global Collections to Domains, then you want to back up Jaspersoft data in case "Re-Deploy" is run. You would then have to re-import your Jaspersoft backup and Domain edits. 

See Document ID: KB000095735 for more information regarding Jaspersoft content Export/Import procedure.