OLAP: show what is filtering the grid

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

  • Posted 24 March 2020, 7:32 am EST

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

    Thank you
  • Replied 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
  • Marked as Answer

    Replied 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
  • Replied 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
  • Replied 25 March 2020, 10:16 pm EST

    Ruchir,
    that makes sense. We need to upgrade to the latest version soon anyways
  • Replied 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.
  • Replied 26 March 2020, 1:56 pm EST

    Okay, have added it to the request.

    ~Ruchir
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels