1KEY BI TOOL FEATURES
Brief overview of the tools available in the 1KEY Agile are described below
1KEY View is a two-dimensional, extremely intuitive report formatting and analysis tool for business users. It provides two-dimensional tables for runtime analysis, grouping and column customizations with Parent-Child Relationships, Drill Down and Drill Back functionalities, etc.
Key Features:
>> Multilevel View using different Data Sources
>> Filter Builder to design requisite reports
>> Style condition to highlight specific data
>> Advance View to drill down to root levels
1KEY Cube is a comprehensive data analysis, data mining, and visual reporting solution. With its powerful data architecture, this multi-dimensional tool is able to slice and dice information efficiently and provide customers with an extremely intuitive experience. 1KEY Cube enables multiple static information to be analyzed in a single report.
Key Features:
>>Grid View Structure for multi-dimensional reporting
>>Summary Variation for trend analysis
>>Interval Grouping
>>Dynamic and customized formula columns
1KEY Charts enables on the trot representation of business data in user defined charts for better data understanding and faster decision making.
Key Features:
>> Dashboards and visual representation of data
>> Drill Down access direct from graph
>>Conditional Runtime field
>>Different forms of graphical representation
1KEY Scheduler enables users to schedule their Reports for exporting to disk or delivering via email. It automates the complete process of reporting and avoids the cumbersome work of manually creating and/or delivering reports to respective business users on a periodic basis.
Key Features:
>>User-defined Frequency of report scheduling
>>Multiple report selection
>>Different export formats
>>Scheduler History
1KEY Query Designer enables you to use simple graphical interface to build SQL statements and create views in a database. It includes graphical panes displaying your SQL statement visually and a text pane displaying the text of your SQL statement. You can work in either the graphical or text panes.
Key Features:
>> Visual Interface to design queries
>> Creation of links with simple drag & drop functionality
>> Automatic SQL Statement Generation
>> Localization - option of specifying own parameters
>> SQL parsing - enter the SQL statement, and the diagram and grid gets populated
1KEY File Reader is a productive analysis tool for users who want to analyze internal/external data, which is not part of the core transaction system.
Key Features:
>> Analyze Local data available on individual desktops
>> Analysis and cube reporting for Text & Excel Files
>> Detailed analysis and Cube reporting for Excel
1KEY User Hierarchy enables creation of ‘secure’ enterprise-wide Business Intelligence & Reporting Infrastructure.
Key Features:
>> Role based security
>> Parametric Control of business information
>> Parameter mapped to the user hierarchy of the organization
