}Cubes Dimension - How is it built?

Post Reply
shopkins
Posts: 19
Joined: Fri Jan 13, 2012 4:31 pm
OLAP Product: TM1
Version: 9.1 Release 3
Excel Version: Excel 2007

}Cubes Dimension - How is it built?

Post 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!
shopkins
Posts: 19
Joined: Fri Jan 13, 2012 4:31 pm
OLAP Product: TM1
Version: 9.1 Release 3
Excel Version: Excel 2007

Re: }Cubes Dimension - How is it built?

Post 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?
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: }Cubes Dimension - How is it built?

Post 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?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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: }Cubes Dimension - How is it built?

Post 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.
Kamil Arendt
John Hammond
Community Contributor
Posts: 300
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: }Cubes Dimension - How is it built?

Post 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...
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: }Cubes Dimension - How is it built?

Post 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.
Post Reply