Which function is the fastest

    HI SvenAndersen,

    The functions are not a similar work.
    PALO.DATA.CNT Count the amount of not zero cells in a specific combination of dimensions
    PALO.SUBSETSIZE show the size of a specific dimension subset(Its similar to a SQL count distinct).This function only works fine with "smalls" subsets of "smalls" dimensions. This Palo function are composed by PALO.SORT() and PALO.HFILTER(), and performance is not good with large subsets (>1M elements).

    I hope been helpfull

    Jorge López Hernández

    Business Intelligence Consultant

    +34 912 868 220– jlopezhernandez@quental.com