Categories
Task Hierarchy in OTBI subject area - refresh mechanism

I have an OTBI report written with the subject area, "Project Control - Financial Project Plans Real Time".
Step 1
The report shows the project number, name, project manager, project status, task name, billable flag, chargeable flag. So far so good.
Step 2
Within the subject area, there is a folder called 'Task Hierarchy'. I report the Level 2 task number & name, Level 3 task number and name.
All the fields work fine for an ongoing project.
I now add a few more tasks to the project using the Financial Project Plan screen.
Step 1 report works fine. It shows the newly added tasks.
Step 2 shows the old report. In other words, it does not show the newly added tasks.
If you add any field from the 'Task Hierarchy' folder, the new tasks are a no show.
I waited for a day to see if any overnight jobs will do the trick. No luck. I ran update project performance data. No luck. I rebaselined the project. No luck.
Can anyone throw light on when the task hierarchy related fields get refreshed?
Comments
-
I found that this requires running of a scheduled process called, 'Denormalize task structure hierarchies for Business Intelligence'. Once you run it, it works.
0