Viewing 15 posts - 931 through 945 (of 1,353 total)
Yes, I set them both to UnsignedInt, since there's no possibility of a negative number.
October 6, 2011 at 3:58 am
I had to change BOTH the data type field in the Advanced section of the measure properties and the data type field in the Basic section. The second is...
October 5, 2011 at 7:02 pm
I have found the stupid thing I overlooked. I had to manually override the data type in TWO places, both properties of the measure. I had altered it...
October 4, 2011 at 8:58 am
I started relooking the issue again. There is a number in the same cube and same spreadsheet with the same data type and it adds up perfectly, and it's...
October 4, 2011 at 2:31 am
I thought of that, and will try it if nothing else comes up. I've disregarded that up to this point, however, because added plenty of fields that have a...
October 4, 2011 at 2:14 am
Agreed. We are glad to help with specific problems, but this is basic research that you need and should be able to do yourself.
October 3, 2011 at 7:23 am
There is an attribute with a composite key comprised of two fields and I linked the dimentions to the fact table by it.
This isn't directly related to your issue, but...
September 30, 2011 at 8:04 am
And also, assign default values to dimension entities.
I don't normally recommend this because when the dimension is not present, it can create confusing information for the user.
As for the Unknown,...
September 27, 2011 at 2:54 am
This one is a tough one, and w/o more information it isn't possible to say with certainty the best way forward.
With things as complicated as you say, I would generally...
September 19, 2011 at 5:45 am
Whether the new manager is tracked with a new row or simply overwritten is not a technical decision, but a business one. There may be lots of reasons to...
September 19, 2011 at 5:31 am
The multi cast won't do it sequential as you initially asked, it's going to go file to Table A and file to Table B, but this should still be okay....
September 19, 2011 at 5:26 am
Still don't understand why you truncate the Time dimension table. I assume that's the date, but either way, the calendar is not changing.
September 13, 2011 at 9:54 am
I applaud your SSIS skills. I'm concerned, however, why you would want to take such a drastic approach and that others reading this will think that this is normal.
I...
September 13, 2011 at 4:37 am
You don't say what version you are using, but I'm pretty sure I've seen that one of the improvements in 2008 is updateable named sets. So if you're using...
August 31, 2011 at 2:08 am
You can populate a date output parameter using the Execute SQL Task by setting the variables in the result set. The first column, Result Name, type 0 (the number...
August 30, 2011 at 1:16 am
Viewing 15 posts - 931 through 945 (of 1,353 total)