This project has moved and is read-only. For the latest updates, please go here.

Using ASSP in Condition || Drillthrough Actions

Topics: Developer Forum, User Forum
Nov 9, 2015 at 1:31 PM
Hi All,

Can we use ASSP or any other dll in condition part while defining actions for calculated measure?
Nov 9, 2015 at 7:29 PM
Sure. I think it will have to be a sproc that returns a scalar like:
http://asstoredprocedures.codeplex.com/wikipage?title=DiscoverSingleValue&referringTitle=XmlaDiscover
Nov 9, 2015 at 8:18 PM
Edited Nov 9, 2015 at 8:24 PM
what if my function returning a string which will then be evaluated as Boolean?

I have written a functional which will returns below string

Except([Measures].CurrentMember, { some comma separated measure names }).count=0

It is not working. When I manually put this string in condition section, it works.

Please advise
Nov 9, 2015 at 9:42 PM
The condition for an action has to return a boolean value the string "Except([Measures].CurrentMember, { some comma separated measure names }).count=0" is not a boolean. If there is some complex logic to work out the list of measures to exclude you could change your function just to return that list.

Except([Measures].CurrentMember, StrToSet( MyDll.MyFunctionCall() ) ).count=0

But if you can write the expression in pure MDX you should do that as there is a performance penalty to calling a .Net function in SSAS.
Marked as answer by furmangg on 11/11/2015 at 3:55 AM
Nov 11, 2015 at 7:04 AM
Thanks Darren. I had already tried above fix without StrToSet function. it worked after introducing this function in my logic.