Query to get project actuals weekly data

[Giri]

please help on how to get project actuals weekly data? we need consolidated  weekly actuals for particular project.
in the below format:

		Week starting
Project ID	Project Name	01/Jun/2020	08/Jun/2020	15/Jun/2020	….	….	…	24/Aug/2020	31/Aug/2020
'zzz'

[David Morton]

Timeslices.

The timeslice functionality breaks down numbers from the BLOB fields that contain the data into relational database tables and columns.
If you want to read those tables/columns you will need to understand how all that works so read the documentation in that area.

I would think the data you are after would be in the WEEKLY_INVESTMENT_ACTUALS slice, but timeslices are very configurable so it really depends upon how your system is set up.

--

If you are looking for SQL to do this ; search for PRJ_BLB_SLICES (this is the table with all the data sliced into it) on the community and you will find lots of discussions and lots of SQL on how to interpret the data.

For example this discussion ; https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=2ab49344-cb5f-4dae-b121-854911259aad&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer#bm2ab49344-cb5f-4dae-b121-854911259aad

Different slice types contain different data and have different relationships to the other system tables, so you do really need to understand how it works to get the right data out of the tables. Once you do understand how they work then it is relatively easy to get the data you want (you just have to make sure your JOINS are correct, the right slice is being used and you are SUM ing and GROUPing correctly)

[Giri]

Thanks David, I will try to understand how this works..

[Martti Kinnunen]

IF you do post to wip you can get it from PPA_WIP.
If  you have weekly time reporting periods you can get it from prtimeentry.practsum when link those through assignments and tasks to projects.