Multi Dimension Ranking

deantari
New Contributor

Multi Dimension Ranking

Hi,

I have 2 modules, 1 has dimensions of TenantGroup, ReportPeriod and UserRole namely AgingperGroup. And the other module has TenantGroup and UserRole namely AgingGroupRanking. The latest module will take the data from the previous and lookup the CurrentPeriod parameter to get the exact data(of which data period) to be ranked for later.

Since I want each of the user who has UserRole to play around without effecting another Role's data, the dimension of the modules has to contain UserRole. But I have trouble to create a ranking system which should be have different result for each user.

the current result I got using RANK() is that from total 30 Tenant Groups, it multiplies with UserRole number and the last ranking become 120 instead of 30(per each user).

Is there a way to work around to get the right result of ranking?

Thanks!

3 REPLIES 3
KirillKuznetsov
Certified Master Anaplanner

Re: Multi Dimension Ranking

If i understand correctly each user will have one UserRole. This means you can limit access of each user via filter line item dimentioned by Users and UserRole. Not sure what RANK is for here. What this number against user and tenant group will give you?

deantari
New Contributor

Re: Multi Dimension Ranking

1 role might have multiple user.
The goal is that I want to show the Aging Ranking based on each User Role, that's why I was hoping to use anaplan Rank().

I have 30 Tenant Group by now(in a list). If I have to rank it from the one who has most amount to the least amount, the rank for each Group should be

rank - group - amount
-------------------------------------------
1 - GroupA - 1000000
2 - GroupB - 900000
3 - GroupC - 800000
...
30 - GroupZz - 0


but using Rank() with the dimensions the result came out like this

userrole - rank - group - amount
--------------------------------------------------------------
Role1 - 1 - GroupA - 1000000
Role1 - 4 - GroupB - 900000
Role1 - 9 - GroupC - 800000
...
Role1 - 120 - GroupZz - 0
Role2 - 1 - GroupA - 1000000
Role2 - 4 - GroupC - 900000
Role2 - 9 - GroupB - 800000
...
Role2 - 120 - GroupZz - 0


I expect the result to be something like this
userrole rank group amount
--------------------------------------------------------------
Role1 - 1 - GroupA - 1000000
Role1 - 2 - GroupB - 900000
Role1 - 3 - GroupC - 800000
...
Role1 - 30 - GroupZz - 0
Role2 - 1 - GroupA - 1000000
Role2 - 2 - GroupC - 900000
Role2 - 3 - GroupB - 800000
...
Role2 - 30 - GroupZz - 0

rob_marshall
Moderator

Re: Multi Dimension Ranking

@deantari 

 

Give this a shot...Concatenate the codes of the lists using a line item and use that as the 4th parameter.

 

Rob