Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Task Hierarchy in OTBI subject area - refresh mechanism

6
Views
1
Comments

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?

1
1 votes

Submitted · Last Updated

Comments

  • ravinat
    ravinat Rank 4 - Community Specialist

    I found that this requires running of a scheduled process called, 'Denormalize task structure hierarchies for Business Intelligence'. Once you run it, it works.