DATA MANAGEMENT USING APPARO FAST EDIT

Using Apparo Fast Edit gives you the possibility of changing and maintaining data within Cognos-Reports and Cognos-Portals.

You can reuse the data input because all data is stored in a free definable database table.

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, 2000, 2003, 2008
• Linux, Oracle Solaris, IBM AIX
• IBM Websphere 7 and Tomcat (default)
• IBM Cognos BI
• Windows with Active Directory without IBM Cognos BI

Supported data sources

• Oracle 9i, 10g, 11g
• MS SQL Server 2000, 2005, 2008
• IBM DB2 8, 9.5
• Sybase ASE / IQ
• Informix
• Teradata

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, Servlets, JSF, JSP, JS, CSS, Ajax