Application of Filter Condition on Tabular Multiple Column Export

Hi Team,

We see a challenge in not getting the Cost Center dimension when filtered to the saved view, it is not getting exported as per the Named Saved views instead we get all the Cost centers as default to the module.

This feature is required for us to have it in the Tabular Multiple Column Export for the Integration from Anaplan.

Request to add this feature at the earliest.

Cost_center_Filter_condition_148181.jpg

Comments

ryan_kohn

@nethra.devi If I'm understanding the request correctly, you would like to be able to leverage the native filter dialog to be able to configure a filter on your Tabular Multiple Column Export. Is that correct?

Based on your post, the "workaround" would be to build a filter in a separate System module and leverage that filter for the export. Is there a reason that approach is not viable for you?

nethra.devi

@ryan_kohn Thank you for the response.

We have used such system modules for quite of the output modules wherein it allows the users to select the required criteria to see the results in the output modules.

But here the selection does not change, so when i have the in-built option to filter out some of the cost centers then the Integration is very much automated. The feature is available but not working for the Tabular Multiple Column Export is what we realized later. The workaround is appreciated but can this feature be enhanced in the near future ?

Thanks !!!

ryan_kohn

@nethra.devi Can you confirm that you've followed the steps documented on Anapedia to configure a filter on a Tabular Multiple Column Export? See here: https://help.anaplan.com/90bbef8d-68bd-47e6-bca3-fecb179fbd94-Filter-an-export

paolovm

Hi @nethra.devi

I believe I came to a similar issue recently. It seems in the documentation included by Ryan above the tabular filter can only depend on a SINGLE general list which is just useless for the purpose I was trying to achieve.

Literal:

"Note: If you want to filter rows in your export, based on a Boolean line item, the line item must apply to a single general list. You cannot filter on Versions, Users, or Time."

In my case as a workaround I had to create specific concatenated list (version+index+attribute all together in a single list) to get an export object with less than 3 lists and get away from tabular.

Quick Links

New ideas

Virtual Data Warehouse using Anaplan metadata
We are writing from Centrify Solutions, an Enterprise Data Integration +AI company. We have developed a solution that integrates metadata from Anaplan and external sources like NetSuite into a virtual data warehouse. This creates a dynamic large language model that can be deployed internally to any data source or securely…
How CloudWorks Changed My Day-to-Day Work
Hello Everyone, I’ve been using Anaplan CloudWorks, and honestly, it has completely transformed the way I handle daily integrations. What I love most is how simple it is — you don’t need deep technical knowledge to get started. It’s simple, user-friendly, and has become an essential part of my daily workflow. If you are…
Select All Members in a Time Level Instead of One at a Time
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: In a working grid I click 'show/hide' and select 'Time'. My time hierarchy is FY > Half > Quarter > Month > Week. I want to display…