MDX and SQL Supported Features for Analytics
- Sarabjeet Kaur
- NIDHI BHANDARI
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 certified tools by Kyvos SQL: Tableau (TDS file) and PowerBI (PBIT file) |
Raw Data Querying | Yes | Yes | MDX: All certified tools by Kyvos SQL: All certified tools by Kyvos |
Member Properties | Yes | No | MDX: Excel, Excel-addin and Kyvos viz SQL: Not Supported |
Calculated Measure | Yes | Yes | MDX: All certified tools by Kyvos SQL: All certified tools by Kyvos |
Calculated Members | Yes | Yes | MDX: All certified tools by Kyvos SQL: All certified tools by Kyvos |
Parent Child Hierarchies | Yes | Yes | MDX: All certified tools by Kyvos SQL: All certified tools by Kyvos |
Alternate Hierarchies | Yes | Yes | MDX: All certified tools by Kyvos SQL: All certified tools by Kyvos |
Unbalanced Hierarchies | Yes | No | MDX: All certified tools by Kyvos SQL: Not Supported |
Custom rollups | Yes | Yes | MDX: All certified tools by Kyvos SQL: All certified tools by Kyvos |
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 certified tools by Kyvos SQL: All certified tools by Kyvos |
Many to Many | Yes | Yes | MDX: All certified tools by Kyvos SQL: All certified tools by Kyvos |
Related content
Copyright Kyvos, Inc. All rights reserved.