• Hi.

    I tested both of solutions you suggested me..

    Unfortunately both i had problems...:doze:

    Probably my fault ..i explain..

    1) I created a new measure in my measure group and with SCOPE Statement i calculate my new measure.

    If i drag and drop in Excel this new masure Margine Percentuale DrillThrough it works fine..but if i use in an Action...ASSP give me a value that is not correct ..it seems it does not execute SCOPE..i receive the same value with i defined my empty measure ( i have SSRS 2008 R2 STANDARD ..perhaps i wrong to define my empty measure ??? When i create a new measure i need to define it equal to any field of my fact table)..

    ASSP.GetCustomDrillthroughMDX("

    [Vendite].[Margine Percentuale DrillThrough] AS [Margine Percentuale]

    ,[Vendite].[Importo Venduto] as [Importo Venduto]

    ,[Vendite].[Costo Vend Ultimo] as [Costo Venduto]

    ,[Vendite].[Quantita] as [Quantita]

    ,NAME([$Marca_Modello].[Codice Interno]) as [Codice Interno]

    ,NAME([$Codice_Filiale].[generated attribute 24]) as [Codice Filiale]

    ,NAME([$Tipo Documento].[Tipo Documento]) as [Tipo Documento]

    ,NAME([$DettaglioVendite].[Numero Riferimento]) as [Numero Riferimento]

    ,NAME([$DettaglioVendite].[Data Riferimento]) as [Data Riferimento]

    ,NAME([$DettaglioVendite].[Numero Riga]) as [Numero Riga]" )

    2) Also with Mosha's Solution i ha d problems.

    When i am in Excel no action appearing when i am over the interested cell...

    I think i wrong to define Option in Action...

    In Mosha's blog it was like that ...

    Measures.CurrentMember IS [Measures].[Margine Percentuale]

    [Measures].[Margine Percentuale] is a calculated member ..

    Can i use a calculated member in option's Action ????

    Sorry for my silly doubts..if you have any ideas , it wuold be appreciate very much 🙂

    DRILLTHROUGH MAXROWS 100000 SELECT (" +

    ASSP.ASStoredProcs.FindCurrentMembers.CurrentCellAttributes()

    + ") ON 0 FROM [Vendite]

    RETURN

    [Vendite].[Importo Venduto]

    ,[Vendite].[Costo Vend Ultimo]

    ,[Vendite].[Quantita]

    ,NAME([$Marca_Modello].[SOLO CodiceInterno]) as [Codice Interno]

    ,NAME([$Codice_Filiale].[generated attribute 24]) as [Codice Filiale]

    ,NAME([$Tipo Documento].[Tipo Documento]) as [Tipo Documento]

    ,NAME([$DettaglioVendite].[Numero Riferimento]) as [Numero Riferimento]

    ,NAME([$DettaglioVendite].[Data Riferimento]) as [Data Riferimento]

    ,NAME([$DettaglioVendite].[Numero Riga]) as [Numero Riga]

    Regards in advance.