Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How can I get default results in a graph under a manager when the manager is the logged-in user?

Received Response
10
Views
3
Comments
Ivony Ann Paula Salango
Ivony Ann Paula Salango Rank 5 - Community Champion
in Oracle Transactional Business Intelligence

I am using OTBI-analysis in creating curtailment report. It will be shown as infolet in Oracle Sales Cloud. I need 2 subject area because I need the default result of the graph to be the counts of curtailment under the manager.

image.png

The result is incorrect because the managers username is not correct per account.

image.png

This should be the correct output. Paul is under Cory. But I can't make the same output in the graph because the filter only works in the prompt.

image.png
Tagged:

Answers

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    Can you try with the subject area that provides the correct manager hierarchy, and then use Add Related Subject Area to merge all other needed subject areas into one?

  • Ivony Ann Paula Salango
    Ivony Ann Paula Salango Rank 5 - Community Champion

    Hello @RVohra ,

    The Sales-CRM Resource is the correct subject area, maybe there are other ways aside from using 2 subject areas ?

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    Hopefully, someone from Oracle can pitch in and provide some insight.