Query bound SSAS partitions

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.

Mark

Advertisements

One Response to Query bound SSAS partitions

  1. Dave Wickert [MSFT] says:

    Yes, I’ve used a SELECT * from time to time. However SSAS will still wrap the SELECT in a sub-select and cast the columns to values it knows about. It is just the way we do things — we use it as a way of forcing the columns names to what we expect. The RDBMS query optimizer recognizes that this is just column re-mappings and it has no effect on the query itself.

    As I’ve said before, you are welcome to do whatever you want in the query binding so long as a minimum of the expected column names are returned as the table binding template expects.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: