Pasting Subset Names into Subset Editor

[garry cook]

New one on me although maybe folk have come across it before.

As per message title, just discovered that you can type a subset name in excel and then copy/paste it into the subset viewer - it appears as an on the fly consolidation (simliar to rollup functionality), allowing you to use the subset as if it was a standard consolidation.

10 years with TM1 and STILL finding undocumented functionality

[Steve Rowe]

Yeah, I've posted on this one before, IMO very dangerous functionality, would love to be able to turn it off.

I've had the situation where my FD built a report showing all the annual totals for the P and L double what they actually were. He used the column header "2009" instead of "Yr 2009", instead of key erroring he got back the result times two since 2009 was a subset that contained all the periods and the annual total.

He was not very impressed and it took me an age to find what had happened. I can see in some circumstancies that it's useful behaviour but I don't think it should be the default as I think it makes it trivially easy for users to report nonsense. One of the main reasons products like TM1 exist is to keep control of the business logic, this drives a horse and cart through system integrity.

The only valid reference for a DBRW should be something that is explicitly defined in a dimension.
Cheers

[Martin Ryan]

10 years with TM1 and STILL finding undocumented functionality

It was documented, at least waaaay back in 7.x days. Perhaps they stopped documenting it because no-one was productively using it. I agree with Steve that it does more harm than good. I've found it useful on a few trivial occassions where I could've easily used a temporary rollup or created a temporary consolidation, but certainly not useful enough to warrant the risk that it poses to FDs.