Post reply

SSAS: Calculated Measures doesn't show in actions columns

  • June 9, 2011 at 1:03 am

    #237702

    Hi,

    I have created calculated measures [monthrevenue] for month, [yearrevenue] for year.

    In actions tab, I created new drill through action. In that, Drill through columns, while selecting Measures, I can't see the above calculated measures. I see only default measures that are created while creating cube.

    Please help.

    Thanks.

    Thank You

  • June 9, 2011 at 5:27 am

    #1336183

    By default, you can't use drillthrough with calculated measures. There are ways around it though, as is discussed here:

    http://sqlblog.com/blogs/mosha/archive/2008/09/01/drillthrough-on-calculated-measures.aspx

    Drillthrough's are expanded upon in the ASSP project on codeplex:

    http://asstoredprocedures.codeplex.com/wikipage?title=Drillthrough&ProjectName=asstoredprocedures

    Hope this helps 🙂

    I'm on LinkedIn

  • June 9, 2011 at 5:58 am

    #1336201

    Thanks for the reply.

    However I heard that we can set scope for calculated measures so that the calculated measures will appear for drill through.

    How far it is correct?

    Thanks.

    Thank You

  • June 9, 2011 at 8:08 am

    #1336323

    I think if you tried that SSAS would still know that it is a calculated measure being used in the scope.

    I had a quick google search and found this from a SQL Server board:

    instead of a calculated member, one could create a physical measure, and then override its values using Scope statements with the calculation that needs to be performed? That way, to client applications this will still appear as a measure and drill through actions wouldn't be prohibited.

    I have no idea if this approach would work though. If you do try it then post back what the result was.

    Good luck 🙂

    I'm on LinkedIn

  • June 10, 2011 at 7:18 am

    #1336960

    Thanks a lot for your help.:-)

    It worked. I created a physical measure with 0 value. Later in calculations, I override its value using MDX scope

    Thank You

Viewing 5 posts - 1 through 4 (of 4 total)

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