Viewing 15 posts - 1,816 through 1,830 (of 3,507 total)
Per Joey D'Antoni. About face, go back to Excel, upsize from there. There's a hack, but for what I'm doing, not worth the hassle.
August 30, 2016 at 1:45 pm
Hi,
Welcome to SSC. Since you're new and your question isn't entirely clear, perhaps reading one (or both) of these articles will help us to help you.
August 29, 2016 at 3:47 pm
Where's the PARTITION BY Company part of your query? PARTITION BY is analogous to GROUP BY... and it seems to be missing, so the totals/counts won't "restart" when the Company...
August 29, 2016 at 2:55 pm
First things first, since you clearly missed it.
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
If you post some consumable data, this probably isn't...
August 28, 2016 at 9:44 pm
" even tho it will double the rows to load into the dim"... so? If you have a normal data warehouse, the number of rows in a dimension table...
August 25, 2016 at 2:51 am
Jeff,
I would but then I would lose the ability to drill into it. It's the smallest data warehouse structure ever! 3 dimension tables and a fact table. Not terribly...
August 22, 2016 at 8:29 pm
What is being clicked on to bring up this menu? When I click the dropdown arrow next to my measure under the Values section, I get just two options: 'Remove...
August 22, 2016 at 1:38 pm
I figured it out...
DIVIDE( [Symptom Count],
CALCULATE(COUNTROWS('Diagnoses'),ALL('Diagnoses'))
,...
August 22, 2016 at 12:42 pm
any chance you can post the two tables... the T-SQL to create and populate them? Then it would be a lot easier to follow...
Not sure but you may need...
August 21, 2016 at 4:28 pm
T-SQL Programming Part 9 - Using the MERGE Statement to Perform an UPSERT
Wait, the more I read your post, the less sense it makes. What are you REALLY trying...
August 21, 2016 at 4:03 pm
How about doing the UPDATE on matched data, then doing an INSERT. Just do the whole table at once. (So it would have to be imported into a table...
August 21, 2016 at 1:45 pm
Sounds like an UPSERT...
August 21, 2016 at 11:42 am
No, all you need are ProductKey, and maybe an alternate key.
The rest of the columns in a Dimension table are just for grouping when you do your analysis.
August 20, 2016 at 9:35 am
Just googling around found this discussion on StackOverflow showing how to do what you are asking in PowerShell.
August 18, 2016 at 5:52 pm
August 13, 2016 at 1:18 am
Viewing 15 posts - 1,816 through 1,830 (of 3,507 total)