Viewing 15 posts - 1 through 15 (of 22 total)
I think with my use case it is imperative that where no variables have changed then each day must have the same amount. When reporting (using an SSAS cube)...
December 8, 2016 at 1:34 am
I have this scenario. Start with an integer value e.g. 365000. Over a period of time (usually a year) I will add one record a day with a proportional amount...
December 7, 2016 at 9:41 am
I think with such a simple query performance would be best improved with good use of indexing. If possible create a clustered index on the column in your WHERE clause,...
May 9, 2014 at 8:54 am
Budd I think that is the perfect way to do what you want. Why don't you want to use the UNION clause?
May 9, 2014 at 7:51 am
I am not sure what you are trying to acheive. When you say "one joined or conditonal statement" what would the condition be? If it is a particular ID from...
May 9, 2014 at 2:50 am
That makes perfect sense. Kudos to you and of course the Jasons.
October 3, 2012 at 9:42 am
Way ahead of you Brendon - amended, deployed and tested. All is well.
Thanks for the follow up. Get someone to make you a nice cup of tea. You deserve it!
October 3, 2012 at 9:32 am
I take it all back, you were absoultely right!!!
Thanks so much everyone,
October 3, 2012 at 9:25 am
Thanks for the quick replies.
I have refreshed my memory on parameter sniffing. I am not convinced that this is the issue, for two reasons:
1) Would the execution of the stored...
October 3, 2012 at 9:16 am
A further update on using AMO to add descriptions to dimension attributes.
I was having problems with this. The code was running fine (all green in the SSIS package) but the...
December 22, 2011 at 10:06 am
I've been working my way through this and am very pleased with the results so far.
One thing people should note is that if they choose to sync Cube Dimensions using...
December 22, 2011 at 7:02 am
You seem to have not provided all of the VB code. For example, where are you providing the name of the stored procedure to run? Where are you setting the...
October 7, 2008 at 10:15 am
I think I've cracked it. Just added a WHILE loop to call the UPDATE statement whilst there are zeros. Then get rid of the NULLS at the end by...
September 26, 2008 at 3:05 am
I thought that might be the case. We just need to call the UPDATE several times to cover all the zeroes.
I will look at this tomorrow morning if that...
September 25, 2008 at 10:19 am
Schoolboy error - I didn't read the question properly, where you clearly said "I want to update the Amount column which has value zero."
This should simply be a case...
September 25, 2008 at 2:12 am