In the Reports module, it is only possible to filter or view by a dimension collection if the collection has been published for reporting.
An administrator can enable reporting on a dimension collection by navigating to Config > Structure > Dimensions, selecting a dimension, and clicking the 'View collections' button. Setting a collection to 'Reporting only' or 'Reporting and assignment' will allow the collection to be used for reporting in the Reports module.