TM1 Forum

I have a Demo TM1 server with large data column in it, which can not be started up in my laptop.

Is there any way to start the server without data of user cubes to be load into memory, so that I can see the dimensions and cubes definition?

Thanks a lot for advise.

If you just want to see the dimensions within the large cube the open the .cub file in a hex editor Notepad++
The first part of the .cub file will show you the dimensions and you should be able to work it out from there.

Edit: Obviously you are in non-prod, etc. etc. no guarantees, warranties, E&O.E...

In actually, I want to replicate the server without user data, but keep all other information such as Dim/Cube/Rule/Process/etc there, which is similar operation to dowload tables structure for relational database.

I don't think just remove *.cub files from data folder will work, since the information kept in system cubes will be not consistent if I remove those *.cub files.

Is there a good approach to copy or replicate a server, but leaving user data away, so that we can get a light weight server just without data?

You could initially load all dimensions without cubes, rules, attributes.
Then you delete all but 1 element in each dimension, then reload the model with cub files.
Export the information needed.
Obviously you lose many elements and see very little or no cube data. So keep a full backup and reload the model again with all dimension elements once you have the information needed (and leave out the cub files).

For the future, write a TI process to dump that information in text files and run it from a chore. But that’s after the facts and not useful now.

I would also look at your TM1 version if your signature is correct here. 10.2 is pretty old.

It does work.
Thanks a million, Wim.