Ranking on data Loads

Jsdeloria21
Jsdeloria21
in Integrations and extensibility

Hi,

 

Please see attachment for details.

 

Thanks in advance.

 

Regards,

Tagged:

Answers

  • LipChean_Soh
    LipChean_Soh

    Hi Jsdeloria,

     

    I'm not sure what your end goal is, whether you're trying to come up with a unique ID for your transactional data, etc etc.

     

    But if you're trying to derive unique ID using Anaplan, then our experience with other clients tell us that this is a solution which is unsustainable and performs poorly [This goes against the 'P' & 'S' within (P)LAN(S)]. The reasons are:

    1. There'll be a lot of TEXT formatted formulas and line items. Anything 'TEXT' is bad for performance. While TEXT is unavoidable, we should still do our best to limit the usage of TEXT.

    2. I'm not sure how big your Transaction list will grow, but a module with USERS x Month x Transaction list will be huge.

     

    Please check out myth 3 in https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-1/ba-p/44493

     

    But in anycase, do see if the following works:

    Screen Shot 2019-05-06 at 12.05.28 PM.png

    1. Number = VALUE(MID(NAME(ITEM(#Transactions)), 2, 10))

    2. Rank = RANK(Number, ASCENDING, SEQUENTIAL, ISNOTBLANK(Metric))

     

    Thanks,

    LipChean

Categories