MicroStrategy ONE

Downloading and viewing multimedia files: Multimedia widget

You can allow users to browse and view files in a web folder, such as documents, images, and videos, using a Multimedia widget. When viewed on a mobile device, the Multimedia widget displays a list of available files, along with information about each file, including the file name, description, and file type. Users can tap the Download icon next to a file displayed in the widget to download and view the file. When the mobile device is offline, users can view files that have been downloaded and automatically stored on their mobile device. Files that have not been stored on the mobile device are grayed out and cannot be viewed offline.

Users can view the following types of files using the Multimedia widget:

  • Audio and video files
  • ePub files
  • Excel
  • HTML
  • Image
  • PDF
  • Plain text
  • PowerPoint
  • Word

PDF files are displayed in-app using a native PDF reader.

Prerequisites

Before creating a Multimedia widget, you must perform the following tasks:

  • Create the document in which to insert the Multimedia widget.
  • Configure an XQuery database instance to retrieve web folder contents. For steps to configure this database instance, see the Custom SQL Queries: Freeform SQL and Query Builder chapter in the Advanced Reporting Guide.
  • Create an XQuery report to use to access the web folder that contains the files to display in the widget. Add the XQuery report as a dataset report in the document. For steps to create the XQuery report, see the Custom SQL Queries: Freeform SQL and Query Builder chapter in the Advanced Reporting Guide.

To create and configure a Multimedia widget

  1. In MicroStrategy Web, open the document in Design or Editable Mode.

  2. From the Dataset Objects panel on the left, click and drag the dataset report to the area of the document in which to display the widget. The attributes on the Grid/Graph of the dataset report should be displayed in the following order:

    • MW_URL
    • MW_Name
    • MW_ModifiedOn
    • MW_ModifiedOnText
    • MW_DBIGUID
    • MW_ThumbnailURL
    • MW_Description

  3. Right-click the dataset report, then select Properties and Formatting. The Properties and Formatting dialog box opens.

  4. From the left, click Widget.

  5. From the Widget drop-down list, point to Mobile, then select Multimedia.

  6. Click OK to save your changes and return to the document.