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 Saturday, August 2, 2014 12:26 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 82, Visits: 173
Hi to all of you.

Using SSAS DrillThrough Actions i discovered there are any assemblies to help programmers ..
I found this article https://asstoredprocedures.codeplex.com/
Here i read there a lot of very useful SP ...

My silly question is ..'What do i have to do to use them i.e inside a DrillThrough Action or in whatever othet calculated member in MDX ???'
Are they inside in SSAS 2008 R2 Version ???
Or what do i have to do to use them ???

I am not a very expert of .NET Environment...

I.E there are some SP to tell SSAS to customize order columns and names in DrillThrough Actions..

Regards in advance,
Post #1598965
Posted Tuesday, August 5, 2014 9:05 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 @ 9:16 AM
Points: 543, Visits: 1,048
All of the documentation for the the assp project is on their codeplex page.

In answer to your specific question, the only way I know of to change the order of columns in a drillthrough action is to edit the xml of the cube directly. Right click on the cube and choose View Code then find your drillthrough action and change the order accordingly. Be careful in there though





I'm on LinkedIn
Post #1599777
Posted Wednesday, August 6, 2014 5:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 82, Visits: 173
Thank you for your kind reply.
In fact all documentation is in their page..i was so stupid...
I read it and i was able to registry their assembly.
I was also able to change columns order using these ASSP libraries...
I solved all my problems creating a normal ACTION (i read their examples)...

I was able to :

Change Order columns
I can run an action also over a calculated measure not only over a standard measure
I can change the name of the columns with a more friendly name..

I think their very good...

I.E

ASSP.GetCustomDrillthroughMDX(
"[Vendite].[Importo Venduto] as [Importo Venduto]
,NAME([$TessereClienti].[Codice Tessera]) as [Codice Tessera]
,NAME([$TessereClienti].[Codice Tipo Tessera]) as [Tipo Tessera]"
)



There a lot of ASSP useful for generic problems...not only DRILLTRough..
I suggest to you to test them...

Thanks again.
Post #1600149
Posted Wednesday, August 6, 2014 6:10 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 @ 9:16 AM
Points: 543, Visits: 1,048
I have used many of them extensively




I'm on LinkedIn
Post #1600185
Posted Friday, August 8, 2014 3:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 82, Visits: 173
Well i think they are useful...

A question if you know..

Can i have Actions both (Rowset) and Action Drillthrough ???
In Action (Rowset) can i write everything in CAPTION ???
Can i have multiple Actions(Rowset) with different names in CAPTION ???

Thanks in advance.
Post #1601090
Posted Friday, August 8, 2014 4:12 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 @ 9:16 AM
Points: 543, Visits: 1,048
You can have multiple actions on a cube, doing different things. As for the caption, you are limited only by your imagination (and any reserved characters).
The caption can also be MDX (which you specify by setting Caption Is MDX? to True). So you could have something like (pseudo code) "Show drillthrough for "+[Dimension].[Attribute].CURRENTMEMBER

This would show a contextual caption based upon what the user was clicking on.





I'm on LinkedIn
Post #1601106
Posted Friday, August 8, 2014 4:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 82, Visits: 173
Thanks for your kind reply..
Uhm it is very interesting what you are writing to me..

I have a last question...if you are so kind

I am writing a ACTION(Rowset) like that ..
My trouble is that i receive an error about [Margine Percentuale]
[Margine Percentuale] is a calculated member and it is not included in a Measure Group..
How can i do that ???
Excel when i invoke the action, tell me that [Margine Percentuale] is not present in the cube ..
I tried also writing [Measures] but i receive error ...

Regards in advance.

ASSP.GetCustomDrillthroughMDX(
"[Margine Percentuale] as [Margine Percentuale]
,[Vendite].[Quantita] as [Quantita]
,[Vendite].[Importo Venduto] as [Importo Venduto]
,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]
,NAME([$Marca_Modello].[SOLO CodiceInterno]) as [Codice Interno]
")
Post #1601111
Posted Friday, August 8, 2014 4:34 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 @ 9:16 AM
Points: 543, Visits: 1,048
I'm not 100% sure but if it's anything like KPIs then there are restrictions when it comes to calculated members - this is because MDX is calculated on the fly and Actions/KPIs are part of the larger MDX code.
A way around this I have heard of (but never tried) is to put the calculated member into a SCOPE, thereby tricking SSAS into thinking it's an actual measure, rather than a calculation.
So in your measure group, create an empty measure and call it what you need to. Then your SCOPE statement would be
SCOPE [Measures].[Your Empty Measure];
THIS = Your calculation;
END SCOPE;

There is an alternative to doing this here: http://sqlblog.com/blogs/mosha/archive/2008/09/01/drillthrough-on-calculated-measures.aspx





I'm on LinkedIn
Post #1601115
Posted Friday, August 8, 2014 4:42 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:08 AM
Points: 82, Visits: 173
Many thanks.
I read it too..
So i will try and i will reply..in this blog...

What numbers of workarounds we need to do...

Thanks again.

I am writing from ITaly and you ???
Have nice holidays if you will do !!!
Post #1601117
Posted Friday, August 8, 2014 5:07 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 @ 9:16 AM
Points: 543, Visits: 1,048
Greetings from the UK! I've just got back from a 2 week holiday in Italy - a little place called Montefoscoli in Tuscany. It's a beautiful country

Let me know how you get on with the code.





I'm on LinkedIn
Post #1601125
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse