multi dimension module to flat module

Panji

Hi Anaplanner,

 

I have 2 module, 1 multi dimension and 1 flat module

 

i want to take data from modul multi dimension to flat, but in module flat data isblank

 

multi dimension module

 

flat module

 

how to module flat have data from multi dimension

DavidSmith

@Panji 

to pull from modules with Time and Versions into a module without there are a few ways

 

Modules with versions.

As with modules by time, you cannot SUM out of a module by Version and you also can't use LOOKUP, so you could use SELECT, but a better solution is to use the Current Version setting in the Versions tab.  this will return the values from the Current Version into the target module

 

Modules with Time

• You can use TIMESUM to pull all values from the module to the target.  This works for all formats and you can choose the Aggregation methods
• You can create a single dimensioned line item and store a time period you want to source, then use this as a LOOKUP. 
• If you have multiple years and want to pul the final value you can use SELECT[Time.All Periods] if this is turned on

I hope this helps

David