Filter Crash in Production

Hi,

I have created a Time filter for a Dashboard and Export view in Dev Model. But when i push that to Production every time the Filter gets crashed in the Saved view, so i am not able to get the desired layout in the Dashboard and Export File. Can you let me know where am i going wrong.

Attaching the screenshot from Dev model which says the layout i want in Production and the Layout gets disturbed in Production where the saved view in not keeping the filter.

Thanks.

Filter_71082.PNG

Production_71082.PNG

Dev_71082.PNG

Saved_View_Dev_71082.PNG

Saved_View_Production_71082.PNG

Accepted answers

nathan_rudman

you can see the filter is based on "L3 cost centre mapping" list.
I'm sure this item doesn't exist in production.

And that's probably because Filter: Month has the L3 dimension, which it doesn't require.

You should centralize your time filters in one system module, that would avoid this issue.

All comments

nathan_rudman

if it works in DEV and not in prod it means you are basing this filter on a list item that doesn't exist in production.

ps: your screenshots do not show the filter settings, would be useful

ShivankurSharma

Hi@nathan_rudman ,

I have a Selection Module without any dimensions where the end user will add the month he wish to view the data for and export from Anaplan.

That line item in selection module is used as a filter in my spoke modules to display the data. Below Boolean formula is created in module to filter data:

Selection Module.Month = ITEM(Time)

and then that filter is used in the saved view

filter saved.PNG

Do I need to change any logic ?

nathan_rudman

you can see the filter is based on "L3 cost centre mapping" list.
I'm sure this item doesn't exist in production.

And that's probably because Filter: Month has the L3 dimension, which it doesn't require.

You should centralize your time filters in one system module, that would avoid this issue.

ShivankurSharma

The list is present in Production model. That is the dimension of the module where that filter needs to be applied. Also the Boolean line item is returning the true when the condition is true but not getting picked in the saved view.

ShivankurSharma

@nathan_rudman Created a new Time Module and used the line items from that modules as a filter and post that this issue got fixed.

Thank you 🙂

nathan_rudman

if you can accept my answer as solution it would be great !

ps: take a look at this app, there's a lot of useful time filters there
https://community.anaplan.com/t5/learning/Time-Filters/ba-p/28086

Quick Links

Can you help?

Unanswered questions

Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…