Filter a module over a dimension subset


Currently if a module has complete list as a dimension, and a line item has it's subset as a dimension, the filter won’t work for that line item.


For example you can have a module for forecasting clients sales. The clients dimension is obviously needed both for Actual sales and Forecast line items. But you wouldn't need a Correction for inactive clients. Say, we maintain a subsets for active clients. We apply it towards the Correction line item, but this means an end user won't be able to filter out the nonblank corrections anymore. This is the error he'll receive:


9 votes

New · Last Updated


  • Miran
    Status changed to: New
  • Hi! 

    If it's a question of how to put corrections only for active clients and save filtering functionality (not about the size of the 'correction' line item), I would rather use DCA here instead of subsets. Then filtering would work properly for users.


    But I agree, the problem with subsets which are not usually recognized as the part of the list automatically (when filtering or, f.e., using SUM finction) is quite annoying. 

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!