Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 195 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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