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

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…