RaviCCC

CABI 3.3 Universe Issue with WBS Phase Name

Discussion created by RaviCCC on Sep 11, 2013
Latest reply on Sep 12, 2013 by Chris_Hackett
Hi
We have recently migrated our Clarity from v12.1.1 to v13.1. We have also upgraded CABI universes from 3.2 to 3.3. I noticed an issue with "CA PPM Investments - Oracle". I added below columns Project Class. Project ID, Project Name. I added columns Task Name, WBS Phase Name from Project WBS class.
I added a Project ID in criteria. I ran this query for single project. There is no other criteria other than project id criteria. When I run the query, it drops few tasks in the WBS. When I investigated query, PRTASK is inner joined with "RPT_WBSINDEX". If there is no entry in RPT_WBSINDEX for a task, it gets dropped.

SELECT
RPT_PRJ_INVESTMENTS.CODE,
RPT_PRJ_TASKS.PRNAME,
RPT_PRJ_PHASES.PRNAME
FROM
PRTASK RPT_PRJ_PHASES RIGHT OUTER JOIN RPT_WBSINDEX RPT_PRJ_WBSINDEX ON (RPT_PRJ_WBSINDEX.PHASE_ID=RPT_PRJ_PHASES.PRID)
INNER JOIN PRTASK RPT_PRJ_TASKS ON (RPT_PRJ_TASKS.PRPROJECTID=RPT_PRJ_WBSINDEX.PROJECT_ID AND RPT_PRJ_TASKS.PRID=RPT_PRJ_WBSINDEX.TASK_ID)
INNER JOIN INV_INVESTMENTS RPT_PRJ_INVESTMENTS ON (RPT_PRJ_INVESTMENTS.ID=RPT_PRJ_TASKS.PRPROJECTID)


But when I checked the CABI 3.2 with the same BOXI query, it PRTASK is outer joined with Z_BO_WBSINDEX. When I ran the query, it is not dropping any task. Even if there is no entry in Z_BO_WBSINDEX, a task is not dropped

SELECT
PRJ_GSE_INVESTMENTS.CODE,
PRJ_GSE_TASKS.PRNAME,
PRJ_GSE_PHASES.PRNAME
FROM
PRTASK PRJ_GSE_PHASES RIGHT OUTER JOIN Z_BO_WBSINDEX PRJ_GSE_WBSINDEX ON (PRJ_GSE_WBSINDEX.PHASE_ID=PRJ_GSE_PHASES.PRID)
RIGHT OUTER JOIN PRTASK PRJ_GSE_TASKS ON (PRJ_GSE_WBSINDEX.PROJECT_ID=PRJ_GSE_TASKS.PRPROJECTID AND PRJ_GSE_WBSINDEX.TASK_ID=PRJ_GSE_TASKS.PRID)
RIGHT OUTER JOIN INV_INVESTMENTS PRJ_GSE_INVESTMENTS ON (PRJ_GSE_TASKS.PRPROJECTID=PRJ_GSE_INVESTMENTS.ID)


Questions.

1. Which Clarity Jobs populates Z_BO_WBSINDEX and RPT_WBSINDEX.
2. What is the difference between Z_BO_WBSINDEX and RPT_WBSINDEX.
3. Is there any reason why CABI 3.3 uses RPT_WBSINDEX instead of Z_BO_WBSINDEX
4. Is there any resolution for above issue

Please let know

Thank you

Ravi KC

Outcomes