Using ASSP in Condition || Drillthrough Actions

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

Can we use ASSP or any other dll in condition part while defining actions for calculated measure?
Coordinator
Nov 9, 2015 at 6: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 7:18 PM
Edited Nov 9, 2015 at 7: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
Coordinator
Nov 9, 2015 at 8: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 6:04 AM
Thanks Darren. I had already tried above fix without StrToSet function. it worked after introducing this function in my logic.