Revelation Newsletter September 2019

The August 28, 2019 issue of Database Trends and Applications features an article written by Stephanie Simone titled Revelation Software Helps Software and Services Company Stay Agile.

California-based BleuPelikan provides software products and services that revolve around Revelation Software to business and consumers. Launched in 2004, the company has focused on software for business transformation strategies that revitalize and invigorate companies since 2010.

Since the early 1980s, Greg Helland, president and CEO of BleuPelikan, has been working with Revelation, which offers a suite of development tools, a database, and companion services that leverage leading computing architectures and operating environments. Revelation’s OpenInsight is a database development suite for NoSQL MultiValue (as well as industry-leading SQL databases) that provides Windows, Web 2.0, and .NET tools used to develop and deploy mission-critical applications.

“The company has a long history and I stay with it because it’s bulletproof, it works, and it makes development easy,” Helland said.

The Challenge

Recently, BleuPelikan was engaged to help turn around a failing food manufacturing and distribution company.  A key challenge was the calculation of commissions, which was taking two full-time employees an excessive amount of time using spreadsheets.

By providing its flagship product, PeliKalc, BleuPelikan enabled the customer to capture all the allowable deductions and sift through data with speed. This helped to reduce the time spent on the calculation of commissions to 2 hours per month, resulting in significant savings in both time and money, Helland explained.

The Solution

PeliKalc was created as a commission and reporting system to solve the age-old problem of accurately calculating and reporting broker commissions. Done manually, the process can be both time-consuming and error-prone.

PeliKalc, built on Revelation’s OpenInsight, provides food manufacturers and sales organizations with actionable review of informational reports to keep margins and sales on target and in budget. The application includes food broker calculation and reporting to ensure that companies are accurately paying brokers on time as well as taking all allowable deductions. It also provides complete unit-based sales forecasting and production planning tools, sales history and gross margin analysis.

Flexibility for the Future

“OpenInsight is so flexible for changing business rules,” Helland said. “We are able to address the changes a customer wants or needs very quickly. It’s also much less expensive to do custom work for customers using OpenInsight versus Oracle or SQL Server.”

Helland can create a prototype, show a customer what a piece of software will enable, and make it all happen rapidly so that companies and employees can spend their time on more valuable initiatives rather than mundane calculation work. “We are giving organizations actionable reports and Excel spreadsheets that are the basis for great sales and marketing decisions,” Helland said.

 Read on...
 

---

Revelation Software named in DBTA 100 2019 - The Companies That Matter Most in Data

The stakes for expert data management continue to escalate. Data volumes are expanding rapidly and it is well-understood today that companies that harness the value of this precious commodity will be the winners.

With a growing appreciation for data’s value, spending on data management and analytics products and services is also on the rise. IDC forecasts revenues for big data and business analytics solutions will reach $189.1 billion in 2019 with double-digit annual growth projected through 2022, according to its “Worldwide Semiannual Big Data and Analytics Spending Guide.”

A new Unisphere Research report sponsored by Pythian also reveals that the vast majority of respondents believe that a well-documented data strategy is critical to their ability to deliver value to the business, and just about all respondents, 97%, have a documented data strategy (“Profiling the Data-Driven Business,” 2019).   Read on... 

---

OpenInsight now provides an option to change the precision of mathematical operations. This can be set by calling the setEPMode stored procedure, passing in 1 to enable and 0 to disable the functionality. By default, the extended precision math will maintain 32 digits of precision, but this can be modified by calling the setEPModePrecision stored procedure, passing in the number of digits of precision desired. Both the enabling of extended precision, and the default number of digits, can also be defined in the application properties. The following operators/functions are affected: +, +=, -, -=, *, /, ==, =, !=, <>, >, <, >=,<=, mod(), int(), abs(), atan(), cos(), exp(), ln(), pwr(), sin(), sqrt(), tan()

OpenInsight's RLIST functionality and performance have also been improved starting with the 10.0.7 release. A new version of RLIST (RLISTX), which optionally replaces and extends RLIST, is available to enable these enhancements. RLISTX merges the features of RLIST, SELECT_INTO, OLIST/RUN_REPORT, and RTI_XBAND. One obvious change is the ability to pass in multiple select statements to RLIST in a single call, @FM delimited. Using the Record Editor, or the Configuration Record option from the OI Console, you must create a CFG_RTI_RLIST record in SYSENV, with RLISTX in field 1. If this record doesn’t exist, or has anything other than RLISTX in field 1, then normal RLIST behavior ("RLIST 9") and functionality will remain. (Note that the CFG_RTI_RLIST information is cached by your system; after changing this value, you should exit and re-enter OpenInsight).

The MultiValue BFS (MVBFS) connections for QM, D3 and U2 have been enhanced to submit multiple select lists to the "back end" host for bulk processing whenever possible. This enhancement can result in significant performance improvements when using an MVBFS connection. Note that these changes work in conjunction with the RLISTX changes discussed above; you must enable RLISTX and install a "plugin" stored procedure on the host system to access these changes. There is now a button on the MVBFS connection designer which will install this plugin (a program named RTI_MVBFS_SERVER_PLUGIN_U2, RTI_MVBFS_SERVER_PLUGIN_D3, or RTI_MVBFS_SERVER_PLUGIN_QM).
   

---