Hi All
I seek some one advise me on my approach for GL Expense analysis. i Have below load script working fine.
//(A) Recoed the Expense
GL_TABLE:
LOAD
'PMC' as SOURCE,
[Account Code] as AccountCode,
If([Account Code]>=8000000 and [Account Code]<=8900000,'EXP0') as [EXP0], //8008100 //SD SALARIES & ALLOWANCES
If([Account Code]>=8008100 and [Account Code]<=8008100,'EXP1') as [EXP1], //8508100 //AM SALARIES & ALLOWANCES
If([Account Code]>=8508100 and [Account Code]<=8508100,'EXP2') as [EXP2],
If([Account Code]>=8008070 and [Account Code]<=8008070,'EXP3') as [EXP3], //8008070 //SD DIRECTOR REMUNERATION
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/MM/YYYY') as [date],
Remarks,
[Deb./Cred. (LC)] AS Amount,
[Account Name] AS GL_DESC_
FROM
[C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\GL_PMC_2019.xlsx]
(ooxml, embedded labels, table is [Modified GL Data]);
//(B) Create Dimension
For Each i in 108
WhatIfDimension$(i):
LOAD * INLINE [
Pls $(i)st Dim,Column$(i)
0_SOURCE,SOURCE
1_EXP LISTING,GL_DESC_
2_DRILL IN,Remarks,
3_YrMth,YearMonth
];
NEXT i;
Hope some one can Give me your comment on the GUI i have design. Any way i can further improve ?
Paul Yeo
