This would benefit us greatly

I agree with this. Anytime we filter by segment tree filter, performance is greatly impacted. It would also be great if there was index on description (name) of the code since performance is also severely impacted when filtering on name instead of code.

Hi, Please see attached archive file. Use this as example Two columns in query: (Using Projects Cross Subject Area) Project Number Formula: "Project"."Project Number" Project ID: CAST("Project"."Project Key" as CHAR) ^^For above note you can hide this column in your output as in the example. In order to edit the drill down…

I'm not sure if this still works, but I had a note from a colleague a long while back specific to BI Reports Here is the workaround to circumvent count restriction within SQL IN clause. For some reason if you put 0 on both sides, it works. Select * from xx_table Where (col_name,0) IN ( ('abc',0), (‘abc1’,0), ------ any…

Hi, I would suggest looking at this documentation: https://docs.oracle.com/en/cloud/saas/project-management/23a/fapca/deep-links-for-project-management.html#s20076969

Hi, From the manage project cost area, click on "Tasks" on right hand side, then select "Manage Committed Costs" In that screen use the "Project Name" use the drop down arrow, then click search, it will also pop up and allow you to search by the project number. Then click search to return the results. What you see in here…

also going to attach archive for otbi analysis that we having been using for 5+ years without issue. You may need to tweak a bit for your needs, but this has been able to supply matching/accurate info. Project Commitment Report.zip

Hi, Total committed costs should give you the balance including the spend down. That should match what you see in manage committed costs screen. Each time invoice comes in against PO, the total committed cost should be reduced as each comes in. Once fully invoiced, or po finally closed it will disappear from manage…

Just realized, I think you should try a different measure in your query "- Commitment Cost Measures"."Total Committed Cost" (In commitment cost measures folder) I think that is actually the issue :)

Hi, Under projects (same area as manage project costs), looks at "Managed Committed Costs" search by project # to view the commitments Looks at both Raw Cost and Burdened cost. If there is a bigger amount in burdened cost, that includes the burden amount. You also may need to look from the award side, sometimes there is an…

Hi, Most likely from project side, it includes the "Burden" Amount. If you look at the PO from main inquiry screen, you would have to look at budgetary control area to see the amount reserved for burden on project. So for example if project have 55% multiple, a PO for $1 would also have $.55 cents added for burden amount.…

sounds like a good case for SR. they will ask you to provide nqquery logs/etc but that may be best approach since it worked in the past. Oracle would need you to provide the logs (several ways, you can search customer connect) or SR will guide you how to provide the detail. Last time I did have this issue was the query…

For anyone who sees this, please upvote my ER: https://community.oracle.com/customerconnect/discussion/663313/need-otbi-subject-area-for-project-cost-journal-workflow-approval

Thank you so much. Will be creating idea lab.

You may want to look at the "BI" audit reports. They are provided by Oracle (either here or in SR). These are the standard reports, I believe BIPCatalogObjectAuditTrail would give detail you are looking for.

Hi - I had this issue where same type of thing stopped working. Turns out in the first analysis which it was based off DFF value in there, there was a NULL value in a row of data for a dff. When passing to second query, the second query failed when there was a null DFF in first analysis. Had to filter out the null, then…

What I found is that if you run the analysis from the "Catalog" the prompts will appear. If just running from "Reports and Analytics", you need to create a dashboard and add the analysis to the dashboard in order for the prompts to show. (From report and analytics screen)

One option I've been using in is the bi report select the parameters you want to default, then click the gear icon -> share report link -> current page It will show a link that you can bookmark locally in your web browser and it will pre-populate parameters.

Thanks for your reply, is there anyway to do this in only cloud environment? Unfortunately I don't have access to any noncloud environment. I'm hoping for an easy way to just export the folder/subfolder names in Shared Folders along with what files/object exist in each folder/subfolder.

Hi Steph, Rutgers university created an enhancement request for this same issue. https://cloudcustomerconnect.oracle.com/posts/e5ab73293f Would really appreciate if you could give the thumbs up on this idea to get some traction from Oracle. Regards, -Rich