Connect your USB drive to your DWAN computer.
In DRMIS Production, run the following transactions with the specified parameters:
IE 36 - Display Vehicles
002
VEH_EQUIP
EV0309
, EV0B54
, EV0B68
, EV0B80
, EV0B82
, EV0B94
, EV0B97
, EV0J06
, EV0J07
, EV0J08
, EV0J31
, EV0J35
, EV0J36
, EV0J37
, EV0J38
, EV0J44
, EV0J46
, EV0J81
, EV0J82
and EV0J83
ZEIW29 - List Edit Display Notification (UDF)
Outstanding
, Postponed
and In process
0001
Export the results to Excel, and save the files to your USB drive as ie36.csv
and depot.csv
, respectively.
In DRMIS BEx Analyzer (DRMIS BW Production), run the following transactions with the specified parameters:
[3663] Minister of National Defence
and [REST_H] Not Assigned Force Element
EV0309
, EV0B54
, EV0B68
, EV0B80
, EV0B82
, EV0B94
, EV0B97
, EV0J06
, EV0J07
, EV0J08
, EV0J31
, EV0J35
, EV0J36
, EV0J37
, EV0J38
, EV0J44
, EV0J46
, EV0J81
, EV0J82
and EV0J83
X
Once the transaction finishes running, right click on any table heading (e.g. Equipment Number), and click Query Properties:
Qty Held
from Chosen Selections to Displayed Key Figures (select each and click the left arrow icon)Plant
from Free Characteristics to Columns fieldPlant
and select properties. In the properties change Display
from Key
to Text
and click OKEquip. Object Type
to Free Characteristics (select each and click the right arrow icon)Equipment Number
and User & Info Statuses
to Rows (select each and click the left arrow icon)Equipment Number
, Equip. Object Type
and User & Info Statuses
The Query Properties must look like the following:
Select all of the table headings and rows, copy and paste into a new Excel file, and save it to your USB drive as bex.csv
.
Disconnect your USB drive from your DWAN computer and connect it to your standalone computer (e.g. Dell XPS 13).
run.sh
and select Run in Terminal
. Then right click on http:\\###:##:##:##
and select Open Hyperlink
Create Report
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.