Previous Value in a Dummy Time Dimension

NakulAggarwal
Certified Master Anaplanner

Previous Value in a Dummy Time Dimension

Hi All,

 

We are developing a module using a dummy time dimension as the planning needs to be done for a period of 3 months. So just to save the space instead of using Anaplan Time dimension we have created a list with a subset for three months to be used in planning.

 

Now we have few line items as below where we calculate the opening stock and the closing stock value.

Challenge I am facing is that the opening stock of the month June 21 should be the closing value of May 21, but as we are using a dummy dimension unable to use previous and any other system lookup because of circular reference.

 

Is there any solution fir the same or any other way to use 3 month dimension for planning without taking much space.

 

NakulAggarwal_0-1618900441636.png

 

NakulAggarwal_1-1618900473576.png

Expected Values are below

 

NakulAggarwal_2-1618900539202.png

 

In Qtr also we need Opening Value as 100 and Closing as 110 in Q1.

 

Thanks,
Nakul
5 REPLIES 5
ChrisHeathcote
Community Boss

Re: Previous Value in a Dummy Time Dimension

@NakulAggarwal 

Use a real time dimension so that you can utilise the time functions and map your fake time to real time.

The actual time periods are irrelevant as you only need to utilise real time so you can use PREVIOUS() therefore create a dedicated timeframe just for this purpose and automate the mapping somehow. 

All the calculations are performed using the real time dimension and the mapping and then presented using the fake time list. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
NakulAggarwal
Certified Master Anaplanner

Re: Previous Value in a Dummy Time Dimension

HI @ChrisHeathcote ,

 

Yes following the same, thought of getting brilliant ideas from you guys or who has faced the same issue.

 

Thanks for the revert.

Thanks,
Nakul
ChrisHeathcote
Community Boss

Re: Previous Value in a Dummy Time Dimension

@NakulAggarwal 

I have used this approach many times and it works well.

Just ensure that you are able to automate the mapping.

Good luck.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Misbah
Moderator

Re: Previous Value in a Dummy Time Dimension

@NakulAggarwal 

 

Since Closing stock is dependent on the Opening Stock, you can not get the previous value of Closing Stock in the Current Period of Opening Stock - running into circular references.

 

The best way & I think the only way as @ChrisHeathcote mentioned is to use Anaplan Timescale and then map it back to Custom Timescale

 

Misbah

NakulAggarwal
Certified Master Anaplanner

Re: Previous Value in a Dummy Time Dimension

Hi @Misbah 

 

Thanks for the suggestion. That's the only way around we can figure out for now. Thought if someone had faced the same issue and have any other way to resolve this. 

Thanks,
Nakul