Filter Issue

BlueSky-Wind chaser
BlueSky-Wind chaser
in Modeling

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:

 

aishabhy05_0-1647330475164.png

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)

aishabhy05_1-1647330527328.png

 

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

 

 

Thanks

Tagged:

Answers

  • ogilkons
    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
    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?
  • BlueSky-Wind chaser
    BlueSky-Wind chaser

    aishabhy05_0-1647333951410.png

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

  • BlueSky-Wind chaser
    BlueSky-Wind chaser

    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_0-1647334193158.png

     

  • BlueSky-Wind chaser
    BlueSky-Wind chaser

    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 

Categories