Metadata is the central hub to all SAS server products and provides the repository for the central source of truth. Here are some papers on how to get the best out of you metadata repository.

View SAS Forum Papers about Metadata

ABSTRACT

Promotion of metadata content is typically used to support movement across Development, Test, and Production environments. In SAS® 9.1.3, we provided tools for full repository promotion and partial promotion. In SAS® 9.2, these tools have been enhanced to streamline functionality and provide batch interfaces. SAS® Management Console will continue to provide interfaces for full repository replication and partial promotion via the export/import framework that exists in SAS 9.1.3 with the BI Manager plug-in. In SAS 9.2, we have implemented a batch interface for the partial promotion framework that will allow you to create a schedulable and repeatable process for moving a set of metadata content across your environments.

INTRODUCTION

IT infrastructure Library (ITIL) Service Support processes define “change control” as the process of controlling change, including requests for change, approvals, execution, and validation. “Change management,” on the other hand, is the process responsible for handling changes to IT infrastructure or IT services (Stickel 2005).

Change control is the process to coordinate changes to content in a given environment in a rational manner. Typically, organizations set up three environments: a playpen environment (Development), a quality assurance environment (Test), and a published environment (Production). Changes can be made in an ad hoc fashion in Development (DEV) and promoted to Test (TEST) for quality assurance. After the content is validated, the changes can be promoted to Production (PROD) for broad end-user consumption. Promoted content is usually not editable by end users, and any changes must go back through the DEV/TEST/PROD process.

With SAS® 9, the SAS® Metadata Server is at the core of the intelligence platform. The SAS Metadata Server facilitates the sharing of content across SAS applications to provide a consistent representation of the business to all constituents in your organization. As a result, it is critical that the information that is surfaced to end users in a production environment has been rigorously protected from the impacts of change. This paper focuses on “change control” for the SAS Metadata Server. This is intended for SAS system administrators who are familiar with the SAS® 9 architecture and the role that the metadata server plays. We focus on the tools available for promoting metadata.

Metadata Promotion in SAS 9.2

 

Metadata Server is the place to store the definitions of your "single source of the truth" and it is the hub of all SAS servers and tools. So get it right and you can rock, get it wrong and you will rol more than a dingy in a storm.

View a list of SAS Metadata Tips and Tricks 

The process of consolidating, relating and synchronizing data elements with the same or similar meaning from different systems. Metadata synchronization joins these differing elements together in the data warehouse to allow for easier access.

W

e are developing a full web service based way of querying and reporting on the SAS metadata.  This allows you to embed SAS metadata in any third party aplpicaton, for example another portal, wiki or sharepoint site.

a language used to specify other languages.

A system of principles, practices, and procedures applied to a specific branch of knowledge.

Micosoft Excel is the second most popular reporting tool (after SAS ;-) and there are lots of ways to pass SAS results to Excel.

View SAS Forum papers about Microsoft Excel Integration 

It aint quite Oracle, DB2, or Tearadata, but it is one of the quickest ways to get a database up and running. Here are some papers on how to integratie with Microsoft Access.

View SAS Forum Papers about Microsoft Access Integration

To be scalable, any particular implementation of the data access environment may incorporate several intermediate distribution tiers in the data warehouse network. These intermediate tiers act as source data warehouses for geographically isolated sharable data that is needed across several business functions.

A communications layer that allows applications to interact across hardware and network environments.

A communications layer that allows applications to interact across hardware and network environments.

the process by which frequently used items of data are moved to more readily accessible areas of storage and infrequently used items of data are moved to less readily accessible areas of storage.

OLAP on Multidimensional models. In MOLAP servers, Data warehouses directly store multidimensional data in special data structures(eg.,arrays) and implement the OLAP operations over these special data structures.

a chained file organization in which the chains are divided into fragments and each fragment is indexed. This organization of data permits faster access to the data.

a join in which the redundant logic components generated by the join are removed.

Need a SAS Mod?

 

We can build this for you.