![]() So, in theory, you could create different physical models, for different technologies, based on one logical model. A semantic model in TimeXtender is a logical model that can serve as the base for creating different types of physical models, which are called endpoints: Different steps when developing a Tabular Model in TimeXtender Create a semantic model and a Tabular Model endpointįirst, you will need to create a semantic model object in TimeXtender. This makes it possible to analyze the origin of a tabular model field to the data warehouse columns and even further all the way to the sources of the data warehouse. In addition, the linked metadata allows for full data lineage. This improves a lot the ease of maintenance. In TimeXtender, the Tabular Model columns remain linked to the metadata of the data warehouse. But in the real world, columns are added, removed, renamed or data types change, even after the table or view has been used in a Tabular Model. In the ideal world, the Tabular Model development is started after the data warehouse development is finished and final. The biggest advantage of developing it in TimeXtender is that it is much easier to maintain the Tabular Model. In this tool, when you start the development of the model, after you connect to the data warehouse database, you can simply select the tables/views to import. ![]() One could argue that this is similar when developing a Tabular Model in a classic way, i.e. When developing a data warehouse in TimeXtender, it not only generates all the necessary tables, views and all the ETL code to fill those tables, but it also stores all the metadata about those objects in its repository.īecause all the metadata of the tables, views, and columns is already available in TimeXtender, it is a simple drag-and-drop operation to add a table or view to the tabular model. If you use TimeXtender to develop your company’s data warehouse / modern data platform, and you want to develop a Tabular Model on top of that data warehouse, then it is a good idea to also use TimeXtender to develop this Tabular Model. Why use TimeXtender to develop your SSAS Tabular Model ![]() Therefore, special attention is given to this subject so that you get a quick start on that learning curve. Because the error messages from TimeXtender are not always that helpful, it is important to know exactly which syntax TimeXtender expects. When developing a Tabular Model in TimeXtender, there are also a few things that remain tricky, especially coding the custom measures in DAX. In this insight, We will explain why it could be a good idea to develop the Tabular Model inside TimeXtender, rather than developing it the classic way in Visual Studio. TimeXtender also allows you to develop and generate a semantic model (SSAS Tabular Model, Qlik or Tableau) based on the DWH that has been developed in the same tool. TimeXtender is a tool that allows to design and develop a data warehouse / modern data platform in a faster way, without having to deep dive into the technical code.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |