Get Value from month to month

6235999

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

245317177

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

hiba010203

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

onelovely

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

cswing_5

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

socaca

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