Viewing 15 posts - 16 through 30 (of 1,425 total)
I would ask a dB admin.
You are picking above a certain shipment number for some business reason.
It is not clear if there are multiple items on the same shipment.
March 21, 2019 at 9:57 am
For our DW, it was all internal. So groups were created role roles in AD, and tickets through the help desk. This worked pretty well, as it was visible to...
January 18, 2019 at 5:36 am
Sorry to hear about your dad’s struggle.
Nothing is worse than watching a loved one having health troubles.
Wish the best for you and family, and that there are some better...
January 16, 2019 at 10:47 am
Year to Date vs. some target and Year Over Year might be worth some thought.
Kind of beyond the scope of the original post, but very real questions that are likely...
January 15, 2019 at 9:20 am
We used a 4-4-5 fiscal quarter.
Building a time dimension is usable in both sql and cube.
With 4-4-5 variations you also have a couple extra days possibly moved to a different...
January 15, 2019 at 7:27 am
Try looking at the data for the product ID for each side of the OR ctriteria.
If they are different your distinct might be not so distinct.
January 3, 2019 at 6:49 am
Database Design and DW Design and Strategies fit together pretty well.
I feel your pain on version vs. topic.Some ways to solve an issue are version related.Almost...
May 24, 2018 at 10:06 am
May 22, 2018 at 1:49 pm
May 21, 2018 at 4:42 pm
April 16, 2018 at 8:12 am
Them: Yeah, we can't get our reports from SSRS, we're getting an error.Me: OK,...
March 1, 2018 at 11:21 am
Sample data looks like :...
February 2, 2018 at 9:07 am
January 11, 2018 at 11:54 am
You mention IT and Strategy vs. the Business.The Business is using PowerBI to address from what I see as IT not being able to create insights fast enough to...
January 8, 2018 at 7:12 am
January 5, 2018 at 8:03 am