TM1 Forum

=SUBNM("server:Dimension","Level 0",BA23,"BS Account")

"BS Account" is a string attribute, not an alias, yet when my young padiwan tried the formula above he got the attribute returned. He should be using a dbra, but I was intrigued to see that this worked. Has anyone used this "feature"? I wonder if it's robust enough to rely on (if I could think of a useful application). I would suspect not, especially as the double click feature of the subnm highlights nothing in the subset editor.

Martin

An easy one. If you work for IBM it's a feature, otherwise it's a bug. Not sure on the why though.

jim wood wrote:An easy one. If you work for IBM it's a feature, otherwise it's a bug. Not sure on the why though.

Hi,

Why works:
All the attributes for a dimension are stored in the same }Attribute cube. Probably this is the reason why it "works".
Why remained hidden:
I think SUBNM is usually generated by slicing a View to Excel. Probably this is the reason it has not been realized and fixed yet.

Regards,

Peter