I set up a separate , temp / workaround copy of the reports without a reference to the offending fields.

I guess I am not understanding why this is a "temporary"...

Hi again Stan, sorry I didn't help.  The only other thing I can think of -- and it may make no difference -- is to remove the two fields from...

• This reply was modified 4 months, 2 weeks ago by Lisa Slater Nicholls.

Stan, you said the report is set not to cache, but the error indicates a shared dataset.  Have you checked the shared dataset's caching settings, not just the report?  (JIC)

I'd...

> Afaik there are only two possible values for the Category colum

AFAICS you are right -- but you'd expect there would be a 3rd value, equals8???

how it is executed

This might be key... is this query executed many more times than others you might be comparing it too?  If so, could the problem be an inability...

> And trying to teach a subject-matter expert how to 'do' IT is equivalent to teaching an actor how to dance.

MMM... usually, but not always.  I'd love to have a...

I have never used temporary sprocs, in fact I didn't know they existed <g>.

But to answer "when would they be useful", for you (Jeff) and danielk1, I thought there was...

Oops, Hang Liu, let me clarify something in turn:

ease of use refers to the data model’s usage from the report writer’s perspective, not necessarily the end user or self-service perspective....

Hi Hang Liu,

Everything you're saying makes sense to me.  Thank you.  I am 100% sure I would "graduate" from the FKs in the fact table to additional dimensional work if...

@jeff,

Wait ... what?  I apologize, in that case, because all this time I thought you were arguing on the side of perf and resource usage, and all I was saying...

Hi Hang Liu,

Thank you again for your article and for this neat summary of the questions and trade-offs.  I'm glad you are continuing the series.

>While this solution may not integrate...

> Did you find it necessary to use temporal range tables, like the one in this article, to solve for those questions?  That's really what started this whole conversation.

Of course...

Yep, Jeff, here's the very crux of it:

"Better" has many facets to consider... accuracy, performance, resource usage, easy of usage, etc.

I'm going to say a lot of things below, because...

• This reply was modified 1 year, 7 months ago by Lisa Slater Nicholls.
• This reply was modified 1 year, 7 months ago by Lisa Slater Nicholls.

Fair point @jeff, but I think Ron and many other people who build DWs (or Power BI developers?) are more concerned with making the data, and potential calculations, as transparent...

I like this a lot. And will definitely use it, thank you! But this sentence in the article had me scratching my head trying to understand what you were trying...