Filtering and UX
Here is my situation:
I got a module (REP_01G) to calculate Version Variance, this module has other dimensions such GL, Project, Currency, Company, and Time scale is Month. And a list of line items as shown below:
Reports with Time and Line Items on column will be build. The row could be project, GL, or company, but the column will be the same. Since the user required to have the ability to control the line items to be shown as column with 5 Years on the report as shown.
A system module has been built with Line Item Subset from REP_01G and user as a dimension. A user filer "Applied Filter" is populated based on user selection on the from CY to CY+5. This filter will be used as column filter.
In model building environment, the filter is working fine on the report column no matter which dimension has been used as row.
However, in UX, the filter only work when GL is used in row. If I use other dimensions such as Project as row, nothing will be filtered on column.
GL as row:
Project as row:
There is a pattern on this behaviour, in UX, the column filter only work on the dimension that is the first in order in "Applied To" of the module.
In REP_01G, Applied To, the order of dimension is "GL, Project, Currency, Company". Then, in UX, the column filter will work only when GL is on Row. Then, I changed the sequence in "Applied To" to "Project, GL, Currency, Company". The column filter will work when Project is on row but not working for the others.
The other behaviour is as long as the first dimension is on the row, whether you stacking with other dimension, the filter will also work.
I hope any of you can help since I expect to reuse the same reporting module to build multiple report with different orientation in UX.