OLAP: show what is filtering the grid

OLAP: show what is filtering the grid

Posted by: abellisomi on 24 March 2020, 7:32 am EST

• 

  abellisomi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 March 2020, 7:32 am EST

  Hello,
  
  Is there an easy way to show what the grid is filtered by?

  Thank you

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 24 March 2020, 7:25 pm EST

  Hi,

  Do you wish to always show the filter icon on the column? Or if there some other setting/layout where you would want to show the field by which the grid is filtered.

  Thanks,
  
  Ruchir

• 

  abellisomi

  • Post Options:
  • Link
    Copy

  Posted 24 March 2020, 10:15 pm EST

  For our users it would be beneficial to always see what is the context of the data they are seeing, so they need a view of what Filters are applied at any point in time.
  
  I solved it by getting the list of active fields this way:

  
  var filtersList = OlapPage.OlapEngine.Fields.Select(GetFormattedFilter)
                      .Where(fieldFilter => !string.IsNullOrEmpty(fieldFilter)).ToArray();
  
  

  and printing that out in a TextBlock.
  
  It would be nice to have something that does this out of the box!

  Thanks

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2020, 6:52 pm EST

  Hi,

  I got it. Currently, there is no UI element that shows such information. So, I have forwarded your request to the concerned team and requested them to consider adding such functionality [ID: 427259].
  
  *Please note C1Olap is now in maintenance mode. So, the feature will be added to the FlexPivot, if the team finds it feasible.

  With regards,
  
  Ruchir

• 

  abellisomi

  • Post Options:
  • Link
    Copy

  Posted 25 March 2020, 10:16 pm EST

  Ruchir,
  
  that makes sense. We need to upgrade to the latest version soon anyways

• 

  abellisomi

  • Post Options:
  • Link
    Copy

  Posted 25 March 2020, 10:32 pm EST

  Oh, an additional note on this one: it is important for the filter criteria to be included in the exported files XLS so the users can keep track of what the data was based on.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 26 March 2020, 1:56 pm EST

  Okay, have added it to the request.

  ~Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 26 March 2020, 6:21 pm EST

  Hello,

  Just as an update, the team has considered the request for future but there is no ETA as such. It would be implemented once they find it feasible

  ~Ruchir