Importing with Time Dim in Mapping

Highlighted
Occasional Contributor

Importing with Time Dim in Mapping

Hi,

 

I have an Module with Tim Dim and list. It has a line item called Data which is an Input filed. I need to create action such that the data gets copied from one quarter to other. Example: I need to copy data which is Q1 to Q2.

I tried to create a saved view and create an Import action from saved view to module, but it doesn't work i.e the data is not getting imported.

 

In the action, mapping tab, Time Dim is Column headers or Just Column 1. Time. I'm unable to map Q1-->Q2.

 

Please let me know how to map Q1-->Q2 in my Import action when Time is a standard dim in the module.

 

Regards,

Rajasekhar

 

4 REPLIES 4
Highlighted
Certified Master Anaplanner

Re: Importing with Time Dim in Mapping

I would try to add a staging line that shows the NEXT(ITEM(TIME))

 

You can then base the time in your import on that new line item

 

jasonblinn_0-1594176298464.png

 

Jason

 

Highlighted
Occasional Contributor

Re: Importing with Time Dim in Mapping

Thank you Jason,

 

But please may I know if you are going to create a saved view and create action from saved view to module. If yes, I how would Anaplan recognize that it the same line item data value would shift from 1 qtr to other.

 

If possible, please can you send screenshot for an example. Thanks a lot in Advance.

 

Regards,

Rajsekhar.

Highlighted
Master Anaplanner/Community Boss

Re: Importing with Time Dim in Mapping

@Rajasekhar 

 

Any specific reason that you want to import the data from one quarter to next? What is the dimensionality of your timescale - Is it weeks,months or quarters? Why don't you think of creating another line item and write a formula in it.

Highlighted
Valued Contributor

Re: Importing with Time Dim in Mapping

Hi @Rajasekhar 

 

You probably need to create 2 saved views where Time (Quarters) is a page selector.

One saves view is the source and the other is the target
Apply a Time filter on each saved view to show the Q to be copied from in the source view and the Q to be copied to in the target view. 

For this to be dynamic, create a system time module to designate the Source and Target Qs either by using a formula or a manual user input. 

Then, create your import action to import from source saved view to target saved view.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"