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!
}Cubes Dimension - How is it built?
-
- 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?
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?
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?
- 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?
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- 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?
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.
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
-
- 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?
tis the .cub$ that causes the spurious cubey to be included in the list. Delete that and you will be in in sync heaven...
-
- 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?
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.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...