Some firms have looked at SAS/Warehouse Administrator and decided to continue developing applications in the traditional way. Why? Reasons include high investment cost, difficulty of incorporating legacy code, and the awkwardness of using terminal emulators when running SAS/Warehouse Administrator on a server located in a "Glass room" or other remote location. However, if one can overcome these objections and let SAS/Warehouse Administrator write the required SAS code, the advantages of metadata take over. This paper illustrates how a data mart is modeled in SAS/Warehouse Administrator, drawing upon a prototype that the author recently created.
Did you find this white paper useful?
22 out of 42 users found this white paper useful
Related white papers
Office Business Application Custom Workflow Solution Connects Business Activities, Improves Data Access, and Analysis
Microsoft Entertainment and Devices (E&D) created an Office Business Application (OBA) using capabilities in the 2007 Microsoft Office system to more easily access and use business intelligence about every facet...
Junk Removal Service Finds Gold With Microsoft Dynamics CRM Online
1-888-TRASH-IT! wanted a CRM system that could capture, share, and use customer data specific to the company's operations to improve customer acquisition and retention. Company managers evaluated five CRM systems...
MSDN Webcast: Demystifying Office Business Applications for the Developer (Level 200)
This webcast provides an introductory look at how to build and deploy Office Business Applications (OBAs), specifically focusing on what and the how. It discusses Microsoft Office client application customization,...
SH Electric Power Improves Data Analysis and Reporting With Integrated Data Warehouse
The Shanghai Municipal Electric Power Company (SH Electric Power) handles the transmission, distribution, and sale of electrical power in Shanghai. A major challenge under the Business Information (BI) project was...
TransMilenio S.A. Integrates Information Systems and Improves Operation of Mass Transit System
TransMilenio S.A. wanted to improve the design, programming, and operation of the city's mass transit system and provide self-service IT capabilities and up-to-date information to enable more informed management decisions....
Fujian Unicom Simplifies Database Management With Help From Neusoft Group Limited
Fujian Unicom is a wholly owned subsidiary of China Unicom, one of the four major telecommunications carriers in China. One of the biggest challenges facing Fujian Unicom was how to...
Ceska lekarna Achieves a Permanent Increase in Profitability With Key Performance Indicators
Ceska lekarna wanted to enable central management of business activities with detailed sales analysis of the data that was previously stored in local database and manage inventory mix and levels....
