Hi all,

Thanks for the responses.

Matt, that looks like what I was looking for! What is "partition" in this case? Or is it a keyword used with OVER?

Cheers,

Chris

Hi all,

Thank you for the help and info.

This is all really great stuff, but I have re-architected the data and am now down another path, which has questions listed in...

Hi Phillip!

First off, thanks a TON for the willingness to help. I am definitely learning this stuff, but if I could get a couple of questions/concepts resolved, I think...

Hi Phillip,

So just a straight COUNT(DISTINCT item_id) will work? How does it know to count only those items where the codes align if I am linking things together via...

Yes... Well in BIDS more specifically.

Just to close this thread:

I solved this issue by re-architecting the data, making the Fact table contain only FKs to Item and Customer and then using a Many-to-Many relationship between...

Ok gang...

I have made some progress, but it has left me with an error that I cannot figure out. It doesn't make sense to me how this is even...

I don't understand that at all... can you clarify, please?

Hey there!

Thanks for the response.

Do you mean each code becomes a row in its own dimension table (like DimCode)?

What about if I left them as a string, and created a...

Anyone have any input on this?

Hi Lynn,

So I wound up linking the MySQL server, and am able to query the data and manipulate it, but it turns out to be noticeably slower than using SSIS.

I...

Hi there,

Thanks for the response. Someone else had mentioned linking the MySQL server and doing it that way... I think I will look into this more.

Thanks!!!

Chris