Module not showing all list items

Hello,

I have a 4 tiered list hierarchy. On the lowest level I have thousands of items that do not have a parent and need to be deleted. I would like to create an action to delete these list items and add the action to an existing process to maintain good model hygiene.

My challenge is that any module where the list is published I cannot see these parent-less items.

Any ideas on how to display these items in a module would be appreciated.

thank you,

Accepted answers

rob_marshall

@michael.chefer

If you have a parent hierarchy, that is fine, do you have a Top Member defined? If you do, and you still aren't seeing the members without "defined" parents, then I imagine you are not looking at the very top member. What I would do is create that SYS Module and look for the members that roll up to the Top Member that you just defined. What likely has happened, is a top member was defined like All Accounts, but that is not defined as the overall Top Member of the list, but rather list member named All Accounts. Also, is this a concatenated list? If so, place the top member in the first level, not level 5 or level 6.

Does that help?

Rob

All comments

rob_marshall

@michael.chefer

I would suggest two things:

Put a top level on the list, this way you will be able to see them
Create a Delete module (SYS Delete) with this list in the Applies To. Create a line item (boolean formatted) having the following formula: isblank(parent(item(list name)))
Use the Delete from List using Selection action to create your action.

That should delete the members that are orphaned.

Hope this helps,

Rob

ankit_cheeni

Hi Rob,

Is this a usual behaviour? I tried creating a small example but did not face the same issue. Does this happen once the list is slightly larger?

rob_marshall

@ankit_cheeni

This is standard functionality on small or larger lists. It all depends if you have a "defined" Top Level Member defined for the list. Not a list member that is the top member, but a member defined as the Top Level Member.

When you have the above defined, there is no way it will be orphaned as it will always have a top member, in this case All Account Types. Now, it can be orphaned from the "hierarchy" order, but that is a different story.

Does that help?

Rob

michael.chefer

Thank you @rob_marshall for your reply.

What do you recommend in a case where my list needs to have a parent hierarchy? It seems that when I add a Top Level Item and keep the Parent Hierarchy my result is unchanged.

Any work arounds that you know of?

rob_marshall

@michael.chefer

Does that help?

Rob

michael.chefer

I added the system module, created a delete action and successfully deleted all the parent-less items. Side note, I was unable to see which items were being deleting as they never showed up in the system module. The bottom f the list showed the last item in the hierarchy but none of the parent-less ones. It could be that list's size of 500k items limited the visible items. However that did not impact the delete action's ability to correctly pick out which list items to delete.

justin_blake

Had the same issue (not being able to see orphan items when the list is dimensioned in a module). The problem was because I had selective access applied to the parent hierarchy, with access to the parent items. With it set up like this, the orphan items are not visible in modules.

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…