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.