I personally don't like system-versioned tables because they require a datetime type, and you don't control the values that are being inserted. I prefer to do that myself with effective...

My personal preference is to land Dates (or Date/Time) fields as text (varchar) in the staging area if I don't trust the source...or if I anticipate possible conversion issues.

The pro...

(see latest post)

• This reply was modified 1 month ago by  Martin Schoombee.

I haven't and can unfortunately not comment on it, but Joe is well-known and respected for his work with the Kimball Group. It would definitely not hurt to read his...

I wouldn't change any configuration properties unless I have a better understanding of the root cause. If the CPU is high, then it is likely due to either a refresh...

How do I track for changes in Cost/Price? Just add a trigger to Product[UnitPrice] and Purchase[UnitCost] and maybe call a stored procedure from the trigger to (1) find all...

• This reply was modified 5 months, 1 week ago by  Martin Schoombee.

I'm not sure about the detail in the physical book as it's been a while since I've read it, but here is the official on the Kimball website: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/timespan-fact-table/

As you...

(While I'm at it, say I have a bunch of recurring business costs, like rent and gas and the like. I can sum those by quarter (say) and then...

• This reply was modified 5 months, 1 week ago by  Martin Schoombee.

Like, one starter consists of something like 7 parts water, 4 parts flour, 3 parts potato starch by volume). And starter is listed as an ingredient... Do I create...

If I have some time, I plan to do something about that next year. Stay tuned!

This is a tricky modeling question, and one that is difficult to answer without a lot of context and spending some time considering all the options (and side-effects of those...

• This reply was modified 5 months, 2 weeks ago by  Martin Schoombee.
• This reply was modified 5 months, 2 weeks ago by  Martin Schoombee.
• This reply was modified 5 months, 2 weeks ago by  Martin Schoombee.

Can you provide some more details around the error-handling in your PowerShell script? I have found in the past that the meaningful part of the error messages aren't always visible...

Analysis Services partitions have to be refreshed as a unit, meaning that you cannot selectively update certain rows of a partition. If your large cube only has one partition for...

I looked at the two blog posts you referenced, and I think it's pretty clear (especially from Jason's post) that these "slice" entries are purely metadata entries that are generally...

Could you share the source of this recommendation?