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