Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SSAS and Stored Procedures Expand / Collapse
Author
Message
Posted Friday, August 8, 2014 8:04 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:19 AM
Points: 78, Visits: 166
I am happy you did good holiday in Italy.

Ok i will write to you about ASSP and calculated measure tests.

Regards.
Post #1601196
Posted Sunday, August 10, 2014 4:07 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:19 AM
Points: 78, Visits: 166
Hi.
I tested both of solutions you suggested me..
Unfortunately both i had problems...
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.
Post #1601619
Posted Sunday, August 10, 2014 4:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:19 AM
Points: 78, Visits: 166
Hi.
I tested both of solutions but i had probelms with both.

1) I created a new measure and with SCOPE statement i defined calculation.
If i use that new measure in Excel all it is fine..otherwise in action no.
The value i receive..it is not tha value in THIS= statement but the value of souce field with which i defined in measure group..
I have SSRS 2008 R2 perhaps i am wrong to define my empty measures ???

2) Also with Mosha's blog i had problem
In this case , it seems falis Option Action...
I wrote
Measures.CurrentMember IS [Measures].[Margine Percentuale]
where [Measures].[Margine Percentuale] is a calculate measure..
Perhaps i cannot use calculate measure in Action's Options ???

Any ideas it would be appreciate very much...
Sorry for my questions...

Thanks you.
Post #1601620
Posted Monday, August 11, 2014 4:02 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 8:23 AM
Points: 510, Visits: 996
I have done a little digging and the issue you are having with Mosha's solution (no drill through action showing in excel) is to do with getting the code exactly correct as discussed here: http://asstoredprocedures.codeplex.com/discussions/404064

You're right, as standard Drill through actions cannot use calculated members - the two solutions we have discussed are workarounds.





I'm on LinkedIn
Post #1601745
Posted Monday, August 11, 2014 6:46 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:19 AM
Points: 78, Visits: 166
Hi ..
Many thanks for your reply.
I wrote a message to Code Plex staff , will see...

Regards.

Post #1601828
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse