Not sure I completely follow your requirement to 'filter every table' but one approach, that will give you the full recordsets from each table, could be written like ...

SELECT ID,...

If you edit the Data Source View, and then right click the fact table, select the option to view the data, does anything get returned?

If there is data returned, then...

Yeah, agreed on the multiple diagnosis example, was more leaning toward the multiple owners of a single bank account, so in your case, multiple NDC 'Groups' 'owning' a single NDC....

Hey Pete,

Isn't this a (somewhat) classic case of many-to-many? Kimbal covers how to manage this with a bridge table (basically NDC stays in the fact, joins to bridge, then...

Have to agree with Ron here - if you simply took the additional attributes from your snow-flaked table and add them to the Period dimension, you can likely create all...

Very roughly this is what I would try to do....

First source is to read from the ID_PPL table, so stream of incoming data is simply

ID Name

1 ...

If joins are the issue, you could try using a Merge Join as this supports Inner, left outer and fullouter joins.

Hope it works for you. I didn't have (didn't take the time to include) any characters that would have proven out the encoding on the received message, so am...

Forgot to mention too, when reviewing the messages in MSMQ, the byte count did rise by 23 for those messages where it *appears* that the encoding has stuck.

For what it's worth, it *appears* that the following code will result in the message retaining the ISO-8859-1 encoding. I will note though, that I was mucking around with...

Sounds like you want dynamic security versus a static setup int he roles. It's a little old now but the following is an article on how to implement dynamic...

Nat,

Not sure what you're aiming for here? 'Generally' (yes, a big generalization) you'd use the DB config as a central repository of configuration/s so that all packages, on any...

Ok, i *think* i'm following....

I think, in reality, you're not looking to 'deal' with a hidden dimension. You're looking to re-write the MDX to not use/reference it. To...

I think you've answered some of your own question - you need to have access to the cube to modify it in any way (such as removing a dimension), or...

Are you saying that, when viewed through BIDS/VS, the dimension does not exist in the dimension list (and is not an attribute in any other existing dimension)?

Possibly there is a...