Overview

This sample will demonstrate how to use the SAS BI Lineage Plug-in to SAS^® Management Console to create a data set that contains a list of the reports in the BIP Tree folder in your metadata repository. That data set can be used as input to an information map, which, in turn, can can be used to create a report in SAS Web Report Studio 3.1. Administrators can use this method to see what folders and reports reside in the reporting structure, including personal user folders. The sample assumes that you have successfully installed the SAS BI Lineage Plug-in.

Scan the BIP Tree for Reports

1. In SAS Management Console, select BI Lineage ► New Scan to launch the Scan Wizard.



2. Click Next on the first wizard page and then enter a name and directory path for the new scan. This sample will scan for reports under the BIP Tree/ReportStudio/Shared/Reports folder.
3. Click Next and then Finish.
4. A message box lists the number of objects that will be scanned. Click OK to run the scan.

Export the Data Sets to an Existing Library

1. After the scan is complete, right-click on your scan output and select Export to Datasets to open the Library Selection dialog box.



2. In the Library Selection dialog box, select one of the Base SAS libraries that are defined in metadata and click OK.
3. A message box lists the data sets that will be exported. Click OK to continue the export.



4. The data set that will be used to create a list of reports is named ARTIFACTS. Import the ARTIFACTS data set into the library that you selected in step 2. In this sample, the selected library is BILineageScans.

   

Create a Report Using the ARTIFACTS Data Set

1. Open SAS^® Information Map Studio.
2. Insert the ARTIFACTS data set into a new information map.



3. Create a filter where the data item named Type is equal to Report.



4. Save the information map (so that you can modify its properties).
5. Open the Information Map Properties dialog box, and define the filter as a general prefilter.



6. Use the information map to create a SAS Web Report Studio Report. Notice that the report in this sample includes a group break by the metadata path.

Additional Documentation

For more information about the SAS BI Lineage Plug-in, see SAS Note 31182.

For a list of available documentation for SAS Information Map Studio, see http://support.sas.com/documentation/onlinedoc/ims/index.html

For a list of available documentation for SAS Web Report Studio, see http://support.sas.com/documentation/onlinedoc/wrs/index.html.

For a list of available documentation for SAS Management Console, see http://support.sas.com/documentation/onlinedoc/sasmc/index.html.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

This sample will demonstrate how you can use the SAS BI Lineage Plug-in to SAS Management Console to create a data set that contains a list of the reports in the BIP Tree. That data set can be used as input to an information map, which, in turn, can be used to create a SAS Web Report Studio report.

Type:	Sample
Topic:	Software Components ==> SMC Plug-in Query and Reporting

Date Modified:	2008-10-14 10:15:07
Date Created:	2008-10-09 14:31:09

Operating System and Release Information

Product Family	Product	Host	Product Release		SAS Release
			Starting	Ending	Starting	Ending
SAS System	SAS BI Lineage Plug-in	HP-UX	3.1		9.1 TS1M3 SP4
		AIX	3.1		9.1 TS1M3 SP4
		Windows Vista	3.1		9.1 TS1M3 SP4
		Microsoft Windows XP Professional	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Standard Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Enterprise Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Datacenter Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows NT Workstation	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Professional	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Datacenter Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Advanced Server	3.1		9.1 TS1M3 SP4
		Microsoft® Windows® for x64	3.1		9.1 TS1M3 SP4
		HP-UX IPF	3.1		9.1 TS1M3 SP4
		Linux	3.1		9.1 TS1M3 SP4
		Linux on Itanium	3.1		9.1 TS1M3 SP4
		Solaris	3.1		9.1 TS1M3 SP4
		Solaris for x64	3.1		9.1 TS1M3 SP4