Working with Data Source XML (.dsx) Files

Understanding .dsx Files

DataSourceDefinition (.dsx) files reside on the SAS Content Server in the

SAS
                     Folders/System/Applications/BI Dashboard/SASBIDashboard 4.3/DataSourceDefinitions

directory. These .dsx files provide a central location in which you can specify data sources or optimize performance.

The following table provides a description of the .dsx files:

Summary of the .dsx Files

Filename	Description
dboard_sas.dsx	Defines a directory in metadata containing SAS data sets that can be read by the SAS Business Intelligence Dashboard using SQL queries. The SAS data sets are located in the SAS-configuration-directory`\Lev1\AppData\SASBIDashboard4.3\sas-datasets`. The SASDATA refers to a pre-defined library that maps to the directory SAS-configuration-directory`\Lev1\SASApp\Data`. You can modify this file to configure performance settings (caching).
infomap.dsx	Enables SAS BI Dashboard to use SAS Information Maps. Data modelers can specify information maps in order to read data. The only change that you might normally make to this file is to configure performance settings (caching).
omr.dsx	Defines the Table data source type.
stp.dsx	This file is deployed and used for data models associated with SAS Stored Processes. The `stp.dsx` file enables users to create indicator data from the output of stored processes. The stored process produces a result package as its output.

If a solution software such as SAS Strategy Management is installed and configured, a .dsx file is also installed. For example, SAS Strategy Management installs the spm.dsx file, which is used by SAS BI Dashboard 4.31.

Modify a .dsx File

To modify a .dsx File in SAS Management Console, follow these steps:

On the Folders tab in SAS Management Console, navigate to SystemAdministrationSAS BI DashboardSAS BI Dashboard 4.3DataSourceDefinitions.
In the right pane, right-click on the .dsx file.
Select Write Content to External File.
Edit the file that you exported, and save your changes.
Right-click and select Add Content From External File(s) or Directories.
Select the .dsx file you modified, and replace the previous .dsx file.
To enable these changes to take effect, restart your Web application server.