MicroAnalytics Logo

Solutions & Services Overview

Specialists in reverse engineering, advanced auditing, and optimization of Business Intelligence environments and Strategy (formerly Microstrategy) projects.

Explore Solutions
Attributes Metrics Dashboard / Report

Our Corporate Solutions

📇

Objects Glossary & Online Documentation

Tailored for end users and self-service data models. Fully automates your corporate metadata cataloging processes.

  • Automated generation of Schema Glossaries (Attributes, Facts, Metrics).
  • Dynamic online documentation integrated directly via Strategy (formerly Microstrategy) HyperIntelligence (HyperCards) technology.
🌿

Documentation & Object's Lineage

Comprehensive and interactive dependency auditing to preserve absolute data traceability across your projects.

  • Dependency tree generation for specific target folders or the entire BI project.
  • Interactive access via direct shortcuts to the technical lineage of every distinct component.
  • Granular analysis tracing down from physical warehouse tables and columns up to metrics and dossiers.
🔍

Documentation & Detection of 'Apply' Functions

Immediate identification of non-standard embedded logic within the semantic layer, perfect for performance troubleshooting audits.

  • Exhaustive parsing of expressions and forms for both Attributes and Metrics.
  • Automated visual alerts (highlighted in red) for ultra-fast critical detection.
  • An indispensable engineering utility during Data Warehouse database upgrades or migrations.
▦

Bus Matrix Mapping

Architecture planning powered by automated reverse engineering routines over already-deployed infrastructure.

  • Precise mapping of direct and indirect relationships between Attributes and Metrics/Facts.
  • Technical validation of expected cross-query architectural frameworks.
  • Active prevention of unexpected Cross Joins caused by missing explicit folder or hierarchy relationships.
⚖️

Environment Alignment & Homogenization (Tree Compare)

Safeguard your deployment pipelines by tracking and comparing object metadata across environments (DEV, QA, PROD).

  • Instant identification of ID discrepancies in objects sharing identical system names.
  • Advanced evaluation rules: Version ID, modification timestamps, security privileges, ACL permissions, and Change Journal history logs.
👥

Duplicate Object Detection & Volumetry Engineering

Cleanse and optimize metadata footprints by eliminating hidden logic redundancy and orphan metadata assets.

  • Automated structural grouping of components sharing identical technical definitions.
  • Detailed Volumetry dashboards and itemized statistical summaries broken down by type (Attributes, Tables, Cubes, Filters, Shortcuts).

Download brochure