Rosella Analytic Server New Generation Platform for BI OLAP WOA SOA

Rosella BI Server is a web-based next-generation business intelligence developer platform. It provides end-to-end BI plus functions over the web using user-written html pages such as executive dashboards, pre-defined management reports, etc. Analytic features include charting and reporting with embedded predictive modeling and rule-based expert systems.

What is Knowledge-Embedded Predictive Reports?

Knowledge-Embedded Predictive Reports can improve business visibility harnessing business reports with predictive modeling and business logic using expert systems rule engines. For example, KPIs can analyze changes in business drivers and co-inference them automatically to detect hidden patterns underneath complex numbers. KPR's incorporate predictive modeling with rule-based expert systems into report writing and charting systems;

  • Predictive analytics can be used to detect patterns and trends in business drivers automatically from hidden numbers, and to predict future directions. It is known that leading predictive indicators are more useful than trailing indicators. Directions and projections can be very useful information to have.
  • Rule-based expert systems can be used to leverage complexity of various business drivers and indicators. As the surveys mentioned found, understanding too many drivers and complex numbers can be very daunting tasks for executives and business users. Expert systems based on business logic can take this task as an expert, making balanced scorecards more friendlier and easier to understand.
  • Business activity monitoring and Event processing provides a platform intelligent business operations, detecting complex business events and taking proactive measure automatically.
  • Web-based reporting & charting engines are essential in generating business reports in a timely real-time fashion so that executives and business users can recognize developing situation in real-time.
  • Embedded statistical Rosella DBMS provides complex statistical analytic information to rule engines and charting systems. Rosella DBMS is a high performance large main-memory optimized DBMS, capable of sorting in high speed for statistical analysis. It implements variety of statistical functions as extensions of SQL query language. In addition, it is the backbone of persistent fact managers for rule engines.

Incorporation of predictive analytics and rule-based expert systems into business reports provides a number of advantages. It will make business reports much easier to comprehend potential problems and successes. Trends developing can be detected early so that actions can be followed as early as possible. Complexity in interpreting KPIs is removed in real-time by embedded knowledge of business experts. Typical applications include the followings;

web embedded credit risk dashbords.

Turning Excel/Spreadsheets into Enterprise Web Applications

Web is a very robust general purpose medium for delivering services and enterprise business applications. When web is harnessed with predictive analytics and expert systems rule engines along with visualization charts, your web applications can do a lot more duties than you have ever imagined. Your web applications can analyze data, reason, think and take intelligent actions.

Spreadsheets are commonly used for ad-hoc business modeling and analysis. Spreadsheet applications are personal use. Rosella BI analytics harnessed with rue engines and charting systems provides a perfect platform for transforming spreadsheet programs into multi-user enterprise applications. The following figure shows an example of Excel/spreadsheet-style reports;

olap predictive BI.

Rapid development of predefined analytic reports

BI server provides an advanced platform for BI reporting and analytics. Typical BI applications consist of hundreds of simple and complex reports or dashboards that may contain complex charts with predictive statistics. Developing such systems can require huge manpower and time. BI server platform provides an advanced platform on which complex applications can be developed and deployed very rapidly, resulting not only significant cost reduction but also with sophisticated analytics!

What is Web-based Business Intelligence (BI)?

Conventional Business Intelligence (BI) software systems are in general single-user stand-alone desktop programs or they require such client programs to be installed on each user's computers. Furthermore, the types of reports and dashboards are largely pre-determined by system's design. There are very little rooms to customize according to user's requirements. Web-based OLAP, on the other hand, uses web technology to deliver analytic information to multiple users simultaneously, overcoming the limitations of conventional BI systems. Data is centrally stored on database systems and processed dynamically when user visits web pages containing analytic information. Analytic information is embedded into html pages, specially written for the needs of special users, such as executives, managers, analysts, specialists, and so on.

How WOA Business Intelligence works?

WOA - Web Oriented Architecture - refers to the approach delivering compartmentalized information to web pages. WOA is a new trend for Business Intelligence (BI) and OLAP. Rosella Analytic BI Platform consists of programs that can be used in HTML <A HREF="..."> and <IMG SRC="..."> tags. In addition, embedded html pages provide powerful report-formatting capability that may include charts and advanced predictive analytics. Analytic components can be operated in multiple modes;

  • Interactive mode: users select fields and options for analytic reports and charts interactively. This is somewhat similar to common statistical packages!
  • Embedded pages: A number of analytic report tables and charts are embedded into html pages, and executed dynamically when users make visits.
  • Direct links: A report or chart page is created dynamically.
  • Image links: chart images are called from <IMG SRC="..."> links dynamically, showing charts based on latest information dynamically.

For more, please read WOA Business Intelligence - How does it work?

Benefits of WOA Business Intelligence

The main purpose of using WOA Business Intelligence is to make your application infrastructure more agile and flexible. This offers the following benefits;

  • Simple, fast and easy implementation of dashboards and analytic reports.
  • Changing requirements can be addressed more quickly.
  • Lower maintenance efforts.
  • High performance.
  • Lower total cost.

Data Visualization Charts

Rosella Analytic BI Platform produces high-quality graphics and reports that can be used in executive dashboards analytic reports. For more examples, please read Dashboards, Reports and Charts.

olap database chart - bar olap database chart - bar

Full Support for SOA and Java/J2EE/J2SE

Rosella BI Platform is based on Java/J2SE/J2EE featuring;

  • Runs on any J2EE compliant server: Resin, Tomcat, JBoss, etc.
  • Embedded large main-memory optimized high-performance DBMS.
  • Supports all major database systems: Ingres, MS Access, MS SQL Server, Oracle, DB2, MySQL, Sybase, ...
  • Runs on all major operating systems: Windows, Mac OS X, Linux, FreeBSD, Unix, Solaris, AIX, ...
  • Supports all major web browsers: MS Internet Explorer (IE), Opera, Firefox, Netscape, Safari, ...

Main features include;

  • SQL query and reports: HTML-based formatting/subtotals/grand totals.
  • Visual charts: pie charts, line charts, bar charts, gauge charts.
  • Report tables: group-by tables and cross tables (may include charts in cells).
  • Rule-based modeling: rules, mathematical formulas, predictive models.
  • Predictive models: decision trees, neural networks, regression functions.
  • Time-series forecasting and trend analysis.

Free Downloads

For free or evaluation copies, click Rosella Analytic Server Download.