Issue When Using List Subset Picklist with a LISS

TimPeterson
Certified Master Anaplanner

Issue When Using List Subset Picklist with a LISS

Hello,

I've come across a scenario that appears to be a bug when combining Line Item Subsets and List Subsets. 

 

The scenario is that I have a report module that I created a LISS of. I then created an input module dimensioned by that LISS with a Line Item formatted by a list subset. The list subset is to only allow users to pick from active drivers and not have to see all drivers in the list. The formulas in the report module use the selections in the input module to pull data from calculation modules depending on what driver is selected. When using the full driver list as the format of the input module's line item, the formulas work correctly. When using the subset of active drivers as the format of the input module's line item, the formulas pull data based on a random driver from the entire list, including the inactive drivers. I've developed a workaround where I have users pick from a line item formatted by the list subset, have a second line item with a line item format of the full list reference the list subset line item, and then have the report module's formulas reference the second line item with the full list.

 

Tim

4 REPLIES 4
Misbah
Moderator

@TimPeterson 

 

When you are trying to pull the values from the calc module,  Is there another list subset (of the same list that you have mentioned) being used as a dimension in any of the source modules.

TimPeterson
Certified Master Anaplanner

@Misbah The source modules for the values being pulled are dimensioned by the full list, not the subset. 

Misbah
Moderator

@TimPeterson 

 

When I am mimicking it, I see the same results in both the lines - one Looking up on Subset and the other one at Full List

Screen Shot 2022-08-06 at 12.24.26.png

Screen Shot 2022-08-06 at 12.26.27.png

Screen Shot 2022-08-06 at 12.20.42.png

Screen Shot 2022-08-06 at 12.22.33.png

TimPeterson
Certified Master Anaplanner

@Misbah 

 

That's very interesting. Can you show what the full list/list subset setup looks like? Does your list have a parent or top-level?

 

Tim