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.
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:
-
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">
-
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.
-
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.
-
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.