Hi Magoo,

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

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

Budd,

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

Budd I think that is the perfect way to do what you want. Why don't you want to use the UNION clause?

Ash

Budd,

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

That makes perfect sense. Kudos to you and of course the Jasons.

Ash

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!

Ash

I take it all back, you were absoultely right!!!

Thanks so much everyone,

Ash

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

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

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

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

Morning Neela,

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

Hey Neela,

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

Hey Neela,

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