Data from With time to No time Dimension

Highlighted
Contributor

Data from With time to No time Dimension

How can i pull a data from a module with time dimension to target module with no time dimension using a finditem mapping made in the source data?

 

To illustrate, my total sales of 1,000,000 was divided into 3 months(using a time dimension) using a condition that turns the distribution this way:

 

Jan 20 - 3,000,0000

Feb 20 - 2,000,000

Mar 20 - 5,000,000

 

I will need to draw this amount using a new list(Month 1, Month 2, Month 3)  in replacement of the time dimension(all other dimensions retained) to arrive to this:

Month 1 - 3,000,000

Month 2 - 2,000,000

Month 3 - 5,000,000

 

Appreciate if you can assist me on this.

 

Best Regards, 

Eia

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Data from With time to No time Dimension

@elaine.novel ,

 

Not sure why you want to do this, but if you have to, create a mapping module (dimensionalized by Time) which maps the Time months to your new custom list of Months (list formatted). 

 

Hope this helps,

 

Rob 

Highlighted
Master Anaplanner/Community Boss

Re: Data from With time to No time Dimension

@elaine.novel 

 

Believe it is for reporting purposes. Let me break it into steps for you

 

Step 1: Create a Mapping module dimensioned by Custom Time and insert one line item formatted as Native Time Period

Step 2: Map it manually by selecting Month 1 against Jan, Month 2 against Feb and so on and so forth

Step 3 : Go to Target module and use the LOOKUP in your formula such as

Source Module. Data Line item[Lookup: Mapping module. Line item]

Note: If your custom list resets after Month 12 (from Month 12 to Month 1 Next year ) then you may need to write a logic in your mapping module instead of doing it manually which will map it months of current year.

 

Hope this helps

Misbah

Highlighted
Contributor

Re: Data from With time to No time Dimension

Thank you Misbah and Rob..