Deleting damaged AttributeElement Cube

Post Reply
Gunnar
Posts: 2
Joined: Fri Dec 07, 2012 8:05 am
OLAP Product: TM1, MSAS
Version: TM1
Excel Version: 2007

Deleting damaged AttributeElement Cube

Post by Gunnar »

Dear all,

I inherited a TM1 Environment from my predecessor.
The ElementAttributes Cube for the Dimension ITEM was somehow renamed to "ElementAttributes_ITEM_damaged".

However for month this Attribute Cube seemed to be ok anyway.
Now I tried to delete and re-structure some Alias Attributes for this dimension.

For some reason I can delete the alias attributes on N-Element level but cannot for C-Elements.
By the way, a cube named "... _damaged" doesn't make me feel very comfortable.

Therefore I would appriciate your thoughts regarding the following procedure:
In an test environment I was able to stop the TM1 Service and then to delete the CUB File for this attribute cube. Afterwards it was re-created automatically when I imported attribut values again. Would this procedure lead to problems?
Alternatively I thought about deleting and recreating just the attributes that cause problems. That might help, but I would need to stay with me "... _damaged" cube.

Is there any better idea?

Thanks for your input,
Gunnar
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Deleting damaged AttributeElement Cube

Post by qml »

Gunnar wrote:In an test environment I was able to stop the TM1 Service and then to delete the CUB File for this attribute cube. Afterwards it was re-created automatically when I imported attribut values again. Would this procedure lead to problems?
This is exactly what I would do, because this is the easiest and quickest way to do it. I can't think of any problems this would cause.
Kamil Arendt
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Deleting damaged AttributeElement Cube

Post by garry cook »

I can't think of any problems this would cause.
I'd agree however the possibly may exist that someone crazy enough to rule or TI reference a cube called x_damaged. Unlikely but given the fact the fact that it exists in the first place, I'd be wary of the whole model and double check personally.
Gunnar
Posts: 2
Joined: Fri Dec 07, 2012 8:05 am
OLAP Product: TM1, MSAS
Version: TM1
Excel Version: 2007

Re: Deleting damaged AttributeElement Cube

Post by Gunnar »

Thanks for your comments. I'm quite sure that the cube i want to delete is not connected to other cubes via rules.. So I think I will try delete and recreate the attributeElements Cube.
- Gunnar
Post Reply