ps_vbdev (6/30/2014)
AdditionallyIf i have one mini-dimension for both color and size this would still give about 5million combinations so could i split this further down to having two mini-dimensions, one for size and one for color feeding into the fact table. otherwise its just sort of moving the problem isnt it?
5 million combinations for sizes and colors? How many colors and sizes are there?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP