Data Flow Controller and TM1 (ACTUALS)

[mnasra]

Hi Expert,

I searched the Forum and Could not find a 'new' answer to my question. SORRY for the inconvenient.

I need to know what is the best way to have Controller and Tm1 cohabit for ACTUALS
Do I load every COA by Company In TM1 or in Controller First.
The Mapping between the Conso accounts and the Coa per company In Tm1 or controller?

Do i read the data twice from the Datamart (or do I read it once, and transfer it between controller and TM1)

PS: I dont know controller at all.

Thanks all

[lotsaram]

Well you have 3 choices for loading "Controller data" to TM1
1. load directly from the source system via ODBC (whatever that is, GL system, ERP, Datawarehouse, etc.)
2. load from the Controller database via ODBC
3. use the built-in FAP instance

Most people who know both Controller and TM1 well tend to opt for #2 but #3 can work pretty well too. There are several ways you can do option 3. Unfortunately the way IBM designed the FAP instance what isn't viable is to just simply "use it". Every time data is published from Controller to FAP everything is destroyed and rebuilt. Everything. You can either export metadata and data out of FAP and import it to another instance or you can have separate cubes and dimensions inside the FAP instance that get built via TI from the FAP objects as a source. But the FAP objects themselves are pretty much not useable.

[mnasra]

Oh WOW. THANK YOU So much Lotsaram.
(oddly, I did not receive an email to tell me that you posted something).
I think, based on your answer I am going to explore both options (2-3) and decide if I want the same option for Metadata and data.
I inherited at my client site, is option 1. The customer was not happy. And I agree.

PS: I did not even know option 2 is 'doable'.

Thanks again