Create counter in a dataflow

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

Hello

 

I am currently trying to do the following: trying to rank some elements in a dataflow

This is the result I would like to obtain (see attachment).

Trying to get this result is fairly simple in a view since the ranking function is available. However, it is not available in processes, so I was wondering if someone on this forum had an idea on how to proceed.

 

Thanks in advance

 

Xavier

Answers

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Hi xavier vanderlynden

     

    I don't have Board to hand to check, but my recollection is that the only way to use the ranking functions 'in a procedure' is to use an 'Extract Layout' rather than a dataflow. Certainly this work if you want to store 80/20 ranking info. Simply put the required ranking function into the layout as normal, extract to a csv/txt file and use an ASCII protocol to load into your target cube.

     

    Rgds

    Robert

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Hi Robert

     

    Works like a charm. Thanks for the tip.

     

    Xavier

Categories