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