TM1 Forum

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

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

garry cook wrote: 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.