Projects Top Task Name and Top Task Number not displayed in OTBI for some Project Numbers?

Fiona Marran

Hello,

We have created an analysis using Projects - Performance Reporting real time however it's showing incomplete data. When we add the column "Top Level Task Name" or "Top Level Task Number", some projects are not displayed.

This issue also appears when we utilise the Projects Control - Budget Real time subject area too.

Would appreciate any advice please?

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24892/projects-top-task-name-and-top-task-number-not-displayed-in-otbi-for-some-project-numbers

Hi @Fiona Marran,

Can you please check if the following scheduled job has been executed or not?

'Denormalize Task Structure Hierarchies for Business Intelligence'

If not, please execute the process from the Scheduled Process area in any Non Production environment and verify if there is any betterment.

Hope this help.

Thank you.

Rich Merkel

Hi,

Does the data appear within the Project Financial Management section?

Also I do know for Projects - Performance Reporting Real Time subject area, the process also should be run: Update Project Performance Data. Try running this process for the project number.

Fiona Marran

Hi @Bhaskar Konar we have run this process, and it populated for a few more project numbers, but certainly not all of them. It's very perplexing!

Fiona Marran

Hi @Rich Merkel thank you for your suggestion - we've run this however this hasn't solved the issue. Do you have any additional suggestions? Thank you!

Rich Merkel

Hi - does the project/task have any revenues/cost/budget?

I do find that if there are no measures, after adding in task the project number will disappear from output. This was a screenshot of old SR, and was advised costs/revenue (or budget) needs to have some measure