Unexpected behaviour with Excel & TM1

[Rashed]

Hi All,
Below are the details of TM1 and Excel versions I use.

TM1 Version: 9.1 SP3
Excel Version: 2003 SP3

I get a very unusual behavior while working with Excel spreadsheets. It happens with SUBNM formula. The formula I am using is as below,

Code: Select all

SUBNM("tm1serv:AGR Cost Centre","","Socrates")

[/color]

Even if I double click the cell with this formula and explicitly select "Socrates" from the Cost Centre dimension it seems to automatically changes the value to the next element. Restarting the tm1 server fixes this issue. I have checked the element security and they all have read/write grant.

Thanks in advance.

[paulsimon]

Rashed

One possible theory I have is:

Do you have Aliases that are derived by Rules? If so it is possible that you have more than one element that has the same Alias, or an element that has an Alias which is the same as another element. If you had two Socrates either as an element and alias or two aliases, then even if you select one Socrates it might always return the second.

Regards

Paul Simon