Fake Time to Real Time Calculation

Options
Ashutosh
Ashutosh Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

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

Tagged:

Comments

  • Ashutosh
    Ashutosh Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    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

Categories