BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Tags

Articles tagged with: Metadata Answers

SAS Enterprise Guide: Best Practice for Centralized User Storage

2012-06-11 – 6:25 AM
Workspace Server Location

A nice feature of SAS Enterprise Guide is the “Files” folder.  This provides direct access to the file system where the workspace server is running.  You can take advantage of this by configuring a central location where users can store data, SAS code, CSV files, Excel files, or anything useful.  If this is not configured it defaults to a user-specific area.  In some cases this …

SAS Management Console: Quick Tip when Creating a Metadata Library

2012-02-03 – 6:53 AM
sas management console tip for SAS admins

Here’s a quick tip for SAS BI Administrators or anyone who has to create metadata library in the SAS Management Console.
Often before I define the metadata library I am at the folder or the physical path of the library.  Obviously, it’s critical that the path is defined correctly in the metadata.  So here’s my quick tip.

In the physical library, click or double-click the path and use the Ctrl+C keyboard …

Impact Analysis – “Hawk Eyes” of SAS Data Integration Studio

2011-12-21 – 5:30 AM
Diagram

Harsh Gajjar is SAS Business Intelligence (BI) and SAS Design Integration (DI) rising star in India. Today he is discussing how to use the SAS DI Studio Impact Analysis feature.
 
As we have observed majorly in large enterprises, particularly the Banking and Finance sectors, there is always a huge amount of data building up every day. Moreover, one cannot ignore the fact that every observation in …

SAS Enterprise Guide: Updating the Metadata with New/Modified Datasets

2011-12-12 – 7:35 AM
sas eg metadata lib step3

When working in SAS Enterprise Guide, you can access data from the metadata libraries. When you make changes to the datasets in the meta library, such as adding or modifying columns, or even deleted datasets, the metadata library does not have the data – it must be registered.  Argh – so frustrating especially if you are use to working with the normal SAS  libraries.  However, you …

A Place of Your Own … from the SAS BI Administrator

2011-10-17 – 2:00 AM
My Folder

When the SAS BI Administrator adds a new user to the SAS BI system, a personal folder called “My Folder” is created for the user.  Each user can create sub folders and store BI content (such as reports, stored processes, and so on).   Users cannot make any other changes to the folder, such as changing the permissions (that’s naughty!).
In the SAS Management Console, all …