NB: This documentation is based on Mantis entries: 

It also incorporates material from the Wikipedia articles on project management and on work breakdown structure. 

InfoQube is often used in the planning and monitoring of activities made up of constituent individual actions. Sometimes these activities, made up of interdependent actions, are sufficiently complicated to merit being treated as a project.

The management of any project should be planned in two stages. These are:

1.      Identify the Work Breakdown Structure – in essence, what are the outputs required from the project.

2.      Plan the Project Schedule – how and when the various actions required to create the outputs will be carried out.

The first stage in the planning of a project should be the identification of its work breakdown structure (WBS). The Work Breakdown Structure is a tree structure, which shows a subdivision of effort required to achieve an objective; for example a program, project, and contract. The WBS tells us WHAT elements ("deliverables") are necessary to plan, execute, control and close a project, while the (subsequent) project schedule will tell us HOW we plan on creating each of those deliverables. In this context, the WBS should always represent exactly 100% of the approved scope (deliverables) of any project.

It is important to understand that the WBS shows only WHAT the deliverables are. It does not (or should not) show the structure of the deliverables, that is HOW they are individually constructed. It makes perfect sense to do that too using IQ, but the WBS should not be confused with that product structure. Nor should the initial creation of the WBS be confused with the subsequent stage of project scheduling, which identifies the schedule of tasks and their interdependencies – the WHEN. It is considered poor practice to construct a project schedule before designing a proper WBS. So the WBS is neither a project plan, a schedule, nor a chronological listing.

In a project or contract, the WBS is developed by starting with the end objective and successively subdividing it into manageable components in terms of size, duration, and responsibility (e.g., systems, subsystems, components, tasks, subtasks, and work packages). Thus it includes all deliverables necessary to achieve the objective. This may take the form of a tree structure.

The most obvious way in which to model a tree structure in InfoQube is of course as a hierarchical outline. However, this is not actually necessary in order to plan a project nor – subsequently - to represent it as a Gantt chart.

The Work Breakdown Structure provides a common framework for the natural development of the overall planning and control of a project or contract and is the basis for dividing work into definable increments from which the statement of work can be developed and technical, schedule, cost, and labour hour reporting can be established.

A work breakdown structure permits summing of subordinate costs for tasks, materials, etc., into their successively higher level “parent” tasks, materials, etc.

For each element of the work breakdown structure, a description of the task to be performed is generated. This technique is used to define and organize the total scope of a project.

The WBS should initially be organised around the primary products of the project (or planned outcomes) instead of the work needed to produce the products (planned actions). Since the planned outcomes are the desired ends of the project, they form a relatively stable set of categories in which the costs of the planned actions needed to achieve them can be collected.

An outcome determines a so-called terminal element of the project, that is, an activity which delivers that outcome. A well-designed WBS makes it easier to assign each project activity to one and only one terminal element of the WBS, which is desirable in phased projects which deliver multiple outcomes and for which – for example – separate costings / billing items are required or desirable as part of the process of accounting for project costs.

A Gantt chart is a type of bar chart that illustrates a project schedule. InfoQube has a Gantt view, which includes a Gantt chart.

Gantt charts illustrate the start and finish dates of the terminal elements and summary (intermediate) elements of a project. Terminal elements and summary elements derive from the work breakdown structure of the project. Gantt charts can also show the dependency (i.e. precedence network) relationships between activities. Gantt charts can be used to show current schedule status using percent-complete shadings. Gantt charts have become a common technique for representing the phases and activities of a project which carries out a work breakdown structure (WBS), so they can be understood by an audience which is wider than the person who is planning the work.

InfoQube cannot pretend to the advanced project management capabilities present in dedicated project management software such as Microsoft Project. This documentation assumes that InfoQube is being used to manage the activities associated with one person carrying out a complete project. The size of an action is measured in person-days of effort. Normally, its duration is determined by its start date and its end date; however, it is no longer required to set the Gantt chart End Date and Duration field. When only the Start Date field is set, this can be used to get a timeline-type view. An action which takes zero time is a milestone; it is represented not a line in Gantt view, but as a lozenge.

