Level 2: Sprint 1 Activity: 1.6.3.3

[gourav1kumar]

Hi,

I am unable to get the result as per the screenshot with respect toCreate Saved View for Export(1.6.3.3).

I gaveTimedimension asHalf-yearlyonly. But still the columns FY19 & FY20 appears in my module (DAT04 Distribution Center Parameters).

Please find the screenshots for reference.

Thanks in advance.

[rahulborkar]

Hi,

你可以隐藏FY20 FY21列选择those column and hiding it. (Right click and hide) Don't forget to save the view at the end.

Thank you

[gourav1kumar]

Hi@rahulborkar

Inspite of 'hiding' FY20 & FY21, can I select (H1 & H2 FY20, H1 & H2 FY21) and do Select Selection and then save the file?

[JaredDolich]

@gourav1kumar

great question. Two solutions available here.

1. @rahulborkaridea to hide the years by right clicking the years and using HIDE. This is not a good long term solution though. In the New UX you can hide the time summaries which is great for visualization but doesn't really help you here.
2. Another way is to create a Boolean line item in your HALF system module (SYS03) called "HY Only?" and set the formula to TRUE. Then use this line item as a filter in your saved view. Now only half years will appear. This is the preferred method.

[gourav1kumar]

Hi@JaredDolich

InSYS02the time scale is already set toHalf yearly. Also the formula is set to TRUE. But still the columns FY20 & FY21 appears in my module (DAT04 Distribution Center Parameters).

However, in the 2nd point you have mentioned - 'Then use this line item as a filter in your saved view'. Can you please make me understand how to do this step.

Thank you,

Gourav

[JaredDolich · Accepted solution]

@gourav1kumar

Sure. Go back to your original post to DAT04. Here you can set a filter on your view that will remove the years from the grid. Here's how to set a filter.

[gourav1kumar]

Hi@JaredDolich,

That's amazing. I really appreciate your guidance.
I got the end result.

Thank you so much.