企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 423|回复: 5

Get Value from month to month

[复制链接]

84

主题

404

帖子

593

积分

高级会员

Rank: 4

积分
593
QQ
发表于 2014-3-16 19:25:50 | 显示全部楼层 |阅读模式
Hi everyone,

I have Cube get value the same image

                        10-31-2013 7-51-31 AM.jpg (104.55 KiB) Viewed 626 times               


How can do ?? I using rules

Thansk all
回复

使用道具 举报

64

主题

404

帖子

556

积分

高级会员

Rank: 4

积分
556
QQ
发表于 2014-3-16 20:33:41 | 显示全部楼层
The obvious thing: the rule inst working...

Perhaps posting the syntax would help us to help you!

Also, I cant really tell what is your application meant to do, but it seems to me that current rule/cube design is not optimal/hard to use given there are 8 dimensions in the cube. I would rather have a satellite cube that drives the "slider".
ET
回复 支持 反对

使用道具 举报

96

主题

400

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-3-16 20:44:55 | 显示全部楼层
Hi EvgenyT
EvgenyT wrote:The obvious thing: the rule inst working...

Also, I cant really tell what is your application meant to do, but it seems to me that current rule/cube design is not optimal/hard to use given there are 8 dimensions in the cube. I would rather have a satellite cube that drives the "slider".
ET


Thank you for reminding me, I realized the reason why my system slowed cube. I will try to split the logical.
My system is running very slow due to too many dimensions in a cube

Thanks
回复 支持 反对

使用道具 举报

81

主题

410

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-16 21:29:20 | 显示全部楼层
Hi EvgenyT
EvgenyT wrote:The obvious thing: the rule inst working...

Perhaps posting the syntax would help us to help you!

ET

This is my rules. Result all zero
['DT08']=N:IF( DIMIX('Month',ATTRS('Month',!Month,'VN')) = DIMIX('Month',DB('SX_DienTichDauTu',!Year,!Version,!CongTy,!PhongBan,!Level_SanXuat,!SX_LoaiDauTu,!Month,'DT02')),1, 0                );

When i try
['DT08']=N:IF( DIMIX('Month',ATTRS('Month',!Month,'VN')) =9),
                        1, 0); It okie
回复 支持 反对

使用道具 举报

74

主题

392

帖子

562

积分

高级会员

Rank: 4

积分
562
QQ
发表于 2014-3-16 21:30:09 | 显示全部楼层
Thank you for reminding me, I realized the reason why my system slowed cube. I will try to split the logical.
My system is running very slow due to too many dimensions in a cube

Not necessary true. 8 dimensions is reasonable number to have. Performance issues would most likely come down to overfeeding, rules efficiency, sparsity, cube design.... to name a few.


ET
回复 支持 反对

使用道具 举报

62

主题

411

帖子

557

积分

高级会员

Rank: 4

积分
557
QQ
发表于 2014-3-16 21:54:37 | 显示全部楼层
This is my rules. Result all zero
['DT08']=N:IF( DIMIX('Month',ATTRS('Month',!Month,'VN')) = DIMIX('Month',DB('SX_DienTichDauTu',!Year,!Version,!CongTy,!PhongBan,!Level_SanXuat,!SX_LoaiDauTu,!Month,'DT02')),1, 0                );

When i try
['DT08']=N:IF( DIMIX('Month',ATTRS('Month',!Month,'VN')) =9),
                        1, 0); It okie

Sorry, but I don't think this rule relates to what you were trying to achieve above.

ET
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-9-24 20:31 , Processed in 0.170472 second(s), 18 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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