MDX and SQL Supported Features for Analytics
With built-in SQL and MDX engines, Kyvos ensures seamless integration that delivers much higher performance than external engines. Kyvos supports all popular BI tools via MDX or SQL connectivity.
The following table provides information on the various BI features supported via MDX and SQL connections.
Functionality/Feature | MDX | SQL | Supported BI Tools |
Kyvos Semantic Layer | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: Tableau (TDS file) and PowerBI (PBIT file) |
Raw Data Querying | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |
Member Properties | Yes | No | MDX: Excel, Excel-addin and Kyvos viz SQL: Not Supported |
Calculated Measure | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |
Calculated Members | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |
Parent Child Hierarchies | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |
Alternate Hierarchies | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |
Unbalanced Hierarchies | Yes | No | MDX: All tools certified by Kyvos for this release SQL: Not Supported |
Custom rollups | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |
Sort Column | Yes | No | MDX: Kyvos Viz SQL: Not Supported |
Cohort Analysis | Yes | No | MDX: Kyvos Viz SQL: Not Supported |
Non-Visual Totals | Yes | No | MDX: Excel SQL: Not Supported |
Display Field | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |
Many to Many | Yes | Yes | MDX: All tools certified by Kyvos for this release SQL: All tools certified by Kyvos for this release |