Recent content by kiwilamb

Sorry about that, but this type of product would only ever be bought by a subset of the customers (different business)so the possibilities would be Yes, No, n/a, I would want to differentiate the n/a and the no's. Which I could do by Customer type.

Thanks for the replies based on the two answers I need to do some experimenting to see what wil offer us the best solution. We aren't capturing history with this dimension but it is a slowly changing dimension, we have approximately 900k records in this table and adding 50k or so a year...

Hi there I have a customer dimension table and I have attributes that are only relevant to some of the customers. If I included these attributes in the table it would mean that I have null (or a key that equals null) for many of the records. I may have a few of these types of attributes...

Hi there I'm attempting to write a report where I have a running balance value field which I want to dissect and show the net amount for the value (today's value less yesterdays). I also have a field which is value type (say Actual and Budget but there are more than this) which means I can't...