Thanks all.

Adding to the existing one is what I am testing now.

Thanks for that.

I see where you are going. This is a new dimension table for the calendar you specifiy.

Or I could add columns to our existing calendar dimension.

Cheers.

Thanks Mike.

You have answered my question.

I realise now that the INSERT INTO is the start of a new SQL statement so the UNION has nothing to do with it.

Time...

Thanks Dirk - sorted. Added a composite key on the qtr and year fields.

Thanks for that but am a bit lost - where do I get the key of the Quarter attribute.

Please accept my apologies for being such a newb....

Is that a user on the SSAS server sql instance John ?

The SSRS server logins as SERVER\Administrator

The SSAS server; All services use a setup account called ZZ_SQL_<Servername>

Since I wrote the...

Thanks for that Jack.

I did get it to work by using

UPDATE mf

instead of the actual MITFAC table name.

I am doing some boning up now on how SQL actually parses...