Synchronized selection issue

Hi Anaplanners,

So I have a Region List (R1) and project list (R2) rolling up to these Regions. Within R1, we identify special regions using a boolean line item in a separate module.

I have a NUX page where all the attributes of only the 'special regions' that is R1 filtered with the above line item, dsiplayed for the end user to review. Within this I also have a grid table which displays the projects (R2) and some attributes pertaining to these projects, set up with synchronized hierarchy selection. For example, If I select a special region from the grid on the top (R1 list with special region boolean filter), projects that roll up to these regions display in the second grid with its respective attributes.

PROBLEM: Since R1 as a list has two sets of data within, that is special region and non-special region, in this particular NUX report i wish to see only special region and its respective projects. So i would like to create another filter that only shows projects of the special region and not all region. Problem however is on the sync selection, say for example i select a special region and if the special region does not have a project under it, the table that displays the projects shows the previous selection of special region instead of empty. I wish to acheive the latter so if there is NO projects under a special region, just display empty table.

Note: I know that this works properly in standalone basis that is if the report grid 1 has only special region for the users to select, then grid 2 would automatically only shows projects based on grid 1 selection. However, problem is there are other pages/reports where users have access to entire R1 list and/or R1 list filtered with non-special region, so when user navigates back into the report with R1 (special region filter) and projects grid the latter's automatically syncing with R1 (non special region) which could lead to confusion in the reading of the data if the user doesnt reselect in the page.

Thanks.

Accepted answers

All comments

BrunoRodriguez

Hello @Sachinsourav02 ,

If I understand correctly, you have a boolean that flags if a Region is a "special Region" in a module dimensioned by R1 Regions. If you create a module dimensioned by "R2 Projects" and create a line item formatted as R1 Regions (Parent), you could use that line item to drive the boolean from the R1 dimensioned module.

The above basically means that you would be able to know at a R2 level which projects are "special" and I believe this filter would display an empty table if there are no special projects.

I hope the above makes sense. Please let me know if it works.

Sachinsourav02

@BrunoRodriguez Thanks for your reply.

I did try this but when i apply the filter to the context selector it asks me to select a region from the list manually while applying the filter and does not dynamically apply to the page. Is there a workaround for this issue ? or am i doing something wrong ?

BrunoRodriguez

Hello @Sachinsourav02 ,

Can you give us a couple of pics from the system module and the application of the filter?

Cheers!

Sachinsourav02

@BrunoRodriguez

I tried couple of options.

1) Using the Region as dimension to the boolean line item that is used as filter:

As you can see its coming as unsupported.

2. I also try to create a boolean at the project level (looking up to R1), this filter works but problem arises in the NUX front end when a user selects South America (special region) but no R2 data, the data for grid 2 dimensioned by Project R2, would still remain in a region that has values say North America/Europe or Africa or the previous selection of the user.

If a user selects South America (Special Region) i would like to display details of South America from module R1 Region attribute while grid 2 which is module R2 Projects Attribute should display no values. This works by default i understand but considering i'm making an exclusive report that only sees special region of both R1 and R2.

BrunoRodriguez

Hello,

What if you set ANY as summary?

Cheers!

Sachinsourav02

@BrunoRodriguez

I'm afraid ANY wouldn't work for regions that do not have projects under it. Like for example if i set ANY as summary, South America despite being Special Region enabled will not have any result as there no projects under south america.

saket22

You can probably create another module for the R2 projects and use a IF THEN ELSE formula to fill in data only from special regions, ELSE it should show 0. That way if user selects a non-special R1, the dashboard will only show 0s.

This other module would be created only for the purpose of getting the dashboards to work as needed.

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…