SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSAS and Stored Procedures


SSAS and Stored Procedures

Author
Message
maretix
maretix
SSC Eights!
SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)

Group: General Forum Members
Points: 905 Visits: 234
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,
PB_BI
PB_BI
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4560 Visits: 2745
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 Unsure




I'm on LinkedIn
maretix
maretix
SSC Eights!
SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)

Group: General Forum Members
Points: 905 Visits: 234
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.
PB_BI
PB_BI
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4560 Visits: 2745
I have used many of them extensively ;-)




I'm on LinkedIn
maretix
maretix
SSC Eights!
SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)

Group: General Forum Members
Points: 905 Visits: 234
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.
PB_BI
PB_BI
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4560 Visits: 2745
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
maretix
maretix
SSC Eights!
SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)

Group: General Forum Members
Points: 905 Visits: 234
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]
")
PB_BI
PB_BI
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4560 Visits: 2745
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
maretix
maretix
SSC Eights!
SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)SSC Eights! (905 reputation)

Group: General Forum Members
Points: 905 Visits: 234
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...:-D

Thanks again.

I am writing from ITaly and you ???
Have nice holidays if you will do !!!
PB_BI
PB_BI
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4560 Visits: 2745
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search