Administering SAS BI Dashboard

Working with Data Source XML (DSX) Files

Beginning with SAS Dashboard 4.3, DSX files reside on the SAS Content Server in the SAS Folders/System/Applications/BI Dashboard/SASBIDashboard 4.3/DataSourceDefinitions directory. Previously, these files resided in the file system. 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 the 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	Beginning with SAS BI Dashboard 4.3, 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.3.

Modify a DSX File

Beginning with SAS BI Dashboard 4.3, DSX files are stored in the SAS Content Server.

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

On the Folders tab in SAS Management Console, navigate to System Administration SAS BI Dashboard SAS BI Dashboard 4.3 DataSourceDefinitions.
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.

Top of Page