TM1 Forum

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

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