LyciaBI Reporting Overview
All organizations with or without 4GL applications use reporting in one form or another. As a result, reporting is considered a mission critical core business intelligence (BI) need and applications used for reporting are usually the main BI applications in use.
User Roles
Depending on the role permission of the user, LyciaBI Reporting allows you to easily access, format, and deliver information to anyone or to the selected users only.
Security
With secure authentication and connection, LyciaBI Reporting delivers any information securely to end-users by providing client access via Lycia 4GL Client System, web-based browser, e-mail and via database driven report storage.
Data Access
LyciaBI Reporting provides access to information in your 4GL application and relational, OLAP, or XML-based data sources.
LyciaStudio
Reports can be created from within LyciaStudio using the professional and market leading tools - BIRT and Jasper graphical report designers. Those offer rich design interfaces for professional report developers and business analysts who need to create detailed and pixel-perfect professional looking reports. Business Intelligence resource synchronisation and management can also be handled in LyciaStudio or using the web-based LyciaBI Server Administration Tool.
BIRT and Jasper Reports
LyciaBI includes the two market leading reporting tools: BIRT and Jasper Reports. Both established themselves as the IT-Reporting-Standard for small to medium up to enterprise business reporting. They both offer a rich designer interface with extremely powerful design capabilities for developers and users who need full control over all design aspects of a report:
- Rich graphical designer for power users and business analysts
- Wizard-based report creation to build pixel-perfect reports in minutes
- Extremely flexible design layouts and conditional formatting capabilities including conditional expressions
- Powerful report selections, data source prompting and passing within 4GL or standalone with dynamic population of selections and default values
- Rich preview WYSIWYG visualizations including in depth customizable charts, bar codes, and survey scales
- Access to multiple data sources including 4GL from a single report
- Additional Data Sources drilling, filtering, grouping and selections on existing data sources
4GL
LyciaBI reports are fully integrated with Lycia4GL to run and control LyciaBI reports and provide data. Lycia4GL introduced the new REPORT data type with methods and properties to communicate with the LyciaBI server and fully control the execution of dynamically created reports from within your 4GL application.
Report Output
The output can be delivered in all popular formats including Adobe PDF, HTML, Microsoft Excel, Rich Text Format, or plain text.
LyciaBI tools are the ultimate benchmark
LyciaBI comprises highly sophisticated capabilities such as:
- Formatting, for pixel perfect report creations
- Grouping and filtering, to drill down your report data in multiple dimensions
- Science and Mathematical functions, to produce and calculate required data such as totals and subtotals.
Three keys for successful Business Intelligence Projects
There are mainly three major factors deciding between success and failure of business Intelligence/data warehousing projects.
- Professionals planning and implementing the project
- Tools and Technology
- Technical support and responsiveness from the chosen tools provider
BI Professionals
Research shows, that poor planning and inadequate resources or skill sets are the main reason for project failures. So, regardless of what tool and technology your are deciding to use, you, the BI Professional will always be the most important key factor in your BI/Data Warehouse project.
Tools & Technology
LyciaBI does not just offer you a rich set of tools for your BI requirements. With this BI suite, you get your hands on a whole suite of BI tools which established themselves as industry market leader, used by thousands of companies and proven back-record to be up for the job in all aspects of a successful BI solution.
Technical support and responsiveness from the chosen tools provider
Querix offers you first class full technical consultancy, support and upgrade services to assist you from the project start and far beyond the project completion.
TCO & ROI or simply Money
Downsizing human resources, cut down budgets and ever increasing and changing requirements of your projects is these days a common situation for businesses of all areas. Modern times strive to get the most out of their investments. There are many Querix customer testimonials from the last 15 years since its operation started, providing evidence that investing in a relationship with Querix saves resources, time and money from the beginning and in the long-term. The ROI is reached immediately and the cost of ownership (TCO) compare to other vendors and technologies is extremely low. Also the risk in this relationship is next to nothing as Querix is established in the world of enterprise IT for nearly two decades, always satisfying and even exceeding customers’ demands. Our products and value-adding services make us the perfect partner for your projects.
* - This service is optional
