Viewing 6 posts - 1 through 6 (of 6 total)
I believe you are having a data type mismatch issue. The sales value is a decimal and specifying "0" is an integer. You should be able to change...
October 17, 2012 at 9:43 am
I can't remember if SSMS 2008 R2 would let you connect to SSIS 2005 or not. If it did it could present some issues if you tried right-clicking on...
August 28, 2012 at 5:42 pm
SSMS 2012 will only connect to SSIS 2012 out of the box. I found a site that lists a work-a-round, but I haven't tried it personally to see if...
August 28, 2012 at 5:32 pm
As long as Dim A-D are all linked together through the fact table, you should be able to add Dimension A as the initial Dimension and the rest of the...
August 28, 2012 at 11:28 am
Check out this link:
http://www.bp-msbi.com/2011/04/ssrs-cascading-parameters-refresh-solved/. Apparently not refreshing the default value on cascading parameters is by design. The above link shows a work around to this behavior.
August 28, 2012 at 11:16 am
Did you try setting the advanced property of the parameter to "Always refresh"? Sometimes the "Automatically determine when to refresh" decides not to refresh the default value for the...
August 28, 2012 at 10:06 am
Viewing 6 posts - 1 through 6 (of 6 total)