Thanks thats great, I'll give it a go 😀

Hi,

After some more playing around I have found that by fully qualifying the MEMBER I don't get the error. Would seem that without that it will default to [MEASURES] (which...

Sounds silly but you have checked you have the same indexes on the new SQL system....

Dean.

Hi,

I have been trying to get the 'WITH MEMBERS' to work within my MDX but I am having trouble.

I can knock together a quick query that gives me the desired...

Why not indeed 🙂 Thanks for the link.

Probably time to get out of the MDX paddling pool and jump in the pool!

Thanks,

Dean.

Thats one of the issues 🙂

One of the columns is a time stamp so I would want to keep the latest entry.

Basically this is a WorkflowStatus table that has status...

Thanks for the replies guys.

I will get the schema and sample data tomorrow and add to this forum.

Cheers.

Dean