Hi Calvin,

Excellent, thanks for that 🙂

2 of the other tasks in the DTS are to set a flag in a seperate table, which tells the rest of the application that...

Sorry, seems the forum didn't like my table aliases and replaced them with smilies, lol. The table alias is just "V"

Hi Phill, thanks for your reply. What you describe is exactly as I have it setup now (4 tasks can be executed in parallel), but it seems to be performing...

Yes, it turns out the cube does need to be updated immediately. On friday I had a meeting with the client, and it turns out the following is what they...

Hi Mike,

I'm new to OLAP myself, but hopefully I can push you in the right direction.

First, create an OLAP database in Analysis Manager, then click on it to expand it....

LOL! For a minute there you sounded like my boss 😛

Thanks for the book/search advice. Much appreciated.

Mark

Thanks Michael,

I did a search in SQL BOL and AS BOL for "vrs" and came up with nothing. Could you possibly post a link please?

I hadn't seen the source table...

Hi Jennifer,

I was beginning to think noone would answer, lol. Thanks 🙂

I don't want to reprocess the cube because I only have 3 months of data in for our first...