none
Set Analyser

    Întrebare

  • It is possible to perform set analysis using PowerPivot. What I mean is, In SQL Language, can I do Union, Except, Intersect OR do Inner Join, Left Outer Join between different Pivot Table ? Finally trying to get all the data in a form of Venn Diagram.
    24 februarie 2012 16:00

Răspunsuri

  • Hi nadirsql

    In PowerPivot, you are establishing relationships between tables (from a base table to a lookup table). As such, you are not really performing set operations over the datasets.  However, you can do this as part of the data loading process you execute to retrieve data into the Vertipaq engine.    Also, you can compare datasets to find out common keys across tables, or keys that are missing from a table, for example.  You would do this purely in DAX, and though it allows you to find, for example, the keys that belong to the intersected population or rows among two tables, it won't produce the same behavior as the TSQL intersect (which outputs one resultset)




    Javier Guillen
    http://javierguillen.wordpress.com/

    27 februarie 2012 04:38