TM1 Forum

Hi

A client has a cube which is showing "error" against 3 attributes in the properties window.

There is no rule associated with it - Does anyone have any idea what might be causing it to display "error"?

I have never seen this before.

J

Have you checked for duplicate alias? Can't think of anything else unless there are weird chars that the properties pane can't display.
Cheers

Well I'm doing this remotely so I'll have to ask them to check.

From the screen shot it was every N level throwing an error so I doubt it's duplicate aliases but thanks for the idea

If it is is I'll be back eating humble pie shortly

John Hobson wrote:Hi
A client has a cube which is showing "error" against 3 attributes in the properties window.

There is no rule associated with it - Does anyone have any idea what might be causing it to display "error"?

I have never seen this before.

I've seen it once... when attributes were populated by DBS formulas which were indeed sending an Error expression.

In other words, I'd browse the attributes cube and see whether the attribute values really ARE "Error".

I've already told them to check the }cube.

The DBS is indeed a potential cause I guess - thank for that idea

J

If the attributes cube looks fine, but the attribute viewer still shows errors, you could check the dimension itself and see if you've got any strange - possibly blank looking - elements, or elements that appear to be duplicates.

I've seen something similar where a dimension has become corrupted by having multiple elements made up of non printable characters. They originally got into the dimension when the source data file was created using the wrong character set. Cube viewer still worked fine, dimension editor fine, subset editor fine, but try and view the attributes through the Edit Attributes interface and the whole thing threw a wobbly, shifted all the attributes around and then complained about duplicate aliases that it had caused itself.

Fortunately the client only ever did attribute maintenance via the attributes cubes as the editor took too long to load anyway. But I think that was another topic!

John Hobson wrote:Hi

A client has a cube which is showing "error" against 3 attributes in the properties window.

There is no rule associated with it - Does anyone have any idea what might be causing it to display "error"?

I have never seen this before.

J

is it correct that you also can't access these elements via rule / dbrw ?

tm1version?

Nope, i've changed values in the element attributes cube by both rules and DBRW methods in past. Only time i've seen error messages was when the rule i was testing went wrong, or the DBRW was sending duff data."Error" is normally and Excel type of message so i'd have a look at whats populating the attributes.

We have this situation today and from the source table column, I found out that there is Horizontal Tab in the end of the string.
I use regexp_replace(string, CHR(09), null) to replace it and works fine.