search cancel

ODF_SL_PLAN_COST_M Slice Table - what does PRJ_OBJECT_ID point to?

book

Article ID: 256651

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

I am just trying to display Cost Plan Monthly data using NSQL query.

For that I am using ODF_SL_PLAN_COST_M which stores monthly cost plan slice data.

Initially I thought it can be joined to FIN_COST_PLAN_DETAILS just like ODF_SSL_CST_DTL_COST slice table, but it’s not giving me the expected values. So, I assume the ODF_SL_PLAN_COST_M table is joining to some other table.

Environment

Release : 16.1.0

Resolution

Clarity uses application logic for some of these tables. 


Using Data Warehouse reporting may be a better option.

The data is normalized and a lot easier to work with:


select period.PERIOD_START_DATE,period.PERIOD_END_DATE,period.PERIOD_TYPE_KEY,fin_plan.INVESTMENT_KEY,inv.INVESTMENT_NAME,
       fin_plan.PLAN_KEY,sum(fin_plan.PLAN_COST)
from DWH_FIN_PLAN_PER_FACTS_V fin_plan, DWH_CMN_PERIOD_V period, DWH_DW_INVESTMENT_V inv
where period.PERIOD_KEY=fin_plan.PERIOD_KEY
and fin_plan.INVESTMENT_KEY=inv.INVESTMENT_KEY
and period.PERIOD_TYPE_KEY='FISCAL'
group by period.PERIOD_START_DATE,period.PERIOD_END_DATE,period.PERIOD_TYPE_KEY,fin_plan.INVESTMENT_KEY,inv.INVESTMENT_NAME,
       fin_plan.PLAN_KEY;