Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Aggregate on string parameters using contains case

Solved1.52K views10th July 2023aggregation CPE EPM
2
Gabriel Borges [SLC] [DevOps Advocate]646 5th October 2020 0 Comments

I am currently working on an EPM solution and one of the aggregations that needs to be done depends on a string column value "Device Class" shown below.

I am aware that if the column is not of type number, then the only solution is to use equationValue, though the functions are basic boolean functions that will not help here since a device class of type RTR cannot be counted using ==, !=, >=, or <=. Is there a way to have a contains boolean for the aggregation, so it simply checks if RTR is present in the column value? Or will I need to get creative and have the collector element send the data so the aggregation is done in a QAction in the EPM manager or create additional columns for each individual device class type and fill it in with either a 1 or 0 signifying it belongs to that class?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th July 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
4
Laurens Moutton [SLC] [DevOps Enabler]8.73K Posted 6th October 2020 0 Comments

Aggregating with wildcards on a certain string value is currently not possible.

The most easy thing to do is add an extra column with value one or zero to indicate whether or not to perform the aggregation.

If you want to save out some memory and avoid this extra column then you might want to consider making that device class parameter a (numeric) discreet type parameter and then use allowValues to include all the items that you want. This way an extra column is avoided and memory contains only numbers instead of a full string value. In the QAction you could then use enums, which makes the code more readable and less sensitive for typos. Downside is that you need to know all the discreet values beforehand and if there's ever a new possibility added then you need to modify the driver to be able to support it.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th July 2023
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (109) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin