Filtering and UX

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.

Accepted answers

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

All comments

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

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

KiddXin

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

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…