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
How to write better rules ?
-
- Posts: 1
- Joined: Fri Apr 27, 2018 4:33 am
- OLAP Product: SQL
- Version: 10.2
- Excel Version: 2013
- 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 ?
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
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