Skip to main content
IMPLEMENTED

Improvements on the semantic layer

Related products:TimeXtender Data Integration
  • June 1, 2023
  • 7 replies
  • 183 views

Stefán Gunnar Jóhannsson
TimeXtender Xpert
Forum|alt.badge.img+2

​​​​​​​There are a few things that would greatly enhance the Semantic Layer. I've come across some old tickets that address some of these points.

  1. It would be highly beneficial to have a library of reusable DAX calculations instead of having to rewrite them each time. This could be similar to the Business Function library found in OLAP cubes.

  2. It would be useful to have some form of syntax verification within the DAX script window. Currently, it can be time-consuming to deploy and execute the Tabular model only to discover a syntax error. (I understand that there are tools like Tabular Editor and other solutions that allow for quicker testing.)

  3. It would be great to have the ability to create folders within the measure tree and easily drag measures into these folders. This feature would provide a much-improved overview and a more user-friendly approach when dealing with numerous calculations, rather than grouping measures to folders by right-clicking the table.

  4. To be able to change the mapping table in the semantic layer, currently you have to delete the table and drag in the new table.

7 replies

Stefán Gunnar Jóhannsson
TimeXtender Xpert
Forum|alt.badge.img+2
  1. Re-use dimensions between semantic models. It can be time consuming to recreate all of hierarchies, set sort columns and everything. 

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • July 6, 2023

There are some older requests to bundle into this one:

It becomes super painful to need to recreate dozens of measures across many SSL and also not be able to see where each measure is used. I would propose Centralized Custom Measures (Custom Measure Snippets if you will) that are also linked into lineage through parameters.

This would allow you to centrally maintain syntax for Qlik, Tableau and Power BI and simply drag the parameters ifrom fields / tables nside the SSL.

 

 

 


Stefán Gunnar Jóhannsson
TimeXtender Xpert
Forum|alt.badge.img+2

Yes and It would be really helpful if you could apply the measures to the model without having to deploy and execute the model. My workaround has been to connect PowerBI or Tabular Editor to the model, create the measures there and the move them into TimeXtender when I know they are working correctly.


Trine Stuhr
Employee
Forum|alt.badge.img+1
  • Employee
  • September 12, 2023

Thank you for gathering all the ideas into one! I fully agree with you, and have brought this forward to our product team :-)


JTreadwell
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • January 9, 2024

Hey @Stefán Gunnar Jóhannsson

I’m happy to announce that It's now possible to add DAX, Qlik, and Tableau snippets, for use in semantic custom fields, custom measures, and calculation groups!

In addition, You can now add calculation groups to semantic models and deploy them to Tabular and PowerBI semantic endpoints.

This and more were release today in v6505.1. Read more about it here.

Keep the ideas flowing!

 

 

Unfortunately, with multiple ideas submitted in a single post, it becomes very difficult for us to measure or compare the need of each of these individual features. Since the first one in this list is now done, and this is the top voted idea. I’m going to go ahead and mark this a Implemented. @Stefán Gunnar Jóhannsson, Can I ask that you please submit any additional requests that you feel are still important as separate ideas? We're doing our best to focus on what’s going to have the biggest impact for all of you and this makes it easier for us to figure out what’s truly important and split up into more achievable chunks. Thank you!. 


JTreadwell
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • January 9, 2024
SUBMITTEDIMPLEMENTED

Stefán Gunnar Jóhannsson
TimeXtender Xpert
Forum|alt.badge.img+2

Thanks for the update @JTreadwell

Excited to try this out