galaktikasoft

[galaktikasoft]

When Xafari applications on Oracle are used for large amounts of data, there has been some decline in the performance compared with the same application which runs on MS-SQL. Analysis of the problem showed that indices did not participate in complex queries in the database, although these indices were present in the database. Deeper localization revealed the cause for it. Field “Oid” of most business classes have type Guid. When mappings of business classes into the Oracle database, these fields will have the type CHAR. When the application ran, complex parameterized queries raised with the conditions under which the transfer was carried out with the parameter type NVARCHAR2 to columns of type CHAR. It is for this reason the indices had not been picked up, since in the queries of such types Oracle performed an internal conversion from one type to another. Thanks to a very flexible architecture of Devexpress XAF, which provides many extension points, this problem has been solved independently. To solve this problem, we developed module Xafari.DB, which presents the implementation of providers for data access Oracle: XafariODPConnectionProvider and XafariOracleConnectionProvider. These classes are the derived classes of the DevExpress classes ODPConnectionProvider and OracleConnectionProvider, respectively. We had to override a method CreateParameter () in base classes so that for fields of type Guid parameter passing in the query is executed with the type CHAR. Below is the analysis of the results obtained in the comparison: without using the module Xafari.DB and with the connected Xafari.DB. In general, due to Xafari.DB we were able to accelerate the execution of complex queries to 40 times or more.

[galaktikasoft]

If an OLAP cube contains KPI (Key Performance Indicator) information, the Pivot Grid automatically recognizes it and display it using the appropriate format.

[galaktikasoft]

[galaktikasoft]

Roadmap for Xafari version x06

The following Xafari Framework versions will be released:

13.2.x06

14.1.x06

The release is expected in late September 2014. Extension of the functionality and enhancements of performance, scalability, and ergonomics of the XAF applications, especially in the Web-interface, are main objectives of the new version.

Functional modules

Support of Branches

It is possible to keep data of multiple separate companies in one database or configuration of the application solution after connecting the module. It is possible to configure, which entities and reference information items are common, and which ones belong to the branches. Access to certain branches can be configured for each user. This functionality was tested in our application systems Galaktika EAM and Galaktika ERP.

Audit

The Audit module is a replacement for the ordinary XAF Audit Trail module. The Audit module offers extended functionality and substantially increased scalability and performance with large data volumes.

Report Server

The following functionality has been implemented:

Asynchronous/postponed report generation in the server or in the client application

Operation of the report server as a XAF/Xafari application

Complete support of the XAF application security model

Generating reports in the servers, thus saving the client resources

Storing the ready reports in the database

Scalability

Generating reports on schedule

Distributing notifications

In addition to the report server proper, the Xafari Message Queue service XafariMQ has been implemented. After the trial operation in the х06 version, we are planning to release a report server /calculation server based on this service in future.

Task List

In the context of release of new Docflow and Workflow modules, a common service for task list management is necessary. This service must be generally usable and applicable for most application tasks. The service would allow:

Generate tasks

Obtain the list of tasks assigned to an executor

Manage tasks

Starting with version x06, the Docflow module will use the common Task List module.

Analysis Report Template

The following report templates are available in the current version: XtraReport, Excel, File In the next release, we will add the Analysis template, which allows to generate reports based on the XtraPivotGrid. The reports based on the Analysis template can be used for analysis of various business information. The report presents the data as an interactive pivot grid. The Analysis report template allows the user to form the desired data presentation intuitively, while using multiple possibilities to configure the presentation. The functionality of the Analysis report template is implemented for the Win and Web modules. Any field of the report data source, that is a collection, can be used as data source for the pivot grid in the Analysis report. The collection item type must be defined in the business model of the application. In the Win version, the Pivot Grid Designer is available for editing the template.

Export / Import Module

Enhancements of the module which improve the end user functionality will be included in the х06 version:

Detailed information on which errors occurred in the course of import or export

Determining the default values

Use of calculated fields

The possibility to import and export the many-to-many relations was added

A mechanism for analysis of the existing initial data in the database in the course of import was added

Support of import and export of images

Interface features and modules

MVC Web Module

In addition to two possible types of the client, the WinForm and the ASP.NET- WebForm, we developed a new type of the XAF client application, which is the ASP.NET-MVC type. The new MVC client creates substantially less load on the server and improves scalability of the XAF-based WEB applications (supporting up to 100 concurrently working users). The response time improves by more than 3 times, which significantly improves overall ergonomics of the web applications. A provisional trial version (covering the standard functionality of the XAF MainDemo and CRM) will be included in the х06 version release; we plan to release the final solution by the end of year 2014.

Improved Multiple Lookup

Initially our visual control Xafari Multiple Lookup Property Editor kept the selected values. It proved not convenient for generating queries. Besides, it affected performance when creating multiple filters. In the forthcoming release, substantial enhancements are included, and the process architecture has been changed. Now the selected values are stored in an internal table, and the JOIN operator is used for application of the filters. It is also possible to create the reusable selection of values, which are available in different forms in the application. A special data type and a special editor were developed in order to support this functionality. This change allowed to improve performance of filters with large data volumes by an order of magnitude (response time less than 1 second, compared to few minutes previously).

