selection control

KubotaNatsuki
Contributor

selection control

hi!

 

I want to create a module that allows me to select only some of the items in the pull-down menu.
Example:I want User to be able to select only Apple, Peach, and Orange.
I want to make it so that Fruit and Grape cannot be selected (not displayed).

KubotaNatsuki_0-1623138491533.png

 

Can i do it?

Please help me.

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Re: selection control

Hi @KubotaNatsuki 

 

Please see if the following helps.

 

LipChean_Soh_0-1623197396860.png.    LipChean_Soh_6-1623197981587.png

LipChean_Soh_2-1623197435776.png

1. I have 2 lists shown above, i.e. Fruit and Tech list. Fruit is the same as yours, but it has a property 'Show? (Yes/No)' for the purpose of driving the dependent list.

2. Tech list can be an existing list you have in your model that you create for technical reasons. I am not a fan of single member list, so the above is just an illustration.  

3. I'll explain the formula of Fruit.'Show? (Yes/No)' later.

 

LipChean_Soh_3-1623197706584.png

Note: Only 'apple' and 'orange' are shown in the drop down list when 'apple' and 'orange' are checked in 'INP Fruit Selection'.

LipChean_Soh_4-1623197766744.png 

LipChean_Soh_5-1623197848730.png

4. Admin Module 2 is created as a LOOKUP module, since i want to avoid hardcoding 'Tech List'.Yes

5. INP Fruit Selection is the module where you as the model admin decides the list of fruits that can be shown in the subsequent drop down list. Any selection made here checks the property from Item 3, i.e. Fruit.'Show? (Yes/No)'

6. INP Fruit Sales is where the dependant list is created. Convert 'INP Fruit Sales'.Select Fruit into a dependent list by checking 'Dependent'. 

 

Thanks,

LipChean

View solution in original post

9 REPLIES 9
Jitendra.Vishnolia
Certified Master Anaplanner

Re: selection control

Hey @KubotaNatsuki ,

 

Use Subsets in the dimension of the module . Please go through this List Subsets - Anaplan Technical Documentation

 

~Jitendra

KubotaNatsuki
Contributor

Re: selection control

Thanks for your reply!
I thought about using subset, but that would automatically include Fruit.
I don't want Fruit to be displayed either.
Harsha
Frequent Contributor

anRe: selection control

You can hide top level (Fruit) from "Select levels to Show" option in module. And publish from the module as page selector to your required DB.

 

Harsha_0-1623140122410.png

Regards,

Harsha.D

anand.shekhawat
Super Contributor

Re: selection control

Hi @KubotaNatsuki 

 

Yes you can do that. Kindly follow the below steps

 

1) Check the 'Selective Access Enabled?' check box from the configure tab of this list.

2) Provide the read access to the users from the 'Read' section from the grid view to the list items that you want the particular user to see or access.

 

Now the user will be able to access only those list items in the page selectors, wherever this list is used as a dimension

 

I hope it helps

 

~Anand

 

 

KubotaNatsuki
Contributor

Re: selection control

Thanks for your reply!
It's a very tedious method if you have a lot of Users.
Is there an easier way to do this?
anand.shekhawat
Super Contributor

Re: selection control

Hi @KubotaNatsuki ,

 

If you don't want different selections for every individual user and if you want this selections to be available for everyone, you can follow the below steps as discussed above.

 

1) Create a subset and check in the booleans for list items that you want to be visible.

2) Use this subset as a dimension in the module.

3) Pull the fruit subset in the rows and right click and go to Reselect Items

4) Untick the summary level and save the view.

 

I think this should meet your requirements.

 

~Anand

ChrisHeathcote
Community Boss

Re: selection control

@KubotaNatsuki 

Use a filter.

Create a module dimensioned by the target list and a boolean line item. Check those items you want displayed and use this to filter the view. 

Alternatively, use the check to inform a DCA write access setting. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
LipChean_Soh
Certified Master Anaplanner

Re: selection control

Hi @KubotaNatsuki 

 

Please see if the following helps.

 

LipChean_Soh_0-1623197396860.png.    LipChean_Soh_6-1623197981587.png

LipChean_Soh_2-1623197435776.png

1. I have 2 lists shown above, i.e. Fruit and Tech list. Fruit is the same as yours, but it has a property 'Show? (Yes/No)' for the purpose of driving the dependent list.

2. Tech list can be an existing list you have in your model that you create for technical reasons. I am not a fan of single member list, so the above is just an illustration.  

3. I'll explain the formula of Fruit.'Show? (Yes/No)' later.

 

LipChean_Soh_3-1623197706584.png

Note: Only 'apple' and 'orange' are shown in the drop down list when 'apple' and 'orange' are checked in 'INP Fruit Selection'.

LipChean_Soh_4-1623197766744.png 

LipChean_Soh_5-1623197848730.png

4. Admin Module 2 is created as a LOOKUP module, since i want to avoid hardcoding 'Tech List'.Yes

5. INP Fruit Selection is the module where you as the model admin decides the list of fruits that can be shown in the subsequent drop down list. Any selection made here checks the property from Item 3, i.e. Fruit.'Show? (Yes/No)'

6. INP Fruit Sales is where the dependant list is created. Convert 'INP Fruit Sales'.Select Fruit into a dependent list by checking 'Dependent'. 

 

Thanks,

LipChean

View solution in original post

KubotaNatsuki
Contributor

Re: selection control

Sorry for the late reply.
Thanks for your reply!

I was able to solve the problem that way.
Thank you!!