How to use the RANK function

taku.s

Hi everyone.

I would like to use RANK function and extract only the data for the most recent date.

However, the module have over 10 million cells. RANK function cannot be used...
What should I do now?

The following error message is displayed.

Best regards.

Accepted answers

dmitrii.mamaev

Hello, Taku!

In my opinion you should at first transform your module with 3 dimensions to module with 2 dimensions only, and only then use Rank function.

The easiest way is to make view in current module that filter only the calendar date you need, and then import it to new module with action. It would make from 300x to 1000x values less. It would be less than 1mln cells for rank function.

All comments

Misbah

@taku.s

Initially it used to be lesser than 10 Million, they have increased it to 10 Million in Q2 2018 but this still is a limitation - I guess to avoid performance issues. However I would like to ask if you you are trying to rank in multidimensionality or Is it just 2 dimensional where you dimension is too big for Rank function to perform. Can you please post your requirement and the way you have coded it.

Thanks,

Misbah

Akhtar.shahbaz

Hi @taku.s

I agree with @Misbah , If you can provide us screenshot then we can provide better solution.

As of now i can think one workaround for your case:

1. Create a System module to select the " From & To date"

2. Better to create another System module for Filter

3. One one line item in your main module for Rank which you want to export.

Hope this helps

Thanks

Akhtar

taku.s

@Akhtar.shahbaz @Misbah

Thank you for your reply.

The module have three dimensions.
Dimensions: Calendar,item and place

I'm so Sorry, It's confidential, so I can't write any details here...

Please give me a solution.
Thanks.

Best regards.

andre.lie

Hi @taku.s ,

What is your module's time scale?

What is the most recent date definition? Is it last date that has data against any Place list item or is it something else?

Regards,

Andre

dmitrii.mamaev

Hello, Taku!

In my opinion you should at first transform your module with 3 dimensions to module with 2 dimensions only, and only then use Rank function.

dmitrii.mamaev

Hello, @andre.lie

As I understood from previous question of @takushimozuru he uses fake date dimension against built-in one.

taku.s

@dmitrii.mamaev

Thank you for your reply.

As you advised, after changing the module to 2 dimensions, imported the data, I could use the RANK function.

The problem has been solved.Thank you so much!!!

Best regards.

Taku

rob_marshall

@taku.s ,

I know you already marked this as solved, but why not use MAX as the summary for the date? This way, you will not have to create a new list, have to run an action, and it will always be dynamic.

Please consider the following:

I have a module with two dimensions/lists, but this also works for 3.

Change the summary to MAX for the Date line item:

Create a new line item named Load? (formatted as a boolean) with the following formula:

Date = Date[SELECT: TIME.All Periods, SELECT: 'OSU L1'.'All Employee''s']

Now, you will only load the data with the "highest" date

Create view filtering on Load?

Final solution:

Let me know if this helps,

Rob

JaredDolich

Brilliant @rob_marshall !!

Now that's thinking out of the box.

PranayG

Hello Team, Can Dynamic Ranking work in a dimensionless module as well? I have 5 dimensions and the user wants to view top 10 values based on selection of one dimension or a combination of multiple dimension. How can that be achieved?

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…