Templates for the WEB Application

We implemented the possibility to use templates for the visual controls assigned to the fields of the business objects. It is possible to created templates for each field separately or for a group of fields. The groups of fields can be determined using various factors: the type, the editor, the view displaying the field, etc. This functionality allows to adapt the standard WEB XAF interface to the client's corporate standards and requirements.

Strategies for Generating Forms

The strategy for generation of forms, in which all new fields that exist in the BOM model, are presented in the forms by default. While it is convenient for prototypes, this strategy can be unacceptable for the series products that are intended for the client's adaptation (including the addition of new properties to the Business Object Metadata (BOM) model) as there can be situations where the added fields interfere with the preconfigured forms. In the new release, we implemented the possibility to control the form generation process based on the description of the applicable client's strategy. The Xafari strategy, which controls the content of the forms, generation of the views, combining properties into groups, and other parameters in the code at the time of describing the business object, has been implemented for the new release. Profiling and performance When preparing this release, much attention was paid to the matters of performance and scalability of the integrated mechanisms. A test bench was created, and a technology allowing to obtain reproducible test results under the multiple user load was determined. They helped to detect and eliminate many issues and problems occurring at multiple user load (over 5 concurrent users) for the Win-ASP client.

Documentation and examples

Documentation will be substantially improved in the forthcoming release. We also plan to develop new demo applications. We also plan to release documentation on common data with this version.

Licensing Xafari

If will be the first version with the integrated license control. The license control mechanism will operate both at the installation time and in the runtime.

[galaktikasoft]

Overview Ranet OLAP

Enabling the user to work with multidimensional data of the Analysis Services (SSAS) quickly and efficiently online is one of the key objectives when creating business intelligence solutions on the Microsoft SQL Server platform. An analysis of the software market revealed shortage of components offering optimum combinations of functionality, licensing terms, usability, and ergonomics.

Library Ranet OLAP is one of the first solutions for the SSAS based on Microsoft Silverlight in the market. It is the only solution that includes:

Report Designer, which is intended for creation of arbitrary reports by the end user based on grid tables with Drag and Drop functionality, automatic parsing and generation of MDX queries (the MDX Designer).

MDX Parser, which is capable of parsing any MDX query of whatever complexity level, including the Crossjoin and formulas, both written by humans or generated automatically by the MDX designer. In so doing, an object model for multidimensional expression (Document Object Model, DOM) is generated based on the Abstract Syntax Tree (AST).

MDX Generator supporting the generation of the MDX query in the course of detailed analysis of pivot grid data using services Expand/Collapse, Drill Down/Up by any dimension of the multidimensional data cube.

Pivot Grid supporting the Writeback (writing data to back the cube), which allows for editing the cube data online over the Internet; it is much demanded functionality for the tasks of consolidation of reports from remote branches, business planning, and business simulation.

Know-how based implementation of client-server data exchange: format JSON + ZIP is 90 percent faster and more efficient than standard format XML/A + ZIP, the speed difference is especially noticeable with large data volumes.

Library Ranet OLAP was placed at the resources intended for open source projects (http://ranetuilibraryolap.codeplex.com/ и http://code.google.com/p/ranet-uilibrary-olap/) and received high interest in the developer community. Over 80000 users visited pages of the project websites, and the project source code was downloaded about 7000 times. In so doing, the project shows growing dynamics of visits and downloads.

The developers worked hard to release the respective product, project website was created for promoting the product. As a result, Corporation Galaktika got clients in the USA, UK, Australia, India, and other countries, who use library Ranet OLAP for development of their own solutions, including an investment bank, a university, companies operating in the field of software development and outsourcing business processes, and independent developers.

Today Ranet OLAP components are used in various applications and sectors, such as: business analysis applications, Business Intelligence (BI) solutions, management decision making support systems, applications for health care, scientific research, etc. Library Ranet OLAP was used for development of Galaktika Business Monitor, Galaktika Business Intelligence (BI), Galaktika Investment Program Management System, and other internal products of Corporation Galaktika.

[galaktikasoft]

The Ultimate Business Application Framework Business platform Xafari is intended for development of powerful business-oriented applications. It uses state of the art flexible platform DevExpress XAF

Universal tüm Developer Express .NET Windows Formlarını, ASP.NET, Silverlight ve WPF bileşenlerini ve IDE araçlarını (CodeRush ve Refactor!), eXpress Persistent Objects (Ticari Uygulama Sistemi) ve eXpressApp Framework’u içerir.

Windows formundaki ürünler 100% C# tabanlıdır ve tümü Visual Studio...

[galaktikasoft]

The Pivot Grid is designed for the visualization and analysis of multidimensional data purposes. The Pivot Grid control shows a summary table which is a result of running the MDX query.

[galaktikasoft]

Ranet OLAP is an open source set of data visualization controls – powered by Microsoft Silverlight and was written specifically for SQL Server Analysis S