Member Login

E-mail:    Password:  




 TitleDate AddedCompany
whitepaper Visual Display of Large Data Volumes2009-03-22
  Many organizations have huge amounts of data, containing hundreds of millions of records. There are good solutions available for the purpose of collecting, organizing and consolidating data, but people still struggle with presenting the data in a useful way. When trying to make use of the data, details are often sacrificed for overview, or the big picture is missed when small sets of breakdowns are investigated. Panopticon can display the millions of records from one's data repositories with fantastic overview in combination with full details. Panopticon delivers value without doing data warehouse acquisition procedures (ETL - Extracting, Transforming, and Loading) from source systems.

Tags: Data Tools		   
whitepaper Have It Your Way: Rearrange and Replay Your Output With ODS DOCUMENT2009-03-20 SAS Institute
  Is everything about the SAS output the way one wants, except for the final order of the report objects? Does one want the output organized by year or by city, instead of by SAS procedure, without using SAS macro programs? Does one like the order that SAS produces, but one just want to change the folder hierarchy? This paper illustrates how to capture the output and save it in an ODS document store. Then, one can create custom folders and a custom folder hierarchy using ODS DOCUMENT and PROC DOCUMENT to rearrange and replay the output.

Tags: Data Tools		   
whitepaper Tethys Solutions Case Study: MediaRing2009-03-14 Tethys Solutions
  MediaRing, a leader VoIP service provider, is headquarted in Singapore, with offices in Sunnyvale (USA), Tokyo, Shangai, Beijing, Hong Kong, Taiwan, Kuala Lumpur and Cambodia. The company needed to access reliable and accurate competitive information, specifically pricing structures and promotional activity in a consistent, cost effective and timely manner. The company deployed Automation Anywhere's SMART Web extraction tool which intelligently extracts the competitor information from the internet and converts the data into .xls/ .csv file and then sends it as an email or update to the company database.

Tags: Data Infrastructure		   
whitepaper Web Data Extraction / Data Integration for Small Business2009-03-14 Tethys Solutions
  SME Customer Service, Inc. (SMECS) is an Oklahoma-based small business that offers debt and judgment collection services for large and small businesses individuals. The company wanted to accurately retrieve data on past due accounts from clients website and transfer to/update Excel spreadsheet for collections agency. The company deployed Automation Anywhere which runs different batch files of varying length-from minutes to hours-daily and weekly to capture up-to-date information about past due accounts.

Tags: Software Development Tools		   
whitepaper Proc Format, a Speedy Alternative to Sort Sort Merge2009-02-27 Wells Fargo
  Many users of SAS System software, especially those working with large datasets, are often confronted with processing time challenges. How can one reduce the amount of CPU required to retrieve specific data? In this paper, an "Outside the box" approach using a matching method utilizing Proc Format replaces the CPU heavy Sort/Sort/Merge. It is ideal for situations when a key from one file is needed to extract data from another file. It is more apparently useful when at least one of the files is quite large. This method has been proven time and again to decrease CPU by 70%-80% and is effective on all platforms utilizing Base SAS.

Tags: Software Development Tools, Data Tools		   
whitepaper Distribution Interruption Performance Reporting: A Complete Solution2009-02-27 SAS Institute
  Most electrical distributors are required to report on the performance of their distributed electrical networks. These measures are required at operational and strategic levels within utilities. Distribution Network Interruption Performance Reporting is the standardized reporting of measures that reflect the performance (reliability) of an electrical distributed network. The measures used for reporting network performance is guided by several international industry standards e.g. Institute of Electrical and Electronics Engineers (IEEE) and International Council on Large Electric Systems (Cigre). This paper aims to give the electrical utility industry an insight into standardization of reporting distribution interruption performance indices by conforming to international standards.

Tags: Data Tools		   
whitepaper Implementing CDISC When You Already Have Standards: A Case Study2009-02-27 SAS Institute
  How one chooses to implement CDISC will be based on current company standards and their robustness, the amount of control one has at each step of the data flow process, one's time vs. resource needs, and one's willingness to change. The author began by implementing CDISC between data collection and analysis. That is, data will be collected in non-CDISC structures, but one will use SDTM and ADaM for analysis, reporting, and filing to FDA. This allows one to file the same data to FDA that the author has used himself in analysis, without having to do extra work at the time the submission is being prepared. This paper will describe what they've done and are still doing to implement CDISC.

Tags: Data Tools		   
whitepaper Manipulating OLAP Cubes: Advanced Techniques for SAS Programmers2009-02-27 SAS Institute
  As the amount of data that is captured electronically increases exponentially, more and more organizations are turning to OLAP Cubes as a way to surface data in a meaningful way. OLAP, or Online Analytical Processing, provides a multi-dimensional view of aggregated data. It provides quick and easy access to facts, figures and statistics and gives the user the flexibility to change the view of the data to hone in on the aspects that are most pertinent to them. This paper will focus on how SAS Programmers can also take advantage of the benefits of storing data in OLAP cubes.

Tags: Data Tools, Data Tools		   
whitepaper Severn Trent Plc Transforms Performance Management With Business Intelligence Without Boundaries2009-02-01 Oracle
  Severn Trent Plc wanted to capture and store five to six million daily readings from telemetry systems monitoring assets such as pipes, treatment plants, pumps, and pressure-flow meters and deliver timely, relevant data on asset health and process performance to more than 400 regional and business managers. The challenge was to cut time and overhead needed to comply with regulatory reports required by the Environment Agency and Ofwat. Severn Trent Plc worked with Oracle Partner Edenbrook to pull asset performance data from telemetry systems and multiple sources into Oracle Database and used Oracle Warehouse Builder to extract, transform, and load information into a two-terabyte data warehouse on a daily basis.

Tags: Data Tools, Data Tools		   
whitepaper Oracle Warehouse Builder Tips and Tricks: Advanced Data Transformations2009-02-01 Oracle
  Oracle Warehouse Builder 11g, the tenth major release of OWB, delivers a rich ETL, data warehousing and data quality feature set that enhances productivity and contributes to project success while lowering total cost of ownership compared to non-Oracle products. This whitepaper looks at advanced data transformation capabilities of Oracle Warehouse that offer compelling value in particular use cases: matching and merging of data, pivoting and unpivoting transformations, advanced aggregation, and DML error logging for advanced error handling. As in any tips and tricks paper, the focus here is on practical applications of the feature set.

Tags: Data Tools