Viewing 15 posts - 16 through 30 (of 50 total)
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...
December 27, 2011 at 6:34 am
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!
October 14, 2011 at 10:00 am
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...
October 12, 2011 at 6:58 am
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...
October 12, 2011 at 6:47 am
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...
October 11, 2011 at 2:37 pm
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....
October 11, 2011 at 11:53 am
BenWard (7/11/2011)
rmechaber (7/11/2011)
Can someone explain to me why you might expect the SUM(CASE) construct wouldn't work? I use this all the time and thought it was pretty straightforward T-SQL.
lol...
July 11, 2011 at 8:18 am
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...
July 11, 2011 at 8:08 am
umas (6/28/2011)
This customer name is an attribute (Keycolumn: CustomerNo ; NameColumn: CustomerName) in my dimension called Shipment (Key column: CustomerNo, Shipment Date, ShipAgentCode ; NameColumn: CustomerNo).
Uma,
Have you made...
July 1, 2011 at 6:40 am
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...
June 29, 2011 at 11:02 am
Happy to help!
Chris Umbaugh
Data Warehouse/BI Consultant
@chrisumbaugh twitter
June 23, 2011 at 2:09 pm
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...
June 23, 2011 at 1:17 pm
That worked! I don't really understand why it worked but it does. Thank you for the suggestion!
Chris
June 17, 2011 at 6:01 am
Viewing 15 posts - 16 through 30 (of 50 total)