Filtering and UX

Ivan_Lo_

Hi all,

 

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.

 

Thanks.  

 

Ivan_Lo_

Hi,

 

There is still no solution for this issue.

Instead of building a custom view in UX, the work around is to create a saved module view with all the filters and publish this saved view into UX. 

 

Thanks,

Ivan

 

ManjunathKN

Hi @Ivan_Lo_ 

 

Can you try to pivot the filter module (with LIS) to the dimension which is first dimension in your reporting module. 

 

lets say you want to pivot/orient the reporting module in UX, context: GL & Company, columns: Time & Line items and rows: Project.

 

your filter module pivot should be like: Context: LIS: rep01, Coumns: time.

 

if it works, you dont need to create many reporting modules but different filter modules with different pivoting is needed.

 

Thanks,
Manjunath

 

Ivan_Lo_

This is the "Applied Filter" which with the correct TRUE in the year and line item intersection.

 

 

Ivan_Lo_

I don't think we need to pivot the filter module to get it work. As long as the boolean is populated, it should filter the required column which is Time and Line Items.

Ivan_Lo_

It looks like a bug in UX to me. 

ManjunathKN

@Ivan_Lo_ I am not sure, if it is a bug or not. I recall that it has happened to me few many times. most of the times i was able to solve by rearranging/pivoting my filter module. you can give it a try, by pivoting both LISS filter and applied filter to the first dimension of reporting module.

 

Thanks,
Manjunath

Ivan_Lo_

@ManjunathKN ,

 

May be my first post is not clear.

 

I got 1 reporting module REP_01G and 1 filter module.

In REP_01G, dimension are GL, Project, Currency, Company, and Time scale is Month.

In filter module, dimension are LIS create from REP_01G, and Time scale is month

 

In UX, I build the report using REP_01G. Applied the boolean line item from filter module  as column filter.

Does it make more clear on my issue?

 

ManjunathKN

@Ivan_Lo_  I will come back on this. 

 

Thanks,
Manjunath

KiddXin

I met the same problem as you. It seems filtering by line item subset does not work on the custom view.