Apparo Fast Edit (Keywords:
data management, data input, commentate reports)
DATA MANAGEMENT USING FAST EDIT
Using FAST EDIT gives you the possibility of changing and maintaining data within Cognos-Reports and Cognos-Portals.
FAST EDIT is completely integrated into the Cognos-Environment.
It is using the Cognos security and the same user interface design.
Your Cognos Support remains fully intact.
Operational areas
- Data administration, e.g. master data
- Manual input of: Plan data, characteristic numbers, facts, single data items
- Import of large amounts of data direct from Excel to Cognos8/ReportNet
- Commentary to Controlling reports (Report versions)
- Enter plan data and immediately evaluate
- Examine data quality and rectify incorrect entries
- Maintain Keys/Codes (Classification lists in DWH, SAP or other vendors’ systems)
Top features
- Defining input masks without programing
- Cognos security based editing of data
- Using Cognos user interface design
- Excel data import with copy & paste
- File import with mouse click
- Multi language support
- Optional: clustering for high availability
Using Apparo Fast Edit you do not require a new application for the editing of data
- Apparo Fast Edit is web-based and completely integrated in Cognos8 / CRN
- Excel files can be imported in order to speed up manual input and avoid input mistakes
- The input masks are specified in the Cognos Connection portal
- Defining of new edit masks do not require much development time
With Fast Edit you can maintain data in your cognos portal
- It’s easy to define – the buisness department can define the business cases
- It’s easy to use – Fast Edit has the same user interface like Cognos
- It’s fully integrated – use the security features of Cognos
Your data is safe
- Fast Edit users can edit data of defined database tables only
- Fast Edit is using the database and the cognos security
Your new data is proved
- Each input field (widget) accept valid values only – interval test, user exit java class test
Fast Edit is your Excel interface to your Data Warehouse
- User can import data with copy & paste from Excel to Fast Edit
- User can import the data of complete CSV Files
- Fast Edit can automatically import CSV Files
Flexible output Organisation
- Representation as a data table
- Alternative: Representation as a single data record integrated into a report in ReportStudio
- Can be called up via a Link in Cognos Connection or in a ReportStudio report.
- Support of Master/Detail relationships
- Security based output of widgets
Supported environments
- Windows XP and 2003
- IBM Websphere 6.0.2 and Tomcat (default)
- Cognos ReportNet 1.1 MR2/MR3 and Cognos 8.1.2 MR2
Supported data sources
- Oracle 9i, 10g
- MS SQL Server 2000/2005
- IBM DB2 8
- Sybase ASE / IQ
- Informix
- eradata
System architecture
Fast Edit is installed in a own tomcat server or as a own Websphere application.
All definitions are stored in a database repository.
Used frameworks: Spring, Hibernate.
Technology: Java 1.4, Servlets, JSF, JSP, JS, CSS, Ajax