Create counter in a dataflow

Previous Member

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

Previous Member

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