List Pattern Matching for Queries using Hierarchical Meta Data

Here we introduce a slightly more difficult problem. Suppose you want to get a list of all employees with any programming skill, regardless of the particular programming language. Since there are no fields in the XML structure that specify this information, it will have to be deduced from the skill description. Assuming all programming skills end with ‘Programming', you can find employees with programming skills by matching the skills against a regular expression pattern, ‘.programming'. The following is a list pattern matching expression:

any skill match '.*programming'

Walkthrough

Follow the following steps to create an ‘All Programmers’ query.

1. Create an XML query as before, with the name “All Programmers”.

2. Select the ‘Employee’ node and click on ‘Select Record’ to make it the selection tree path.

3. Enter the condition expression in the condition text area: ANY skill match '.*programming'

4. Select ‘Save’ (on the main toolbar) to save the expression.

5. Select the ‘Map to Table’ option, then follow the same procedures to map the result sub-tree to a table.

Selecting InetSoft

• Cost Management Leader

  NCN, a leader in out-of-network healthcare claims cost management, chose InetSoft's Style Intelligence to enhance savings opportunities through custom analytic dashboards. The platform streamlines reporting with transparent, cost-based data analysis for external clients. Key attractions include its drag-and-drop interface, which cuts report design time dramatically, and superior dashboard features for professional visualizations. This selection enables intuitive data organization and automated reporting, fostering polished, interactive outputs for end-users.

• Tailored Lending Solutions

  Cloudbankin, a digital lending provider offering onboarding and credit tools for financial institutions, selected InetSoft's Style Intelligence for visualization dashboards. The choice emphasizes unlimited data caching in on-premise setups to handle large datasets efficiently. Flexible pricing models support scalable growth from small to enterprise levels. Benefits include a robust data mashup engine for transforming disparate sources and self-service analytics across user types, reducing deployment costs.

• Risk Identification Provider

  HBP Group, Australia's top corporate risk and health prevention services firm, opted for InetSoft's Style Scope to embed real-time interactive dashboards on AWS. Transitioning from static reports, it addresses needs for web-based, scalable analytics. The platform's data mashup engine facilitates quick transformations from multiple sources. Granular security and multi-tenancy ensure secure, self-service access for diverse users, minimizing ownership costs.

• Data-Driven Diagnostics

  Focus Consulting Group, specializing in culture and performance assessments for investments, selected Style Scope to manage its vast diagnostics database. Integration with tools like SurveyMonkey enables complex cross-analysis and process efficiencies. The drag-and-drop interface simplifies data combination and dashboard building without expertise. Cloud connectors for 73 applications enhance seamless integrations, supporting self-service and low-cost ownership.

• Private University Executives

  Sullivan University, Kentucky's largest private institution, chose Style Scope for intuitive management dashboards and mobile reporting. It replaces ad-hoc requests with real-time, interactive visualizations accessible on devices. Ease of use and graphical richness provide clear, up-to-date insights distinguishing facts from perceptions. Self-service features empower non-technical users to integrate sources and build custom views, freeing IT resources.

• Billing Services Provider

  360 Medical Billing Solutions, aiding emergency care in claims and cash flow, selected InetSoft's BI for secure medical dashboards. Needs for multi-tenancy, web access, and Crystal Reports conversion drove the decision. Style Scope offers granular security customizable by data level for industry compliance. The mashup engine and self-service tools enable scalable, interactive analyses with minimal costs.

• Migration Data Sharing

  The Intergovernmental Consultations on Migration selected Style Intelligence for advanced views on global migratory trends and enforcement. Replacing outdated ASP pages, it delivers faster data with interactive charts and multi-parameter reports. Intuitive self-service improves redistribution and user experience for participating states. Seamless integration saves time and effort in infrastructure embedding.

• Trafficking Prevention Nonprofit

  The Anti-Human Trafficking Intelligence Initiative chose InetSoft's BI for dashboards visualizing financial-trafficking links from open-source data. Exploratory and predictive tools aid proactive industry measures. Cell-level security protects sensitive connections, like business types to ads. The mashup engine supports flexible transformations without warehouses, enabling scalable self-service.

• Drywall Distribution Network

  GMS, the U.S.'s largest building materials distributor across 26 states, selected Style Intelligence for real-time sales and receivables views. Data mashups consolidate performance measures from multiple sources. Flexible design and licensing ensure cost-effective integration. Self-service eliminates manual consolidations, accelerating accurate decisions.

• CNC Machining Specialist

  Brenk Brothers, a precision machining firm for aerospace and medical, chose Style Scope for efficiency dashboards and automated reports. Lower pricing and self-service capabilities outshone costly competitors. It replaces manual SQL and Excel processes, adapting to new queries easily. Drag-and-drop modifications reduce IT dependency significantly.

• Pharmacy Benefit Management

  SUNRx, a pharmacy solutions provider, selected Style Scope for internal BI due to its visual appeal and mashup ease. Flexible licensing suited their needs over other options. The Java-based platform enables quick deployment and user adoption. Interactive dashboards enhance business efficiency through intuitive data access.

• Surgical Products Specialist

  Theragenics, focused on surgical and cancer treatments, chose Style Intelligence to centralize reporting from disparate sources. Simplicity, broad access, and flexible licensing addressed data proliferation. Customizable visualizations aid management decisions dynamically. Mashup technology streamlines knowledge management for all levels.