Hi Praveen,
Just want to add a couple of things to the query written by Gauri,
Please consider joining with BIZ_COM_PERIODS table to get the month name using the PERIOD column.
Another important use of joining with BIZ_COM_PERIOD is, you should check if your BIZ_COM_PERIOD START_DATE and ODF_SSL_CST_DTL_COST START_DATE are matching, this determines if your Slice data are matching if you are using an external interface to XOG in the Cost Plan details.
Which database you are dealing with, SQL Server or Oracle
If you are using SQL Server, then
To get the cost data , try using isnull(ROUND(cslice.SLICE*(DATEDIFF(DAY, cslice.START_DATE, cslice.FINISH_DATE)),2),0) in the place of
sum(ROUND (NVL(cslice.slice,0) * (NVL(cslice.finish_date,SYSDATE) - NVL(cslice.start_date,SYSDATE)),3)) costdata
Please let me know you need any help in writing the query.
Regards,
Mathan