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

Accepted answers

All comments

jasonblinn

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

Jason

Rajasekhar

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.

Misbah

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

einas.ibrahim

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.

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…