Show Parent when no child + selection

Good morning,

My lists are as follow. Parent: Mission --> Programm --> Activity --> Expense (lowest level)

My objective is to put in place a filter that allows me to see the Activity items even though I have no existing Depense under the acitvity, combined with a filter where the user can select to narrow the view on one acitvity (in a module that has Expense dimension).

First in the process the user can select on different level of the hierarchy through line items published on the dashboard. If the user select (for example) Activity 1 the module should only display activity one.

If user doesn't select anything, all activities (and rest of hierarchy) should be displayed in the view.

I managed to show all the activities (with and without child) by creating a 'True' boolean and another item saying 'if true then 1 else 0' and applying a formula summary method. This works and shows every level of the hierarchy However, I cannot find a workaround to be able to show only the activity selected in the filter.

Thanks in advance for you help.

Accepted answers

All comments

DavidSmith

@sweemaels

The problem you face is in the module dimensioned by Expense, if there are no children, there is effectively no data at that level.

It might be worth posting some screenshots of your dashboards, but from what I've understood I would create a module by activity and just display the rows and use this as a selector itself. The displayed activities should be filtered based on the user selection. The lower grid, by expense, should then be set to synchronise to this module.

In my example below, I have just used a page selector for Program to synchronise the activities instead of a filter for simplicity.

I hope that helps

David

SathyaM

Hi @sweemaels,

PFA the detailed document with screenshots.

1. Create a Selection module with a line item (no dimension) - “Activity” as format.

Create another module with Expense as dimension and add line items as per below screenshot
Create a dashboard, publish the below with the Filter enabled (see screenshot).

“Select Activity” line item from “Selection” module
Test module

Thanks

Sathya

Acitvity_Example_44031.docx

DavidSmith

Just a couple of best practice tips for the above (and I know this was just a mock up) when/if you put this into production

1. You should have a module by expenses (and no other dimension) to hold the parent values

2. Keep the filter line items in a separate module (a la DISCO) so it could be re-used if needed

3. Resolve the filter to a single boolean; this will be faster than multiple conditions

David

sweemaels

Hi Sathya,

I've been trying the same way but, unfortunately this doesn't work as some activities do not have any expenses, the formula parent(item(expense)) will be blank and not work.

Thanks for you input

sweemaels

Hi David,

Thanks a lot for you input.

It is indeed what we have at the moment (see screen shots):

1) user select filter that filter the first table per activity

2) user select an activity in the first table

3) selection synchronizes with tables underneath

However we had some comments from the end user that didn't understand that their filter were not applying to all the tables. The objective would be to apply the filter selected in the first step in the second table (that for now has expenses only for some activities)

Any idea ?

thanks a lot,

Sarah

Filter_1_44119.JPG

Filter_2_44119.JPG

DavidSmith

I'm a little confused because the approach above from @SathyaM will work for any grid where you use the filter, but if there are no expenses under the activity then there should be nothing to show anyway, so the fact the parent field is blank doesn't matter

What do you want the grids to show if there are no expenses under an activity?

David

sweemaels

Hi David,

It is necessary for us to show the parent (=activity) in order to be able to add an expense manually via the dashboard.

To be able to add an item manually (via a creation action), users need to select the parent. This is mainly why we need all activities to be visible.

Thanks again for your answer

Sarah

DavidSmith

Sarah,

I think it might be better to use a selection module, as I described earlier, which will automatically sync all other views, but have you tried using "prompt for parents" in the create action?

David

sweemaels

Hi David,

Yes we thought about it but it doesn't seem to be a solution for us as it would add an extra step to the process and we are trying to simplify and reduce the number of clicks as much as possible..

Thanks

Sarah

ramonito

Hello, I encountered a similar issue. Here is the work around that I did:

Have a SYS Module for the parent of the dimension or create a line item to calculate the parent of the dimension
Create a line item (Format: Parent List) with Applies to the parent of the dimension
Create a line item (Boolean) with Applies to the parent list of the dimension ( if your reference is on another Sys module, use the line item in Number 2)
Create a line item (Boolean) with Applies to the dimension and do a LOOKUP on the line item in Number 3 using Number 1 as reference. (E.g Line Item Number 3 [Lookup: Line Item Number 1]

I hope this is clear. :)

ramonito

Hello, we can also use the logic on this post , to show the Parent even if there is no children

https://community.anaplan.com/discussion/155373/conditional-formatting-on-parent-and-on-father-of-the-father

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…