Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Zheng Zheng
    OTBI computed field and graph
    Topic posted October 1, 2019 by Zheng Zheng, tagged OBI Answers, OTBI, Reports 
    36 Views
    Title:
    OTBI computed field and graph
    Summary:
    creating computed field and graph
    Content:

    Hi all, 

    I am very new to Oracle Fusion business intelligence. 

    Background:

    • Fusion 19C 
    • try to analyze the company's employee expense reports by taking the "Expense - Expense Transactions Real Time" subject area
    • Analyses report include these fields: "Report Number", "Report Status", and "Expense Report Total"
    • Computed fields: 
      • "Report Threshold", formula: CASE WHEN "Expense Report Amounts"."Expense Report Total" >= 500  THEN '>=500'   ELSE '<500' END
      • "Report Count", formula: ABS(1)*1
      • as you can see in the attached picture #1 - "Report Threshold" has the "measure" type icon, and the "Report Count" has the dimension type icon.

    The result looks like this: 

    Report Number Report Status Expense Report Total Report Threshold Report Count
    xxxxxx Paid 2,968 >=500 1
    xxxxxx Ready for Pa 271 <500 1


     

    When I create a pie chart using the configuration (see attached image 2), it does not generate the graph correctly. 

    Please advise what I miss or how I can make it work. 

    Thank you so much! 

     

     

    Version:
    19C
    Image:
    Document:
    2.png (44KB)