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

Accepted answers

Misbah

@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

All comments

rob_marshall

@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

Misbah

@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]

Hope this helps

Misbah

elaine.novel

Thank you Misbah and Rob..

aniket9917

@Misbah @elaine.novel @muizzsk9890

My source module is in number-formatted & mapping (system) module is in list formatted. how can we apply LOOKUP function to achieve this. as you said I followed the steps that you mentioned but step 3 is not working.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…