• Ciao.

    First of all , many thanks for your kind reply.

    I understand what you wirtten , so i thank you very much...

    Fortunately i discover also a good tutorial of C.Webb about MDX concepts SET and TUPLES, so now i am bit more able to do something, even if MDX is not very easy so every time it is difficult to do something..

    My problem was to do an INTERSECT to obtain same members about a CUSTOMER dimension.

    In fact i have in my scenario the same custoemr code in 2 different companies whose data in the same DW.

    So i was able to dot that.

    I think NAMED SETS are very useful,,,without them i never obtain my purpose...

    I could display all customers about 2 companies but i would do a visual serach to discover same customer codes...

    Here is my sample and tutorial that opened my strange mind...:-)

    http://projectbotticelli.com/knowledge/mdx-basic-concepts-unique-names-tuples-sets-video-tutorial?pk_campaign=cw2012cwb

    ===================

    SET 1

    ====================

    FILTER ([Stat_Resp_Age_Cli].[Gerarchia SOLO CodiceCliente].[CodiceCliente].members

    ,

    [Azienda].[Chiave_CodAzienda].[2])

    ===================

    SET 2

    ====================

    FILTER ([Stat_Resp_Age_Cli].[Gerarchia SOLO CodiceCliente].[CodiceCliente].members

    ,

    [Azienda].[Chiave_CodAzienda].[1])

    =======================

    SET USED IN Excel to obatain data i wanted

    =======================

    INTERSECT

    (

    [Set Clienti CER]

    ,

    [Set Clienti COMET],ALL

    )