Oh to be able to code on 2005...

My company refuses to let us upgrade to new software until it's been out for a...

Apologies... it was my colleagues question to me which had me stumped and I essentially just pasted in his question without illustrating it.

Ironically... whilst typing out an explanation just now...

Never tried it but have often read these details in MSAS2000 from the OlapObjects table in the repository.

Theoretically you could maybe UPDATE that but the idea scares me somewhat......

Oh no, the worst kind of solution... the one where you've no idea why.

I don't know if it's a clue but that's an ODBC error message and I think the...

Re: Dates

I wouldn't. I think it depends on what you are trying to report though. To expand a little:

Joining a FACT table to a Dimension table effectively is creating an inner...

Have you tried opening the repository in Access?

Right hand click on the server and select Edit Repository Connection and have a look in there... should tell you the location...