Home

User Manual Reporting

1. e Statistics olume Statistics View You can now see the so called instances reports with your personalised settings which are available for you Categories View Latest Instance ii Schedule History y Shipment_Date_W Content Summary View Volumes by Arrival Mol Airport Transit Time in hours Detailed View on Ex History Global Sea Volume Statistics by Shipment Date V1 dans amp Show All C Show Completed Show only instances owned by me Filter Instances By Time Organize Y Pause El wM 1 ot gt Ju Title Run By Parameters Format Status z 2 10 Global Sea Volume Statistics by Shipmen csr ce kn comb viewer DEHAM6O KN LOGIN TEST 6 9 Resume i 1 MicrosoftExcel Success Y DEHAM60 KN LOGIN TEST 6 1 Microsoft Excel Success DEHAME6O KN LOGIN TEST 6 1 f Recurring del DEHAM6O KN LOGIN TEST 6 1 Failed x y abrira P us y Hi Lory C Dues ana Ligusics Dy Siuprnerd Daa Le amp Show Al C Show Completed F Show orty instances owned by me Fiter Instances By Time az ww Instance Time Title Run By Parameters Format i9 Ape 2012 12 10 Goba Sea Volume Statishes by Shipment Date V1 cs ce kn comb viewer DEHAMEO EM LOGIN TEST 6 Merosolt Excel 194Apr 2012 12 03 GONA Sea Voume Statistics bes Shipment Dare v1 cen ce kn cmb viewer DERHAMSO PEN LOGIN TEST 6 Microsoft Excel i9
2. Replace existing schedule This option replaces the existing schedule The origin Instance will be deleted and substituted by the new one You can change all the parameters like you require them This is for example useful if you want to change the e mail recipients or change the reporting period of an existing instance Create new schedule from existing schedule The parameters of the origin report can get modified e g you need a report just for another KN Login customer Active Customer Profile but the same time interval and receivers should be applied This option creates a new recurring instance Reschedule if the Report status is shown as Success at least one successful run of the Instance is shown in the History table Actions Organize au of 1 Parameters Format Status Global Sea Volume Statistics by lcsr ce kn comb viewer DEHAM60 KN LOGIN TEST 6 1 Microsoft Excel Success Global Sea Volume Statistics by csr ce kn comb viewer DEHAM60 KN LOGIN TEST 6 1 Microsoft Excel Recurring The option to set up a Reschedule based on a successfully transmitted version is quite useful if you wish to keep the underlying report schedule Recurring unchanged and create a copy version with slightly different settings It cannot happen that you accidentally change the settings of your original Schedule Instance because the creation of a new schedule will be done by default KN Login v
3. Customer Name DEHAMBO KN LOGIN TEST 2 Double click on the customer line in the window on the left hand side or click on it once and use the gt button so that it 23 April 2012 13 15 39 GMT 00 00 m E DEHANEO n O appears under Please select customer from list 2 More Information Select or type the values you want to return to reports for each prompt displayed here w came KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 7 of 20 Copyright Kuehne Nagel 2008 2012 The first prompt line will contain the selected KN Login Code Customer name select customer from list DEHAMBO KN LOGIN TEST If there is a red arrow in front of one prompt you need to answer this prompt to run the query By default you will be asked for the customer code before running any query 1 2 2 2 Select Date Range The date range is selected relative to the execution date It is predefined for a half year report which means that all shipments will be shown which have a shipment arrival date within the last six months prior to the month in which the report is executed Prompts x Reply to prompts before running the query v 1 Please select customer from list DEHAM60 KH LOGIN TEST 2 Start Please enter number of months prior to current month 6 To change the date range click into the line you want to v 3 End Please enter number of months pr
4. gt Shipment Reporting User Manual July 2012 Page 14 of 20 Copyright Kuehne Nagel 2008 2012 Explanation of Placeholders Title Instance Title as shown in the initial screen ID Do not use Owner Your KN Login User ID DateTime Date and Time of the report refresh E mail Address Do not use User Full Name Do not use Viewer Hyperlink Do not use only for the message field Once you have selected a placeholder it will be shown in code format e g SI OWNER for placeholder Owner Schedule Instance Title Recurrence Prompts Formats and Destinations Caching Events Scheduling Server Group The settings in Caching Scheduling Server Group and Events should not be changed Then click on Schedule to activate the report definition KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 15 of 20 Copyright Kuehne Nagel 2008 2012 1 4 Rescheduling Reports Rescheduling is a helpful tool if you want to change the e mail recipients of a report or if you want to send the same report to the same recipients with other prompt values e g another KN Login Code KUEHNE NAGEL D S Home Document List Open Send To i New Add Organize All Titl Properties Personal Categories A o Corporate Categories KN Login Reporting 4 clo Choose your report click on lt Actions gt and lt History gt to see the additional details
5. 3 8 gt gt Shipment Reporting User Manual July 2012 Page 17 of 20 Copyright Kuehne Nagel 2008 2012 1 5 Deleting Reports KUEHNE NAGEL 1 S Home Document List Open Send To Choose your report click on Actions and then on History rw A amp New Add Organize Properties amp Personal Categories View e Statistics BE Corporate Categories Categories olume Statistics ES KN Login Reporting ae View Latest Instance y_Arrival_Date_V1 Ames by Arrival Iv schedule Detailed View on Ex y Shipment Date v Content Summary View Volumes by Arrival Mo Airport Transit Time in hours Detailed View on Ex Actions Organize Mark the respective report This will change the colour of Organize and activates it Instance Time Title Es 23 Apr 2012 09 42 Global Sea volume Statistics by ES 23 Apr 20 12 09 42 Global Sea volume Statistics by 23 Apr 2012 09 42 If you want to control that this is the right report to delete click on lt Instance details gt and check the presented information History Global Sea Volume Statistics by Shipment Date V1 Show All C Show Completed Show only instances owned by me Filter Instances By Time Actions Organize Instance Time Title Parameters Status E 23 Apr 2012 09 42 Global_Sea_Volume_Statistics_by_Shipment_Dat csr_ce_kn_comb viewer DEHAM60 KN LOGIN TEST 6 1 Microsoft Excel Suc
6. Ape 2012 12 03 Goba Sea Volume Statishes by Shipanent Bate V1 ca ce kn comb wieg DEHAMEO EM LOGIN TEST 6 Merosolt Excel 19 Apr 2012 11 54 Giohal Ses Voume Statistics bw Shipment Dare v1 cer ce kn cmb viewer DERAPSO PEN LOGIN TEST 5 Microsoft Excel Click on Recurring to receive additional information about a scheduled instance HistoryStatus Global Sea Volume Statistics by Shipment Date V1 Title Global Sea Volume Statistics by Shipment Date V1 You Can now see when the report will run next time Document Type Microsoft Excel Status and the interval is shown Destination DO Owner csr ce kn comb viewer Creation Time 23 04 2012 09 42 Next Run Time 23 04 2012 12 41 Recurrence Type Object runs every O days 3 hours and O minutes Parent Object Path KM Login Reporting Global Standard Reports Seafreight Expiry 26 04 2012 09 41 Formats Microsoft Excel Parameters DEHAM60 KN LOGIN TEST 6 1 Back KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 16 of 20 Copyright Kuehne Nagel 2008 2012 _Reschedule Global Sea Volume Statistics by Shipment Date V1 danke Reschedule Replace Instance Tit 9 i err a The Replace section offers you the possibility to e AA dup de aus dli replace or to create a new schedule from an already Prompts existing report Formats and Destinations Caching Events Scheduling Server Group Schedule Cancel
7. E to the right of the Start Time End Time fields x q April 2012 gt sun Mon Tue Wed Thu Fri Sat ee ta E Ps 851 o 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 2313011 213149415 E aaa liliz KN Login v 3 8 gt gt Shipment Page 12 of 20 Reporting Choose your Start and End Date and Time In this example the report will run every month between 18 April 2012 and 31 May 2012 on the 4 day of each month as we kept the default settings User Manual July 2012 Copyright O Kuehne Nagel 2008 2012 1 3 2 Prompts Clicking on lt Prompts gt and then lt Modify Values gt will take you to the prompt dialog again Please handle entries as explained in the above chapter on calling off Ad hoc Reports Schedule Prompts Instance Title Modify values for Global Air Volume Statistics by Arrival Date V1 Recurrence Prompts Formats and Destinations 2 Start Please enter number of months prior to current monta 1 Please select customer fram list Caching Events Scheduling Server Group 3 End Please enter number of months prior to current month To finally save the values for the scheduled refresh and close the Prompts Reply to prompts before running the query F 1 Please select customer from list DEHAM60 KH LOGIN TEST Q 2 Start Please enter number of months prior to current month 6 J 3 End Please enter number of months prior to cu
8. KUEHNE NAGEL KN Login Shipment Ve EYES Dire 18 Minni a d E da ox y A 18 ils USER MANUAL KN LOGIN REPORTING VERSION 3 8 JULY 2012 Table of Contents A A 4 11 PFertetence SONO S eer 5 MZ Ad TOG AC OOF RE iii 6 1 2 1 Step 1 Select your Report samenen ae EEA A EEEE EEEE 6 1 2 2 Step 2 Fill out your Report Criteria Prompts and Start Refresh oooooococoninncccccicnnnnccccononnnnnnnnnnnnnnos 7 1 2 2 1 Select Customer first Filter Criteria mandatory oooocccnnncccccconnnccnnnccnononanncnnnnnonononannnnnnnnnnnnnnans 7 EAS las AP oo TO e O 8 its y ARA Ay Pa A 9 12 39 18 9 Save Report to MSM Excel eo iode an oct iii dieta 10 ANA A P 11 1 3 1 Timer S ttinS ccccecccccccccsesseeeceeeeeeseeeeeeeceeeeeeeeeeeeeeeeeeeeeseeesseeeeesseaeseeeeeeeeessuaeaaseeeeessssaeaeeeeeeeeesseaeas 12 132 A ere OU UE O O PUES TI 13 1 3 3 Output Formats and E mail Recipients ccccccccocconnccnnnncccnnnnonncnnnnnnnononanncnnnnnononnnnnnnnnnnnonnnnnnnnnnnnennss 14 1 4 He scheaulng Reports scsi i a r Eaa ida 16 To A 18 1 6 Useful Hints for Printing Reports from MS Excel G esses 19 1 7 Logout OF Business ODIGCIS ini 20 KN Login v 3 8 Shipment Reporting User Manual July 2012 Page 2 of 20 Copyright Kuehne Nagel 2008 2012 L Notice o
9. View which opens in a new Browser Window Tab You will be taken directly to the list of available reports in Business Objects M InfoView KUEHNE NAGEL ur j Welcome judith guthoff Home Document List Open Send To Help Preferences About Log Out Xx fa E New Add Organize Actions Search title J of 1 All Title Last Run Type Owner Instances e Personal Categories e Regional Standard Reports Category administrator amp Corporate Categories Ti OO User Manual Global Volume Statistics Adobe Acrobat csr_global publisher KN la o Global Ai volume Statistics by Arrival Date V1 04 Jun 2012 07 01 Web Intelligence Report csr global publisher 70 Global Air Volume Statistics by Shipment Date V1 25 Jun 2012 07 16 Web Inteligence Report csr_global publisher 110 Global Combined Volume Statistics by Arrival Date V1 05 Jun 2012 10 27 Web Inteligence Report csr_global publisher 100 KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 6 of 20 Copyright Kuehne Nagel 2008 2012 If you have personalised reports you will find them in the My Favorites folder Home Document List Open Send To New Add Organize Actions Title Personal Categories ES Regional Standard Reports E Corporate Categories T3 O1 User Manual Global volume Statistics Home Document List Open Send To m Select My Favorites and
10. and Preferred Viewing Locale in case you want to customise your language specific settings Product Locale Use browser locale Product Locale The menu header of the Reporting application will be translated in the selected language All reports will always be generated in English Preferred Viewing Locale Use browser locale Preferred Viewing Locale Define the format of dates and figures in your report KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 5 of 20 Copyright O Kuehne Nagel 2008 2012 For Example Date e g 31 March 2012 Number English United Kingdom 31 03 2012 23 14 9 076 00 kgs English United States 3 31 12 11 14 PM 9 076 00 kgs German Germany 31 03 12 23 14 9 076 00 kgs Change Password Web Intelligence Desktop Intelligence and Crystal Reports must not be changed This options are listed by default of Business Objects Close the Preferences screen with a click on lt OK gt on the right bottom of the page 1 2 Ad hoc Report 1 2 1 Step 1 Select your Report To access the Reporting function move your mouse over Report in the header menu KUEHNE NAGEL 2 KN Portal Services View Interact Report Configure Support 60 Dashboard Image Archiving Data Extract and then click on Reporting in the drop down menu The standard reports are provided in Business Objects M Info
11. cess 23 Apr 2012 09 42 Global Sea Volume Statistics by Shipment Dat csr ce kn comb viewer DEHAM60 KN LOGIN TEST 6 1 Microsoft Excel Recurring Select Organize and click on Delete KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 18 of 20 Copyright Kuehne Nagel 2008 2012 1 6 Useful Hints for Printing Reports from MS Excel It may happen that the page break is not properly transferred from InfoView to MS Excel In this case the layout can be adjusted in MS Excel Ed Elle Edit Vi Insert Format Tools Data Window Help J Page Break Preview Click on lt View gt gt lt Page Break Preview gt The View now changes to the page break preview TC Detailed View on Export Trade Lanes Chargeab Airport of Jepartare ee AE Airport of Arrival Shipper LII HAWE Shipmcet Tepe Fate le pola A CEE seas NN IET EE IE aL I ECC A EA O aL Pa ae Debs ik TI UA 1 Sngl Concigment ATA 10 menos f aof 2 7020 san sf Lm ee pesi sr Demeue fucer fesem ingle Consignnant ATA Diecad p senos rea isos ass Sf oa A Pia AE Dua m De E E resso Single Consignment IATA 1 Direct A bite S me aso oat VULT AZ H OA A ETT AE Dubai zw Harare UNICEF ACIDO03T726 single Concignment IATA Direct Ad d 22770008 a amoro 3358 L ae Des NP Katimand uncer EEC Single Consignment ATA Dread meos s sos s20r c za B Dui M
12. displayed because this terminates the preparation of the MS Excel file Opening Global Sea Volume Statistics by Arrival Date Yi xls Tou have chosen to open pst Global 5ea Volume Statistics by Arrival Date VY1 xls l l which is a Microsoft ExcelArbeitsblatt 82 5 kB In this dialog click on the Save File radio button In from https boxi extra cluster int kn the next dialog the folder can be selected which the what should Firefox do with this file MS Excel file shall be saved in From there the report can be opened with MS C Dpen with Microsoft Office Excel default Exce e prise j Do this automatically for files like this from now on 90K Cancel Once the report is saved to MS Excel the report can be refreshed for another customer time period by clicking on the Refresh Data button on the top right of the report To exit KN Login Reporting just close by clicking on Log Out KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 10 of 20 Copyright Kuehne Nagel 2008 2012 1 3 Scheduled Report In this chapter we will show you how to schedule your reports Scheduling means setting up the report to run automatically at a specific time and in specific time intervals These personalised settings will be registered in KN Login Reporting as so called Instances KUEHNE NAGEL T Welcome judith guthoff S Home Document List Open Send To Hel
13. ects InfoView which opens in a new Browser Window Tab You will be taken directly to the list of available reports in Business Objects M InfoView KUEHNE NAGEL T Welcome judith guthoff F Home Document List Open Send To Help Preferences About Log Out xf E le GP New Add Organize Actions v Search title 2 lofi ch AJ Title Last Run Type Owner Instances e Personal Categories e Regional Standard Reports Category administrator amp Corporate Categories 00 User Manual Global Volume Statistics Adobe Acrobat csr global publisher Global Air Volume Statistics by Arrival Date V1 04 Jun 2012 07 01 Web Inteligence Report csr_global publisher 70 Global Air Volume Statistics by Shipment Date V1 25 Jun 2012 07 16 Web Intelligence Report csr global publisher 110 Global Combined Volume Statistics by Arrival Date V1 05 Jun 2012 10 27 Web Intelligence Report csr_global publisher 100 Before you start with the creation of a report you can adapt your personal settings in Preferences KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 4 of 20 Copyright Kuehne Nagel 2008 2012 1 1 Preference settings KU E H N E NAG E L Welcome csr ce kn comb viewer Home Document List Open Send To Help About Log Out The click on Preferences leads you to the following screen Preferences csr ce kn comb wlewer rare InfoView Start Pa
14. f Confidentiality Proprietary and Confidential Material This document and all information contained herein are property of the Kuehne Nagel group comprising of its affiliates and subsidiaries No part of this document may be reproduced by any means or transmitted without the prior written permission of the Kuehne Nagel group comprising of its affiliates and subsidiaries except with respect to copies made or transmitted internally by the recipient of this document for the purpose of evaluating the contained information In any event shall this document and any copies thereof be held in strict confidentiality KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 3 of 20 Copyright Kuehne Nagel 2008 2012 1 Reporting Reporting allows you to access within KN Login the Global and Regional Standard and Customised Reports across carriers and modes Please discuss your reporting needs with the KN account representative to determine which reporting solution will be suitable for you The following describes the process of calling off a standard report both ad hoc and scheduled To access the Reporting function move your mouse over Report in the header menu KUEHNE NAGEL 2 KN Portal Services View Interact Report Configure Support 60 Dashboard Image Archiving Data Extract and then click on Reporting in the drop down menu The standard reports are provided in Business Obj
15. ft umicer inessssses Single Concignment ATA t Dire ed opioa 1 sof oosa ap Se oe o Cold pese mentir ECTS mthi 18 COITO CO CO A ESTE ETT E morenos s isseo naze 3p 18 A O CA E ETT BB pons s ssoj oseo wef 18 Des mese 7 CEA E EAT Dec f A reno tl isso woof sl A A MTC e a NERO RESO AE Dubai er Manis unicer CTS ENTRADA E ETE IE To ET RN I _ G al I FR rm m I AGE rmn m TO TO I The dotted blue lines can now be moved to create the desired page break AAA SETTE z de Lane In this case the vertical line needs to be moved to the right Departare Therefore the mouse pointer needs to be positioned on this line Date until it looks like this and then it needs to be pulled to the Single Consignment IATA Direct Air desired position in this case to the next blue line to the right 3hipmest Type Single Consignment LATA Direct Air 132 2003 KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 19 of 20 Copyright Kuehne Nagel 2008 2012 adeLanes J Chargesab Yolum LELA le Weight Tima kg Pm nua Departerc Piece Shipmecet Tepe Date Single Consignment ATA Direct Air 01082008 2 6 0000 sama i Single Consignment ATA Direct air mweroos so 4ews war Jo ERA ra ECT TO ETT CEE O RN CT MEE PENES EEE u In the print out all columns
16. ge You will see the standard reports by Rome C My Infoview default C Favorites C Inbox C Folder unspected EfOWSeFGkder Document Navigation View As long as the Category is category KNLogn Reporting ENNENENEEEEM chosen as the InfoView Start Page the selection in a Document Navigation View has not an impact This will be a a the same when Folder is specified as InfoView Start Page Sel he number ol objects max per page 10 Document List Cisplay E ducti Set the number of objects max per page Use this option in to define the number of reports or folders per page to be F retance count displayed on the InfoView Start Page Document viewing E ine Infoview portal C In a single fulscreen browser window one document at a time In multiple fullscreen browser windows one window for each document Document List Display Select which kind of information you ase rore cic want to see on the InfoView Start Page Current Time Zore Local fo web serwer Home DocumentList Open Preferred Viewing Locale ae z e Crystal Reports SP Mew Add Acbons Search tite Lge browser kxzale Eta Tithe Last Run Type Omer Dres Lares e Change Password BE personal Categones E regional Sta C3 ER ll H Web Intelligence VP Corpor SEPT Ve nic 4 Desktop Intelligence rs tie Global vo Language specific settings Change Product Locale
17. ior to current month 1 change and type the new value into the window shown below the prompt field 2 Start Please enter number of months prior to current month 6 Currently selected values in listbox cence The figure 0 relates to the current month Report will include shipments with a Shipment Departure respectively Arrival date in the current month starting or ending Negative figures relate to previous months Report will cover shipments with a Shipment Departure respectively Arrival date in the past Positive figures relate to upcoming months Report will cover shipments with a Shipment Departure respectively Arrival date in the future The Shipment Arrival date is the status date of the ACTUAL event shipped arrived if it is available otherwise it is the last update of the planned event expected departure expected arrival KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 8 of 20 Copyright Kuehne Nagel 2008 2012 Start Refresh After all prompt lines are filled all prompt lines should show the 4 symbol click on Run Query Retrieving Data While the report is refreshed meaning compiled this message is shown Last refresh time Oh Om 10s Cancel When this message disappears the refresh is finished and your report is ready KN Login Sea Freight Statistics Report by Arrival Date Your selection Summar
18. ntelligence Adobe Acrobat PDF or Comma Separated Values CSV is also possible Output Format Details E mail recipient is the default setting please do not change it Define the E mail recipient by clicking on Destinations Options and Settings Formats and Destinations Output Format and Destination v Destinations Options and Settings Destinations for the output format Options and Settings Email recipients Use the Job Server s defaults donotreply kuehne nagel com V Add attachment Enter Email Address Attachment C Automatically generated amp Specific name SI_NAME EXT Title Title Y Add file extension ID ID Owner Date andTime Email Address Owner Date andTime Email Address Date andTime Email Address User Full Name Viewer Hyperlink C Cleanup instance after scheduling From To Cc Please enter the applicable e mail addresses From and To are mandatory Subject Sl_Name is set by default It results in the report name to be shown in the Instance Title box You are free to choose your own e mail subject title also by means of the placeholders Message You can enter a free text or use the contents of the placeholder drop down list Specific name This is the name of the report In the above example the name would be the Instance title plus the extension XLS You can also extend the name by using the placeholder menu KN Login v 3 8 gt
19. p Preferences About Log Out X Ec E New add organize Actions search tite TA ora ch All Title Last Run Type Owner Instances B Personal Categories e Regional Standard Reports Category administrator zu E Corporate Categories T3 OO User Manual Global Volume Statistics Adobe Acrobat csr global publisher ES kN Login Reporting Global Air volume Statistics by Arrival Date V1 04 Jun 2012 07 01 Web Inteligence Report csr_global publisher 70 ES Global Air Volume Statistics by Shipment Date V1 25 Jun 2012 07 16 Web Intelligence Report csr_global publisher 110 Global Combined Volume Statistics by Arrival Date v1 05 Jun 2012 10 27 Web Intelligence Report csr_global publisher 100 Choose your report and click on it Home Document List Open Send To l The Actions button changes the colour to black x what indicates that it is usable Choose in the i S New add organize Actions Actions menu lt Schedule gt All Properties i ER Personal Categories view B ES Corporate Categories H KN Login Reporting Schedule Global_Air_Yolume Statistics by Arrival Date v1 Schedule Instance Title This window will open up Instance Title By clicking on the headers under Schedule Recurrence you can open the individual settings to mampi define them in detail Formats and Destinations Caching Events In case you want to rename the report for Scheduling Server Group the ex
20. port just change the name shown in the Instance Title box By default this field will show the name of Schedule Cancel the report you are working with Discussions KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 11 of 20 Copyright O Kuehne Nagel 2008 2012 1 3 1 Timer Settings Schedule Global Air volume Statistics by Arrival Date V1 Schedule Recurrence Instance Title Recurrence Prompts Formats and Destinations Caching Events Scheduling Server Group Run object Nth Day of Month Now Once Hourly Daily Weekly Monthl 1st Monday of Month Last Day of Month X Day of Nth Week of the Month Calendar Object will run on the Nth day of each month Day N 4 Start Date Time 1i 04 18 4 2012 End Date Time 11 04 30 5 2012 Discussions The values shown are default settings The default Instance Title instance report with your personalised settings is always the report name Under Recurrence you need to select the interval in which the report shall run Run object Some selections require an additional entry of details Example The default Nth Day of Month needs an entry in the Day N field to run Default for the Day N is 4 The report will run on 4th Day of Month by default Further you have to define the time frame for the recurring call off Click on the calendar symbol
21. rrent month 1 Cancel select a customer Prompts x Reply to prompts before running the query 1 Please select customer from list DEHAM6O KN LOGIN TEST v 4 Start Please enter number af months priar ta current month 6 v 3 End Please enter number of months prior ta current month 1 Refresh values FA 1 Please select customer from list KN Login Code Customer Name gt DEHAMBO f KN LOGIN TEST DEHAMBU ERN LOGIN TEST amp April 18 2012 11 48 20 AM GMT 00 00 Enter vour search pattern here qe 2 Currentiyselected values in listhax DEHAMBU i KM LOGIN TEST Apply Cancel and click on the Apply button KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 13 of 20 Copyright Kuehne Nagel 2008 2012 1 3 3 Output Formats and E mail Recipients Schedule Formats and Destinations Instance Title Y Output Format and Destination Recurrence Output Format Output Format Details Prompts Formats and Destinations web Intelligence Destinations for Microsoft Excel Caching v Global Air Volume Statistics by Arrival Date V1 7 Adobe Acrobat Inbox File location l FTP server M Email recipients Comma Separated Values CSV Events Scheduling Server Group Destinations Options and Settings Output Format The default setting is Microsoft amp Excel amp which we recommend to keep Receiving the report in the format Web I
22. will now be on one sheet The horizontal alignment is automatically done by MS Excel 1 7 Logout of Business Objects KUEHNE NAGEL 1 Welcome csr ce kn comb viewer Home Document List Open Send To Help Preferences About FX ic EB i New Add Organize Actions Searchtite Od a i ofa You can securely log out of Business Objects by clicking on Log Out This will take you to the Business Objects log on screen just close the browser window or browser tab If you want to log in again select Report Reporting from the KN Login menu KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 20 of 20 Copyright Kuehne Nagel 2008 2012
23. y Customer Code DEHAM60 No of Shipments 32 Customer Name KN LOGIN TEST No of TEU 36 Arrival Date from 01 10 2011 Volume 1 128 305 cbm Arrival Date to 31 03 2012 Gross Weight 419 090 28 kgs Last Refresh Date 18 04 2012 08 46 Export Number of Shipments and TEU per Loading Country Import Number of Shipments and TEU per Discharge Country max Top 10 displayed max Top 10 displayed HR HK CN DE CA GB IN RO SI TW AE DK GB HK KE BI No of Shipments g No of TEU No of Shipments E No of TEU We suggest exporting the reports because they are optimised for the view in MS Excel KN Login v 3 8 gt gt Shipment Reporting User Manual July 2012 Page 9 of 20 Copyright Kuehne Nagel 2008 2012 1 2 3 Step 3 Save Report to MS Excel After the refresh is finished the report can quite easily be saved to MS Excel Ey Document gt View gt 514419 Close Save az Details by Port of Discharge Shipment Details ES with options Click on the lt Document gt button on the top left of the browser window in which the report is displayed Navigate to Save to my computer as click on lt Excel gt and the whole report will be saved Save report to my computer as saves only the actual visible sheet After a few seconds large reports will take a bit longer the browser standard dialog opens for downloading Do not click anything else within the browser window in which the report is Y
24. your reports will appear The All folder tree lic amp New Add organize Actions contains also the inbox where reports can be stored Title E 2 Public Folders There are two ways to open your report just double click on the report name KUEHNE NAGEL 1 S Home Document List Open Send To Dee eS New Add Organize Sal Title Properties E2 Personal Categories T og ve 507550PPg E E Corporate Categories Categories Glob Schedule un E KN Login Reporting or mark the report name with one click and select in lt Actions gt the option lt View gt Blume Statistics nal Volume Statistics cs by Arrival Date V1 1 2 2 Step 2 Fill out your Report Criteria Prompts and Start Refresh Once a report is selected the report criteria need to be defined in Prompts This dialog automatically opens after selection of the report 1 2 2 1 Select Customer first Filter Criteria mandatory Prompts Ss Reply to prompts before running the query 1 Please select Customer from List v 2 Start Please enter number of months prior to current month 6 1 Enter the KN Login Code or the Customer name into the v 3 End Please enter number of months prior to current month 1 search field and click on the a look up icon Refresh Values F 1 Please select Customer from List KN Login Code

User Manual Reporting

Contents

Download Pdf Manuals

Related Search

Related Contents