Forum Replies Created

Viewing 15 posts - 16 through 30 (of 50 total)

  • RE: Christmas Fun

    Rudolph is an imposter!

  • RE: Query Tuning

    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...

  • RE: Using SP_

    Did not know that. Thanks!

  • RE: Merge statement

    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!

  • RE: MDX Query: Every end of each month on rows

    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...

  • RE: exceptional logic

    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...

  • RE: Unsure about Fact and Dimension

    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...

  • RE: exceptional logic

    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....

  • RE: In-CASE you need to SUM...

    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...

  • RE: In-CASE you need to SUM...

    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...

  • RE: Calculated Measure using Grand Total

    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...

  • RE: Calculated Measure using Grand Total

    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...

  • RE: Calculated Measure using Grand Total

    Happy to help!

    Chris Umbaugh

    Data Warehouse/BI Consultant

    @chrisumbaugh twitter

  • RE: Calculated Measure using Grand Total

    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...

  • RE: SSRS Matrix Subtotal Random Label Behavior

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

    Chris

Viewing 15 posts - 16 through 30 (of 50 total)