Update Library Metadata via EG GUI Interface

Instead of writing proc metalib statements, SAS has a custom task that you can download into Enterprise Guide. This interface provides non-SAS coders a quick mechanism to register new tables created on the server to the Metadata Library. http://www.sas.com/apps/demosdownloads/setupcat.jsp?cat=SAS+Enterprise+Guide

Immediate Changes to Security for your SAS BI Installation

The initial installation of a SAS Metadata Server allows for all undefined (in SAS User Manager) users to have access. It is recommended (after testing the entire install & before deploying to the business) that the security defined in the ‘Users & Permissions’ tab of the Default ACT is modified to the following layout:

Identity	RM	CIM	Admin	Create	WM	R	W	Delete
SAS System Services (saswbadm, sastrust)	G
SAS Administrator (sasadm)	G	G	G	G	G	G	G	G
PUBLIC	D	D	D	D	D	D	D	D
SASUSERS	G				G	G
Portal Admins	G			G	G	G	G	G

Note – Denying all access to Public will then REQUIRE that all individuals are defined in the SAS User Manager. *All defined users in the SAS User Manager fall into the ‘SASUSERS’ group. The above Default ACT settings will then allow defined users Read Metadata, Write Metadata and Read on all SAS Objects.

No DI for Impact Analysis? Use the BI Lineage Plug-in to search for metadata inconsistencies.

Just wanted to let everyone know of this new (but still experimental) functionality in SAS Management Console: An experimental SAS Management Console plug-in is available in 9.1.3 called BI Lineage. The following Sample document provides an overview of the tool, with screenshots on it's use: http://support.sas.com/kb/33/574.html This SAS Note provides documentation on installing the plug-in, as well as a link for download: http://support.sas.com/kb/31/182.html