locked
DAX calculation lineage viewer RRS feed

  • Question

  • The calculation lineage viewer announced at Microsoft BI conferences looks like a very interesting tool.  Other than the fact that it will show dependencies between DAX calculations, do any of you know where we can find more details about it?  We want to start learning about its capabilities

    Thanks!!!

     




    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx
    Monday, February 14, 2011 1:55 PM
    Answerer

Answers

  • Hi Javier,

    You might have seen a prototype we were experimenting with. We don't have any current plans for building that into the product as yet. However, the dependency graph of calculations will be provided natively as part of the product so you can discover these for yourself and visualize as appropriate.

    Regards

    Ashvini Sharma

    Analysis Services

     

    Wednesday, February 23, 2011 5:13 AM

All replies

  • Hi Javier,

    You might have seen a prototype we were experimenting with. We don't have any current plans for building that into the product as yet. However, the dependency graph of calculations will be provided natively as part of the product so you can discover these for yourself and visualize as appropriate.

    Regards

    Ashvini Sharma

    Analysis Services

     

    Wednesday, February 23, 2011 5:13 AM
  • Thank you so much for your response Ashvini

    Yes, the prototype I saw appears on this page (third screenshot): http://www.powerpivot-info.com/news/428-june-8-2010-microsof-presented-first-information-on-what-to-expect-in-next-powerpivot-release 

    Is this different from the dependency graph of calculations?  If it is, is there any blog/white paper/description about it?

    One of the reasons I am interested on it is for troubleshooting DAX calculations.  It is not always obvious what the filter context applied to a cell is when dealing with complex measures, even more if they use multiple evaluation passes. It would be great to be able to tell with certainty which filters where applied to a calculation output, or what were the active rows across one or many tables when determining how the engine interprets the expression context.




    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx
    Sunday, February 27, 2011 6:05 PM
    Answerer