Filter Issue

aishabhy05

Hi All,

I have 2 modules,

Module 1-

Dimensions - Entity, Custom Version, Time Period, Department

Line Item - A,B,C

Module 2-

Dimensions - Custom Version

Line Items as Follows:

When i apply this filter in source module (module 1) , It still shows me the estimate and budget. which i wanted to hide. (Jan 22, Feb 22 for estimate and budget versions are blank by using DCA)

I want to filter only Actual Jan 22 and Febb 22. Not sure whats going wrong here, can help on this please?

Thanks

Accepted answers

All comments

ogilkons

Hi @aishabhy05 ,

Are you sure that filter in Module 2 is equal FALSE for Estimate and Budget Versions in Jan 22 and Feb22? I can't see that from your first screenshot, so can you please check this?

Thanks,

Nikolai

M.Kierepka

Hi,
It should work, so the problem has to be somwhere else - can you show exactly how filter is applied, and also recheck that in your filter source Jan & Feb are TRUE only for Actual version?

aishabhy05

It is false for Feb 22 and JAn 22 for Estimate and budget

aishabhy05

It is true only for the actual version. Has it anything to do with a summary of the source module? The summary has been set to Any for filters of actual, estimate, and budget versions. And no other filter condition has been given in the target module apart from the below condition

aishabhy05

I found a solution, in source module i was using Subset of Custom version list. In target module i used Custom Version list. when i change the target module dimension to Subset of Custom Version List it worked!!! Thanks for your support !! @ogilkons @M.Kierepka

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…