Hi,
I know we can clear/zeroout the data in the cube while the TM1 server is running. But I am looking for a functionality/workaround by which I can clear the data within the cubes while the server is not running.
This will be handy if the server does not have enough physical resources and we would like to clear the data of the cubes before we load them.
Any suggestions?
Thanks!
Cube Zero Out while TM1 server is not running
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Cube Zero Out while TM1 server is not running
.cub files are binary. I'm sure that some clever enough person could find a way to hack them to remove the data but there is no way in the gods' little green Earth I'd recommend even trying that for a production environment.ExApplix wrote: I know we can clear/zeroout the data in the cube while the TM1 server is running. But I am looking for a functionality/workaround by which I can clear the data within the cubes while the server is not running.
This will be handy if the server does not have enough physical resources and we would like to clear the data of the cubes before we load them.
The easiest way is to simply remove the .cub file from the data directory before the server starts, then recreate the cube once it has. You could do that through either TI or the GUI.
If you have more than one cube that's causing this problem you could set all of the relevant cubes to load on demand (so that they only load into memory when they're accessed; see the right click menu for any given cube for this option), then zero them out one at a time. In that way only one of the problem cubes' full data set will be in memory at any given time.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Cube Zero Out while TM1 server is not running
You do realise that "ViewZeroOut while server not running" is an oxymoron?
However I think this could be achieved easily enough. (And for what it's worth I think if you thought about it for 5 minutes you could figure it out too.) Just keep a non-running data directory handy with copies of empty cube files. To start your actual server without data in a cube just replace the cube file with the "empty template".
That will work just fine if you want to completely clear a cube. If you want to selectively clear data with server not running then I think like Alan that you are out of luck.
However I think this could be achieved easily enough. (And for what it's worth I think if you thought about it for 5 minutes you could figure it out too.) Just keep a non-running data directory handy with copies of empty cube files. To start your actual server without data in a cube just replace the cube file with the "empty template".
That will work just fine if you want to completely clear a cube. If you want to selectively clear data with server not running then I think like Alan that you are out of luck.
-
- Posts: 103
- Joined: Mon Sep 21, 2009 7:09 pm
- OLAP Product: Cognos Tm1
- Version: 10.2.2
- Excel Version: 2016
Re: Cube Zero Out while TM1 server is not running
I understand we can not run an TI function if the server is not running. I thought someone might be aware of a 3rd-party tool or some work around to empty the cubes. Unfortunatly, I do not have a 'empty template' of the cubes.lotsaram wrote:To start your actual server without data in a cube just replace the cube file with the "empty template".
Recreating the cubes is probably the last option I also thought about but for that I need to know the dimensions and thier order which was used to make those cubes initially. If the server is not running then can we find out which dimensions are required and what is thier order?Alan Kirk wrote:The easiest way is to simply remove the .cub file from the data directory before the server starts, then recreate the cube once it has. You could do that through either TI or the GUI.
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Cube Zero Out while TM1 server is not running
No, it would be pretty uncommon to have such a thing sitting around on the off chance you needed it, especially as it would have to be maintained in sync with the production environment to be of any value.ExApplix wrote:I understand we can not run an TI function if the server is not running. I thought someone might be aware of a 3rd-party tool or some work around to empty the cubes. Unfortunatly, I do not have a 'empty template' of the cubes.lotsaram wrote:To start your actual server without data in a cube just replace the cube file with the "empty template".
Do you have any TI processes which use a view from the cube as a data source? If so you could open the .pro file in Notepad and you'll find the dims listed in there somewhere. (The location will be fairly obvious.) A view (.vue) file won't work for that purpose, unfortunately; those will often have the dimensions but they won't necessarily be in order. Just be careful if you've reordered the dimensions of the cube since it was built, but I'm assuming that you haven't.ExApplix wrote:Recreating the cubes is probably the last option I also thought about but for that I need to know the dimensions and thier order which was used to make those cubes initially. If the server is not running then can we find out which dimensions are required and what is thier order?Alan Kirk wrote:The easiest way is to simply remove the .cub file from the data directory before the server starts, then recreate the cube once it has. You could do that through either TI or the GUI.
Or... do you have a slice from the cube saved somewhere? If so, load it up in Excel with manual calculation on, and trace the View() and/or DBRW functions' arguments. You should be able to work out from that what the dimensions are.
Another alternative is (and I'm assuming here that you can't get the server up at all) to create another server session which loads only that one cube; take a copy of your entire data directory into the new server and delete every .cub file that isn't either a system one or the cube that you're interested in. In that way the cube that's causing you problems will have all of the server resources to itself; you should be able to load it at least long enough to be able to get the dimension information.
Once you've done that I do suggest making some documentation on the cubes, and not just for this kind of problem.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.