Establishing and using a SAS data set as a BI Dashboard 4.2 source

A couple notes on how to set up and use a SAS dataset for a BI Dashboard Data Model.

1. The folder location (for TS2M2 installations) of dboard_sas.dsx is:
<config dir>\Lev1\AppData\SASBIDashboard4.2\dataSourceDefs\

2. The format for the libref change is LIBRARYName 'File Location'; LIBRARYName 'File Location';

Such as:
<LibRefs>BIDASH 'C:\SAS\Data\BIDashboard';</LibRefs>

Where BIDASH is my libref and the path is on the C: drive.

3. I had to restart the Object Spawner, Remote Services and jBoss to recognize changes to the above mentioned file (at least from my machine).

4. Generate a sql query in the Data Model Screen to grab the data tables in this location.

Note, no proc sql, semicolons, or run/quit statements are required. Included is an example:

select * from bidash.bartrend

Reference:

Online Documentation "Specifying the Location of SAS Data Sets for SAS BI Dashboard" http://support.sas.com/documentation/cdl/en/biwaag/63059/HTML/default/a003169350.htm

Blogs