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

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

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

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

I figured it out...

DIVIDE( [Symptom Count],

CALCULATE(COUNTROWS('Diagnoses'),ALL('Diagnoses'))

,...

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

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

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

Sounds like an UPSERT...

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.

Just googling around found this discussion on StackOverflow showing how to do what you are asking in PowerShell.

DelimitedSplit8K maybe? Read the article, which is here[/url].

Welcome to SSC,

Since we're not at your computer, you'll have to meet us halfway and provide CREATE TABLE and INSERT scripts to populate them. Please read this article "Forum...

SSC is becoming SPAMalot??? Hmm... Anybody have coconuts (or am I mixing up Camelot and Holy Grail?)

It's one of those "features" they don't tell you about... Maybe check out Jessica Moss's articles on SSRS to see if there's anything there that's helpful.