Yes, this would be ok. In fact, it would be desireable, assuming the comments could be made into an attribute.

I think more information is needed, but as a general rule, you would not want to import straight duplicates.

I think your original solution solves the problem well.

Your boss will need to give you a lot of extra time. If there is any complexity to your business, and the assumption is that it would be, this...

For whatever reason I have found that most of the most creative IT professionals have a degree in a non-STEM subject, if they even have a degree at all. ...

I got a fact table with 10 columns (let us say column A-J). Columns A-G determines the unique set of records. Does that mean I have to create primary key...

I'm not sure what purity has to do with it. If there's a business need for it, then it's our job as data organizers and providers to make that...

You seem to be describing fact tables that can be construed as parent child. If that's the case, most, if not all or nearly all, dimensions that can be...

Sorry, but you...

You need to provide more information. How are you trying to update the variable, for example. Thanks,

I haven't tried to use currency, but I have found that for many number related items, I have to import the items as an append into a worksheet that has...

Agree...

Each cube has a visible property. Maybe it was somehow set to false? I know this is an old thread, but this just happened to me, and that...

You can create a fact dimension that references such properties that are part of the fact table but don't belong in an dimension. You must remember to reprocess it...

I have and they are. The numbers don't come anywhere close to the upper limits of an integer.