In a project schedule, dependencies between actions are identified.

The implementation of projects in IQ usually involves a combination of specific IQ features. These are:

1.      Gantt View. This can be enabled for any grid, although typically it is used with a Projects grid. To toggle Gantt view on or off for a given grid, used Grid / View Gantt. To set the Gantt-related properties for a grid, use Grid / Properties and open the Gantt Chart properties for that grid.

2.       A set of system fields intended to represent Projects. These fields include:

Part of the flexibility of IQ is that it is not necessary to stick to a strictly hierarchical breakdown of work. Thus a sub-project of one project may equally be used as an element of a second project. Similarly, a task which is a sub-task of one task can be a sub-task of another task.

Thus one thing which is essential to effective project planning in IQ is grouping together tasks which together constitute a project. It might therefore be sensible to represent the project as a tree structure of hierarchically-linked tasks and their sub- and sub-sub- tasks. However, this is not in fact the way in which IQ shows how tasks are related. Instead, IQ permits task dependencies to be represented and stored explicitly. One task can depend on more than one other task, and one task can precede more than one subsequent, dependent, tasks. Thus, it is only by convention that tasks and sub-tasks are represented as a hierarchy, and IQ ignores the tree structure when considering dependencies. Instead, it relies upon the use of two system fields to show how one task relates to others.

Traditionally, project tasks are labelled using letters. However, IQ uses the numerical system field TaskID to identify individual tasks and the system field NextTaskID to store dependencies. In fact, the NextTaskID field can be used to identify several “next” (dependent) tasks since it takes the form of a comma separated list.

The standard sample database contains a project called Somiro. The screenshots which follow are taken from such a sample database.

In the screenshot we can see the following elements:

1.      A TLI (top level item) ‘Project Samiro’ and its constituent tasks, here labelled 1.1 to 1.11; this grid shows the principal fields needed to implement a Gantt chart in IQ; these fields are discussed below.

2.      Above the grid is shown the project overview – this extends over the whole length of the project, which is here all of May and most of June 2008; it is shown if the Gantt Chart property Show Overview is set; the scale of the display can be set to one of Min, Hr, Day, Wk, Mo (minutes, hours, days, weeks, months).

3.      To the right of the main grid is shown the magnified detail Gantt view of the tasks which are active in a particular seventeen day period; the part of the project which is currently displayed is indicated by orange shading in the project overview described in the previous element.

4.      Below the detail Gantt view is the resource utilisation histogram; it is shown if the Gantt Chart property Show Histogram is set.

Gantt charts are good for project management, but they can also be used for other things, since:

1.      The amount of scaling is under user control.

2.      The current time is shown as a green vertical bar in the minute, hour and day scales.

3.      If you double-click on the header, the chart is centred to the current date/time.

4.      If you double-click on the chart on an item line, the chart is centred on that item bar.

5.      Using the mouse-wheel when over the Gantt scrolls the chart left-right; using the page scroll buttons makes larger left and right centred movements.

6.      As the user moves the mouse (just below the date headers), a Date Ticker is shown.

Grid: Item colour: an option has been added to select which columns are shown in that colour.

Currently, the item back color is set to all columns. This is sometimes not desired (in particular with the new Gantt chart bar color). The new option permits setting the list of fields which show the color; it should be left blank to color the whole item:

Additionally, in a Gantt chart:  an option has been added to set bar colors. The steps necessary are these:

1.      Grid>>Properties>>Gantt Chart>>Bar color field : set it to field containing the color (by default, the ItemColor field is used)

2.      Set the values for the bar colors (using ItemColor field is easy because IQ has context menus to set this field)

These are set using Grid / Properties, then opening the Gantt Chart properties, which are:

If you set your grid source to your Gantt Start date field (normally TaskActStart), the DateFilter toolbar can then be used to limit the items displayed. This is useful to view just what you want, to reduce crowding in the overview area and it also helps when printing.