Clarity

CA PPM SAAS 15.3

I have created custom adhoc view from Project Management domain.

I selected both project attributes and program attributes.  

Each project is linked to only one program (project hierarchy->Parent)

I get duplicate records (all the rows are repeated twice) and not sure what is causing the duplicate

Any help/pointer is greatly appreciated

Thanks

-Venkitta

Hi Venkitta,

Do you mean that all projects are duplicated in adhoc view?

If you select projects on adhoc view, they are duplicated in report?

Could you provide more details about duplicate?

Did you run Load Data Warehouse job with Full option?

It will truncate DWH tables and re-insert records from PPM tables.

(DWH tables will be synchronized by current PPM tables.)

After Load Data Warehouse job with Full option, duplicated records may be removed.

Regards,

Shoichi

Hi Shoichi

I did run the DWH full load and checked the report and still seeing the duplicate records.

This issue is happening when we add program attributes and the project had more than one parent

Thanks

-Venkitta

Hi Venkitta,

I added attributes and the some project had more than one parent.

I could not replicate your issue.

Could you run below query in DWH scheme?

This query shows Projects and Programs.

select INV.INVESTMENT_KEY,INV.INVESTMENT_NAME,INV.INVESTMENT_TYPE_KEY,PRG.IS_PROGRAM
from DWH_INV_INVESTMENT INV, DWH_INV_PROJECT PRG
where INV.INVESTMENT_KEY=PRG.INVESTMENT_KEY

Please check if there is duplicate record in the result from above query.

Regards,

Shoichi