What is the rollover interval, slice period and number of periods for system time slice costplandetail::cost::segment?
Can we create a custom time slice for cost?
What are you trying to accomplish?
You can create user-defined Time Slices to slice planned costs.
Go to Administration, Time Slices, click 'New' button and pick the type of data you want to select for your custom slice using standard calendar periods.
You must have already looked at it and found that the data is not there.
To me that suggest that the period in reality is the period used in the plan and the number of periods is the number of periods in the plan and the slices do not roll over as the plan does not roll over either.
As costplandetail:cost:segment is not available as such or for eg projects as an object neither directly nor eg. for projects you cannot create a custom slice either.
What you can do is to create a time varying attribute and manually copy the values from the plan.
Yes, as there is no roll over there is lot of data accumulated in the respective ODF_SSL_CST_DTL_COST table which slows down the performance of custom reports.
I would like to have a custom slice which would copy only the current year data from the plan to a separate table. How can I do that?
I am not clear on your suggestion for a time varying attribute and copy from plan. Can you please provide more details?
To create a user-defined slice for cost plan data, you can accomplish in using the following steps:
1. Go to Administration, Time Slices, click 'New' Button
2. Create the new definition and pick the appropriate Investment type and Planning data
Example: I have created a Monthly Slice for the total planned cost for projects ; there is also separate items for capital and operating which can be used as well.
Try this out and query the slice ID that is created and see if you get the data that you need for your reports.
I guess that the reason for "segment" not being available is that, that slice will contain what ever the period is while for custom slice you have to define what the period is as Kathryn posts above.
As a user you know what the period is in your plan so you can select it for the custom slice.
No need to create a custom TSV attribute (which you do as you normally do for any Clarity object)
I need the actual cost details posted from ppa_wip, not the planned costs. None of the custom timeslice show the actual cost which I require.
Can you also explain how to create a tsv?
If you want ppa_wip actuals, there is a nice portlet named 'Posted Transaction Review' which you can look at the query and and use that to leverage for making your own query.
I am able to get the actuals using the timeslice table odf_ssl_cs_dtl_cst which is populated by time slice costplandetail::cost::segment.
What I am asking - is there a way to have a custom time slice for the same data with user defined rollover? I am unable to get the same data with the item options available when creating a custom timeslice.
I think the answer in the above posts is no - you cannot have that.
What would be the benefit - if you do not mind me asking - of using the slices if you get the same data with a query to PPA_WIP with whatever time limits you want.
We have a custom job that xogs in transactions from ppa_wip to Forecast cost plan details.
The reports should display only the finally posted actuals from financial plan detail not from ppa_wip as there might be a differences in both if there are any xog related errors.
Retrieving data ...