Data Access Studio Value

Data Access Studio™ - Analysis of Value

Overview

Data Access Studio™ is a feature-rich data-browsing and report-writing tool. Using this software, a user with no programming experience can produce a wide array of Columnar and Cross-Tabular reports. The user sees the report data as the user formats the report. This approach is significantly easier than the Enterprise Report Writer (ERW) model. Consider the following comparison:

Data Access Studio™ report writing model:

Design ► Run ► Save

Enterprise Report Writer model:

Create UBE ► Design ► Code ► Debug ► Checkin ► Define, Build, Deploy Package ► Run ► Repeat

Data Access Studio™ is not a replacement for Enterprise Report Writer (ERW and UBE). ERW provides many features that are valuable to an Enterprise such as: programming support, batch processing, and server-side processing. Data Access Studio™ supplements ERW’s functionality by providing an easier method to produce ad-hoc reports as shown above.

Data Access Studio™ lowers your cost

Consider how much time and money you spend writing reports with your current system:

How long does it take to train each of your users?
How long does it take to get from concept to report?
What are the losses to your operation that result from these costs?

Part of the quality offering of Data Access Studio™ is that it reduces your reporting creation costs:

By providing a simpler reporting solution for most of your needs, Data Access Studio™ lets you spend more time on your business and less time on the reporting tool.

Data Access Studio™ versus Universal Table Browser

The following table is a side-by-side comparison of Data Access Studio™ (DAS) features vs. JD Edwards Universal Table Browser (UTB):

Feature	DAS	UTB
Display data in tables	■	■
Re-size, re-order columns	■	■
Load data without tying up the user interface	■	■
Cancel button cancels load at any time	■	■
Filter with wildcards	■	■
Filter with blanks	■	■
Sort any set of columns	■
Display data in business views	■
Summarize data	■
Add column totals	■
Group by any set of columns	■
Show collapsed summaries	■
Multi-column operations	■
Landscape/Portrait printing	■
Multiple paper sizes	■
Print preview	■
Zoom/View multiple pages at a time	■
Copy multiple rows to file	■
Copy multiple rows to the clipboard	■
Drag-and-drop rows from DAS to third-party applications	■
Columns displayed by Description, Alias, SQL Name, or Long Data Item Name	■
Hide and show columns	■
Change fonts, colors, lines	■
Save, restore, delete layouts	■
Filters as you type	■
Filter with ranges	■
Filter with list of values	■
Filter with distinct values	■
Number of records shown for every query	■
Go to buttons: top, previous page, next page, bottom	■
Progress bar shows percentage of records read	■
Summary, column, index, and join information	■
Open OLE DB and ODBC compliant tables	■
Snapshot data	■
Compare snapshot to any environment	■
Edit snapshot data	■
Search and replace snapshot data	■
Index assistant that identifies and makes use of available indexes.	■
Calculate columns	■
Lookup related data on-the-fly	■
Dynamically link to Excel	■
Create business view on-the-fly	■