Langsung ke konten utama

Postingan

Menampilkan postingan dari Januari, 2018

Format Label Tom Jerry (MS Word)

Setelah beberapa lama aku tidak membuat label undangan, tiba-tiba kemarin aku diminta untuk membuat label undangan Wisuda dengan menggunakan label merek Tom & Jerry (TJ). Harusnya sih menjadi tugas sekretaris panitia tapi karena yang bersangkutan ada tugas di luar kantor maka aku yang membereskannya. Mula-mula aku membuat format labelnya dengan cara manual, tapi untung ada pak Mulyadi (staf tata usaha) yang menyarankan aku untuk mengunduh format label yang telah ada di Internet. Mulailah aku browsing di google dan menemukan format label berbagai ukuran dari website Tom & Jerry di alamat berikut  http://tjlabels.com/en/download.html  (yang link ini agak rempong krn pake masukin nomor captcha-captcha-an). Sedangkan kalau yang link ini langsung pilih file ga pake nomor captcha-captcha-an ( http://tjlabels.com/assets/download/ ). Ternyata juga ada banyak berbagai blog yang menyediakan  link download seperti ini, tapi aku mem- posting  artikel ini adalah untuk diri sendiri, ya

How to make Relation in Extended Data Type and add 'View Details' for field on a form in AX 2012

Because AX 2012 is not support  for add relation to Extended Data Type like in AX 2009. This is my solution how to do it in 2012: - Duplicate an EDT have relation in AX 2012: ex SalesId and change name. relation table, reference table to yours -> you have an EDT with relation **** If your project have been customized already and have a lot tables with field extend from your EDT, you don't need to change  EDT property in each table (because it takes lot of time). Follow these steps: - Export your Proj xpo (with old EDT too) - Delete old EDT, rename duplicated EDT to your EDT ( now tables with fields extended by your EDT lost all EDT property) - Import project  without old EDT  ( auto fill property for all extend field) The filed with EDT have relation aut o add 'View Details function on form ( Right-click a field in a form, and then click  View details) ***1 more way to add 'View Details' with field not extend from EDT Open the form in the AOT, expand its d

MDX previous and current day/month

Current day/month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 WITH   MEMBER  [Measures].[ Day Revenue] AS AGGREGATE(   PERIODSTODATE([Calendar].[ Day ],[Calendar].CurrentMember), [Measures].[Sales Revenue EUR] )   MEMBER  [Measures].[ Month Revenue] AS AGGREGATE(   PERIODSTODATE([Calendar].[ Month ],  [Calendar].CurrentMember), [Measures].[Sales Revenue EUR] ) Previous day/month 1 2 3 4 5 6 7 8 9 MEMBER  [Measures].[Yesterday Revenue] AS   PARALLELPERIOD([Calendar].[ Day ],1,[Calendar].CurrentMember), [Measures].[ Day Revenue] ) MEMBER [Measures].[ Last   Month Revenue] AS PARALLELPERIOD([Calendar].[ Month ],1,[Calendar].CurrentMember), [Measures].[ Month Revenue] ) This is just to make my select statement compact 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 MEMBER  [Measures].[Today] AS ([Measures].[ Day Revenue], ([Calen