DEVELOPMENT ASSISTANCE DATABASE FOR IRAQ (DAD – IRAQ)
Contents
1. 24 6 3 4 EdI ig an ExIisbilidg ea Pull tet ee ote m te coe tua haus acne soe 24 T 24 7 REPORT MODULE vi 25 JLOUNGCESSINGOTHE REPOR MODULE UNE I IER x IL LI E DULCI IR 25 L2 INSTRUCTIONS FOR CREATING A REPORT a tes 25 dz ICE dise ue ss ew a 26 DAD IRAQ APPLI CATI ON USER MANUAL 3 pa eis zcv eS Riso RTT 26 J 9 GUSTOMIZING REPORTS o E MI 21 7 5 1 Formatting Styling Report Components e reete veta Era e UE RUE ean 27 7 5 2 Re ordering Report Table 27 7 5 3 SORIAG Report Table CompohelbkS s esci edi tette dnte orit tor rrt scel ret tees 28 1 5 4 Displaying Iria REPO cepe es oe een 28 Loo Removing a Report Table GCompofeblt u d um e P eti ie c e is 28 7 5 6 Switching Report Table 29 FILTERING ieee ei he EEA SEA Rs 30 8 1 INSTRUCTIONS FOR CREATING FILTERING CRITERIA cccccccccccccccsccesccuccceccaeccesccesc2. ems enne nne nna naa naa nn nnn 8 THE USER REGISTRATION FORM bcne d duds bur ase de rnc AERA Eb CLER e a 9 THE MY PROFICE SECTION tn NU NERO TUE GUN UNIES UP eR exa pilae ur 10 DAD IRAQ LIST MODULE iik eap da Event n on ci oe ce Re ie one cea ad bor e 11 EXPANDING THE LIST TEM ip td P dpa P ado co Ac i din de eR p E YU aD Rt de 12 AIDING IMAGES IN due Bat ean dew e un Pap des e 12 MODIFYING THE CURRENT VIEW cive vatis quta qup VER Tia ORE EP VERE ATE CU QE EA M xU PRORA 13 DEFINING LIST VIEW GROUPINGS ciciren und Gat dud rs Bap ano ddnde oun sca dad s tenet vane cal Deis 14 DEFINING LIST MEW COLUMNS RE RAI EL REI abd SATA TIE Chal MAPA ERATIS DEAN GU RM S 14 EW E 15 THE DETAILS SECTION 16 DAD IRAQ APPLICATION CHART MODULE Ee Mines rbi re aeo dte dinde ve 17 F XAMPLE CHART REPOR T Eta DD I DE 18 SETANG THE CHART OPTIONS N dE 19 DAD IRAQ APPLICATION MAP MODULE Hmmm eme enean rane rn rna nenas 21 EXAMPLE POR 23 DAD RAQ APPLICATION REPORT MODULE e
3. 11 SORTING LIST ITEMS 9 5 9 008 0 12 A A BROWSING AMONG LUST ITEMS 3 5 pM n es lies atta tee n osi aliai atts eee 12 4 5 HIDING SHOWING IMAGES IN THE erret ena aed eee Em veo wicks veo Rr Ex e decl von tipos Uno et eto o eee verra ho Eo 12 4 6 INSTRUCTIONS FOR MODIFYING THE CURRENT pud Ecos ERO UE US UU Eu Lu UOS Dou Co CH UC d DER DES 13 4 6 1 Adding List Groups Columns Column Groupings sss eene eene nennen 13 4 6 2 Re ordering Groups Columns Column Groupings enne nennen 14 4 6 3 Removing Groups Columns Column Groupings sese enne enne 14 VIeW as Derallt iae vdd 14 7 VIEWING PROJECT IP pd 15 A Mio inea eee m mtm 15 4 7 2 Printing the Project Details e a EEEE nnn nnne 15 tete a n etie tec tuna te eto 15 2 7 4 Eating etu tod feo casks sedute sees 16 4 1 5peletiig anm ExistiligjPEOLGCE eom o dec etam csl teda ed 16 5 CHART MODULE Vos eo uu Vo Oo cho due oet s a tov acta deve seu duse esae e
4. Figure 32 Organizing the Reports 37 E Cancel E kename Delete i Add Group Ar Mowe IL Move Down DAD IRAQ APPLI CATI ON USER MANUAL 38 11 EXPORTI NG AND PRINTING REPORTS From the Report Chart and Map modules the user can design appropriate reports and export them in the PDF MS Word and MS Excel formats Moreover the user able to print the reports created and save them for future reference 11 1 How to Export Reports In order to export the reports in the PDF MS Word and MS Excel formats the user should follow the steps described below Steps l Click on the respective Tj Export in PDF Format Export in MS Word Format Export in MS Excel Format button A separate window will open 2 Make changes if necessary 11 2 How to Print Reports In order to print out the reports the user should follow the steps described below Steps 1 Click the Print button in the top toolbar A separate window will open 2 Select the Print option from the File menu
5. From the List Report Chart and Map modules the user can design appropriate reports and organize them in the desired way In order to organize the reports the user should follow the steps described below Steps l Click on the Organize Reports button at the top right side of the Screen An Organize Reports window Figure 32 will appear 2 Rename a report report group if necessary In order to rename a report report group Highlight the report group that needs to be renamed Click the Rename button Fill in the desired name for the report group Click the Enter keyboard button to confirm renaming Note Public Reports and My Reports groups cannot be renamed 3 Delete a report report group if necessary In order to delete a report report group Highlight the report group that needs to be deleted Click the Delete button Click the Ok button to confirm deletion Or click the Cancel button to abort the operation Note Public Reports and My Reports groups cannot be deleted 4 Add a sub group to include reports under it In order to add a sub group Click the Add Group button Fill in the desired name for the sub group Click the Enter keyboard button to confirm adding 5 Re order reports groups In order to re order reports groups Highlight the report group the sorting order of which needs to be changed Click the Move Up Move Down button DAD IRAQ APPLI CATI ON USER MANUAL Public iews Views
6. The purpose of this document is to describe how the Development Assistance Database for Iraq DAD Iraq application functions and provides the necessary instructions which the user should follow to ensure successful work with the application Use of this document and compliance with the standards specified herein is mandatory for anyone working with the above mentioned application The present document consists of the following main sections Section 2 provides overview of the DAD Iraq application Section gives instructions on how the user log into the Development DAD Iraq application Section 4 gives a description of the List module of the application and provides necessary instructions on the actions which the user can take in the module Section 5 describes the Chart module of the application and provides necessary instructions on the actions which the user can take in the module Section 6 describes the Map module of the application and provides necessary instructions on the actions which the user can take in the module Section 7 describes the Report module of the application and provides necessary instructions on the actions which the user can take in the module Section 8 describes the filtering opportunities that the system provides Section 9 provides instructions on how to save the reports created Section 10 gives instructions on how to organize the reports created Section 11 describes the steps
7. For instance if the user selects to switch between table grouping and row the selected table grouping item will be removed from table grouping and added as the row item while the row item will trade places with the table grouping item DAD IRAQ APPLI CATI ON USER MANUAL 30 8 FILTERING The system allows for data filtration Filtering allows the user to narrow down the information displayed in the reports The filtration works in the Step by Step technology which enables the user to implement new filtering over the results of the previous one This option reduces the size of reports and makes them easier to read Filters can be added to new or existing reports Defined filtering is applicable for list reports charts and maps The list of the most frequently used filter categories is displayed under the Filter By section The list of all available filter categories is displayed when the user clicks on the More Filters link 8 1 Instructions for Creating Filtering Criteria The user must follow the instructions described below to create filtering criteria Steps l Click on the hyperlink under the Filtering section that represents the Category according to which the filtering will be carried out A Filters window Figure 25 will appear having the Category Items pull down menu set to the selected Category The first text area holds a list of all the available Category items that the report could display whereas the second text a
8. c 25 SELECTING A GROUPING FOR A REPORT aR 26 PREVIEWING THE REPORT dicas van add vU a iin A ot vno Md tb 26 CREATING A REPO T cect Em 27 EXAMPLE LIST REPORT qua quota terio Ven d A MM LP UAM ME 27 FORMATTING STYLING TEXT ENTRIES sas eade Ue ERA Seba mate Rueda ERR UE cente e 27 ASSIGNING PROPERTIES TO REPORT TABLE COMPONENTS 27 DEFINING THE SORTING ORDER co auc Ning Dad dac tea ep eae eua 28 CREATING A FILTERING E Sa eda qu Fox caceass CA VE Md URS 31 E XAMPLE FILTERING CRI Risse idet sconti amit comte ncm LIEU m rts c LEE DE 31 PETER ED EIS dp ameet adottate bu praterea atu da t baud dat ap RARO at 32 CREATING Ay SEARCH SG RIERA Lud oce nti mE Sand mS 33 DEFINING SEARCH CRITTER Ac via Aram ite datu io epa OT OH aa AI dE aaa M E rq EM du 33 SEABCHESUEIS ra iru MET EE d LS 34 VIEMORIZING A ISEPORTAs veta iin hr d a e FC Roe c e e QOL Ra De A RR ERROR BOOKMARK NOT DEFI NED ORGANIZING THE REPOR T ND Cd EOD I D RP 37 DAD IRAQ APPLI CATI ON USER MANUAL 5 1 INTRODUCTION
9. displayed on the map In order to view more detailed information about the categories the user should click on the respective icon on the category based map Steps 1 Click on the appropriate icon for the details to be displayed The user will be directed to the Details sub section of the application where all items matching the selection will be listed The first item in the list will be displayed in an expanded mode 2 Take the necessary actions print out the project details browse among other projects listed under the same parent item add new projects etc Please note that it is possible to view print all project details in a particular selection For this the user should select a Funding Source Sector etc that has more than one project and click on its project to open up details and then click on the View Print Projects button to open the project details for preview and print 3 After finishing click the Close button to return to the Map Screen 6 3 1 Browsing among List I tems In the Details section the user can browse among the list items presented on the screen In order to browse among the list items the user should follow the steps described below Steps l Scroll down to find the relevant list item and view its details by clicking on its ID Or 2 Click on the relevant First q Previous Pl Last button found in the top right corner of the Details screen DAD IRAQ APPLI CA
10. text e Report grouping allows grouping data according to a specific category Grouped data appear in different tables Each table contains data that fall under one group of the category specified e Rows group data within the report table e Columns show details specific to each table row e Sub columns divide the row details displayed under each column DAD IRAQ APPLI CATI ON USER MANUAL 26 In order to add report components the user should follow the steps described below They provide instructions on how to compose and submit queries Steps l Type the text that should appear as the report title in the Title text box 2 Enter a Subtitle Header and Footer if needed 3 In the Group Report by section specify the category which will be used to group data into different tables To add a report grouping click on the Add Grouping link in the Group Report by section and select the appropriate category from the menu that appears Figure 18 Note The report will be divided into as many tables as there are table groupings selected 4 Select table rows by clicking on the Add Row link and selecting the appropriate item from the menu that appears Please note that it is possible to select one row at a time from the list of available rows 5 Select table columns by clicking on the Add Column link and selecting the appropriate item from the menu that appears Please note that it is possible to select one column at a t
11. that are necessary to take when exporting and or printing the reports created DAD IRAQ APPLI CATI ON USER MANUAL 6 2 OVERVIEW The Development Assistance Database for Iraq DAD Iraq application is an automated information management system which is designed to improve efficiency and coordination of donor activities in Iraq It is also a powerful tool for tracking and analyzing aid flows The system serves as the main database and data collection and reporting system as it ensures effective access to aid data The main objectives of the DAD Iraq is to serve as a reliable and credible source of information on overall donor contributions to Iraq s reconstruction economic recovery and socio economic development as well as to support the Government in effectively managing development assistance and promoting the accountable and transparent use of resources The DAD Iraq application is a powerful tool that allows the user to view project data organized into lists reports charts and maps In the DAD Iraq application the user is able to present the project data in the form a list chart and map reports memorize save the reports print them and export them into PDF MS Word and MS Excel format files The DAD Iraq application is designed to provide quick access to the project and aid data remotely via Internet Once the user accesses the application s he can view the project data stored in the database add new projects edit existi
12. the Report Designer Note the event any of these actions is not possible the respective option will be disabled in the menu 7 5 3 Sorting Report Table Components The user may change the order in which the table components will appear in the final report The report table components can be sorted either in an Ascending A Z or a Descending Z A order In order to alphabetically sort the report table components the user should follow the steps described below Steps l Click on the component item for which the sorting order needs to be changed 2 Select the Sorting Order option from the actions list Figure 24 3 Define whether the report item values should be sorted in the ascending or descending order Please note that selecting the None option from the list removes the sorting criteria Note The sorting order for the report components can also be defined from within the Properties window Figure 24 Defining the Sorting Order 7 5 4 Displaying Totals in a Report The user may choose to display totals for report table components These totals can be placed before or after detailed data In order to define whether the totals should be displayed in the report and where they should be placed the user should follow the steps described below Steps l Click on the component item for which totals need to be added 2 Select the Total option from the actions list that appears 3 Define whether the totals should be displa
13. the application 5 4 4 Editing an Existing Project In the Details section the user can edit an existing project Please take into account that the user can edit only those projects which have been created by him her or for which s he has been granted with editing rights by the administrator In order to edit an existing project the user should follow the steps described below Steps l Click on the Edit button at the top of the Details screen The user will then be directed to the Data Entry module of the DAD Iraq application 2 In the Data Entry module make the appropriate changes Note Please refer to the Data Entry Module user manual for more details on how to make changes in the project data 5 4 5 Deleting an Existing Project In the Details section the user can delete an existing project Please take into account that the user can delete only those projects which have been created by him her or for which s he has been granted with deleting rights by the administrator In order to delete an existing project the user should follow the steps described below Steps l In the Details sub section select the project to be deleted 2 Click the Delete button at the top of the Details screen The selected project will be deleted DAD IRAQ APPLI CATI ON USER MANUAL 21 6 MAP MODULE In the Map module Figure 15 of the DAD Iraq application the user can create and execute ad hoc queries on projects data and have the resul
14. vrac pa dee ca eus TVs Deve e Ve ceo odo 17 S d JACCESSINGOTHB CHART MODULE eee are s gto pu E CES EN CO NS A A NU RR LUE 17 5 2 E NSTR CTONS FOR CREATING CHART REPORTS 980 2 2 02 0 0200 208420 20250 baad Noc eR aaa ode Out d acd pao 17 FRING CHART a eo M coti et ELA AT 18 Sod VIEWING CHART CONSTITUENT DETAILS uem otto eet o n re hs e ao uoa SOL RU dee EE 19 sr M Browsing anong i a cmt E 19 EO CCU DCIS eset 20 54 3 a One 20 5 4 4 Edi ung EXISEIigPEOISCE 1 20 54 5 DElEtING arn EXISEING mm 20 MODULE e E 21 O L ACCESSING THE MAP MODULE n e anna a 22 6 2 INSTRUCTIONS FOR CREATING MAP 22 9 5 VIEWING MAP CATEGORY DETALES oti thin bed dieu s EM Gain ELLA EMO E 23 6 3 1 BROWSING among LISE FEGITIS 23 6 3 2 Printing the Prorect m ee Co ore en etes 24
15. DEVELOPMENT ASSISTANCE DATABASE FOR IRAQ DAD IRAQ User Manual Version 1 0 Created on 16 June 2006 Last Updated on 11 December 2006 DAD IRAQ APPLI CATI ON USER MANUAL Revisions DAD IRAQ APPLI CATI ON USER MANUAL 2 5 TABLE OF CONTENTS 4 niece oecee ee eoe eed esee vu eee a op eo od eoe uo Pa Copa E eve cos Have Fus co dp Iosue Poe pee S vet oe eee RE Co aoo pese eve cvs ere 2 TABLE OF FIGURES rores ode Co Fea Pep evo Devo oo eo oa Dee se veuve eue c lobe sese a ode Sot e sor UE 4 Be IN DRO DU GED ON uv 9 o 5 FAS AZ e 6 3 LOGGING INTO DAD IRAQ APPLI 8 3 1 REGISTERING FOR A USERNAME AND PASSWORD ccccscccecccecccecccecececcesccescccececcueccuecccecsseccesccsceesesescueccusceusceeseetseetseuess 8 3 2 LOGGING INTO THE SYSTEM WITHOUT REGISTERING a had e esae te decide ee bre cedo tne iode eod ER eua 10 A EISIT MODUNLE 5 5 em ar rts mr ee CLE S ID EDO Re 11 Zl ACCESSING THE NS FIV NOD UE 11 Z2 EXPANDING TE EST des adt tct teur Sep ls DP AD NO LA DEDE LCS LIU Dose
16. SD set as the chart values is displayed 2 In this module the user can create and display reports in the form of different charts save them as pre defined reports arrange them in the desired way print them etc 5 2 Instructions for Creating Chart Reports In order to create a chart report the user should follow the steps described below Steps l Define one or more of the following e Category Select one of the options provided in the Category pull down menu located at the top of the Chart Screen The selected category will define one of the chart axes Note Selection of a category for the chart report is required e Series DAD IRAQ APPLI CATI ON USER MANUAL 18 Select one of the options provided in the Series pull down menu located at the top of the Chart Screen The selected series will define the chart legend Note Selection of a series for the chart report is optional Note Clicking the button allows trading places of category and series selections Value s Select one or more of the options provided in the Values section Note that when only the Category is defined the user can select one or more Values Hence the Values section consists of a collection of checkbox type elements If however the administrator has defined both Categories and Series prior to defining Values the user can only select one Value Hence the Value section consists of a collection of radio button type elements e Chart Type Click
17. TI ON USER MANUAL 24 6 3 2 Printing the Project Details In the Details section the user can print out the details of the selected project order to print out the selected project details the user should follow the steps described below Steps l Click the Print button in the top toolbar A separate window will open 2 Select the Print option from the File menu 6 3 3 Adding a New Project In the Details section the user can add a new project order to add a new project the user should follow the steps described below Steps l Click on the New button at the top of the Details screen The user will then be directed to the Data Entry module of the DAD Iraq application 2 In the Data Entry module fill in the information requested Note Please refer to the Data Entry Module user manual for more details on how to enter project data into the application 6 3 4 Editing an Existing Project In the Details section the user can edit an existing project Please take into account that the user can edit only those projects which have been created by him her or for which s he has been granted with editing rights by the administrator In order to edit an existing project the user should follow the steps described below Steps l Click on the Edit button at the top of the Details screen The user will then be directed to the Data Entry module of the DAD Iraq application 2 In the Data Entry module make the appro
18. View Criteria Finance and Banking 84 289 437 20 875 583 Filter by oP 02283 Issuing Iraqi Bank Mate 16 470 680 Advanced Search OP fooz4o7 First Capacity Building project closed 418 557 418 557 Donor Agency oP 002408 Capacity Building II 1 750 000 302 199 d OP U02771 Iraq watching brief macroeconomics 260 000 74 827 Governorate 02107 Contribution ta CBI Iraq 2 660 000 1 330 000 More Filters OP 008957 ud of 250 Dinars notes to the Central Bank of 16 000 000 18 000 000 E EN oP 093539 Supply of notes to Central Bank of Iraq 17 260 000 PUBLIC VIEWS DP 009378 Supporting Economic Reform in Iraq Phase 2 2e4 700 000 opfoioo6a IMF Technical Assistance Fund 750 000 Total 84 289 437 20 875 583 Results 1 9 of 8 MY VIEWS Figure 30 Search Results DAD IRAQ APPLI CATI ON USER MANUAL 35 9 SAVING REPORTS After creating reports of different types the user can memorize them as pre defined reports and include them either in the Public Reports group and make them available for all users who have got access to the application or in the My Reports group which is available only to the current user It should also be mentioned that there are two ways of saving a report in the DAD Pakistan application The user can save a newly created report or s he can save a copy of an existing report with a different name in a different location or with a different content 10 1 How to Save New Reports From the List Rep
19. al Show numeric values in ariginal hal OK Cancel Figure 14 Setting the Chart Options 3 Define the format in which the numeric values should be displayed on the chart whether the original values should be displayed or they should be shown in thousands millions etc This prevents large numeric values represented by many zeros from taking a lot of Space on the chart 4 After finishing click the Ok button for the changes to take effect Or click the Cancel button to discard the changes made 5 4 Viewing Chart Constituent Details The user can view detailed information about the chart constituents To view more detailed information about the chart constituents the user should follow the steps described below Steps 1 Click on the chart constituent for the details to be displayed The user will be directed to the Details section of the application where all items matching the selection will be listed The first item in the list will be displayed in an expanded mode 2 Take the necessary actions print out the project details browse among other projects listed under the same parent item add new projects etc Please note that it is possible to view print all project details in a particular selection For this the user should select a Funding Source Sector etc that has more than one project and click on its project to open up details and then click on the View Print All Projects button to open the project d
20. ce in Iraq Rapid Civil Deployment Mechanism IMF Technical Assistance Fund European Community U H italy Japan EZ Jordan 2 Korea sm Norway Figure 5 Expanding the List Item Level Modify Current View Committed Amount USD 100 2 467 562 92 920 250 16 714 000 30 000 000 3 750 000 2 250 000 7 200 000 3 750 000 7 200 000 261 250 5 250 000 525 000 1 500 000 1 500 000 11 250 000 750 000 6 018 229 19 422 419 3 664 392 1 258 943 414 75 000 162 001 393 9 115 009 12 Disbursed Amount USD 2 487 552 35 557 953 22 425 000 3 735 000 062 275 5 283 222 568 433 1 167 773 1 125 000 525 000 16 200 750 000 1 559 742 19 422 419 2 821 738 1 236 942 371 132 884 223 392 460 The user can sort the list view by column by clicking on the name of the column This will sort the list alphabetically or numerically depending on the type of data entered into that column The red arrow that appears on the column can reverse the order of the list 4 4 Browsing among List Items The user can browse among the list items by clicking on the number link of the page s he would like to navigate to Also the user can make use the Previous and Next buttons to move to the page of his her choice 4 5 Hiding Showing I mages in the List In order to make the list load quicker the user can choose to hide the images which are displayed in the list These images can be donor flags secto
21. cludes text formatting buttons and a text area Figure 22 For other report components like rows columns etc the Properties window also allows assigning additional characteristics e g sorting order reference text etc Figure 23 3 Change the properties as needed Note To prevent the user from navigating away from the section every time that s he needs to change the properties of a different report table component the Properties window allows selecting the next item to be modified To do it the user needs to select the appropriate instance from the Items drop down list in the Properties window The list contains the report table components previously selected by the user 4 Click the Apply button for the changes to take effect Clicking the Ok button will close the window and navigate the user to the Report module Figure 23 Assigning Properties to Report Table Components 7 5 2 Re ordering Report Table Components This option enables the user to establish and modify the order of the report table components like rows columns etc In order to re order report table components the user should follow the steps described below DAD IRAQ APPLI CATI ON USER MANUAL 28 Steps l Click on the component item that needs to be reordered in the report 2 Select the respective Move Up Move Down Move Right Move Left option from the menu that appears The report generated will maintain the order of the items that was displayed in
22. convenience the most frequently used filtering categories are constantly present on the screen whereas others become available when the user clicks on the More Filters hyperlink e Public Reports and My Reports This section contains a number of predefined map reports that are stored in the database Two options are available in this section Public Reports This section contains the list reports available to all users of the application My Reports This section contains the list reports available to the current user only 7 1 Accessing the Report Module As it has been stated above the system provides for the opportunity to create different sorts of list reports In order to access the Report module of the system the user should follow the steps described below Steps l Click on the Report tab The user will be navigated to the Report module of the application where the Report Designer Figure 17 will open 2 In this module the user can create list reports save them as pre defined reports arrange them in the desired way print them etc Figure 17 DAD Iraq Application Report Module 7 2 Instructions for Creating a Report In order to create a report i e to structure the report table and choose what information should appear in the rows and columns of the table the user should add report components which are e Text entries title subtitle header and footer For these fields the expected input is a free
23. e Tite Organization Department Position Postal Address Phone E mail Comment Mote You should provide valid e mail address It will be used for future correspondence Figure 2 The User Registration Form Once the user submits the registration form the administrator receives a notification about it This way the administrator is able to review the information submitted and either to approve the application or to reject it case the application is accepted the user receives an email message to the account s he indicated at registration The message contains the user s login information username and password which will automatically be generated by the system as well as the link to the DAD application Later the user is able to change his her personal details as well as the password provided if it is necessary order to make changes in his her personal details the user should log into the application go to the My Profile section Figure 3 and make the changes s he thinks appropriate DAD IRAQ APPLI CATI ON USER MANUAL 10 My Profile Regulrad Field Mote You should provide a valid e mail address It will be used for future correspondence First Name synergy admin Last Name E mail Organization Tide Department Position Postal Address Phone Old Password New Password Confirm Password Figure 3 The My Profile Section 3 2 L
24. e National Budget PIP this application is designed to track the public investment projects that have been approved for the implementation and the projects that are currently being implemented These projects comprise the Public Investment Portfolio and are financed out of the national budget Once the user accesses this application s he is able to view project details and create analytical reports in the forms of Lists Charts and Maps Moreover in this application the user can add new projects or modify the information of existing projects which is done in the built in Online Data Entry Module e Country Project Activity this application is of statistical nature and is designed to track the entire project activity going on in the country Once the user accesses this application s he is able to view project details track aid flows to the country and create analytical reports in the forms of Lists Charts and Maps The examples described in the sections below are based on the Projects application DAD IRAQ APPLI CATI ON USER MANUAL 7 Note To ensure more flexibility and a more user friendly environment the DAD Iraq application has been implemented as a bi lingual system allowing the users to view the data presented in the system in two languages English and Arabic DAD IRAQ APPLI CATI ON USER MANUAL 8 3 LOGGING INTO DAD IRAQ APPLICATION The starting screen of the DAD Iraq application is the Login Screen The application
25. e icon The information will be displayed in the status bar above the Map screen e Scaling Map The user can select to show data on the scaling map by clicking the Scaling button on the toolbar above the Map screen and choosing the category to be displayed on the map The regions in the map generated will be colored according to the number of the projects When pointing the mouse cursor on the region the actual number of the projects received will be displayed in the status bar Note Clicking the button allows the user to zoom in zoom out to the next map level Example Map Report In the event the user selects to view a sector based map s he will acquire the following map report Figure 16 DAD IRAQ APPLI CATI ON USER MANUAL 29 List Chart Report APPLICATIONS Ma k PROJECTS REQUESTS DONOR PLEDGES FILTERS AL Muthanna Select All Legend View Criteria e AGRICULTURE FOOD AMD FISHING Filter by Advanced Search Donor Agency Donor Sector Governorate More Filters pd PUBLIC MAPS li ECONOMIC DEVELOPMENT EDUCATION SCIENCE AND CULTURE ENERGY ENTERPRISE AND INDUSTRY G ENVIRONMENT A GOVERNANCE AND DEMOCRACY DEVELOPMENT HEALTH HOUSING LABOUR SOCIAL AFFAIRS INFRASTRUCTURE M Y MAPS security unallocated Saudi Arabia Figure 16 Example Map Report 6 3 Viewing Map Category Details The user can view detailed information about the categories
26. e list items the user should click on the relevant First lt Previous b Next bi Last button found above the Details screen 4 7 2 Printing the Project Details In the Details section the user can print out the details of the selected project In order to print out the selected project details the user should follow the steps described below Steps 1 Click the Print button in the top toolbar A separate window will open 2 Select the Print option from the File menu 4 7 3 Adding a New Project In the Details section the user can add a new project order to add a new project the user should follow the steps described below Steps l Click on the New button at the top of the Details screen The user will then be directed to the Data Entry module of the DAD Iraq application 2 In the Data Entry module fill in the information requested Note Please refer to the Data Entry Module user manual for more details on how to enter project data into the application Note It should be taken into account that the user can add a new project from the main screen of the List module In order to add a new project the user should click on the 1 New Project button in the top toolbar above the screen DAD IRAQ APPLI CATI ON USER MANUAL 16 4 7 4 Editing an Existing Project In the Details section the user can edit an existing project Please take into account that the user can edit only those projects which
27. eescceccceseseccueccusceescesesescueccasceaseeecens 30 8 2 INSTRUCTIONS FOR CREATING SEARCH CRITERIA cccccceccceccceccccccscccccuccceccaeceesceeeceesccucccesecescueccasccasceesesescueccacccaesenscens 32 9 SAVING REPORTS innen aaa co Mos cce ALD nde oc eaa DU hee 35 TO LHOW TOSSAVE NEW RBPORTS niic dae nid tle aside epa dale ode desideres dee 35 T0 2 HOW TO SAVE A CORY OF THE REPORT 2 55 21 Sieb a citrate 35 10 ORGANIZING REPOR DO o e isieteceovevebe eee ee eee vete prob sca aere ape ve De ee ros ceo pete pe ete pe eto ve eva pa de 36 JO TOW TO ORGANIZE REPORTS2s2 6 datei a 36 11 EXPORTING AND PRINTING REPORTS ecce eee eee eee 38 TIT HOW POX PORT HAE POR US Sac en Los s A poe pL SE Ic iM ek 38 TEZ ERO TO PRINT REPORTS enean a a tees Gan ahead dato eh hg Seg cero Mode 38 DAD IRAQ APPLI CATI ON USER MANUAL TABLE OF FI GURES FIGURE 1 FIGURE 2 FIGURE 3 FIGURE 4 FIGURE 5 FIGURE 6 FIGURE FIGURE 8 FIGURE 9 FIGURE 10 FIGURE 11 FIGURE 12 FIGURE 13 FIGURE 14 FIGURE 15 FIGURE 16 FIGURE 1 FIGURE 18 FIGURE 19 FIGURE 20 FIGURE 21 FIGURE 22 FIGURE 23 FIGURE 24 FIGURE 25 FIGURE 26 FIGURE 27 FIGURE 28 FIGURE 29 FIGURE 30 FIGURE 31 FIGURE 32 THE DAD IRAQ APPLICATION LOGIN
28. eps l Click the Advanced Search link under the Filters section The user will then be directed to the Filters section Figure 28 DAD IRAQ APPLI CATI ON USER MANUAL 33 Filter Advanced Search bul Text to find Search in Donor Agency Implementing Organisation sector Sub sector Current Criteria Figure 28 Creating a Search Criteria Define the text to search for in the appropriate field Specify the fields to look in by selecting the appropriate checkbox es Click on the OK button to apply the search criteria to the ad hoc query and to the screen that was active prior to the filtering alterations i e List Chart or Note The simple search searching on fields is also available at the bottom of the Filers section Example Search Criteria Filter by Advanced Search bal Text to find Finance Search in a Donor Agency F Implementing Organisation Sector Sub sector Current Criteria Figure 29 Defining Search Criteria DAD IRAQ APPLI CATI ON USER MANUAL 34 In the event the user selects to look for Finance among sectors and sub sectors Figure 29 s he will acquire the following results Figure 30 List Map Report APPLICATIONS List k PROJECTS Please note a filter is applied you are currently reviewing a selection sub set of all projects REQUESTS Modify Current View DONOR PLEDGES Sector Sub ME EE FILTERS sector Project Projects USD USD
29. etails for preview and print 3 After finishing click the Close button to return to the Chart module 5 4 1 Browsing among List Items In the Details section the user can browse among the list items presented on the screen In order to browse among the list items the user should follow the steps described below Steps 1 Scroll down to find the relevant list item and view its details by clicking on its Or DAD IRAQ APPLI CATI ON USER MANUAL 20 2 Click on the relevant First q Previous bi Last button found in the top right corner of the Details screen 5 4 2 Printing the Project Details In the Details section the user can print out the details of the selected project In order to print out the selected project details the user should follow the steps described below Steps 1 Click the Print button in the top toolbar A separate window will open 2 Select the Print option from the File menu 5 4 3 Adding a New Project In the Details section the user can add a new project In order to add a new project the user should follow the steps described below Steps 1 Click on the New button at the top of the Details screen The user will then be directed to the Data Entry module of the DAD Iraq application 2 In the Data Entry module fill in the information requested Note Please refer to the Data Entry Module user manual for more details on how to enter project data into
30. gure 9 s he will acquire the following view Figure 10 DAD IRAQ APPLI CATI ON USER MANUAL 15 Figure 10 Example View 4 7 Viewing Project Details The user can view detailed information about any of the projects listed in the List module To view more detailed information about the project the user should follow the steps described below Steps l In the List module click on the project for the details to be displayed Note Depending on the user s choice of view s he may be required to expand list item level to view the projects listed under it The user will be directed to the Details section Figure 11 of the application where more detailed information about the project will be displayed 2 Take the necessary actions print out the project details browse among other projects listed under the same parent item add new projects etc Please note that it is possible to view print all project details in a particular selection For this the user should select a Funding Source Sector etc that has more than one project and click on its project to open up details and then click on the View Print Projects button to open the project details for preview and print 3 After finishing click the Close button to return to the List Screen 4 7 1 Browsing among Projects In the Details section the user can browse among the projects listed under the same parent item e g k donor sector etc In order to browse among th
31. have been created by him her or for which s he has been granted with editing rights by the administrator In order to edit an existing project the user should follow the steps described below Steps l Click on the Edit button at the top of the Details screen The user will then be directed to the Data Entry module of the DAD Iraq application 2 In the Data Entry module make the appropriate changes Note Please refer to the Data Entry Module user manual for more details on how to enter project data into the application Figure 11 The Details Section 4 7 5 Deleting an Existing Project In the Details section the user can delete an existing project Please take into account that the user can delete only those projects which have been created by him her or for which s he has been granted with deleting rights by the administrator In order to delete an existing project the user should follow the steps described below Steps l In the Details sub section select the project to be deleted 2 Click the Delete button at the top of the Details screen The selected project will be deleted DAD IRAQ APPLI CATI ON USER MANUAL 17 5 CHART MODULE In the Chart module Figure 12 of the DAD Iraq application the user can create and execute ad hoc queries on projects data and acquire results in the form of different charts the left frame of this screen the user is able to view the following sections e Applications This option al
32. he sign next to the name of the list item s he would like to expand This will expand the list item group level displaying the first sub level Figure 5 This can further be expanded unless there are no more sub levels to be displayed Note It should be mentioned that the user can expand one group level at a time In the event that the user wants to expand the group level of another list item the previously expanded group level will collapse Chart APPLICATIONS k PROJECTS REQUESTS DONOR PLEDGES FILTERS Select All View Criteria Filter by Advanced Search Donor Agency Donor Sector Governorate More Filters PUBLIC VIEWS M Y VIEWS 4 3 Sorting List Items Map Report List DAD IRAQ APPLI CATI ON USER MANUAL 9 Asian Development Bank Pl Belgium M4 Canada oPr 00770 OBr l0017 oP ii 2681010059 oGPr l 041 221010043 261010044 221010045 2010046 OGPr OTIO0047 oPr l0042 oPr l0056 oPral00523 am Denmark Supplying of 50 grain stars canadian government The Recovery of Irag s Vital Social Sector Rehabilitation of WATSON Health and Education Systems in Kerbala Restoration of the Mesopotamian Marshes Canadian Contribution to Security Sector Reform Middle East Good Governance Fund Civil Society Capacity Building Fund Regional Human Security Center International Mission for Iragi Elections Democratic Governance Irag Governance Program Governan
33. he will acquire the following results Figure 27 Chart Report APPLICATIONS k PROJECTS REQUESTS Modif View DONOR PLEDGES Donor Agency Donor Agency of conde JE Type Project Title Vrbem Amount Amount USD USD PUL ENS 4 Asian Development Bank 100 Select All European Community 19 422 419 19 422 419 VESTRI Multilateral IFI 19 422 419 19 422 419 Filter by oP 02543 Support ta Elections Phase 11 1 798 829 1 798 829 Advanced Search OP n02533 Irag Reconstruction and Employment 12 533 457 12 533 457 Donor Agency Programme IREP II Donor OP O02646 IREF capacity building 1 455 600 1 435 600 Sector OP 02762 Mine action support 2 603 935 2 603 935 Governorate Medi More Filters OPB 002767 edia campaign in support of nationa 1 050 598 1 050 598 canference wert 67 343 665 343 23 129 789 BS world Bank 16 240 000 76 014 PUBLIC VIEWS Total gg 363 327 862 42 628 222 MY VIEWS Results 1 5 af 5 Figure 27 Filtered List 8 2 Instructions for Creating Search Criteria The DAD Iraq application is equipped with a comprehensive search mechanism which allows searching for any relevant information For instance it is possible to indicate UNDP as a Donor or and get result on all projects where UNDP is either the Donor Agency or Partner as Maps Charts Lists or Reports The user must follow the instructions described below to create search criteria St
34. ime from the list of available columns 6 Note Once the user selects a report column an Add Sub column link becomes available under the selected column It allows indicating how the row details displayed under each column will be divided Figure 18 Selecting a Grouping for a Report Note At any point it is possible to remove all components selected for the report and design a new report from scratch by clicking on the Reset button located at the right top of the Report Screen 7 3 Previewing a Report At any time during the process of creating a report the user can refer to the Preview section at the bottom of the page in order to view the final structure of the report s he is creating Figure 19 However the Preview will not be ready for viewing unless the user has at least one table row defined Figure 19 Previewing the Report As soon as the user has finished adding report components and structuring the report table structure s he can expand the Preview section to check whether the report created clearly communicates the information that needed to be gathered for analysis 7 4 Generating a Report The final step in the process of creating a report is report generation Thus if the user clicks on the Generate Report button s he will submit a request to the Reporting Engine to access the database gather the data the user needs and present it in the manner s he has already specified The Report containing all the real data appear
35. is section Public Maps This section contains the map reports available to all users of the application My Maps This section contains the map reports available to the current user only DAD IRAQ APPLI CATI ON USER MANUAL 22 6 1 Accessing the Map Module As it has been stated above the system provides for the opportunity to present data on the map of Iraq and its regions order to access the Map module of the system the user should follow the steps described below Steps l Click on the Map tab The user will be navigated to the Map module of the application where a default map is displayed 2 In this module the user can create map reports save them as pre defined reports arrange them in the desired way print them etc 6 2 Instructions for Creating Map Reports The steps described provide instructions on how to create map reports Steps l Define whether a category based map or a scaling map will be created by clicking on the relevant button e Category based The ory based map can of the following types 1 Sector based and 2 Donor EN based To display the information of any of these categories on the map the user should click on the respective button The map legend to the right will prompt what icons stand for the category items Please note that the user can receive factual information about the projects in any of the regions of Iraq when pointing the mouse cursor on the appropriat
36. lows the user to define the object of the analysis By defining an appropriate object the user specifies to the application which data the following ad hoc queries will be run on If the analysis object is changed the system will reset the list of categories and measures on the user s screen accordingly e Filters This section contains the list of categories hierarchies by which the user may define filters for ad hoc queries For user s convenience the most frequently used filtering categories are constantly present on the screen whereas others become available when the user clicks on the More Filters hyperlink e Public Charts and My Charts This section contains a number of predefined chart reports that are stored in the database Two options are available in this section Public Charts This section contains the chart reports available to all users of the application Charts This section contains the chart reports available to the current user only Figure 12 DAD Iraq Application Chart Module 5 1 Accessing the Chart Module As it has been stated above the system provides for the opportunity to present data in the form of different charts In order to access the Chart module of the system the user should follow the steps described below Steps 1 Click on the Chart tab The user will be navigated to the Chart module where a predefined chart based on the Donor set as the chart category and Committed USD and Disbursed U
37. ng ones etc In the current design the DAD Iraq consists of three applications which are e External Assistance this application is designed to track the ongoing projects that are financed from external sources e g donor community International NGOs etc Once the user accesses this application s he is able to view project details track aid flows to the country and create analytical reports in the forms of Lists Charts and Maps Moreover in this application the user can add new projects or modify the information of existing projects through the built in Online Data Entry Module e Requests this application is designed to track the projects identified by the local ministries and ready for implementation as soon as the appropriate funds are made available Once the user accesses this application s he is able to view project details track aid flows to the country and create analytical reports in the forms of Lists Charts and Maps Moreover in this application the user can place requests for funding which is done in the built in Online Data Entry Module e Donor Profile this application is designed to track the donor profile information Moreover it gives the donor organizations entities the possibility to provide information about the amount of assistance provided to the country etc This is done in the built in Online Data Entry Module Also the user is able to create analytical reports in the forms of Lists and Charts
38. ogging into the System without Registering To ensure more flexibility and to provide access to the project data to a wider range of users the system is designed in such a way that it allows public users to enter it without having to register for a username and password Although public users have access to the project data they are not able to create new projects or modify delete the existing ones Public users wishing to view project data should click on the Click Here to Enter DAD button They will be directed to the List module of the DAD Iraq application DAD IRAQ APPLI CATI ON USER MANUAL 11 4 LIST MODULE In the List module Figure 4 of the DAD Iraq application the user can create and execute ad hoc queries on projects data and acquire results in the form of a list Figure 4 DAD Iraq Application List Module In the left frame of this screen the user is able to view the following sections e Applications This option allows the user to define the object of the analysis By defining an appropriate object the user specifies to the application which data the following ad hoc queries will be run on If the analysis object is changed the system will reset the list of categories and measures on the user s screen accordingly e Filters This section contains the list of categories hierarchies by which the user may define filters for ad hoc queries For user s convenience the most frequently used filtering categories are cons
39. on the button that represents the preferred chart type from the following a m column chart b ME pie chart C line chart d bar chart Stacked column chart stacked bar chart g 3D column chart h 3D pie chart 3D bar chart j 3D stacked column chart and k 3D stacked bar chart Note In the event the administrator defines pie chart or 3D pie chart as the chart type s he can define only one value for that chart to be generated 2 Click on the Please click here to see your changes in effect link for the chart to be generated Example Chart Report be shown on the chart and clicks on the 2 3D pie chart button to specify the chart type s he will acquire the following chart report Figure 13 Figure 13 Example Chart Report 5 3 Setting Chart Options In the Chart module the user can set the chart options i e indicate the number of items to be displayed on the chart and define whether the numeric values should be displayed in thousands millions etc In order to set the chart options the user should follow the steps described below DAD IRAQ APPLI CATI ON USER MANUAL 19 Steps l Click the Set Chart Options button in the top toolbars An Options window Figure 14 will appear 2 Indicate the number of items to be displayed on the chart by selecting the appropriate value from the relevant pull down list x Humber of items to be displayed 10 h
40. ort Chart and Map modules the user can design an appropriate report and save it In order to save the report created the user should follow the steps described below Steps 1 Click on the Save button on the top right side of the screen A Memorize Report window Figure 31 will appear 2 Define the report name in the Memorized Name field Figure 31 Memorizing a Report 3 Specify the group the report will be included in by selecting the appropriate value from the Include under the Following Group combo box 4 Check the Include currently selected filters checkbox to save filtering defined along with the report 5 Click on the OK button to save the report for future reference 10 2 How to Save a Copy of the Report In the DAD Pakistan application the user can save a copy of an existing report The copy of the report can be saved in a different location with a different name or edited content In order to save a copy of a report the user should follow the steps described below Steps 1 Click on the xi e button on the top right side of the screen A Memorize Report window Figure 31 will appear 2 Save the report by following the steps described in the section above DAD IRAQ APPLI CATI ON USER MANUAL 36 10 ORGANI ZING REPORTS The user can organize the reports in the desired way This means that the user can rename the reports create groups to include reports under etc 10 1 How to Organize Reports
41. priate changes Note Please refer to the Data Entry Module user manual for more details on how to make changes in the project data 6 3 5 Deleting an Existing Project In the Details section the user can delete an existing project Please take into account that the user can delete only those projects which have been created by him her or for which s he has been granted with deleting rights by the administrator In order to delete an existing project the user should follow the steps described below Steps l In the Details sub section select the project to be deleted 2 Click the Delete button at the top of the Details screen The selected project will be deleted DAD IRAQ APPLI CATI ON USER MANUAL 25 7 REPORT MODULE In the Report module of the DAD Iraq application the user can create and execute ad hoc queries on projects data and acquire results in the form of different reports In the left frame of this screen the user is able to view the following sections e Applications This option allows the user to define the object of the analysis By defining an appropriate object the user specifies to the application which data the following ad hoc queries will be run on If the analysis object is changed the system will reset the list of categories and measures on the user s screen accordingly e Filters This section contains the list of categories hierarchies by which the user may define filters for ad hoc queries For user s
42. r status Type of Assistance Mt OK Funding Type x Cancel Beneficiary Type Procurement Method Type of Project Year Year Month Set as default Donor Agency Type i L Implementing Organisation f Implementing Organisation T Set as default Program for public users 4 Mowe 9 Down Figure 7 Modifying the Current View 4 6 1 Adding List Groups Columns Column Groupings In order to add a group column column grouping to the list the user should follow the steps described below Steps l In the Available Groups Columns panel select the group column column grouping to be added to the list Note It is possible to select several groups columns column groupings by means of the Shift or Ctrl keyboard buttons 2 Click the Select button The selected group s column s column grouping s will appear in the Selected Groups Columns panel DAD IRAQ APPLI CATI ON USER MANUAL 14 4 6 2 Re ordering Groups Columns Column Groupings In order to re order the selected groups columns column groupings the user should follow the steps described below Steps 1 Select the group column column grouping that needs to be re ordered in the Selected Groups Columns panel 2 Click the Move Up Move Down button 4 6 3 Removing Groups Column
43. r icons etc To hide the images in the list the user needs to click on the amp Hide Images screen All the images in the screen will not display Figure 6 Figure 6 Hiding mages in the List Note Clicking the 5 Ima2 button will show the images button located at the top of the DAD IRAQ APPLI CATI ON USER MANUAL 13 4 6 Instructions for Modifying the Current View It is possible to modify the list that is currently displayed in the List module The user can add new groupings to it or remove the selected ones un select columns re order them etc The steps described below provide for the necessary instructions for modifying the current view Steps l Click on the Modify Current View link at the top right corner of the List screen A Modify Current View window Figure 7 will appear presenting the administrator with the groupings columns selected and available for the list view In the Groupings section add re order remove groups In the Columns section add re order remove columns In the Cross Tab Groupings section add re order remove column groupings Set the view as default if necessary After finishing making changes in the view click the Ok button for the changes to take effect Or click the Cancel button to discard the changes made TA Groupings Ill Coluranz Crass tab Groupings Available Groups Selected Groups Donor Donor Agency Sector Project Sub secto
44. rea holds a sub set list of the first one The user may only edit the sub set list in the second text area At the end of the filtering if the sub set list is empty all the Category items will be included in the report If however the sub set is non empty only the items in the sub set list will be included in the report At the bottom of the pop up window the selection criteria from all categories are presented This view is also available from the main screen under the hyperlink View Criteria 2 Select a Category item from the list in the first text area 3 Click on the downward pointing arrow button to add the item selected to the list in the second text area 4 Repeat steps 2 and 3 to add more than one Category item Note If a Category item needs to be removed from the second text area select it from the list in the second text area and click on the upward pointing arrow button 5 Click on the OK button to apply the filtering to the ad hoc query and to the screen that was active prior to the filtering alterations i e List Chart or Map The system will regenerate and download to the client s side an updated report that applies the updated filtering criteria DAD IRAQ APPLI CATI ON USER MANUAL 31 Project Title Po Total Requested Cost USD Project Code ee Current Criteria Figure 25 Creating a Filtering Criteria Note It is possible to exclude a Category item s from being included in
45. requires the user to enter a valid username and password and then to submit them The section below provides for the necessary instructions on how the user can log into the DAD Iraq application In order to log into the application the user should follow the steps described below Steps l Provide the username and password in the appropriate fields on the Login Screen Figure 1 2 Click the Login button Note The password is case sensitive Figure 1 The DAD Iraq Application Login Screen A successful login directs the user to the List module of the DAD Iraq application Note the event the user has forgotten his her password s he can retrieve it by clicking the Forgot Your Password link in the Login Screen and confirming his her identity After submitting his her identity information the user will receive the password into the e mail account indicated 3 1 Registering for a Username and Password New users can sign up for a username and password to start using the system In order to register in the system new users should follow the steps described below Steps l Click on the Request a New Account link at the bottom of the Login Screen A User Registration Form Figure 2 will appear 2 Fill in the information requested 3 Click the Submit button to submit the information provided DAD IRAQ APPLI CATI ON USER MANUAL User Registration Form Field User Name First Name Last Nam
46. s Column Groupings In order to remove the selected groups columns column groupings from the list the user should follow the steps described below Steps 1 In the Selected Groups Columns panel select the group column column grouping that needs to be removed from the list 2 Click the a Unselect button The selected group s column s column grouping s will be removed from the Selected Groups Columns panel 4 6 4 Setting a View as Default After making changes in the view currently displayed in the List module the user can set the newly created view as default This means that the new view will be displayed when the user accesses the List module In order to set a view as default the user should follow the steps described below Steps 1 Make the necessary changes in the current view as described in the sections above 2 After finishing click the Set as Default button in the Modify Current View window Please note that the view will be set as default only for the current user Note Clicking the Set as Default for Public Users button will display the view to those who access the application as unregistered public user Example View Figure 8 Defining List View Groupings Figure 9 Defining List View Columns In the event the user indicates e Sector Sub sector Project hierarchy as groupings Figure 8 and e Title of projects Committed Amount USD Disbursed Amount USD as columns Fi
47. s in a new window Example Report In the event the user indicates e Projects by Years of Implementation as the report title e Financial Year as the report table grouping Developing Partner Agency Project hierarchy as rows DAD IRAQ APPLI CATI ON USER MANUAL 27 of Projects Project Financing USD million Project Financing INR crores Type of Assistance as columns Figure 20 Figure 20 Creating a Report s he will acquire the following list report Figure 21 Figure 21 Example List Report 7 5 Customizing Reports The user can customize the reports by assigning font characteristics to report components re ordering rows and columns etc The sections below will describe what steps the user should take in order to customize the reports 7 5 1 Formatting Styling Report Components The user may format style the text entries as well as main report table captions and values by assigning to them value characteristics such as font font size font color background color alignment i e left center or right etc In order to format style a report component the user should follow the steps described below Figure 22 Formatting Styling Text Entries Steps l Click on the report component that needs to be formatted styled 2 Select the Properties option from the actions list that appears The Properties window will appear Please note that for text entries the Properties window in
48. tantly present on the screen whereas others become available when the user clicks on the More Filters hyperlink e Public Views and My Views This section contains a number of predefined list reports that are stored in the database Two options are available in this section Public Views This section contains the list reports available to all users of the application My Views This section contains the list reports available to the current user only 4 1 Accessing the List Module As it has been stated above the project data can be presented in a form of a list A list consists of at least one group and one column but the actual quantity of groups and columns is defined by user s choice of the view Please refer to the Modifying the Current View of the present document for more details on how to define more groups columns for the list In order to access the List module of the system the user should follow the steps described below Steps l Click on the List tab The user will be navigated to the List module 2 In this module the user can view the data organized into a view according to the selected groupings and columns modify the currently used list save it as a pre defined report include it under a definite group print it etc 4 2 Expanding the List Item It is possible to expand the list item level to view the information of the sub level s In order to expand the list item level the user should click on t
49. to the filtering criteria to be created In this case the user has to tick the Exclude check box All the Category items that appear in the second text area will be excluded from the filtering criteria to be created APPLICATIONS k PROJECTS Modify Current View REQUESTS DONOR PLEDGES Donor Agency Donor Agency itl of Committed Disbursed projects Auso gay FILTERS Asian Development Bank 100 Select All European Community 19 422 419 19 422 419 View Criteria Multilateral IFI 19 422 419 19 422 419 Filter oP 02543 Support to Elections Phase 11 1 798 829 1 798 829 Advanced Search OP 002633 Irag Reconstruction and Employment 12 533 457 Agency Programme IREF II Donor OP 02646 IREP capacity building 1 435 600 1 435 600 Sector OP 002762 Mine action support 2 603 935 2 603 935 Governorate Medi EMT More Filters OP 02767 edia campaign in suppart of nationa 1 050 598 1 050 598 conference 1 2 E 343 665 343 23 129 789 ES world Bank 240 000 76 014 PUBLIC VIEWS 363 32 7 862 42 628 222 Total M Y VIEWS Results 1 5 of 5 Figure 26 Example Filtering Criteria Example Filtering Criteria In the event the user selects Funding Agency Type as a filtering category and DAD IRAQ APPLI CATI ON USER MANUAL 22 International NGO International Organisation and Multilateral IFI as category items Figure 26 s
50. ts displayed on the map of Iraq and its regions List Chart J Report APPLICATIONS Ma t PROJECTS REQUESTS DONOR PLEDGES O Disbursed Amount USD be Disbursed USD of Projects mme alia Committed Amount USBI FILTERS Select All View Criteria Higher Filter by 414 230 200 Advanced Search Donor Agency 357 885 400 Donor Sector 301 540 600 Governorate More Filters 245 195 800 188 851 000 PUBLIC MAPS 132 506 200 Lower M Y MAPS Saudi Arabia Figure 15 DAD Iraq Application Map Module In the left frame of this screen the user is able to view the following sections Applications This option allows the user to define the object of the analysis By defining an appropriate object the user specifies to the application which data the following ad hoc queries will be run on If the analysis object is changed the system will reset the list of categories and measures on the user s screen accordingly Filters This section contains the list of categories hierarchies by which the user may define filters for ad hoc queries For user s convenience the most frequently used filtering categories are constantly present on the screen whereas others become available when the user clicks on the More Filters hyperlink Public Maps and My Maps This section contains a number of predefined map reports that are stored in the database Two options are available in th
51. yed before or after detailed data in the final report Note Selecting the None option from the list will not display the totals Note Alternatively the user can define whether totals should be displayed in the report and where to place them from within the Properties window 7 5 5 Removing a Report Table Component It is possible to remove a report table component from being included in the report if this is necessary In order to remove a report table component the user should follow the steps described below Steps l Click on the component item that needs to be removed 2 Select the Remove option from the menu that appears The selected grouping value will be removed DAD IRAQ APPLI CATI ON USER MANUAL 29 7 5 6 Switching Report Table Components The report table components may be switched between report grouping rows and columns In the event there are sub columns selected switching between table groupings rows and columns is disabled It is possible to switch between table groupings rows and sub columns In order to switch report table components user should follow the steps described below Steps l Click on the component item that needs to be switched 2 Select the Switch Place with option from the menu that appears 3 Define what component item the selected instance needs to switch place with The selected component item will be removed from its current position and added as an item to the specified component
Download Pdf Manuals
Related Search