Get Value from month to month

[ChauBSD]

Hi everyone,

I have Cube get value the same image

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

How can do ?? I using rules

Thansk all

[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

[ChauBSD]

Hi EvgenyT

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

[ChauBSD]

Hi EvgenyT

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

[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

[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