I tried this but couldn't get it working.  Can any one help please

with member [x] as

CASE

WHEN [dash sap crm Visits].[visit type].currentmember.member_value = 'phone call'

THEN

"https://my346449-sso.crm.ondemand.com/sap/public/byd/runtime?bo_ns=http://sap.com/thingTypes&bo=COD_GENERIC&node=Root&operation=OnExtInspect&param.InternalID="

+ [dash sap crm Visits].[sap link visit].currentmember.member_caption

+...

Hi

Thank you for the reply.  I was search for help with IF statements.  Didn't realise you could use CASE in MDX.

I will give it a go

Thanks

Nick