Dimension.Currentmember ?

• Michael Torsson

  SSC Eights!

  Points: 881

  More actions

  April 29, 2014 at 12:29 am

  #145013

  Hi

  I am using ASSP.DiscoverSingleValue() to get the description set on the measure according to asstoredprocedures.codeplex.com/wikipage?title=DiscoverSingleValue

  In combination with Gregs solution:

  http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=17.

  That works well, but I would like to get the description on dimensions as well., without adding an action in ssas on every dimension. The ASSP function can to that for me by using the MDSCHEMA_HIEARCHIES, but I haven’t found any way to do it dynamicly. With measures I use Measure.Currentmenber.

  Is there a way to get CurrentMember on the DimensionCell that has been rightclicked on I n Excel?

  Thanks

  Michael