Been doing some thinking about the best way to design query bound partiton queries. In the wizard in BI Studio, when you switch the partition to query bound instead of table bound (so you can put a WHERE clause as a row constraint) it lists out each column. That means that if you need to add a new dimension to your star/cube, you will need to edit the query in each partition before you can load and process the cube.
Would it be better to do a select * in the query? I’m not sure and I’m curious what anyone else thinks about it.
Leave a comment.