Erractic Behaviour in DBRW when entering strings

[harrytm1]

Hi all,

We are experiencing an erractic behaviour in TM1 right now.

We have TM1 9.5 deployed through Citrix and Excel 2007 is used. We have some cubes that have both numeric and string elements in the dimensions that form those cubes. For example, the developer who designed the cube had set some PL account elements to "S", and some of the measure elements are of "S" type too.

Problem:
If we enter text into the String measure elements in cube view, everything is fine. If we slice the view to Excel and enter the text into DBRW, the whole sheet recalculates but the entry is not stored.

Also, the sliced view does not show the text that is currently stored in the cube. Note that this behaviour occurs intermittently i.e. not consistent.

It appears NOT to be a TM1 version or Excel version issue as we tested it on another PC with TM1 9.4 and Excel 2003.

Possible cause:
I think the reason behind this behaviour is due to the presence of both S and N elements in more than one dimension in the cube. Perhaps TM1 gets confuse wen more than one of the elements that made up the location of the cell is "S" type and thus affecting the behaviour of the entire worksheet.

but why does it not affect the cube view? Can someone shed some lights on this? thanks!

harry

[Alan Kirk]

I think the reason behind this behaviour is due to the presence of both S and N elements in more than one dimension in the cube. Perhaps TM1 gets confuse wen more than one of the elements that made up the location of the cell is "S" type and thus affecting the behaviour of the entire worksheet.

TM1's not the only one; I am as well considering that you should have S elements in only one dimension in a cube:

To include a string in a cell in a cube, the element from the last dimension defining the cell must be a string element. TM1 treats string elements that occur in any dimension other than the last one as numeric elements.

(Page 20, version 9.5 Developer's Guide.)

I haven't seen the behaviour that you're describing, but to avoid ambiguity (and the possibility of unpredictable behaviour) I'd suggest rebuilding your cube ensuring that you have your S elements only in the last dimension.

[yng]

Hi!

You can try change DBRW function to DBR in Excel form.

We do it and it's works.

yng