select distinct count(substr(d.global_attribute3,2,8)||d.global_attribute4||d.global_attribute5) Codcliente
from ra_addresses_all d

WITH MEMBER ([Measures].[Codcliente]) AS
  dimensions.count
SELECT ([Measures].[Codcliente]) ON 0
FROM [Vendas]