I've encountered this a few times where I need to change an underlying source fact table because of a design change in the development of a semantic model. Currently, you have to add a new table, configure all relationship again and create all measures again. This requires a lot of manual work that is prone to errors. Being able to substitute a source table with another table or a view with the same field names could be very useful.
Submitted
Change source table of a semantic table
Agreed. I'm running into a scenario where I have 3 very large fact tables in the semantic model. In order to cut down on dataload times in the DW, we are considering splitting a given fact table into several tables. Since the bulk of the data is historical legacy data, we can load it once and forget it in the DW.
However, that would require unioning the fact tables back together in a view to drive the semantic layer facts. Since there are well over 100 calculated measures in the fact table, which have already been validated... it would be easiest to repoint the semantic layer table's source.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
