AnsweredAssumed Answered

Querying Time-Varying Attributes

Question asked by harrisge on Sep 23, 2016
Latest reply on Sep 29, 2016 by Chris_Hackett

I have a requirement to extract the data from the Cost blob attribute of Budget Plans using a SQL Query that pulls the details for each line and month

 

I have set up a Time Slice for  Project: Detailed Budget Cost with a Rollover Interval of 'Monthly' a Slice Period of 'Monthly' and Number of Periods of '12'. After running both the Datamart Extraction and Datamart Rollup jobs, I find that the odf_sl_budget_cost table is loaded with information. I use the following query to get slice data:

SELECT
  I.ID,
  I.CODE,
  FP.NAME,
  FP.ID FP_ID,
  FPD.ID FPD_ID,
  FPD.TOTAL_UNITS,
  SL.SLICE_DATE,
  SL.SLICE
FROM INV_INVESTMENTS I
     INNER JOIN FIN_PLANS FP ON FP.OBJECT_ID = I.ID
                AND FP.OBJECT_CODE = I.ODF_OBJECT_CODE
                AND FP.IS_PLAN_OF_RECORD = 1
                AND FP.PLAN_TYPE_CODE = 'BUDGET'
     INNER JOIN FIN_COST_PLAN_DETAILS FPD on FPD.PLAN_ID = FP.ID
     INNER JOIN ODF_SL_BUDGET_COST SL ON SL.PRJ_OBJECT_ID = FP.ID          
WHERE I.CODE = '<project_code>';

It return the following data:

 

Our organization has never dealt with Budget Slices so I have no idea how to move beyond this level. I cannot find anything beyond this level one the web that show me how to get the Charge Code and period amounts.

 

Thanks,

Garth

Outcomes