Map Result from System Time (Days) to Customer Days (Fake Days)

LILYLIU
Frequent Contributor

Map Result from System Time (Days) to Customer Days (Fake Days)

Dear Anaplan Experts,

 

I have below module using Days as time dimension. I also have a line called fake days where I mapped the system days to a fake days list.  

LILYLIU_0-1622733322378.png

Then I would like to do a LOOKUP to pull the data from the above module to a module with the fake day list as dimension.  Time is not a dimension.

 

LILYLIU_1-1622734158515.png

 

THanks for your help.

 

Lily

 

 

13 REPLIES 13
rob_marshall
Moderator

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

@LILYLIU 

 

Before we start going down this path, why are you creating a fake days list?  What are you trying to accomplish that Native Time at the Day level can't?

 

Rob

LILYLIU
Frequent Contributor

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

Thanks, Rob. @rob_marshall 

 

Yeah, I would love not use fake days, if possible. 

 

I need to: 

 

(1) to map from May 25 - June 24 to July - A

(2) to map from June 25 - July 24 to July - B (July - A and July - B need to be looked at separately)

(3) to map from July 25 - Aug 24 to Aug 

(4) to map from Aug 25 - Sep 24 to Sep and so on

 

I asked about it last week without mentioning the July - A and July - B issue (seems like a fake month is needed unfortunately). Using your workaround, I was able to eliminate days from the 25 to the 30 but wasn't able to pull days from the pervious month to the current one (e.g. to pull July 25 - July 31) to August. 

 

Thank you so much!

 

Lily

rob_marshall
Moderator

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

@LILYLIU 

 

Is the A and the B for Actuals and Budget, respectively?  If so, why have two fake months (July - A and July - B) and instead dimensionalize the module by versions?

 

Rob

LILYLIU
Frequent Contributor

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

Hi Rob,

Unfortunately, July - A and July - B are both for Actuals. The reason is May 25 - Jun 24 's salary (all calculation needs to be based on these days) need to be reported in July. And June 25 - July 24 's salary also need to be reported in July. We are showing double salary for July.

ChrisHeathcote
Community Boss

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

@LILYLIU 

You can map these dates into their respective time periods and use SUM function to pull the data from a date formatted module into a month module.

There is no need to use a fake days list.

NEVER use a fake time list!!!

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
LILYLIU
Frequent Contributor

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

Hi @ChrisHeathcote ,

 

Thank you so much!

 

" You can map these dates into their respective time periods and use SUM function to pull the data from a date formatted module into a month module." 

 

I tried this approach but didn't work. Could you please point me what I did wrong? 

 

Step 1 Module with System date, mapped to a system month 

LILYLIU_1-1622736850673.png

Step 2 Try to Sum from Day to Month using a SUM function

LILYLIU_0-1622736832508.png

 

Thanks,

 

Lily

rob_marshall
Moderator

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

@LILYLIU 

 

Ok, I see your issue and got it working but I did have to use a Fake Days list because the sum was having issues due to getting confused because of the different Time blocks (the mapping vs the real days).

 

So, here it goes, with a Fake Days list:

 

2021-06-03_13-38-22.png2021-06-03_13-38-48.png2021-06-03_13-39-00.png2021-06-03_13-40-35.png

 

Hope this helps,

 

Rob

LILYLIU
Frequent Contributor

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

Thank you so much @rob_marshall .

 

I am sorry for a follow up question.  Would it be possible to start with a "real date" module and then map the data to a "fake date" or "fake month" module?

 

Looking at your example, I would like to use PREVIOUS function, which fills a cell(s) with the contents of the cell above it, in module "Fake Time Days". This is why I want to start with a "real date" module to track changes on a particular day which applies onwards. 

 

In the worst case, I can do an import from the real date module to the fake date module if the mapping doesn't work, but it would be great to map it.

 

rob_marshall
Moderator

Re: Map Result from System Time (Days) to Customer Days (Fake Days)

@LILYLIU 

 

First, don't be sorry, you have a question and we are here to help.  Plain and simple.  And this is how people learn, by asking questions.  So, all good.

 

Tell me more about how you envision using the previous function.  I think you can do that, but there might be a lot of hoops to jump through.

 

Rob