Summary:
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Hi Abhishek,
Thank you for posting about reporting on organization hierarchy.
Please note that we have some out of the box analysis under /shared/Sales/Subject Area Contents/Saved Queries - OTBI under this folder you have some filters created and you can adjust accordingly.
Or you can also create an analysis based on Sales - CRM Resource and retrieve the hierarchy from Employee / Sales Resource Hierarchy folder. For further details about the subject area, please refer the doc https://docs.oracle.com/en/cloud/saas/sales/22c/faoec/Sales--CRM-Resource-SA-75.html#Sales__CRM_Resource_SA_75_d1e39084
If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer.
Regards,
Priscila Terazawa
Hi @Priscila Terazawa-Support-Oracle
Thanks for your quick response.
Unfortunately, I don't see any out of box queries in given path: /shared/Sales/Subject Area Contents/Saved Queries - OTBI.. most probably, they are only available with an admin access levels.
Sales - CRM Resource and retrieve the hierarchy from Employee / Sales Resource Hierarchy folder: Apologies, but can I ask you where to look out for this folder, as when i try to look out for 'Sales Hierarchy folder', I am not exactly sure which subject area to look for.
I was using WF Management - Worker Assignment Real Time subject area in my report & would like to add the correct hierarchy fields. The report I am trying to build is a type of HC report.
Thank you in advance for your assistance.
Abhishek
Apologies for the delay.
The Organization Hierarchy I mentioned is the Sales/Service Organization that you setup in Resource Directory. I checked the mentioned subject area and I don't see it there.
Sorry about that.
Priscila
Hi @Priscila Terazawa-Support-Oracle -
No worries - thanks for your response & assistance.
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
