Skip to main content
Planview Customer Success Center

Field "Unbillable Request Time Cost associated with a fixed fee" missing from Cognos Data Model(CP 2012)

Symptoms:
The field "Unbillable Request Time Cost associated with a fixed fee" is missing from Cognos.
The field is expected under:

Financial analysis summary->Financial analysis by project by fiscal period->Unbillable project request time (rectype 9)

Financial analysis summary->Financial analysis by project daily->Unbillable project request time (rectype 9)

Financial analysis summary->Financial analysis by project monthly->Unbillable project request time (rectype 9)

Reason:
There is no corresponding field in Cognos for "Unbillable Request Time Cost associated with a fixed fee".
This issue has been acknowledged as defect and will be fixed in a future release of Changepoint.


Alternative:
The alternative is to fetch the same field from the database via SQL:

1- Add a new query (e.g. Query2), with the following SQL which returns the missing field “NonBillFixedFeeRequestTimeCost”

Select engagementid, projectid, sum(NonBillFixedFeeRequestTimeCost) NonBillFixedFeeRequestTimeCost from DS_Fin_AllByProjectByFiscalRaw group by engagementid, projectid

2- Make sure that the Data source is selected for Query2 otherwise you will experience problems

3- Join the original query (Query1) which has the other fields to be shown in the report, with Query2 (the result of the join will be called Query3)

4- Select the field you would like to show in Query3, which is the joined query to be used in the report