企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 530|回复: 7

Can't view cube data during executeprocess?

[复制链接]

85

主题

427

帖子

621

积分

高级会员

Rank: 4

积分
621
QQ
发表于 2014-3-16 20:25:34 | 显示全部楼层 |阅读模式
e.g. Process A is using excuteprocess to invoke some other child processes, such as p1 will refresh cube1, p2 will refresh cube2 and p3 will refresh cube3.
When p1 finishes executing and Process A is still executing p3, can I view the data in cube1? It looks like the data has NOT been commited to cube1 and cube1 is still empty.
Anyone has any opinion?
回复

使用道具 举报

87

主题

428

帖子

615

积分

高级会员

Rank: 4

积分
615
QQ
发表于 2014-3-16 22:08:05 | 显示全部楼层
If you are updating and dimension or subset then the service will lock as you are making meta data changes.
回复 支持 反对

使用道具 举报

80

主题

401

帖子

588

积分

高级会员

Rank: 4

积分
588
QQ
发表于 2014-3-16 22:36:35 | 显示全部楼层
Yes, P3 will update dim or refresh data in the cube3. But Since cube1 is already done with any updating, I assume I can check the data in cube1 before the whole Proccess A finishes? BTW, I can open the cube1 in another machine while Process A is running P3.
回复 支持 反对

使用道具 举报

73

主题

409

帖子

584

积分

高级会员

Rank: 4

积分
584
QQ
发表于 2014-3-16 23:04:03 | 显示全部楼层
Any meta data change locks the service not a cube. So yes you can change data before the process runs but not once it has started. When running a chore the service is locked until the chore finishes so you can't check any cube.
回复 支持 反对

使用道具 举报

70

主题

357

帖子

523

积分

高级会员

Rank: 4

积分
523
QQ
发表于 2014-3-16 23:07:04 | 显示全部楼层
thanks for quick reply.
Actually, Process A is just a parent process instead of a chore. In fact, the cube1 is still empty when the process A is running P3, while P1 has already been finished. That's why I have this question.
回复 支持 反对

使用道具 举报

70

主题

353

帖子

524

积分

高级会员

Rank: 4

积分
524
QQ
发表于 2014-3-17 00:11:05 | 显示全部楼层
It looks like the data will be commited to all cubes until the whole Process A finishes instead of just one child process.
回复 支持 反对

使用道具 举报

85

主题

408

帖子

596

积分

高级会员

Rank: 4

积分
596
QQ
发表于 2014-3-17 00:30:16 | 显示全部楼层
Glad to post some testing results here.

Parent P process has two child processes p1 and p2. And p1 is just refreshing data in cube1 and p2 is just refreshing data in cube2. They don't update any metadata in both cubes.
Untill the P process finishes, I can see the data changes in cube1. That means by using executeprocess method, the data for all cubes would be committed until the parent process finishes. You can't view any changes in the child cubes while parent process is still running even if you can open those cubes from another machine. That is my conclusion.

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

73

主题

386

帖子

554

积分

高级会员

Rank: 4

积分
554
QQ
发表于 2014-3-17 01:00:44 | 显示全部楼层
So it is not relevant to metadata changes for this case.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2022-9-29 19:58 , Processed in 0.067555 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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