SAS Data Sets for SAS BI Dashboard

Specifying the Location of SAS Data Sets for SAS BI Dashboard

In order to enable the SAS BI Dashboard to read data from existing SAS data sets, you must specify the location of the SAS data sets in a .dsx file.
For a description of the .dsx files, including their location, see Working with Data Source XML (.dsx) Files.
To allow SAS data sets to be read by the SAS BI Dashboard, you can do any of the following:
  • Add data sets to the default library that is referenced in dboard_sas.dsx. By default, this library is created in SAS-configuration-directory\Lev1\SASApp\Data directory.
  • To reference a different library, in dboard_sas.dsx, change the <LibRefs> element so that it specifies the name and location of your library. For example:
    <LibRefs></LibRefs>
         <CommonLibRef>SASDATA</CommonLibRef>
    You can provide multiple statements, each separated by a semicolon.
  • Make a copy of dboard_sas.dsx and then reference a different library in the new file. If you make a copy of the file, follow these steps:
    1. Change the ID attribute of the <DataSourceDef> element. The ID attribute must match the name that you give the file, minus the .dsx extension.
      For example, if your new file is named myData.dsx, then the file contains the following element:
      <DataSourceDef id="myData"
      providerClass="com.sas.bi.dashboard.provider.JdbcProvider">
    2. Add the <text> element inside the <LocalizedText> element. For example:
      <LocalizedText id="name">
      <text>My Dashboard Library</text>
      </LocalizedText>
      In this example, the text “My Dashboard Library” is assigned to the myData data source.
      The name that you specify here appears in the list of available data sources when dashboard developers create or edit data models.
    3. Change the <LibRefs> element so that it specifies the name and location of your library.
      You can provide multiple statements, each separated by a semicolon.
    4. Store the new file in the same directory where dboard_sas.dsx resides.
  • After you make changes to any .dsx file, restart SAS BI Dashboard.