I had to search for a bit before the expensive query appeared in the top 10.   Can we show more than top 10?   Anyways I have drilled into...

Thanks folks. Interesting food for thought.   Solved the issue with an intermediate table. Thankfully, this operation isn't a frequent task.

Right.  So to avoid the 1 row value overwriting the next the data has to move.  I wonder if there's any benefit from us doing the moving ourselves. i.e. clear...

Thanks Rob - good food for thought.

Thanks.  The reason we want a little more RTO is due to hourly loads of the DW - so in addition to restoration of DB we also have to factor...

Thanks for providing the solutions.  It's interesting to see how unions can be removed with cross join (good...

I'll test queries and let you know the stats.

Lee

Thanks everyone for the excellent points.

I'm thinking about this now as I manage a team of developers. I will definitely keep to DRY principles with the calculations at...

I actually work in marketing too. If you're dealing with the Google API's from Adwords and so forth, then you don't actually have a lot of changes there. What I...

This is semi-structured data really. It records new customers and has tags such as Name, Address + 60 other fields.

When I said unstructured I mentioned this as JSON data...

Thanks Jeff. I've already feedback to data owners. I'm going down the route of parsing json to SQL and un-pivoting.

It was not an Excel thing - saw the same results with SSMS. I'm pretty sure it's related to the fact that ALL isn't a member name in...

Apologies for the delay, been very busy. I had to solve other measure problems with this fact table. I came back to this and used the dry...

This problem went away. Power Pivot solved the problem with a DAX calculation.

Hi,

This doesn't solve the problem. It only seems to change the label of the dimension when browsing the dimension. Writing an MDX query against the attribute...