---
description: View data from multiple sources in a dynamic, consolidated table.
---

# Multisource

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2F4kfNo9bAL6pq3YCnBjNX%2Fimage.png?alt=media&#x26;token=4bd96b8d-ab3f-4a41-aadb-1d9ca05ff6f7" alt=""><figcaption></figcaption></figure>

### Getting Started

Access **Multisource Reports** from the navigation panel. The Multisource Report page will show a list of the saved reports that you have permission to view, and your recent searches.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FIHt3UPxWgMONcsxHol2l%2Fimage.png?alt=media&#x26;token=7ba8941e-266c-4751-b9f6-d9e1a18de7c9" alt=""><figcaption></figcaption></figure>

To create a new Multisource Report, click <mark style="color:purple;">**+ REPORT**</mark>. This will give you the option of a Assembly report or a List report. To create an Assembly report you will enter a Part Number and a Multisource Report will be generated based on that part and all of its child-parts (i.e., its Bill of Materials). To create a List report you will choose a connected entity-type and property-type, and a multisource report will be generated based on that property-type. For example, you could create a list of all ION Purchase Orders based on Purchase Order Number.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FKYvUdtaYXUDqPwvXDvCB%2Fimage.png?alt=media&#x26;token=411ecc54-e4af-4a31-b50f-aa009c333c4c" alt=""><figcaption></figcaption></figure>

Once you've selected your Assembly Part Number or List Property, you must select the additional properties you wish to populate your report with. The properties you choose are the ones that will be queried when generating the report, and can be selected as columns or referenced in Custom Column equations. While you can choose as many properties as you want, choosing only the properties you need will allow your report to load faster and make the table easier to organize. Click <mark style="color:purple;">**APPLY**</mark>, and the report will be generated. By default, the columns will be grouped by App and Entity Type.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2Fgb3vf0V5eeCfHBM0ROkO%2Fimage.png?alt=media&#x26;token=95ccf57c-4627-480c-9c1f-351bc757a70c" alt=""><figcaption></figcaption></figure>

Once you've created the report, you can re-arrange or remove columns using the "Columns" panel to the left of the table. You can also drag, re-size, re-order, and filter the columns using the column title blocks in the table.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FASPqutag1TsFD1lUAssO%2Fimage.png?alt=media&#x26;token=d82aa090-269c-4282-96fa-50a8559c386a" alt=""><figcaption></figcaption></figure>

You can add or remove property columns, view a list of saved Multisource Reports, save the current Multisource Report, create a chart based on the data in your report, or download your report using the icons above the table.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2Fz8rzorPmDlWfnviLYnDQ%2Fimage.png?alt=media&#x26;token=59f13a57-462b-4bd7-80d9-c9af65d34934" alt="" width="563"><figcaption></figcaption></figure>

You can also view the table in condensed form, remove subrows, apply a quantity multiplier to the BOM you've selected, and show the report on your Dashboard.

<figure><img src="https://2091741164-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvrraExym8pNEUvBDoima%2Fuploads%2FSzgepQXfXMzGuxAosMhQ%2Fimage.png?alt=media&#x26;token=74d1ab64-b647-4582-8f5e-1710b7405fd6" alt="" width="316"><figcaption></figcaption></figure>

Saved Multisource Reports, or Explorations, can be made private or public depending on who needs access to the report. The Exporations will retain their formatting and will immediately refresh with updated data the next time you or one of your teammates opens them. To return to the main Multisource Reports page, click on <mark style="color:purple;">**Multisource Reports**</mark> in the top-left corner of the window.

### What are Violet Explorations?

A Violet Exploration allows you to save and share views, capturing your chosen layout and sorting preferences for the data table. Saved views retain your tailored settings, enabling seamless access to specific data configurations whenever needed. Violet Explorations are available on the [Data Explorer ](../data-explorer)and Multisource Reports pages.

<mark style="background-color:purple;">**Creating Explorations**</mark><mark style="background-color:purple;">:</mark> Click the save button above the table to create a Violet Exploration. You will be asked to provide a name and address whether your teammates should have view/edit permissions to your Violet Exploration. Should you make additional changes after saving, click on the save button once more to lock them in for future use.

<mark style="background-color:purple;">**Viewing Existing Explorations**</mark><mark style="background-color:purple;">:</mark> Select an existing Violet Exploration by clicking the folder icon above the table. Should you navigate to other pages on Violet and later return to the Multisource Reports page in the future, we will automatically open the most recently viewed exploration on your behalf.
