Is there any way to select or Update line item @ top level of page selector

Hey,

I have got one requirement from my customer, users want to update Boolean line item or edit a line item at tope level of page selector dimension. Please see below example there are three dimensions: Country(Page selector), City & Products(Rows) and one Boolean line item: Select Product. If I select top level item(ALL) for country then line item field is grey out but users wants to select line item even at top level item of page selector. Is it possible to do?.

Example 1.JPG

Thanks,

Suman.

Accepted answers

ChrisAHeathcote

@Suman Reddy

As @Misbah has confirmed it is not possible to enable a user to select the top level in the list as it is. He is also correct in that you can create a second grid and allow the user to select from this.

However, have you considered creating a dummy top level in the list and to use this additional list item to run all the functionality for the top level?

All comments

Misbah

@Suman Reddy

It is not possible within the same grid, however if you are ok creating two input grids then

1. Create a Parent of Country List (Instead of having Top Level) and call it All Countries and Keep just one list item in it i.e, All.

2. Create a module dimensioned by All Countries list, Product and Cities. This will be Input field

3. Go back to Original module and create another line item and use LOOKUP to pull the boolean selections from All Countries Module to Country Module. Note: You will have to write IF ELSE Statement just to give precedence to All Countries.

ChrisAHeathcote

@Suman Reddy

However, have you considered creating a dummy top level in the list and to use this additional list item to run all the functionality for the top level?

rob_marshall

@Suman Reddy

I have a slightly different idea than @Misbah and @ChrisAHeathcote and that is to look at this from a different perspective...If none of the members are selected then they actually want all of them (like a select * in SQL) but it will also allow the users to pick and choose which members they want.

So this is allowing them to pick just the ones they want, but if everything was "false", that would essentially be an ALL selection. This can be accomplished a couple of different ways, but the easiest might be using the summary option of ALL for a boolean (basically it would be a NOT of the above). If the "ALL" line item is true, then you know they want all of them.

Does that help?

Rob

Suman Reddy

Thank you @Misbah , @ChrisAHeathcote and @rob_marshall for your ideas.

I can see @ChrisAHeathcote method is much simpler and it work within same grid. But I will propose all of your solutions to customer then let him decide what is best and simpler for them.

Suman.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…