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.

Accepted answers

JaredDolich

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

All comments

rahulborkar

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

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.

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

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

JaredDolich

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

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…