Today SSAS generates the TSQL when dimension and facts are loaded. BISM Tabular allows You to enter your own queries. The SSAS generated SQL is not the best and in order to do optimization in the loading scenarios you should be allowed to enter your own queries.