Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kiwilamb

    Attributes that don't relate to all of the dimension records.

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

    Attributes that don't relate to all of the dimension records.

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

    Attributes that don't relate to all of the dimension records.

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

    Net Change summary

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

Part and Inventory Search

Back
Top