Post reply

Replicate SQL Function in a Cube

  • November 20, 2013 at 3:28 pm

    #285511

    Hello,

    I hope somebody can help me, I made a 2012 SSAS Multidimensional Cube, but I need to do a function (Assembly) to make a math operation, that must recieve 5 parameters, four dates and 1 decimal value, and return a result, but I have not idea what to do it, i expect yours comments

    thanks

  • November 21, 2013 at 3:38 am

    #1668058

    When you say assembly do you mean in the sense of say, a .net assembly? If so you can add these to your AS server instance. Have a look at this for help on that.

    Or could the function that you have in SQL be achieved with an MDX calculation? Have a think about that last point as you are now dealing with a completely different way of storing data as opposed to SQL. Oftentimes people will get mixed up trying to replicate a SQL process in OLAP. Also think about applying this function in, say, a view prior to processing.

    Good luck.

    I'm on LinkedIn

  • December 6, 2013 at 4:11 pm

    #1671690

    I appreciate your response, it was very useful because we had completed something similar, only we needed to confirm with an expert like you.

    Thanks again.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply