KB221639: “Join Derived Elements from different reports are not supported” displays when using a media widget showing a video in a Report Services Document in MicroStrategy Web 9.4.1 Hotfix 6

SYMPTOM:
Users encounter the following error message in both Express and Interactive mod of a Report Services Document, when attempting to play a video in a media widget in Strategy Web 9.4.1 Hotfix 6:

 Join Derived Elements from different reports are not supported

1. Create a blank document.
2. Create a grid inside of the new document’s panel stack.
3. Go to the grid Properties and Formatting > Widget.
4. Select the Media widget and click OK.

5.  Run the dashboard in Flash mode to configure the video URL.

6. Attempt to run the document in Express or Interactive mode.

 
CAUSE:
This is a known issue in Strategy Web 9.4.1 Hotfix 6.
 
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
 
WORKAROUND:
Use an HTML container to display the video in Strategy Web 9.4.1 HF6. This object can be found under the “Insert” menu. The content of the html container should include the code found under most video sharing options for Embedding. e.g.

<iframe src="https://player.vimeo.com/video/108792063" width="500" height="281" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>