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
Mapping SAP to Legacy system
- 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
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
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
Jodi Ryan Family Lawyer