MITS (r), provider of Online Analytical Processing (OLAP) business intelligence and operational reporting solutions, announced a major new release of its flagship business intelligence solution, MITS Discover .

MITS Discover 7.0 delivers significant enhancements to the end user experience, improved tools for creating and adjusting analysis focused data collections known as hypercubes, and numerous enhancements to performance and reliability. Existing customers, partners and prospective users will all find improvements of interest in the solution.

The release has been in beta use by select customers, who have been impressed with the improved performance of complex queries and the overall stability of the solution despite numerous enhancements.

Powerful New Dashboard Tools

"We have done major expansion and enhancement in our dashboarding capabilities, which we believe will please current users and attract new interest in Discover," says MITS Vice President of Engineering and Product Development, Gary Owen. The release includes a new, browser-based Dashboard Object Creator, which allows business users to rapidly create dashboard components in familiar grid, gauge, chart, and other formats, each of which can be incorporated into any number of dashboards. The enhancement, along with new dashboard library tools, will simplify the creation and use of dashboards while reducing the need to involve scarce IT resources in the process.

Other improvements will please both existing and prospective users. "Many of the enhancements included in this release are a direct response to input from our customers and our professional services unit," says Owen. "So, not only do we feel the new features are strong ... we're also certain they're precisely what our user community wants most."

One Report, Many Sources

With the new release, end users will be able to create reports from multiple data sources, not just from a single hypercube. This will speed and simplify the process for many queries that previously required more complicated effort.

"It's a powerful new feature," cites Owen. "For those organizations that build their own cubes and like to really push the solution to its limits, it will open a number of new doors-with a lot less pushing."

Extensive Usability Improvements

Enhancing queries and reports will get easier as well, notes Owen. "We've added drag-and-drop capabilities for relocating columns within a query or report grid. And now users can add or omit multiple columns simultaneously, instead of one-at-a-time." Performing "what if" and other more involved analysis will also be easier. Furthermore, the ability to selectively drill down within a displayed query or report by limiting results to specified values of a key data column has been substantially re-engineered.

One enhancement in particular that will deliver significant time savings to end users is the ability to add new drill-down paths to a hypercube without the need to rebuild the cube. End users who realize they need to explore data in a new way will now be able to do so without delay.

Reports and queries will be easier to navigate and view. Sorting on multiple columns is now easier, and new icons indicate the current sort order in effect, column by column. Users can hide "zero value" report rows, and navigate instantly to the beginning or end of the results.

Finally, a small but important enhancement adds a dynamic, visible status bar to queries in progress. For analyses needing several minutes to process, end users will know when results will be available.

Under the Hood: Shared Technology Breeds Flexibility, Reliability

Some of the improvements with the new version-particularly those focused on improved performance and wider application in the future-leverage the work MITS has done on its companion MITS Report product. Now, says Owen "both solutions will more fully leverage state-of-the-industry constructs and technologies-Java gateways, AJAX (Asynchronous Javascript and XML) calls and tiered application design."

"Though it will make us more flexible moving forward, the prime motivator is the end user," explains Owen. "These newer technologies let us incorporate familiar user interface models-the kind people are accustomed to using on Google(tm) and Facebook(tm) and Flickr(tm)-so it will work in a way that people will expect it to work."

Existing users are encouraged to contact their MITS provider to arrange upgrades, which involve a simple licensing formality. For more details on this or any MITS software solutions, individuals can contact a MITS representative at info@mits.com or visit the MITS Web site at www.mits.com .

SAPUG - Seattle Area Pick User Group

http://www.sapug.org
Date: Thursday, Aug 21
Time: 05:30pm
Location: TBD
SAPUG goes to the Ball Game - Oakland at Seattle

TEXMUG - Texas MultiValue User Group

http://www.texmug.org/
Date: Thursday, Jun 19
Time: 04:00pm - 08:30pm
Location: Black Eyed Pea, 1400 N Collins St, Arlington, TX

CMUG - Colorado Pick Users Group

Http://cmug.plaxogroups.com/
Date: Tuesday, Jul 8
Time: 05:30pm
Location: IBM Offices

SoCalRUG - Southern Calif Revelation UserGroup

http://www.srpcs.com/rev_socalrug.aspx
Date: Wednesday, Jul 16
Time: 09:00am - 12:00pm
Location: SRP Computer Solutions Office
Speaker: Steve Botes - RetailWare

Atlanta Area Pick Users Group - AAPUG

http://www.aapug.org
Date: Tuesday, Sep 16
Time: 06:30pm - 09:00pm
Location: Aldo's Italian Restaurant

Jun 17th, there will be a MultiValue Forum held in Spain.

The people at Arcoinet have put together the First Iberian MV Conference (actually called a Forum but in this internet context it's best to not confuse that with a web discussion forum).  This one day session will be held on 17 June in northern Spain.  So far over 50 people from over 35 companies are expected to attend, and live and virtual presentations will include.

To findout more, go to http://www.arcoinet.com

Chuck Barouch, one of International Spectrum's popular authors, has had an article published in eWeek.  This is a 2 page article in the June 2nd eWeek (Print Edition) on Post-Relational Databases.

You can read a digital version at:
http://www.eweek-digital.com/eweek/20080602_stnd/?pg=31

How to find any value in a string and then determine the multivalue number in which it exists.

Let's say that you have a multi-valued field of telephone numbers in a customer record, and as has happened so frequently in the last few years, new area codes have been assigned to specific telephone exchanges. In order to update and change the area code, the INDEX/DCOUNT combo might be useful.

Example:
POS = INDEX(STRING,VALUE,1)
POS = DCOUNT(STRING[1,POS],CHAR(253))

STRING - the string we are going to search in (ex: attribute)
VALUE - the value we are looking for
POS - multivalue position

First line is going to give us position in our string, the second one will count the number of multivalues up to length specified by POS. If the returned value is 0(zero) - value has not been found.

Note: the INDEX/DCOUNT combo is only a suggested format of searching for a partial match in a multivalued field, as opposed to looping through all the values and comparing each value. This technique may not apply to your data structure and should never be used when LOCATE statements would suffice. And as always, "Know your data."

This code example was found on http://www.pick911.com/indexdcount.html