Structure

The Cognos Analytics displays the Project Status Details reporting area as shown.

The Project Status Details query subject, the first item listed in the reporting area, is the fact table. If you expand that node of the tree, the list displays the identifier and attribute fields, followed by a Measures folder that contains the hours and amount fields.

The other query subjects provide additional data related to the data in the fact table that you may want to use or display in your reports. Of special note is the Subperiod query subject. It not only lists accounting period information but also provides a yes/no flag that identifies the current open period.

The following is a sample output from this query subject:

The Filters for Project Status Details folder contains the pre-built filters for the reporting area.

The Advanced Reporting folder contains the query subjects and fields that you can use to implement rollups by project level and organization level, to report based on home organization, or to report based on reorganization.