Please refer below , once user has BI admin role they should as below Admin view. Oracle Fusion BI: How to Add the BI Administrator Role to a user. (Doc ID 2238277.1)

If this for idea please post here https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary

This is core BI behavior to use the actual rpd subject area name, and not the label. As alternate user can save the column in a different Shared Folder. They could create a shared folder with the subject area name they see and save the custom columns there. If needed please raise new idea for this.

One option is user A can archive report and send it to User B so user User B can un archive in which ever folder they need (My folders or custom)?

Please see if below helps: https://cloudcustomerconnect.oracle.com/posts/37c2c3b716

Refer How To Drill Down To Fusion Financial Applications Transactions From OTBI ERP Reports (Doc ID 2603149.1) else you can post here: https://cloudcustomerconnect.oracle.com/resources/a670a2ff88/summary

Please see if below solution works for you may be you need update latest jre path…

If this for new idea please also post this in as idea in https://cloudcustomerconnect.oracle.com/resources/26c1078615/summary

Not sure if below would work but just try to add () for second in division like (Column1)/(Column 2) (FILTER("Candidate Counts"."# Candidates" USING (("Application Current CSW"."Application Current CSW Step" IN ('Background Check DHC')) AND ("Application Current CSW"."Application Current CSW Status" IN ('Initiate…

Dhanuka is the error you see on view data or parse sql or in report, as using same sql works for me though there is no data due to filters.

Vipin yeah will be better to start new thread and attach a screenshot of what you see.

Vipin see below if that helps , infolet is not related to sandbox as customization can be done using page composer or add infolet button in infolet page. If you are not seeing infolets dots on home page then enable using structure. https://www.youtube.com/watch?v=Zpm0XxjaQOY https://www.youtube.com/watch?v=fhmhMRHYP3Q

Thanks Vipin for sharing table info for Product hub.

Question2: Vipin you get the underlying physical query from manage sessions and see column in subject area to which table its hitting in back end. See below doc how to see session log Fusion Applications: How to Get nqquery Using Manage Session(Doc ID 2225909.1) For example for New Item Request Number from subject area…

Vipin you can advance sql or combine analysis and see if that works for your requirement. Sample docs: Need A Report That Shows All Acitve Users (REsource Record) And If They Are An Active Participant (Doc ID 2607003.1) Oracle CX Sales and B2B Service Analytics: Creating Cross-Subject Area Reports Using BI Answers for CRM…

Thomas seems this is by design for Simple Trellis , not sure if Advance works for your requirement. The Simple Trellis displays a single type of inner visualization, for example, all bar graphs. The inner visualization always uses a common axis, so that all inner graphs are viewed on the same scale. Having a common axis…

Please try with below. TIMESTAMPADD(SQL_TSI_DAY, -1*(DAYOFYEAR(CURRENT_DATE )-1) , CURRENT_DATE )