Fake Time to Real Time Calculation

Dear All,

I have one use case where I have created one template for input the data. For this I used fake time dimension because the data will enter at monthly level in Year 1 and for future it's on yearly. Screenshot one shows the template which used to enter.

But I am stuck between creating summary report. Because for this I need the month + total and for future years only year total. For this I need a mapping between fake & real time but I am not sure how it will work.

Screenshot 1: Dimensioned by Fake time for input

Screenshot 2 : output required[Summary Report format].

Can any one help me on this please?

Regards

Ashutosh

Ss1_136520.png

SS_2_136520.png

Accepted answers

All comments

andrewtye

Hi @Ashutosh

One question would be why the use of "fake-time"? Why not have two input modules, one at a monthly and one at a yearly level which you'd then be able to import the values from the template.

Then the summary module would be module 1 + module 2 with formula as the summary setting.

Finally have a system module that defines the visible time periods with line items Month?, Year? that are booleans defined appropriately with a final Month & Year? one that combines them - use this final line item as a filter on the UX page.

Hope that helps

Andrew

Ashutosh

Hi @andrewtye ,

Thank you for your response.

Initially , I am also thinking same. But we did only one template to input data in one module. That's why I am using fake dimension. Because in real time, we can't input at month level and year at same time.

Hope that clear your doubts.

Regards

Ashutosh

andrewtye

You can use the same input file to load into separate modules. This would reduce the amount of maintainence going forward as there would be no need to update lists and make sure everything flowed correctly.

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