企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 270|回复: 2

How to Restore the data in a Cube

[复制链接]

85

主题

433

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-3-17 08:39:38 | 显示全部楼层 |阅读模式
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

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

67

主题

355

帖子

520

积分

高级会员

Rank: 4

积分
520
QQ
发表于 2014-3-17 10:40:09 | 显示全部楼层
guru1988fortm1 wrote: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.

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

70

主题

437

帖子

587

积分

高级会员

Rank: 4

积分
587
QQ
发表于 2014-3-17 12:11:51 | 显示全部楼层
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!!!

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-10-29 10:25 , Processed in 0.182100 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表