Page 1 of 1
Get Value from month to month
Posted: Thu Oct 31, 2013 12:57 am
by ChauBSD
Hi everyone,
I have Cube get value the same image
- 10-31-2013 7-51-31 AM.jpg (104.55 KiB) Viewed 3618 times
How can do ?? I using rules
Thansk all
Re: Get Value from month to month
Posted: Thu Oct 31, 2013 1:07 am
by EvgenyT
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
Re: Get Value from month to month
Posted: Thu Oct 31, 2013 2:09 am
by ChauBSD
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
Re: Get Value from month to month
Posted: Thu Oct 31, 2013 3:21 am
by ChauBSD
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
Re: Get Value from month to month
Posted: Thu Oct 31, 2013 3:37 am
by EvgenyT
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
Re: Get Value from month to month
Posted: Thu Oct 31, 2013 4:14 am
by EvgenyT
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