thanks for your replies. I was thinking that too, to be honest, that 1 tool and 6 months is not nearly enough time. However let me tell you about the...

To update : The issue is I don't want to lose the unique reference numbers from the table as I also want to be able to drill down directly to...

No help so far?

I'm so close to smashing my head into concrete! I imagine the logic is about SCOPING the dimension to only the skill group top level, performing the...

My only concern with moving to SSIS is my experience performing tasks such as lookups from OLE DB sources operations are SLOW, really slow compared to SQL code.

I appreciate just...

Thanks guys - both suggestions will work and from your advice, I think i'll stay away from the UNION approach and just plump with either a staging table or insert...

I have had a similar issue. I deleted the cube and then re-deployed it with the new name. Issue resolved.

Backup the cube first, though.

amit_gupta01 (1/12/2011)

---

You will have dimension surrogate key (say DSK) in dimension and same key will be in fact also. So if you join fact and dimension on the same DSK...

You know, I thought his reply was rude and was elitist - but then i researched who he was and removed my post berating his communication style because I thought...

-

Dave Ballantyne (12/23/2010)

---

To restate your problem :

You need a list of 5 minute intervals betweeen '07:45:00' and '20:15:00' that are between the start and stop time on wfm_actualactivity.

Is that correct...

Dave Ballantyne (12/23/2010)

---

Then i suspect something like this....

Create Table #Source

(

dateRaw datetime,

Agent varchar(20),

Exception varchar(20),

e_start datetime,

e_end datetime

)

go

Insert into #Source(dateRaw,Agent,Exception,e_start,e_end)

select '2010-01-06',...

23,000 rows ish.

with 1500 rows per day.

Yes. Well, any interval really, I would much prefer 1 minute intervals, the problem is query time which is why it's 5 minutes.

The source table looks something like this.

date, agent,...

Frustrating. Reading through this thread a smile grew on my face as I realised I had found the resolution to my issues.

Alas not. I have exactly the same problem as...

gtschech (11/11/2010)

---

This seems to be a pattern......