Minimizing Custom Tableau Calculations

Minimizing Custom Tableau Calculations reduces complex calculated fields, Level of Detail (LOD) expressions, and table calculations created in Tableau when equivalent functionality exists in the Kyvos semantic model. While Tableau's calculation engine is powerful, it processes calculations after data is retrieved, adding computational overhead. Kyvos, on the other hand, performs calculations against pre-aggregated semantic models optimized for massive scale. Complex LOD expressions and table calculations can be particularly resource-intensive and may negate the performance benefits of Kyvos' optimization. By pushing calculation logic to Kyvos, you ensure optimal performance and consistency across all analytical tools accessing the semantic model.

To minimize custom Tableau calculations, perform the following steps.

1. Create LOD calculation at the semantic model level instead of creating it on Tableau.

   • Tableau LOD expression- { FIXED  :SUM([Sum Sales])}

     Open

     

   • Equivalent LOD expression in MDX

     Open

     
     Sum( [Geo].[H_Geo].[Country].allmembers, [Measures].[Sum Sales] )

2. Here, you can compare both the calculations created in Kyvos and Tableau. You get the same value for the Kyvos-created LOD, and it also provides the performance benefits of Kyvos' optimization.

   Open