How to Restore the data in a Cube

[guru1988fortm1]

Hi ,

i am using Cognos TM1 9.5.2 with BI Security

I have an assumptions cube where users will either give manual inputs or load from SQL database

Now, they executed the process to load the data and it is not correct

So they want to restore the data from Backup

I read in TM1 guide that .cub file is the data file

So, does copying the .cub file of that cube from backup to my currenct DB will restore my data?

Please advice

Thanks
Regards
Guru

[Alan Kirk]

i am using Cognos TM1 9.5.2 with BI Security

I have an assumptions cube where users will either give manual inputs or load from SQL database

Now, they executed the process to load the data and it is not correct

So they want to restore the data from Backup

I read in TM1 guide that .cub file is the data file

So, does copying the .cub file of that cube from backup to my currenct DB will restore my data?

Not unless you take down the server first, THEN copy the backup of the .cub file to your data directory, THEN reboot the server. .cub files are (usually) only read on server startup. And to be honest doing that is not something that I'd make a habit of given the possibility of dimension or rules changes that may have affected the .cub file since it was last saved; it's a last resort only.

But if data changes to the cube are being logged, your first option should be to roll back the incorrect entries from the log file.

[guru1988fortm1]

wow!!!
That really helps
The data was saved and i had data changes in the logs
I removed them and restored the backup , started the services and its fine
Thanks Alan!!!