Page 1 of 1

}Cubes Dimension - How is it built?

Posted: Wed Feb 15, 2012 3:50 pm
by shopkins
Hello,

When we turn on View -> Display Control Objects, we see a dimension called }Cubes.
How is this dimension built? I didn't see any processes that create this dimension.
We are using the }Cubes to do some processing on the list of Cubes, but there is a value in it that no longer exists. If we try to delete it, it will ask us to save it as a separate subset which we don't want to do.

Thank you!

Re: }Cubes Dimension - How is it built?

Posted: Wed Feb 15, 2012 3:59 pm
by shopkins
OK - quick update.
We created the cube of the same name and then deleted it which then fixed the problem and removed it from }Cubes.

However, I am still curious as to how }Cubes is built. Also, could it have been a system hiccup that caused that cube to be added to list but when it was being cleaned up that there was a system issue and it didn't update }Cubes properly?

Re: }Cubes Dimension - How is it built?

Posted: Wed Feb 15, 2012 4:02 pm
by jim wood
I'm not exactly how it's built but my guess would be that it's built when the server starts. Did you try stopping and starting the service?

Re: }Cubes Dimension - How is it built?

Posted: Wed Feb 15, 2012 7:16 pm
by qml
If memory serves well, this dimension gets updated with any new cubes at server startup or when cubes are created during a server session. If a cube is deleted from the data directory as opposed to removing it from the GUI, the respective element of the }Cubes dimension will not be deleted and there will be a warning recorded in the tm1server.log when the service starts.

Also, shopkins, it sounds like you were trying to delete an element of a dimension using the Subset Editor, which obviously can't be done - Dimension Editor is the interface to do it. Furthermore, you can't edit any control objects (or, more generally, objects whose name starts with a "}") from the GUI. You can, however, use TI functions to add/delete/manipulate control objects, including removing obsolete elements of the }Cubes dimension. In this case DimensionElementDelete() would do the trick.

Re: }Cubes Dimension - How is it built?

Posted: Thu Feb 16, 2012 5:04 pm
by John Hammond
tis the .cub$ that causes the spurious cubey to be included in the list. Delete that and you will be in in sync heaven...

Re: }Cubes Dimension - How is it built?

Posted: Thu Feb 16, 2012 10:04 pm
by lotsaram
John Hammond wrote:tis the .cub$ that causes the spurious cubey to be included in the list. Delete that and you will be in in sync heaven...
I think John may be onto something there. You can also get this behavior if you have a .cub file in the data directory but some of the .dim files associated with the cube are not present. In that case the cube won't be able to load and so you won't see it in server explorer but you might get a ghost of its presence as an element in the }cubes dimension.