Move data from fake time period to real time period (For restriction of drop down selection on time)

Hi,

I want to move the data from fake week to real week. I tried with multiple formulae and still getting errors. Request your help.

Please find the screen shot of requirement below:

And I have a mapping module as below:

And my fake week list is as below:

Note: The reason why I have created a fake time is period is that my original time period has more than ~250 weeks including the historic years. But I want to select only from the 52 weeks of current year. So, I have created a fake time list and using a subset of 52 weeks alone from that fake time period as a selection drop down rather than the original ~250 weeks.

Accepted answers

AdamCookson

No problem, if I understand the issue then does the below example cover your scenario:

User selects fake time and auto generates the real date (or time period)

Data can then be moved using this combination if required (note that sum/lookup is a very intensive formula):

Does this provide the solution you're looking for?

All comments

AdamCookson

You can transition data from a fake timeline to a real timeline via the SUM formula when the fake timeline has a real time reference attached to it.

Fake time list (I had this as a property, but best practise would be to have the reference in an attribute module):

Data stored on fake time:

Data transferred to real time:

Hopefully that process makes sense and helps resolve the issue you're seeing.

Kaviah

Hi @AdamCookson ,

Thank you for taking time and replying to my question.

The simple sum may work to move the data if data is entered against the fake list member. But here in my case, the input data itself is a drop down with data format fake list.

The complexity here is moving data between two different data types.

Blue Print view of the above screenshot below:

Here you can notice that the source and target have a different data type.

Any further help here is much appreciated.

Thank you.

AdamCookson

No problem, if I understand the issue then does the below example cover your scenario:

User selects fake time and auto generates the real date (or time period)

Data can then be moved using this combination if required (note that sum/lookup is a very intensive formula):

Does this provide the solution you're looking for?

ShubhamCh

Hi @Kaviah

Here is my solution

Start creating one list "Weeks"
Insert 52 members like Week 1, Week 2,.........., Week 52
Create one SYS Weeks module as shown in the screenshots below
Notice that Current Year line item doesn't have any dimension and you'll have to manually update this value.
Now see the calculation in your target module

I hope it helps. This method will automatically update the relation between the dropdown weeks and the current year (Manually set). As you change the current year value, it will point to the weeks of that years.
In case you want to show "FY .." in your dropdown as well then you'll have to use the numbered list and create a formula for Display name property which makes the dropdown dynamic.
One thing that you should know is that as you change the value of current year the earlier user input values will also change.

If you've any doubts, feel free to reply and ask those doubts.

If you find this helpful. Please kudo it (It helps me stay motivated to answer the questions).

Thanks!

-Shubham

Kaviah

Hi @AdamCookson

Exactly, this is my scenario to convert from fake time to real time. Thank you for giving me the right direction. It fixed my issue.

Kaviah

Hi @ShubhamCh

Thank you for taking time and providing the alternate ways for the solution.

ShubhamCh

Hi @Kaviah

I think I didn't get the whole problem earlier and provided only one part of the solution. Now I re-read @AdamCookson 's solution and understood the problem completely. It is an interesting use case. 👍

Thanks for the kudo.

- Shubham

Quick Links

Can you help?

Unanswered questions

Can we disable Create page button from the UX page
I want to disable the [create page] button for the end user from the dashboard. The end user can create a page or worksheet to link to the module to edit the data. can anyone please give some suggestion? Thx…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…