Rudolph is an imposter!

Great question Jeff! I like you explanation for the last answer, option (I). I was going to be angry if that were one of the correct answers. We do not...

Did not know that. Thanks!

Nice question!

All this time travel has me a little freaked out. To everyone from September: Don't put your money on the Yankees in October!

Are you looking for the sales ON the last day of each month or the sales for each month AS OF the last day of each month (including all of...

Ben,

I absolutely will be using these keywords now that I know about them and what they do. I have a habit of comparing and contrasting "new-to-me" techniques and tools...

I would always choose to materialize my facts and dimensions separately in ETL as you suggest TVR. I am unclear on what business event you are attempting to measure (having...

I also had never heard of EXCEPT and INTERSECT and learned a lot from this QOD. I even had an opportunity to employ INTERSECT in a QA query this afternoon....

BenWard (7/11/2011)

lol...

Good question! The title almost had me fooled too. I breezed right by and figured 47 would be the answer. However, I've been answering these QODs long enough to know...

Uma,

Have you made...

Uma,

Sounds like you need to SCOPE the calculation. SCOPE over-rides a member when the specified set is "in scope". If I have some time tonight, I will shoot a...

Happy to help!

Chris Umbaugh

Data Warehouse/BI Consultant

@chrisumbaugh twitter

Hello,

So I understand that you basically need to allocate values to members based on a value of a member at another level, the ALL member (the total shipment amount). Here...

That worked! I don't really understand why it worked but it does. Thank you for the suggestion!

Chris