TM1 Forum

Hi,

we are migrating from Alea onto Tm1. Obviously we have a large amount of reports in excel where the functions have to be converted:
DBGETC ->DBRW,
DE.NAME -> SUBNM,
and so on ...

I am surely not the first one who have to cop with this. Does anyone know about Excel-assistent which can enlight the cure?

Many thanks

Benoit

Hi Benoit,
if it is a mere find/replace in formulas issue in Excel it can be solved with some VBA. I could program it on Monday if you want. Please confirm.
Bon week-end, M.

If you just need something to do a whole lot of find/replace then the following should do the trick.
TM1 reference updater

It was designed for a different purpose but provided you are just changing formula names from one value to another without changing syntax then I think it will do what you want as is.

Hi Marcus and lotsaram,

many thanks for your replies.

The Reference update looks cute. I still didn't tested it, but the VB-Code makes a good impression.

The biggest problem is that, even if Alea and Tm1 are near to each other, some differences make the Find/Replace to a torture: while Alea manages server and cube as 2 separate Excel cell, Tm1 get it in one separate by a ":"
=DBGETC($A$1;$A$2;... --> =DBR($A$1&":"&$A$2; ...

same for the header dimension, where the subset aren't used in Alea:
=DE.NAME($A$1;"Region";"Germany") --> =SUBNM($A$1&":Region";"Region";"Germany")

Means, I will not have to make a Find/Replace but also to parse the formulas to get the parameters done.

Let's see what comes. I will report...

Benoit

I would suggest that in any case if doing something as substantial as changing software vendors that looking at a model and report redesign would be in your best interests anyway ..