Hi Friends,
I want to create an Action process.
That will automatically import the current year data.
Please assist me in this.
Hi @Sravan_Kumar ,
Create a dynamic filter based on current year and apply to module 1 and create saved view to import to the module 2.
Thanks,
Naushad
Can you please share an article mentioning the same.
Hi @Sravan_Kumar -
Create a system module:
which should have 1 year formatted line item and no dimensions.
You can get Anaplan System Time by writing a formula as mentioned below or you can use as existing drop down (without writing formula).
Create additional 2 Line item, to get the year and to filter
Apply filter and use the saved view as a source for import.
Hi @Sravan_Kumar,
why do you need two modules? do you have the same dimensions in both of them?
Thanks @prabhu.
I am trying and letting you know.
First is the initial module with historic year data.
Second is the final module (which we will be building) with the current year data.
Thanks for the help.
I am able to select the current year.
Follow these steps to convert Text formatted date to Real DATE
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…