Deleted calculated element in measure still showing

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Deleted calculated element in measure still showing

Post by mnasra »

Hello experts,

I have the weirdest 'bug' i have ever seen with my 6 years with TM1.
I had an element in a measure that I calculated via rule.
I changed the element name, I change the rules and I deleted the element.

I opened an old 'perspectives' report where this element is still mentioned. I would expect a KEYERR message, but no: TM1 calculates it perfectly using the new data.
No: I dont have an ALIAS
no: i dont have persistent Feeders on
Yes: I stopped the service and restarted it many times.

in tm1 architect I dont see it obviously, but in Perspectives, even if I open a new one and write down a DBRW command, it shows with a calculation!!!
Thanks
Micheline
tomok
MVP
Posts: 2832
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Deleted calculated element in measure still showing

Post by tomok »

Do you perhaps have a subset on the measures dimension having the same name? There's an undocumented feature in TM1 whereas you can supply a subset name to a DBRW and it will treat it like a consolidated element and do the consolidation on the fly. This could be your issue.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply