Level 2: Sprint 1 Activity: 1.6.3.3

gourav1kumar
Frequent Contributor

Level 2: Sprint 1 Activity: 1.6.3.3

Hi,

 

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

I gave Time dimension as Half-yearly only. But still the columns FY19 & FY20 appears in my module (DAT04 Distribution Center Parameters).

Please find the screenshots for reference.

 

Thanks in advance.

 

gourav1kumar_1-1641184344895.png

 

gourav1kumar_2-1641184451570.png

 

gourav1kumar_0-1641184312329.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Level 2: Sprint 1 Activity: 1.6.3.3

@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.

JaredDolich_0-1641249184738.png

 


Jared Dolich

View solution in original post

6 REPLIES 6
rahulborkar
New Contributor

Re: Level 2: Sprint 1 Activity: 1.6.3.3

Hi,

 

You can hide the FY20 and FY21 column by selecting those column and hiding it. (Right click and hide) Don't forget to save the view at the end.

 

Thank you

gourav1kumar
Frequent Contributor

Re: Level 2: Sprint 1 Activity: 1.6.3.3

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
Moderator

Re: Level 2: Sprint 1 Activity: 1.6.3.3

@gourav1kumar 

great question. Two solutions available here.

  1. @rahulborkar idea 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.

 


Jared Dolich
gourav1kumar
Frequent Contributor

Re: Level 2: Sprint 1 Activity: 1.6.3.3

Hi @JaredDolich 

 

In SYS02 the time scale is already set to Half 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

 

gourav1kumar_0-1641246845006.png

 

gourav1kumar_1-1641246927483.png

 

gourav1kumar_3-1641246964819.png

 

JaredDolich
Moderator

Re: Level 2: Sprint 1 Activity: 1.6.3.3

@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.

JaredDolich_0-1641249184738.png

 


Jared Dolich
gourav1kumar
Frequent Contributor

Re: Level 2: Sprint 1 Activity: 1.6.3.3

Hi @JaredDolich,

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

Thank you so much.