Mapping SAP to Legacy system

Post Reply
palmorek
Posts: 1
Joined: Mon Apr 11, 2011 8:53 pm
OLAP Product: TM1 Cognos
Version: 9.1 I think Old
Excel Version: Excel 2003

Mapping SAP to Legacy system

Post by palmorek »

I am currently using TM1 at my workplace. We are converting from our old legacy software to SAP. My challenge is to figure a way we can map the SAP profit centers, cost centers and account numbers to lagacy. Can TM1 handle that task and if so what direction should I take. I am just not sure. Any help would be appreciated.

Thanks
Palmorek
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Mapping SAP to Legacy system

Post by Martin Ryan »

If there's a one to one relationship then aliases would probably be the best option. If there's many to one or one to many then you'll need to create a lookup cube. Or you could even possibly create a lookup dimension where SAP cost centres are children of legacy cost centres and use elcomp or elpar as your lookup instead.

I'd probably go with the lookup cube myself as its the most flexible.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply