How to write better rules ?

Post Reply
hoilangthang
Posts: 1
Joined: Fri Apr 27, 2018 4:33 am
OLAP Product: SQL
Version: 10.2
Excel Version: 2013

How to write better rules ?

Post by hoilangthang »

Hi all,
I am a newbie, I have a question about how to write better rules. Rule identifier or automap way to write better ?

Case1:
['NhanVienHienHuu','NhanVienNghiepVu']=>DB('KeHoachDinhMuc.TrungGian',!DonVi,'DongPhucNVNghiepVuNam',!PhanLoaiCPNS,'Tong',!Nam,!Thang, PhienBan);
['NhanVienHienHuu','NVNghiepVuDVCap2']=>DB('KeHoachDinhMuc.TrungGian',!DonVi,'DongPhucNVNghiepVuNam',!PhanLoaiCPNS,'Tong',!Nam,!Thang,!PhienBan);
['NhanVienHienHuu','NVNghiepVuDVCap3']=>DB('KeHoachDinhMuc.TrungGian',!DonVi,'DongPhucNVNghiepVuNam',!PhanLoaiCPNS,'Tong',!Nam,!Thang,!PhienBan);

Case2:
[]>DB('KeHoachDinhMuc.TrungGian',!DonVi,!ChucDanh,!PhanLoaiCPNS,'Tong',!Nam,!Thang,!PhienBan);

Best regarads,
LangThang
User avatar
orlando
Community Contributor
Posts: 167
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365

Re: How to write better rules ?

Post by orlando »

Hi,

i don't like case2 very mutch, because of overfeeding.

When NhanVienNghiepVu, NVNghiepVuDVCap2 and NVNghiepVuDVCap3 are elements of the same dimension you could write


['NhanVienHienHuu',{'NhanVienNghiepVu', 'NVNghiepVuDVCap2', 'NVNghiepVuDVCap'}] => DB('KeHoachDinhMuc.TrungGian',!DonVi,'DongPhucNVNghiepVuNam',!PhanLoaiCPNS,'Tong',!Nam,!Thang,!PhienBan);

For learning rules i recommend the rules guide.
https://www.ibm.com/support/knowledgece ... -gen5.html
Post Reply