KB46818: How to retrieve the list of multisource reports that depend on an MDX cube.

When right clicking on an MDX cube under Data Explorer and selecting "Search for Dependents...", we will get the list of dependent MDX reports. However, multisource reports will not be part of that list. The steps below describe how to obtain the list of dependent Multisource reports:

• Right-click the project name and select “Search for objects…”
  
• In the New Search window, go to Tools menu > Options and enable the following options:
   
  a. Show ‘Contains’ and ‘Contained by’ tabs
   
  b. Display Managed Objects
   
  

• Go to the Contains tab. Select “At least one of the selected objects” and press “Add…”
   
  

• Search for the cube under the relevant Data Explorer.
  
• Double click on the cube name: the metrics folder and the cube hierarchies will appear. In order to find the cube dependent reports, we will need to add all the metrics and attributes contained in each hierarchy.
   
  

• Once every metric and attribute within the cube is added, click OK and “Find Now”, the dependent objects will appear below: