How to Set search conditions for each user

taku.s
Contributor

How to Set search conditions for each user

Hi everyone.

 

I would like to set search conditions for each user and I want to filter and display data.

There are 110,000 items of data I want to display, and I want to specify search conditions for each user and filter and display them.

Please tell me a good solution. 

 

Best regards.

 

Taku

1 ACCEPTED SOLUTION

Accepted Solutions
VIGNESH.M
Super Contributor

Hi Taku,

 

Try a smart filter, this will help you to set search conditions for each user.

 

Check below link,

https://community.anaplan.com/t5/Best-Practices/Increase-End-User-Adoption-With-Smart-Filters/ta-p/4... 

 

Regards,

Vignesh M

View solution in original post

5 REPLIES 5
VIGNESH.M
Super Contributor

Hi Taku,

 

Try a smart filter, this will help you to set search conditions for each user.

 

Check below link,

https://community.anaplan.com/t5/Best-Practices/Increase-End-User-Adoption-With-Smart-Filters/ta-p/4... 

 

Regards,

Vignesh M

taku.s
Contributor

Hi,@VIGNESH.M 

 

Thank you very much. I will refer to here.


By the way, if Users List is set to Dimension, RANK function cannot be used?
The following error was displayed:
"Invalid use of 'Users' list with function 'RANK'"

 

Best regards,

Taku.

VIGNESH.M
Super Contributor

Hi,

 

We cannot use the Rank function on User Dimension. Why do you need to use rank for the filter?

 

~Vignesh M

taku.s
Contributor

Hi,

 

Thank you for your reply.

I am using the RANK function because I want to get 10 rows from the last record entered.

 

For your reference, the formula is below

 

IF RANK(1, ASCENDING, SEQUENTIAL, Entered FLG) <= 10 THEN List.NO ELSE 0

 

 

Regards.

Taku

taku.s
Contributor

Hi @VIGNESH.M 

 

For the RANK function, I solved it myself.
I understand that users cannot use the RANK function.
I'm really thankful to you.

 

Best regards.

 

Taku