Dengan fitur Prvasive Analytics ini Anda dapat membuat desain KPI dan dashboard sesuai keinginan Anda.
Pervasive Analytics juga merupakan analitik real-time yang mencerminkan aktivitas transaksional yang sedang terjadi, serta membantu karyawan lini depan untuk melihat data yang relevan dengan pekerjaan mereka saat dibutuhkan. Anda juga dapat mengakses dan memvisualisasikan data secara customized.
Fitur ini juga sudah menyediakan beberapa KPI dan dasbor standard. SAP telah membuat KPI dan pelaporan dasbor mudah dengan menentukan dataset untuk pengguna. Untuk membuat KPI atau dasbor Anda, cukup drag and drop pelaporan yang ingin anda ketahui di Dashboard nanti.
Dengan otorisasi yang benar, pengguna dapat membuat tampilan dashboard mereka sendiri . Atau pengguna dapat memilih dari salah satu tampilan cockpit SAP standar - Penjualan, Pembelian, Keuangan dan Inventaris adalah tampilan cockpit standar yang tersedia. Kilasan informasi akan menunjukan pendapatan per pelanggan dan jumlah pesemsanan Anda.
Berikut contoh query dan dashboard custom untuk penambilkan data Profit n loss di SAP B1
1. Query
SELECT SUM(T0."Credit" - T0."Debit") AS "Total", YEAR(T0."RefDate" ) AS "Tahun", '1. Revenue' as "Type"
FROM JDT1 T0
INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
WHERE YEAR(T0."RefDate" )= YEAR(CURRENT_DATE) -1 AND T1."GroupMask" = '4'
AND T0."TransType" <> '-3'
GROUP BY YEAR(T0."RefDate" )
UNION ALL
SELECT SUM(T0."Credit" - T0."Debit") AS "Total", YEAR(T0."RefDate" ) AS "Tahun", '2. Cost of Goods Sold' as "Type"
FROM JDT1 T0
INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
WHERE YEAR(T0."RefDate" )= YEAR(CURRENT_DATE) -1 AND T1."GroupMask" = '5'
AND T0."TransType" <> '-3'
GROUP BY YEAR(T0."RefDate" )
UNION ALL
SELECT SUM(T0."Credit" - T0."Debit") AS "Total", YEAR(T0."RefDate" ) AS "Tahun", '3. Gross Profit' as "Type"
FROM JDT1 T0
INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
WHERE YEAR(T0."RefDate" )= YEAR(CURRENT_DATE) -1 AND T1."GroupMask" in ('4','5')
AND T0."TransType" <> '-3'
GROUP BY YEAR(T0."RefDate" )
UNION ALL
SELECT SUM(T0."Credit" - T0."Debit") AS "Total", YEAR(T0."RefDate" ) AS "Tahun", '4. Total Operating Expenses' as "Type"
FROM JDT1 T0
INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
WHERE YEAR(T0."RefDate" )= YEAR(CURRENT_DATE) -1 AND T1."GroupMask" in ('6')
AND T0."TransType" <> '-3'
GROUP BY YEAR(T0."RefDate" )
UNION ALL
SELECT SUM(T0."Credit" - T0."Debit") AS "Total", YEAR(T0."RefDate" ) AS "Tahun", '5. Operating Profit (EBIT)' as "Type"
FROM JDT1 T0
INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
WHERE YEAR(T0."RefDate" )= YEAR(CURRENT_DATE) -1 AND T1."GroupMask" in ('4','5','6')
AND T0."TransType" <> '-3'
GROUP BY YEAR(T0."RefDate" )
UNION ALL
SELECT SUM(T0."Credit" - T0."Debit") AS "Total", YEAR(T0."RefDate" ) AS "Tahun", '6. Taxes and Ordinary Item' as "Type"
FROM JDT1 T0
INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
WHERE YEAR(T0."RefDate" )= YEAR(CURRENT_DATE) -1 AND T1."GroupMask" in ('8')
AND T0."TransType" <> '-3'
GROUP BY YEAR(T0."RefDate" )
UNION ALL
SELECT SUM(T0."Credit" - T0."Debit") AS "Total", YEAR(T0."RefDate" ) AS "Tahun", '7. Net Profit ' as "Type"
FROM JDT1 T0
INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
WHERE YEAR(T0."RefDate" )= YEAR(CURRENT_DATE) -1 AND T1."GroupMask" >= '4'
AND T0."TransType" <> '-3'
GROUP BY YEAR(T0."RefDate" )
2 . Dashboard View
- Tarik Total ke bagian Target Measures untuk menampilkan nilai pada grafik batang di dashboard, kemudian pastikan type kalkulasinya adalah SUM,
- Tarik Type ke bagian Target Dimensions untuk menentukan dimensi dari grafik batang di dashboard,.
- Jadi jika dirasa sudah sesuai antara tampilan Dashboard dengan data yang dibutuhkan maka tinggal klik centang untuk save dashboard yang sudah diCreate.
